JSON to CSV | How to use and interpret results
Collect keys across a JSON array of objects to build CSV columns. A property that appears only in a later row still becomes a column for comparing uneven records.
- Runs in your browser
- Nothing is uploaded
- No signup; device limits apply
Loading the tool. If it does not appear, reload this page.
How to use this tool
Paste a top-level array of objects. Nested objects become JSON text in cells rather than separate flattened columns, so check that the layout matches your purpose.
Results and examples
[{"name":"A"},{"name":"B","score":2}] creates name and score columns, leaving A's score blank. Cells containing commas or quotes use CSV quoting.
Worked example
[{"name":"A"},{"name":"B","score":2}] creates name and score columns, leaving A's score blank. Cells containing commas or quotes use CSV quoting.
Limitations
- Nested relationships are not normalized into multiple tables.
- Before opening in a spreadsheet, consider safe text handling for cells that resemble formulas.
Fields
| Field | Guidance and constraints |
|---|---|
| JSON (array of objects) | Check the unit and format displayed beside this field. |
| CSV | Check the unit and format displayed beside this field. |
Data handling
Processing stays in the current browser tab; the site does not upload tool input for the calculation itself.
Sources
Frequently asked questions
Will a key found only in a later row be included?
[{"name":"A"},{"name":"B","score":2}] creates name and score columns, leaving A's score blank. Cells containing commas or quotes use CSV quoting.
Can I open the output directly in a spreadsheet?
Nested relationships are not normalized into multiple tables. Before opening in a spreadsheet, consider safe text handling for cells that resemble formulas.
