Arrays of objects become rows; each distinct field becomes a column. Nested objects are flattened into dotted columns by default, and a root path pulls the array out first if it isn't already at the top level.
address.city becomes one column. Arrays of scalars are joined with a semicolon; arrays of
objects need a root path pointing at them, or stay as a single JSON-encoded cell.
This page ships no analytics and sets no cookies. The content security policy blocks network requests, so your payload cannot leave the tab.
Have an array of objects — API results, exported records, a log dump — and need it as a spreadsheet? Convert it to CSV in one click, entirely in your browser.
Json Web Viewer's CSV export takes a JSON array of objects and turns each object into a CSV row, with each
distinct field becoming a column. Load the array into Table mode first to preview it as a
grid — sort columns, spot-check values, edit a cell — then export exactly what's on screen as a
.csv file from the Save menu.
Nested objects and arrays inside a record don't fit a flat CSV cell, so you get a choice: keep them as raw
JSON text in that cell, or turn on Flatten nested properties in Settings to spread nested
fields into their own dotted columns instead (address.city, address.country, and so
on).
Example — this JSON array:
[
{ "id": 1, "name": "Ada Lovelace", "role": "Engineer", "active": true },
{ "id": 2, "name": "Grace Hopper", "role": "Rear Admiral", "active": true },
{ "id": 3, "name": "Alan Turing", "role": "Mathematician", "active": false }
]exports as this CSV:
id,name,role,active
1,Ada Lovelace,Engineer,true
2,Grace Hopper,Rear Admiral,true
3,Alan Turing,Mathematician,false
Open this example in the editor →
The link above pre-loads the array above into Table mode. From there, open Save in the
toolbar and choose CSV… to export it.
No. The conversion runs entirely in your browser using the File System/download APIs — your JSON and the resulting CSV never touch a server.
CSV has no concept of nesting, so by default a nested value is kept as its raw JSON text inside that cell.
Table mode's "Flatten nested properties" setting can instead turn nested fields into their own dotted
columns (e.g. address.city) before export.
Yes. Use Open > Import CSV to load a .csv file and get back a JSON array of objects, one per row.
Need a real Excel workbook instead of plain text? See JSON to Excel — it writes typed numeric cells directly, skipping Excel's CSV import wizard. Going the other direction? See CSV to JSON.