• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 451
  • Last Modified:

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 ..!
0
chokka
Asked:
chokka
1 Solution
 
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
 
chokkaAuthor 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
 
ste5anSenior DeveloperCommented:
Use a different editor (WordPad, UltraEdit, vim, emacs,..). The problem is only the file size and notepad.
0
Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

 
António SargentoCommented:
You have a couple of online converts, like:

0
 
chokkaAuthor 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
 
António SargentoCommented:
If you are familiar with javascript, you could use the json2csv on node.js.
In Java you have this simple project on Github.
0
 
Daniel JonesData Research AnalystCommented:
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now