How to convert JSON to CSV
- Paste your JSON into the left box, or click Open File to load a .json file.
- The CSV appears on the right. Choose a different separator if your spreadsheet needs one.
- Click Download to save a .csv file, or Copy to paste it elsewhere.
What kind of JSON works?
The converter expects a list of records, which is what most APIs and exports produce:
[{ "name": "Ana", "age": 34 }, { "name": "Ben", "age": 28 }]
Each record becomes a row and each key becomes a column. If the list is wrapped in an outer object, such as { "results": [ … ] }, the tool finds the list for you. A single object becomes a table with one row.
How nested data is handled
JSON can hold objects inside objects, but a CSV table is flat. With Flatten nested objects ticked, inner values get their own columns named with a dot, so { "address": { "city": "Leeds" } } becomes a column called address.city. Lists inside a record are kept in one cell as JSON text.
Records do not all need the same keys. The table includes every key found, and missing values are left empty.
Opening the file in Excel
The downloaded file is saved in a way that lets Excel show accented letters and symbols correctly. If all your data lands in one column, your version of Excel expects semicolons: choose Semicolon as the separator and download again.
Need the reverse? Use CSV to JSON.
Your data stays on your device
The conversion runs entirely in your web browser. Nothing you paste or open is sent to a server, so it is safe to use with customer lists, exports and other private data. There is no sign-up and no size limit beyond what your device can handle.
Frequently asked questions
How do I convert JSON to CSV?
Paste the JSON or open the file, then click Download to save the CSV.
How do I open a JSON file in Excel?
Convert it to CSV here, download the file and open it in Excel. Each record becomes a row.
What happens to nested objects?
They are flattened into columns named with dots, such as address.city. You can turn this off.
Is my data uploaded?
No. The conversion runs in your browser and nothing is sent to a server.