Turning a JSON array into CSV sounds trivial until two objects have different shapes, or a value contains the character you’re about to use as a delimiter. Our new JSON to CSV Converter handles both correctly instead of quietly producing a broken file.
- Union of keys, not just the first object’s keys — the header row covers every key that appears anywhere in the array. Objects missing a given key get an empty cell instead of breaking the conversion.
- Nested objects flattened to dot notation —
{"user":{"name":"Ada"}}becomes a column literally nameduser.name, so no data is silently dropped or turned into[object Object]. - Quoting only when necessary — a field is wrapped in double quotes exactly when it contains the delimiter, a double quote, or a newline, with any internal quote doubled. This is the write-side mirror of a correct CSV parser, and it’s what makes round-tripping possible.
- Comma, semicolon, or tab — pick the delimiter your target spreadsheet expects.
- Private by default — conversion happens in plain JavaScript in your own browser; nothing you paste is ever sent to a server.
Paste the output straight into our CSV to JSON Converter and you’ll get your original data back — we test that exact round trip on every release.