About JSON to CSV
Use the JSON to CSV converter to prepare records for a spreadsheet or data import. You can convert a JSON array to CSV with columns drawn from all rows. Missing properties become empty cells, while nested objects and arrays are serialized as JSON text inside a cell.
How to convert JSON objects into a CSV table
- Paste a JSON array containing objects with named properties.
- Keep formula-cell protection enabled unless your trusted workflow requires otherwise.
- Select Process, inspect the table text, and download converted.csv.
A practical example
- Input
[{"name":"Ada","count":2}]- Result
name,count Ada,2
The object keys become column headers and the object becomes one CSV row.
Supported input and limitations
- Input must be an array of objects. Limits are 5 MB of input, 100,000 rows, 1,000 columns, and 1,000,000 output cells.
- Nested objects are not flattened into dotted columns. CSV does not preserve a full JSON type schema.
Processing happens on your device. Read about local processing and optional workspace recovery.
Frequently asked questions
Can I convert nested JSON to CSV?
Nested objects and arrays are kept as JSON strings inside cells. This tool does not expand them into separate columns or additional rows.
Why is an apostrophe added before a CSV formula?
Formula-cell protection prefixes risky spreadsheet-like values to reduce formula execution when the CSV is opened. It can change cell text; review the output for your destination.