88 · Text Tools

CSV to JSON Converter

Paste CSV, or copy cells straight from a spreadsheet, to get a JSON array of objects.

How to use the csv to json converter

  1. Paste CSV or copied spreadsheet cells.
  2. Check the delimiter and header options.
  3. Copy the JSON.

Details

  • Quoted values can contain commas, quotes (written as "") and line breaks.
  • Spreadsheet cells paste as tab-separated values, which are detected automatically.
  • With number conversion on, empty cells become null.

Examples

name,age\nAda,36

[{"name": "Ada", "age": 36}]

"Lee, Jr.",29

"Lee, Jr." stays one value

Questions

Is my data uploaded?

No. Conversion happens entirely in your browser.

What if there’s no header row?

Untick the header option to get an array of arrays.