chokka
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 ..!
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 ..!
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
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.
You have a couple of online converts, like:
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.
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Take a look at this link, hope this will help you out: http://stackoverflow.com/q uestions/4 130849/con vert-json- format-to- csv-format -for-ms-ex cel
If you are using SQL Server 2016, SQL Server supports JSON data.