JSON conversion
JSON to CSV
Convert a JSON array into a downloadable CSV file.
What is JSON to CSV?
Turn an array of JSON objects into CSV without uploading it. Nested object values become dot-notated columns; arrays are preserved as JSON inside a CSV cell.
How to use JSON to CSV
- Paste a top-level JSON array of objects.
- Select Convert to CSV.
- Review columns before copying or downloading the CSV.
Example
[{"name":"Ada","age":36}] →
name,age
Ada,36Limitations and details
Nested objects use dotted column names, which can collide with literal dotted keys. Arrays become JSON text in cells; null and missing values become empty cells. Formula-like values are prefixed with an apostrophe for spreadsheet use, which changes the cell text. JavaScript numeric precision applies.
Frequently asked questions
What JSON format is supported?
Use a top-level array of objects. Nested objects become dot-notated CSV columns.
Are arrays lost?
No. Array values are stored as JSON text in their CSV cell.