Convert your CSV or TSV formatted data to JSON. Optionally transpose your data, or output an object instead of an array. Copy/paste or upload your Excel data to convert it to JSON.

     

Ctrl + A then Ctrl + C to copy to clipboard.

About CSV

  • CSV stands for Comma Separated Values. Often used as an interchange data format to represent table records, one per line. CSV is plain text.
  • The first line is often the header, or column names. Each subsequent row is a record and should have the same number of fields.
  • Fields containing the separator character, line breaks and double-quotes must be enclosed inside double quotes ".
  • Other separator are often used like tabs \tor semi-colons ;. TSV or Tab Separated Values is used to store table data in Clipboards. When data is copied from Excel for example, it is stored as TSV in the Clipboard.
  • You can transpose the csv before conversion. Rows become columns, and columns become rows.
  • You can also output a hash (or object) instead of an array. In that case, the hash key will be the first column.

Change Log

  • 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.

Feedback

Code available on Github. Report bugs or ask for improvements either through Github issues or by writing a Disqus comment.