?
Solved

How to convert JSON file to csv?

Posted on 2016-11-09
7
Medium Priority
?
278 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 8

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 35

Expert Comment

by:ste5an
ID: 41881827
Use a different editor (WordPad, UltraEdit, vim, emacs,..). The problem is only the file size and notepad.
0
Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

 
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 2000 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

What Is Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

Question has a verified solution.

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

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
The well known Cerber ransomware continues to spread this summer through spear phishing email campaigns targeting enterprises. Learn how it easily bypasses traditional defenses - and what you can do to protect your data.
Viewers will learn how the fundamental information of how to create a table.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

771 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