Online tools to convert popular data formats. Persist your session for later, share with co-workers.

More tools

SQL to JSON    CSVJSON to JSON


CSV and JSON Data Formats

CSV and JSON are ubiquitous data formats for the Internet age.

CSV or Comma Separated Values is widely used for tabular data and often associated to spreadsheet applications like Excel. Many data reporting tool output to CSV format. TSV or Tab Separated Values is a close brother used in Clipboards to copy and paste table data to/From Excel for example. Find out more about CSV on the CSV to JSON page by scrolling below the text areas.

JSON or JavaScript Object Notation was specified by Douglas Crockford in the early 2000s. JSON has become the defacto computer format readable by humans to store structured data. From APIs to configuration files, JSON is now everywhere. Find out more about JSON on the JSON Beautifier page by scrolling below the text areas.

About CSVJSON

As a developer, format conversion is something I sometimes have to do. I often look online for solutions and tools finding they only cover partly my needs.

CSVJSON is a do-it-myself and more permanent solution. Its best feature? You can save your session for later, and share it with a co-worker.

If you find bugs or would like an improvement, please leave a comment below or open an issue on Github.

I hope it can be useful to you. Happy conversions!

--Martin

Change Log

2018-09-13

Added a new tool JSON Validator to validate and format JSON. Integrates a beautiful code editor (CodeMirror) with interactive JSON linting.

2018-04-03

Added a new tool CSVJSON to JSON to support conversion of the new CSVJSON format, a CSV variant proposed by Dror Harari.

2018-03-31

Improvements to CSV converters to support CSVJSON format variant (csvjson.org).

2018-01-24

Added a new converter: JSON to CSV.

New button to report a bug or ask for improvements.

2018-01-08

Support escaped quotes in SQL to JSON: GitHub issue #26. Thank you lbottoni for reporting.

2017-12-18

SQL to JSON parsing bug fix. Convert NULL to null.

Added a minify option to compact JSON by removing spaces and new lines. Fix for GitHub Issue #21. Thank you Myat Min Soe for requesting this feature.

2017-12-13

SQL to JSON parsing bug fix. Do not split when detecting a comma in a string value: GitHub Issue #25.

2017-10-07

Abimbola Idowu added single quote option. GitHub issue #23

2017-09-04

SQL to JSON parsing bug fix: GitHub Issue #22.

2016-09-27

CSV to JSON improvement: GitHub Issue #13 - Added option to parse number values or not to retain original number formatting.

2016-09-27

JSON Beautifier bug fix and improvement: GitHub Issue #12 - Inline short arrays bug fix and improvement. Added nesting depth option.

2016-08-29

SQL to JSON bug fix: GitHub Issue #11 - support multile values in single-line INSERT INTO statement.

2016-08-22

JSON Beautifier bug fix: Inline short arrays was not working properly. GitHub issue #9

2016-07-09

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

2016-06-20

CSV to JSON bug fix: strings containing quotes and commas were prematurely cut.

2016-03-19

Make the Github repository public again. Re-opened to community.

2015-11-25

Added options to CSV to JSON:

  • Transpose: You can now transpose the csv data before conversion.
  • Output object instead of array: By default an array of objects is output. You can now output an object or hash. The first column becomes the hash key.

Bugs and Feature Requests

Code available on Github. Report bugs or ask for improvements through Github issues.