JSON to CSV
Turn JSON into rows and columns. Nested fields get their own columns; save CSV for any app or an Excel file.
Spreadsheet
Paste JSON: an array of objects, or an object that contains one.
Ctrl+F search · Ctrl+↵ copy result · Ctrl+Shift+F result to input · Esc then Tab leaves the editor
How to convert JSON to CSV
- Paste JSON or open a .json file. It is checked as you type; Repair fixes common mistakes.
- If the JSON holds several lists, choose the one to use under Rows from. Nested fields become columns such as
customer.city. - Check the table preview, then download CSV or Excel, copy the CSV, or send it to another tool.
Frequently asked questionsUseful details
4 answers +
Is my JSON uploaded?
No. The table, the CSV and the Excel file are all made in your browser.
What happens to nested objects?
They are flattened into dotted column names: {"customer": {"city": "İzmir"}} becomes a customer.city column. CSV to JSON can turn those columns back into nested objects.
My records have different fields. Is that a problem?
No. Every field found in any record gets a column, in the order they first appear. Records without a field leave that cell empty.
Can I convert JSON Lines (NDJSON)?
Yes. Paste it and press Repair: the lines are wrapped into one array, and each line becomes a row.
More help
Guides, common conversions and useful next steps.
Continue with your result
Use the action beside a finished result to send it directly, or open another tool: