📊 CSV to JSON Converter
Paste or open a CSV and get JSON records instantly — headers become keys, numbers and booleans stay typed, and the delimiter is auto-detected.
2 records, 3 fields (delimiter: ",")
How the csv to json converter works
The parser follows the RFC 4180 conventions: fields may be quoted, quoted fields may contain commas, newlines and doubled quotes ("" means one quote character). With headers on, each subsequent row becomes an object keyed by the header names; values that look like numbers, booleans or null are emitted as real JSON types rather than strings. Auto-detect samples the first lines to pick comma, semicolon, tab or pipe.
The two classic CSV traps are both handled: quoted fields containing commas ("Doe, Jane" stays one field), and European Excel exports, which use semicolons because the comma is the decimal separator in those locales. If a conversion ever looks like one giant column, that is the delimiter — switch it manually.
Frequently asked questions
Why does my CSV come out as one column?
Wrong delimiter — most often a semicolon-delimited Excel export (standard in European locales) read as comma. Auto-detect handles it; the delimiter dropdown overrides it explicitly.
How are commas inside values handled?
Per RFC 4180: fields wrapped in double quotes may contain commas and even newlines; a doubled quote ("") inside means a literal quote. The sample data demonstrates it.
Do numbers stay numbers?
Yes — values that parse as numbers, true/false or null become real JSON types. Long digit strings (IDs, phone numbers) above 15 digits stay strings to avoid precision loss.
What if my CSV has no header row?
Untick "first row is headers" — you get an array of arrays, or objects with column_1, column_2… if you keep the objects shape.
Is there a size limit or upload?
Neither — conversion is local and instant even for large exports. Business data never leaves your machine.