Turn JSON into a CSV you can open in Excel or Google Sheets - nested data flattened - or convert CSV back to JSON.
Last updated:
For CSV to JSON, switch tabs; the first row is used as keys.
| JSON | CSV column(s) |
|---|---|
| {"name":"Sam"} | name |
| {"address":{"city":"Austin"}} | address.city |
| {"tags":["a","b"]} | tags = a; b |
| {"items":[{"id":1}]} | items = [{"id":1}] (kept as JSON text) |
| Missing keys in some rows | Empty cells |
| Delimiter | Use when |
|---|---|
| Comma , | Default for most tools and US/UK Excel |
| Semicolon ; | Excel in Europe (comma is the decimal mark) |
| Tab | Pasting into Sheets or data with many commas (TSV) |
| Pipe | | Legacy systems and data with commas and tabs |
| Tool | Example |
|---|---|
| Python (pandas) | pd.json_normalize(data).to_csv("out.csv", index=False) |
| jq | jq -r '(.[0]|keys_unsorted) as $k | $k, (.[]|[.[$k[]]]) | @csv' in.json |
| Node.js | json2csv / papaparse libraries |
| Excel | Data → Get Data → From JSON (Power Query) |
| Source | Tip |
|---|---|
| REST API response | If the list is inside {"data": [...]}, it is picked up automatically |
| MongoDB | mongoexport --type=csv also works; nested fields become dot columns here |
| Firebase / Firestore | Export the collection JSON, then convert |
| Stripe / Shopify | Use the API JSON when the built-in CSV lacks fields |
| Google Analytics / Search Console API | Rows with dimension arrays become joined text |
Paste the JSON above and press Convert. Download the CSV or the Excel version.
Convert it here, then use Download for Excel and open the file - columns and special characters appear correctly.
Yes. Nested objects become columns like address.city; simple arrays are joined with semicolons.
Yes. Switch to CSV → JSON. The first row becomes the keys.
If it contains an array (like {"data":[...]}), that array is used; otherwise the object becomes one row.
No. Conversion happens in your browser.
Your Excel expects semicolons. Choose Semicolon as the delimiter and download again.
Files of several megabytes and tens of thousands of rows work in a modern browser.