The result appears here.
Free tool · runs in your browser
JSON to CSV converter
Paste an array of objects and get CSV with a header row. Nested objects become dotted columns such as address.city, and the table view shows the rows before you download.
Nested data
Objects inside a row become columns like address.city. Arrays inside a row are written as JSON text in one cell.
Pick the list
If the array sits inside the document, filter to it with a path such as $.items and only that list is converted.
Ready for spreadsheets
Fields with commas, quotes or line breaks are quoted the standard way (RFC 4180). Choose semicolons for spreadsheets set up for European number formats.
Shortcuts
- Ctrl/⌘ Enter
- Format
- Ctrl/⌘ Shift M
- Minify
- Ctrl/⌘ F
- Find in the editor
- Ctrl/⌘ Alt [
- Fold all
Questions
What JSON can be converted to CSV?
An array of objects (each object becomes a row), an array of plain values (one column called value), an array of arrays (each inner array becomes a row) or a single object (one row). Use the path filter to pick a list inside a larger document.
How are nested objects and arrays handled?
Nested objects are flattened into dotted columns, so {"address": {"city": "Toronto"}} becomes a column address.city. Arrays inside a row are written as JSON text in a single cell.
Which delimiter should I use?
Comma is the standard. Semicolon suits spreadsheets that use a comma as the decimal separator, and tab is easiest to paste into a spreadsheet.
Is my data uploaded?
No. Everything is converted in your browser. Nothing you paste is uploaded or stored; only your layout and option choices are remembered.