Solved

How to convert JSON file to csv?

Posted on 2016-11-09
7
104 Views
Last Modified: 2016-11-12
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
Comment
Question by:chokka
7 Comments
 
LVL 7

Expert Comment

by:Dung Dinh
ID: 41881755
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
 

Author Comment

by:chokka
ID: 41881761
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
 
LVL 33

Expert Comment

by:ste5an
ID: 41881827
Use a different editor (WordPad, UltraEdit, vim, emacs,..). The problem is only the file size and notepad.
0
Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

 
LVL 2

Expert Comment

by:António Sargento
ID: 41882516
You have a couple of online converts, like:

0
 

Author Comment

by:chokka
ID: 41882527
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
 
LVL 2

Accepted Solution

by:
António Sargento earned 500 total points
ID: 41882540
If you are familiar with javascript, you could use the json2csv on node.js.
In Java you have this simple project on Github.
0
 
LVL 4

Expert Comment

by:Daniel Jones
ID: 41883321
0

Featured Post

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question