JSON to CSV
Turn an array of JSON objects into CSV. Choose the delimiter, flatten nested keys, and protect against spreadsheet formulas.
Runs entirely in your browser. Nothing you type is uploaded, stored or sent to analytics.
Limit reached: only the first 1,000,000 characters are kept. Split the data into smaller parts.
About this tool
- Works best with an array of objects: each object becomes a row and each key a column. A single object becomes one row.
- Nested objects are flattened into columns such as address.city; arrays are kept as JSON text in a single cell.
- Cells that start with =, +, - or @ can run as formulas when a CSV is opened in a spreadsheet. By default they are prefixed with an apostrophe to prevent that; real JSON numbers such as -5 are left alone.
- Follows RFC 4180 quoting. Downloads include a UTF-8 byte order mark so Excel reads accents correctly.
Limits
To keep your browser responsive, input is limited to 1,000,000 characters, 200 levels of nesting and 300,000 values.