JSON to CSV

Turn JSON into rows and columns. Nested fields get their own columns; save CSV for any app or an Excel file.

Your data is never uploaded

Your JSON

Paste JSON, drop a .json file, or open oneOr start from an example:

Waiting for JSONLists

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 it works

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 questions

Useful 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: