Convert JSON to CSV
Turn an API response into a spreadsheet.
About this converter
The usual reason is that someone who does not write code needs to look at an API response. CSV opens in Excel, Numbers and Sheets; JSON does not.
The hard part is that JSON is a tree and a table is not, so something has to give. A nested object becomes dotted columns — address.city, address.postcode. A list of plain values is joined into one cell, because three tags do not deserve three columns. A list of objects gets numbered columns instead, because joining those would throw the structure away.
If your JSON is an object wrapping a single list — which is the shape of most API responses — the list is used as the rows, and the page says which key it took them from. That is almost always what you meant, and it is the thing most converters get wrong by producing one row with an enormous cell in it.
Frequently asked questions
What happens to nested objects?
They become columns named with a dot: an object under "address" with "city" and "postcode" inside it produces address.city and address.postcode. It is the convention spreadsheets and flattening libraries both use, and it survives a round trip back through the CSV-to-JSON page.
Why do some rows have blank cells?
Because the columns are the union of every record's keys. JSON does not require every object in a list to have the same fields, and a table does — so a record missing a field gets an empty cell rather than being dropped or shifted.
My JSON is an object, not a list. What happens?
If it holds exactly one key and that key contains a list, the list becomes the rows — that is the shape of nearly every API response. Otherwise the object itself becomes a single row, which is usually what you want for a config file.
Does what I paste get sent anywhere?
No. The conversion runs in your browser, on your own machine — which is why the result appears as you type. Nothing is uploaded and nothing is logged. That matters for this kind of tool in particular: config files and API responses are exactly the things that carry keys, hostnames and customer data.