CSV to JSON
- RFC 4180
- Type inference
- Nothing uploaded
Rows to records, with proper handling of quotes, newlines and delimiters.
Paste input on the left to see json.
Everything runs in your browser — nothing is uploaded.
About csv to json
Converting CSV to JSON turns rows into records. JSONic uses an RFC 4180 parser, so quoted fields, doubled quotes and newlines inside values all parse correctly. Type inference is deliberately conservative: 01234 stays a string, because leading zeros almost always indicate an identifier rather than a number.
Most CSV-to-JSON converters split on commas, which breaks the moment a field contains one. This uses a real RFC 4180 parser: quoted fields, doubled quotes inside them, and newlines inside quoted values are all handled. Type inference is optional and deliberately conservative — it will not turn a zip code of 01234 into the number 1234.
Questions
Does it handle commas and newlines inside fields?
Yes. Quoted fields are parsed properly, including doubled quotes as an escaped quote and literal newlines inside a quoted value.
What does type inference convert?
Plain integers and decimals, true, false, null, and empty cells to null. Numbers with leading zeros are left as strings, because those are almost always identifiers rather than quantities.
Can I use tabs or semicolons as the delimiter?
Yes — the delimiter is configurable, so TSV and semicolon-separated exports from European locales both work.