Convert

CSV / JSON Converter

?

About CSV/JSON conversion

How are commas or quotes inside a CSV field handled?
Standard CSV quoting rules (RFC 4180) apply in both directions: a field containing the delimiter, a quote, or a newline is wrapped in double quotes, with any internal quote doubled ("") to escape it.
Does CSV → JSON infer numbers or booleans?
No — every CSV value becomes a JSON string, unchanged. That's deliberate: auto-detecting types would silently turn a zip code like "02134" into 2134, or an ID column into a number that loses precision. Convert the JSON output's fields yourself if you need real numbers.
What happens to nested objects or arrays when converting JSON → CSV?
CSV is flat, so a nested object or array value is stringified as its own JSON snippet inside that cell rather than expanded into extra columns.
What if my CSV has no header row?
Turn off "First row is a header". Not every CSV names its columns, and with the option on the first line of a headerless file would be read as column names and disappear from the data. With it off, CSV → JSON gives you an array of arrays — one array per row, values in column order — rather than an array of objects. It deliberately does not invent names like "column1": a file with no header has no key names, and made-up ones would look like they came from your data.
How do I convert JSON back to CSV without a header row?
The same option controls it. An array of arrays is written out as plain rows, so a headerless file survives a round trip unchanged. An array of objects still uses its keys for column order, but with the option off the row of column names is left out.
What if my JSON records have different keys?
The header row is the union of every key seen across all records, in first-seen order. Records missing a given key just get an empty cell for it.
Can I use a different delimiter, like semicolons or tabs?
Yes — the delimiter selector applies to both reading CSV input and writing CSV output.
Does this tool upload my data anywhere?
No. Parsing and conversion happen entirely in your browser with hand-written code — no network calls. Nothing you paste ever leaves your device.

Convert between CSV and JSON, with or without a header row.

input chars
0
output chars
0
status
idle