JSON to CSV Converter
Turns a JSON array of objects into a comma-separated table you can open in a spreadsheet.
Results
What this tool does
An API gives you JSON and the person who asked for the data wants a spreadsheet. The conversion only makes sense when the JSON is a list of objects with more or less the same shape — that is the part that looks like a table. Fields are quoted the way RFC 4180 requires, so a value containing a comma, a quote or a line break survives the trip into Excel or Numbers intact.
Formula
each object in the list becomes a row ; the union of the fields becomes the header
Variables
| Symbol | Meaning | Unit |
|---|---|---|
text | JSON | — |
delimiter | Separator | — |
OUT | CSV | — |
RW | Rows | — |
CL | Columns | — |
Worked example
- JSON[{"nome":"Ana","idade":30},{"nome":"Bruno","idade":41}]
- Separator,
- CSVnome,idade Ana,30 Bruno,41
- Rows2
- Columns2
Limitations
- The calculation runs entirely in your browser. The values you type are never sent to a server.
Frequently asked questions
What if the objects have different fields?
The header is the union of every field that appears anywhere in the list, in the order first seen, and any row that lacks one of them gets an empty cell. Nested objects and arrays are a different matter: a table has no room for them, so they come out as their raw JSON in the cell. If that is not what you want, flatten the structure before converting.