Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

CSVJSON – Self Rise of an Online Tool

medium.com

Post reply on HN
Print view View original

1–10 of 36 posts

Re: CSVJSON – Self Rise of an Online Tool

#2

Post by HoyaSaxa »

Coincidentally, I used this today for the first time. It was the 2nd result on Google for me, but was far superior to the first in ease of use. Thanks for your contribution and good luck going forward. My use case today was to create a fixture of initial data for a django app from csv. Oddly enough I wasn't able to find a specialized online tool to create the django fixture and was forced to use your tool along with some manual hacking.

Re: CSVJSON – Self Rise of an Online Tool

#3

Post by kawera »

Thanks, I've used your tool a few times and it works beautifully. Quite interesting article too from the SEO pov.

BTW, does anyone know of a tool to do the reverse? I have some json files with deeply nested arrays and would like to output a csv file with one line for each "leaf". I can write it myself but would be happy to use an existing tool.

Re: CSVJSON – Self Rise of an Online Tool

#4

Post by martin_drapeau »

kawera wrote: post #3

Thanks, I've used your tool a few times and it works beautifully. Quite interesting article too from the SEO pov. BTW, does anyone know of a tool to do the reverse? I have some json files with deeply nested arrays and would like to output a csv file with one line for each "leaf". I can write it myself but would be happy to use an existing tool.

I suggest you go to Github and open an issue: https://github.com/martindrapeau/csvjson-app/issues From there, I'll be happy to code it.

Re: CSVJSON – Self Rise of an Online Tool

#5

Post by martin_drapeau »

HoyaSaxa wrote: post #2

Coincidentally, I used this today for the first time. It was the 2nd result on Google for me, but was far superior to the first in ease of use. Thanks for your contribution and good luck going forward. My use case today was to create a fixture of initial data for a django app from csv. Oddly enough I wasn't able to find a specialized online tool to create the django fixture and was forced to use your tool along with…

Glad it was helpful. And thanks for the nice comment.

Re: CSVJSON – Self Rise of an Online Tool

#6

Post by matthewmacleod »

kawera wrote: post #3

Thanks, I've used your tool a few times and it works beautifully. Quite interesting article too from the SEO pov. BTW, does anyone know of a tool to do the reverse? I have some json files with deeply nested arrays and would like to output a csv file with one line for each "leaf". I can write it myself but would be happy to use an existing tool.

jq (https://stedolan.github.io/jq/) is a great tool for general JSON manipulation. It includes a CSV export filter, so you can run commands like:

  jq -r '. | map(.key), map(.value) | @csv'
which will output a JSON array as CSV.

Re: CSVJSON – Self Rise of an Online Tool

#7

Post by jsnell »

kawera wrote: post #3

Thanks, I've used your tool a few times and it works beautifully. Quite interesting article too from the SEO pov. BTW, does anyone know of a tool to do the reverse? I have some json files with deeply nested arrays and would like to output a csv file with one line for each "leaf". I can write it myself but would be happy to use an existing tool.

One that I wrote a while ago, which might or might not do what you want: https://github.com/jsnell/json-to-multicsv

Note that the mapping from nested / hierarchical JSON file to CSV file(s) is not as obvious as it is the other way around. There's some configuration involved. I wrote a blog post about that particular aspect: https://www.snellman.net/blog/archive/2016-01-12-json-to-mul...

Re: CSVJSON – Self Rise of an Online Tool

#8

Post by hayksaakian »

from 15000 quality page views you should expect at least $15 of revenue ($1 CPM) even higher numbers from developers (valuable users).

Check out something like https://carbonads.net/ and it might at least pay for your hosting. It's invite only though, so you might have to ask for an invitation.

Re: CSVJSON – Self Rise of an Online Tool

#10

Post by yareally »

kawera wrote: post #3

Thanks, I've used your tool a few times and it works beautifully. Quite interesting article too from the SEO pov. BTW, does anyone know of a tool to do the reverse? I have some json files with deeply nested arrays and would like to output a csv file with one line for each "leaf". I can write it myself but would be happy to use an existing tool.

> BTW, does anyone know of a tool to do the reverse?

I created a java/scala library[1] (source is scala, but there's a jar with dependencies for java) a few years ago for an Android app I was hired to work on that converts nested JSON to CSV. I was allowed to open source the library later on and released it under the MIT License, so anyone can use it now.

Never thought anyone else would ever need to convert json to csv, but I guess I was wrong :)

I don't have a use case for it anymore, so I haven't maintained it, but if someone wants to update it, feel free to send a pull request.

[1] https://github.com/yareally/json-to-csv

Post reply on HN