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 ..!
chokkaStudentAsked:
Who is Participating?
 
António SargentoConnect With a Mentor Chief ArchitectCommented:
If you are familiar with javascript, you could use the json2csv on node.js.
In Java you have this simple project on Github.
0
 
Dung DinhDBA and Business Intelligence DeveloperCommented:
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.
0
 
chokkaStudentAuthor Commented:
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
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
ste5anSenior DeveloperCommented:
Use a different editor (WordPad, UltraEdit, vim, emacs,..). The problem is only the file size and notepad.
0
 
António SargentoChief ArchitectCommented:
You have a couple of online converts, like:

0
 
chokkaStudentAuthor Commented:
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.
0
 
Daniel JonesData Research AnalystCommented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.