[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now


How to convert JSON file to csv?

Posted on 2016-11-09
Medium Priority
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 ..!
Question by:chokka
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

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.

Author Comment

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
LVL 35

Expert Comment

ID: 41881827
Use a different editor (WordPad, UltraEdit, vim, emacs,..). The problem is only the file size and notepad.
Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.


Expert Comment

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


Author Comment

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.


Accepted Solution

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.

Expert Comment

by:Daniel Jones
ID: 41883321

Featured Post

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

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

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
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…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

649 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