CSV to JSON converter
Paste a spreadsheet export or an API response. Quotes, commas inside fields and newlines are all handled.
Häufige Fragen
How are quotes and commas inside a field handled?
To the CSV standard (RFC 4180). A field wrapped in double quotes can contain commas, line breaks and doubled quotes ("") for a literal quote. Going the other way, fields are only quoted when they need it, so the output stays readable.
Why is my ID with leading zeros still a string?
On purpose. 0123 stays text because turning it into the number 123 would lose the zero, which matters for IDs, postcodes and phone numbers. Only plain numbers are converted, and you can switch the conversion off entirely.
What if rows have different fields?
Going from JSON to CSV, every key found anywhere becomes a column, in the order the keys first appear. Rows without that key get an empty cell. Nested objects and arrays are written back as JSON inside the cell.