Back to home

CSV to JSON

Convert tabular data both ways, with the delimiter detected automatically

Delimiter
CSV
0 chars0 bytes0 lines
JSON
The result shows up here

Powered by Papa Parse, so quotes, embedded newlines and escaped quotes are handled correctly. With the delimiter set to Auto it is inferred from the first row.

FAQ

How are commas and line breaks inside fields handled?

Per RFC 4180, fields containing commas, line breaks or quotes are wrapped in double quotes, and embedded quotes are doubled. The delimiter is detected automatically.

Why does my Chinese CSV look garbled in Excel?

Usually an encoding issue: Excel prefers UTF-8 with BOM. Use Data → From Text and pick UTF-8 explicitly, or re-save the file as UTF-8 with BOM.