Structured data
CSV to JSON
Convert real CSV rows without breaking delimiters or line breaks inside quoted fields.
Processed locally. Your input and output are never uploaded.
Tool overview
Why reliable CSV parsing matters
A state-machine parser handles comma, semicolon, tab, pipe, or custom delimiters along with double-quoted values, doubled quotes, embedded newlines, and a UTF-8 BOM. Output can be objects keyed by headers or arrays.
Turn spreadsheet exports into JSON records
- Turn spreadsheet exports into API fixtures
- Parse multiline quoted fields
- Generate headers for headerless data
- Opt into number, boolean, and null conversion
Parse quoted CSV before conversion
- Paste CSV or open a local file.
- Detect or select the delimiter and header mode.
- Keep strings preserved or enable explicit type conversions.
- Preview and download the JSON.
Delimiter, headers, trimming, and type conversion
- Preserve strings is the safe default.
- Generated headers use column_1, column_2, and so on.
- Duplicate headers receive unique numeric suffixes.
- Empty cells can remain empty strings or become null.
Preserve commas and newlines inside cells
Before
name,note Ana,"Hello, world" Bo,"Line 1 Line 2"
After
[
{
"name": "Ana",
"note": "Hello, world"
},
{
"name": "Bo",
"note": "Line 1\nLine 2"
}
]Malformed quotes and uneven rows
- Malformed or unclosed quotes produce an error.
- Rows shorter than the widest row receive empty cells.
- Automatic delimiter detection prioritizes consistent multi-column rows.
Browse all structured data tools →
Questions
CSV to JSON FAQ
Does it use split on commas?
No. It uses a quote-aware parser that preserves commas and newlines inside quoted fields.
Will 001 become the number 1?
Not by default. Preserve strings is enabled to protect identifiers and leading zeroes.