JSON is how APIs and web apps hand over data, but it is awkward to read, sort or filter by eye. Converting it to CSV gives you a table: one row per record, one column per field, ready for a spreadsheet.
What JSON does it accept?
An array of flat objects, which is what most APIs and exports produce:
[
{ "id": 1, "name": "Anna", "city": "Utrecht" },
{ "id": 2, "name": "Ben", "city": "Gent" }
]
Every key found in any object becomes a column, in the order the keys first appear. Each object becomes one row. A single object on its own is treated as a one-row table. JSON whose records sit under a property such as "data" or "results" needs to be reduced to the array first: copy the array out in a text editor, or ask the API for the list directly.
What if my objects have different keys?
That is fine. The columns are the union of all keys, so an object that lacks a field simply gets an empty cell in that column. Records from APIs where optional fields come and go convert without any preparation.
What happens to nested data?
CSV is a flat table, so it cannot hold objects inside objects or lists. A nested value is written into its cell as compact JSON, such as {"city": "Gent"} or ["red", "blue"]. Nothing is lost, and you can parse it back later, but for analysis in a spreadsheet you will usually want to flatten it first, for example turning "address": {"city": "Gent"} into "address_city": "Gent".
Is the output Excel-friendly?
The CSV is comma-separated and UTF-8 encoded. Google Sheets and LibreOffice open it directly. Excel in some European regions expects semicolons; if everything lands in one column, use CSV to Excel to get a proper .xlsx instead.
What happens to my upload?
The conversion runs on our server. The file is uploaded over an encrypted connection, converted in Germany and deleted automatically within two hours.
Is it free?
Yes. Files up to 50 MB are free without an account, with 20 server jobs a day included, or 50 if you sign up for a free account; Pro takes 500 MB. Daily API dumps can be converted together; up to 5 files at once are free without an account.
How to convert JSON to CSV
- Drop your .json file onto the drop zone.
- Click Convert to CSV.
- Download the .csv file and open it in your spreadsheet.
FAQ
Why did the conversion fail?
The file is not valid JSON, or it is not a list of objects. The error message says which. Check the structure in a JSON viewer.
Can it handle JSON Lines files?
No. JSON Lines puts one object per line without an enclosing array. Wrap the lines in square brackets and add commas between them first.
Are numbers kept as numbers?
They are written as plain values in the CSV. Your spreadsheet decides how to read them.
How do I convert CSV back to JSON?
Use CSV to JSON.