What happens to an empty cell?

It becomes null rather than an empty string, so a missing value stays distinguishable in the JSON. Switch Types to “Keep as text” if you would rather see “” everywhere.

Are rows with too few columns dropped?

No, every row is padded out to the widest one, and the count of ragged rows is reported.

Does it handle a line break inside a field?

Yes. The parser walks the input one character at a time instead of splitting on commas, so a quoted field can run across several lines and keeps them. A CRLF inside such a field is normalised to a single newline. This is precisely where naive converters shred postal addresses and free-text notes.

CSV to JSON

No upload · runs in your browser

Delimiter

Header

Types

CSV in

0 characters

JSON out

Runs entirely in your browser, nothing is uploaded.

How it works

CSV to JSON Converter: RFC 4180 Quoted Fields Handled

Paste a CSV, TSV or semicolon export and get clean JSON back. Quoted fields, escaped quotes and line breaks inside cells are parsed properly instead of being split on commas.

What this does

A quoted field can hold the delimiter, a doubled quote or a line break, all preserved
Comma, semicolon, tab or pipe delimiters, for European exports and for TSV
Three output shapes: indented objects, minified objects, or every row as an array
Blank or duplicated header names are renamed to column_3 and name_2, and the count is reported
Empty cells become null, and ragged rows are padded out to the widest row and flagged
Coercion refuses to touch a leading zero or an integer past 2^53, so long IDs stay intact
An unterminated quote reports the line and column where it opened

FAQ

Because coercion is deliberately conservative. A value only becomes a number if it matches a strict pattern that forbids a leading zero, so 01234 stays the string “01234”. Any whole number beyond JavaScript’s exact integer range, 9,007,199,254,740,991, is kept as a string as well, which is what saves long order numbers and account IDs from quietly losing their last digits. Set Types to “Keep as text” and nothing is converted at all.

Keep going