CSV to JSON
Parse CSV (or TSV) into JSON, with delimiter detection, type inference and a table preview.
About CSV to JSON
CSV is the common exchange format for spreadsheets and databases; JSON is what APIs and programs prefer. This tool parses CSV according to RFC 4180, handling commas and line breaks inside quoted fields, and prints structured JSON.
When you would use it
- Feeding an export from Excel or Google Sheets into an API or a front-end.
- Checking a CSV in the table preview to confirm the columns line up before using it.
- Turning a database export into JSON for fixtures or configuration.
How to use it
- Paste the CSV into the input; the delimiter is detected automatically.
- Check the table preview, paying attention to fields that contain commas.
- Adjust the options as needed: header row, type conversion, trimming.
- Copy the JSON from the output below.
Things worth knowing
- A field containing a comma, a line break or a double quote must be wrapped in double quotes, with inner quotes doubled. The parser restores such fields correctly.
- Type conversion is deliberately conservative: values such as 007, 1.0 and integers beyond the safe range stay strings so nothing is silently altered.
- If detection picks the wrong delimiter, set it manually. Semicolons are common in Excel exports from Europe.
- Everything is parsed in your browser; no data is uploaded.
Frequently asked questions
- Why do non-ASCII characters show up as garbage?
- That is a file encoding problem rather than a parsing one. Excel often exports CSV in a regional encoding or UTF-8 with a BOM. Re-save the file as UTF-8 in a text editor and paste it again.
- Can I convert JSON back to CSV?
- Yes, with the JSON to CSV tool. Both sides follow RFC 4180 quoting, so a round trip preserves the values.