CSV to JSON
Parse comma-separated data into clean JSON objects
Quoting, delimiters and type inference
- Records split on CRLF or LF, fields on comma/semicolon/tab — the delimiter is sniffed from your first line.
- RFC 4180 quoting is honoured: doubled quotes become literal quotes, and commas inside quotes never split a field.
- Cells that look numeric become JSON numbers; leading-zero codes (007) stay strings so you do not lose them.
CSV has dialects; this one speaks RFC 4180
Delimiters detected for you
Comma, semicolon, tab and pipe are all auto-detected from your data, with a manual override — European and Asian exports parse without setup.
Headers become object keys
The first row turns into JSON property names automatically, and every following row becomes an object — clean output ready for code.
Numbers stay numbers
"42" becomes a number, "true" becomes a boolean, and ambiguous strings are preserved as text — the JSON stays true to your data.
Frequently asked questions
How are quoted fields handled?
Fields wrapped in double quotes may contain the delimiter, newlines and escaped quotes ("…""…") exactly as the CSV spec requires; the parser returns them as a single clean value.
Can I control the output shape?
Yes. By default the first row becomes the object keys and each following row an object. Turn that off to get an array of arrays, or edit the generated text manually before copying.
Is my CSV uploaded anywhere?
No. Everything runs in your browser with plain JavaScript — nothing you paste is transmitted or stored.
Why does my file import with a strange character in the first cell?
That is a UTF-8 BOM exported by Excel. It rides invisibly before the first header name. This tool strips it before parsing; if you pipe the JSON onward, the first key comes out clean.
Related tools
What is a CSV to JSON converter?
A CSV to JSON converter parses plain comma-separated (or tab-separated, semicolon-separated, pipe-separated) text and rebuilds it as structured JSON objects. CSV is the most common interchange format for legacy systems, spreadsheets and bulk exports, but most code prefers JSON. This tool handles the fiddly parts of real-world CSV correctly: quoted fields, embedded commas, escaped quotes, multi-line values, and columns whose values are numbers or booleans.
What it can do
- Auto-detect comma, semicolon, tab or pipe delimiters
- Use the first row as object keys — or emit arrays of arrays
- Parse quoted fields, embedded commas and doubled escaped quotes
- Convert numeric and boolean strings into native JSON types
- De-duplicate repeated column names so keys stay unique
- Download or copy the indented JSON result
When to use it
- Turning a spreadsheet export into API-ready JSON
- Loading DB-dump CSV into JavaScript or Python code
- Republishing legacy feeds as modern structured data
- Migrating data out of government or banking CSV formats
Privacy: the conversion happens entirely in your browser — nothing you paste is ever uploaded.