JSON2CSV – convert json files to csv


Hits: 8653  

JSON2CSV is a python script that converts json data to a csv file.

json2csv

json2csv.py_.txt

Download above text file “json2csv.py_.txt” then rename “json2csv.py”

>> python json2csv.py “input.json” “output.csv”

JSON – input.json

[
{
“createdAt”: “2014-02-20T18:15:56.818Z”,
“fbID”: “34534534534”,
“lessonQuestions”: 5,
“lessonScore”: 2750,
“lesson_no”: 2,
“objectId”: “htmsuPr6F6”,
“updatedAt”: “2014-02-22T15:42:38.166Z”
},
{
“createdAt”: “2014-02-21T16:45:52.550Z”,
“fbID”: “100001132788807”,
“lessonQuestions”: 5,
“lessonScore”: 1100,
“lesson_no”: 3,
“objectId”: “xgmJxEyBHl”,
“updatedAt”: “2014-02-22T18:14:38.107Z”
}
]

CSV – output.csv

createdAt, fbID, lessonQuestions, lessonScore, lesson_no, objectId, updatedAt
2014-02-20T18:15:56.818Z, 34534534534, 5, 2750, 2, htmsuPr6F6, 2014-02-22T15:42:38.166Z
2014-02-21T16:45:52.550Z, 100001132788807, 5, 1100, 3, xgmJxEyBHl, 2014-02-22T18:14:38.107Z

Ref: https://github.com/vladikk/json2csv

Published by

Sandeep Verma

I’m an Entrepreneur. I’m proud to work as Blogger, LAMP Programmer, Linux Admin, Web Consultant, Cloud Manager, Apps Developer, Searcher. Concentrate > Observe > Imagine > Launch

18 thoughts on “JSON2CSV – convert json files to csv”

  1. Thank you! Your script is very fast and simple to use! It was very useful for me!

  2. Right here is the right blog for anybody who wants to find out
    about this topic. You know so much its almost hard to argue with
    you (not that I personally would want to…HaHa).
    You definitely put a fresh spin on a topic which has been discussed for years.
    Excellent stuff, just wonderful!

  3. Awesome blog! Is your theme custom made or did you download it from somewhere?

    A theme like yours with a few simple adjustements would really make my blog stand out.

    Please let me know where you got your theme. Thanks a lot

  4. Good day! This is kind of off topic but I need some advice from an established blog.
    Is it very hard to set up your own blog? I’m not very techincal but I can figure things out pretty fast.

    I’m thinking about creating my own but I’m not sure where to begin. Do you have any tips or suggestions?
    Many thanks

  5. Its like you read my mind! You seem to know a lot about this, like you wrote the book in it or something.
    I think that you could do with some pics to drive the message home
    a little bit, but instead of that, this is excellent blog.
    An excellent read. I will definitely be back.

  6. Its like you read my mind! You seem to know a lot about this,
    like you wrote the book in it or something. I think that you
    can do with a few pics to drive the message home
    a bit, but other than that, this is great blog. A fantastic read.
    I will definitely be back.

  7. Greetings! I know this is somewhat off topic but I was wondering which blog platform are you using for this site?
    I’m getting tired of WordPress because I’ve had issues with hackers and I’m
    looking at alternatives for another platform.
    I would be awesome if you could point me in the direction of a
    good platform.

  8. Simply wish to say your article is as astounding.
    The clearness on your publish is just cool and that i can suppose
    you’re knowledgeable in this subject. Well along with your permission let me to clutch your RSS feed to stay up to date with impending post.
    Thank you 1,000,000 and please continue the gratifying work.

  9. It’s truly very difficult in this busy life to listen news on Television, therefore I
    just use the web for that reason, and get the newest information.

  10. Heya! I just wanted to ask if you ever have any problems with
    hackers? My last blog (wordpress) was hacked and I ended up losing many months of hard work due to no backup.

    Do you have any solutions to protect against hackers?

  11. Excellent post. I was checking constantly this blog and
    I am impressed! Very useful info particularly the last part 🙂 I care
    for such information a lot. I was seeking this certain information for a
    very long time. Thank you and best of luck.

  12. Hey I am so delighted I found your blog, I really found you by
    mistake, while I was searching on Google for something else, Regardless
    I am here now and would just like to say kudos for a remarkable post and a all round exciting blog
    (I also love the theme/design), I don’t have time to read it all at the minute but I have book-marked it and also added your RSS feeds, so when I have
    time I will be back to read more, Please do keep up the superb b.

  13. We are a bunch of volunteers and starting a new scheme in our community.
    Your site provided us with valuable info to work on. You have performed
    a formidable process and our whole group will probably be thankful to you.

Leave a Reply

Your email address will not be published.

*