Turnkey CSV ImporterInstalls in minutes

Beautify your JSON.

To get started, upload or paste your JSON.


Download Save Copy to clipboard

Need help cleaning data?

Embed all the functionality of csvjson in any web application with Flatfile. Auto-match columns, validate data fields, and provide an intuitive CSV import experience.

More Details

  • This function is available as a npm package.
  • JSON stands for JavaScript Object Notation. It is a lightweight data-interchange format and fully described on www.json.org.
  • JSON is based on JavaScript but the format is stricter. JSON requires double quotes around keys whereas JavaScript does not.
  • Modern browsers have a built-in global object JSON with encoding and decoding functions. These are:
    • JSON.stringify to encode a JavaScript object into a JSON string; and
    • JSON.parse to parse a JSON string and convert it to a JavaScript object.
    To support older browsers, use JSON2 written by Douglas Crockford as polyfill.
  • CSVJON uses a modified version of JSON2 which adds formatting options to drop quotes on keys, and sepcify the quote type. Anyone is free to use and extend it by forking the CSVJSON GitHub repo.

Mar 20, 2019

Bug fix: Detect duplicate column headers and make them unique. GitHub issue #71.

Feb 2, 2019

Refactored and published npm package csv2json. Fix for GitHub issue #70.

Jan 26, 2019

Improvement: Removed 64k limit on download button. Also fixed issue #68 'Cannot work functional with special letters'.

Mar 31, 2018

Improvement: Added option to parse JSON values.

Dec 18, 2017

Improvement: Added option to minify or compact JSON. GitHub issue #21

Oct 7, 2016

Improvement: Added option to parse number values or not to retain original number formatting. GitHub issue #13

Jul 09, 2016

Fixed bug : If no text is present in a csv field, it was assigned 0 (zero) by default.

Jun 20, 2016

Bug fix: strings containing quotes and commas were prematurely cut.

Dec 30, 2015

Bug fix: drop quotes on keys of nested objects.

Nov 26, 2015

Improvement: Added options to transpose and output object instead of array.

Jan 30, 2014

Bug fix: Pasting Excel data into Textarea would cause an upload.

Jan 12, 2014

Initial release.

Jun 25, 2019

Adjustable width for inling short arrays. Fix for issue #76.

Feb 3, 2019

Refactored and published npm package json_beautifier.

Jan 26, 2019

Improvement: Removed 64k limit on download button.

Dec 18, 2017

Improvement: Added option to minify or compact JSON. GitHub issue #21

Oct 7, 2017

Improvement: Abimbola Idowu added single quote option. GitHub issue #23

Sep 27, 2016

Bug fix: Inline short arrays bug fix and improvement. Added nesting depth option. GitHub issue #12

Aug 22, 2016

Bug fix: Inline short arrays was not working properly. GitHub issue #9

Dec 30, 2015

Bug fix: drop quotes on keys of nested objects.

Jun 1, 2015

Bug fix: proper support of commas inside quotes.

Jan 12, 2014

Initial release.