JSON to CSV Converter
Turn a JSON array of objects into clean CSV — header and all.
Waiting for input…
Each object becomes a row; the header is the union of every key seen. Nested objects and arrays are written as compact JSON inside the cell. Cells containing the delimiter, quotes, or newlines are quoted per RFC 4180.
How to convert JSON to CSV
Paste your JSON array into the box and pick a delimiter — comma, semicolon, or tab. The CSV appears below with a header row built from your keys, ready to copy or paste into a spreadsheet.
Why a header union
Real-world JSON often has rows with slightly different keys. Taking the union means every field gets a column and no value is dropped, with blanks where a row didn't include that key.
Questions
What JSON shape does it expect?
An array of objects, where each object becomes one row. The header is the union of every key seen across the objects, so rows with missing keys simply get an empty cell. A single object is treated as a one-row table.
How are nested values handled?
Nested objects and arrays are written as compact JSON inside the cell, so no data is lost. If a value contains the delimiter, a quote, or a newline, the whole cell is wrapped in quotes per RFC 4180.