CSV To JSON Converter and Download

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 codepen. Feel free to fork and fix.

Upload