csv to json converter

Scroll Down and click on Continue button for destination

Congrats! Link is Generated

CSV to JSON converter on GoojDex

Deep to

Convert CSV/JSON to fully compliant JSON/CSV and back again.

Toggle Info

• Import/export fully compliant JSON/CSV, maintaining full JSON structure
  • Tested with Google Sheets / MS Excel import + export
  • #TODO: support cell new-lines! Update: new-lines now work as expected
  • #TODO: test everything else / check the actual spec
  • #TODO: refactor / optimise into a library
• Standard CSV formatting applies (e.g. double-double quotes inside a cell in raw CSV)
• CSV format has been extended to allow for JSON data types: array/object/number/boolean
  • Arrays/{key:value pairs} are (enclosed) and can be ((nested)) == ['enclosed'], [['nested']]
  • Simple arrays can also be encoded unenclosed with newlines (currently a one-way encoding): a\nb\nc == ['a','b','c']
  • {key:value pairs} are delimited by a colon: (key:val) == { key: 'val' }
  • Objects are made of repeated {key:value pairs}: (a:val)(b:val) == { a: 'val', b: 'val' }
  • Content with commas inside of an array/object (is, "double-quoted, like this") == ['is', 'doubled-quoted, like this']
  • Booleans are (strings:true) with (quotes:false) == { strings: true, quotes: false }
  • Numbers are unquoted: (answer: 42) == { answer: 42 }
• This is a first attempt, coded from scratch in code pen. Feel free to fork and fix.

Upload

[ { "name": "Soursop", "url": "https://en.wikipedia.org/wiki/Soursop", "aka": [ "Custard Apple", "Graviola" ], "price": 1.45, "unit": "kg", "meta": { "notes": "heir apparent to the \"fruit\" throne", "tastes": [ "sour", "sweet", "acidic, yes" ] }, "description, etc.": "an enchanting tropical fruit", "grown": "", "awesome": true }, { "name": "Mangosteen", "url": "https://en.wikipedia.org/wiki/Purple_mangosteen", "aka": "Purple Mangosteen", "price": 5.45, "unit": "kg", "meta": { "notes": "the god of fruit", "other prices": [ 6.2, 10.65 ] }, "description, etc.": "", "grown": [ "Southeast Asia", "Australia" ], "awesome": true } ]

Powered by Dev Solutions

Clicking on the Continue button will redirect you to the Google search page. Click our site, goojdex.blogspot.com, from the first search result to get your link.