Data & CSV
JSON to CSV
Convert a JSON array of objects into a downloadable CSV.
A clear answer. Here’s how.
Collects the union of object keys as headers. Missing and null values become empty cells; nested objects and arrays are serialised as JSON. Formula protection prefixes cells beginning with =, +, − or @, including after whitespace. Spreadsheet applications vary in how they interpret imported CSV.
See a worked example
Worked example
A fixed demonstration, separate from the values you enter above.
- JSON array of objects
- [{"name":"Ada","score":95},{"name":"Sam","score":88}]
- Spreadsheet formula protection
- On — prefix potentially active cells with an apostrophe
Example result
| name | score |
|---|---|
| Ada | 95 |
| Sam | 88 |
Spreadsheet formula protection is on.