Link to home
Start Free TrialLog in
Avatar of chokka
chokkaFlag for United States of America

asked on

How to convert JSON file to csv?

I have downloaded yelp dataset which is about 2.7 gb JSON file. I'm not able to open the file in notepad.

After reading online materials, there are some python codes available in GitHub to convert JSON to csv.

I'm not familiar with python. I did try. I couldn't.

Experts, requesting for advise ..!
Avatar of Dung Dinh
Dung Dinh
Flag of Viet Nam image

I am not expertise in JSON but you could prefer the link https://www.simple-talk.com/sql/t-sql-programming/consuming-json-strings-in-sql-server/

If you are using SQL Server 2016, SQL Server supports JSON data.
Avatar of chokka

ASKER

Thank you ..!! This is totally new for me. I'm using sql 2012.

Other problem is, file which I downloaded from yelp is about 2.7 gb
Use a different editor (WordPad, UltraEdit, vim, emacs,..). The problem is only the file size and notepad.
Avatar of chokka

ASKER

Hello Antonio.. Thank you.. Online converters will not be able to handle the large size file.  Size of the file is 2.7 GB.

Thanks.
ASKER CERTIFIED SOLUTION
Avatar of António Sargento
António Sargento
Flag of Portugal image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial