How the converter works
- Every object in the array becomes one row; every distinct key becomes a column.
- Nested objects are flattened into dot-notation columns, e.g.
address.city. - Arrays of simple values are joined with semicolons in one cell.
- Cells with commas, quotes or line breaks are quoted and escaped as defined in RFC 4180.
- If your JSON is an object that contains an array, that array is used.
Opening the CSV in Excel
Excel in many European locales expects semicolons — choose the semicolon delimiter there. For other tools, comma is standard. Download the file with the Download button and open it directly.
Need the opposite? Use the CSV to JSON Converter. To tidy the JSON first, use the JSON Formatter.
Frequently asked questions
Is my data uploaded?
No. The conversion runs entirely in your browser.
What happens to nested arrays of objects?
Their items are flattened with numeric indexes, for example items.0.sku and items.1.sku.
Which delimiter should I use for Excel?
Comma works in most English-language setups; use semicolon if Excel puts everything in one column.