Toolcedar

CSV to JSON Converter

Turn CSV into JSON in your browser. Handles quoted fields, embedded commas and line breaks, with a choice of delimiter and header row.

How to use the CSV to JSON Converter

  1. Paste your CSV. Drop in the rows, including the header line if you have one.
  2. Set the delimiter. Comma, semicolon or tab, depending on where the file came from.
  3. Copy the JSON. Copy the formatted array of objects straight out.

Frequently asked questions

Is my spreadsheet data uploaded anywhere?
No. Parsing happens entirely in your browser and nothing is transmitted, which matters for CSV in particular because exports so often contain customer or financial records.
Are quoted fields with commas handled?
Yes. Fields wrapped in double quotes may contain commas, line breaks and escaped quotes written as two double quotes in a row, which is what the CSV convention specifies.
Why are my numbers still strings?
Because CSV has no types, guessing them loses data. A leading-zero postcode or a long identifier becomes wrong the moment it is treated as a number, so values are kept as written unless you ask otherwise.
What happens if a row has too few columns?
Missing trailing fields become empty strings rather than being dropped, so every object keeps the same shape and downstream code does not have to test for absent keys.

Learn more

Related tools

Last updated