Advertisement

JSON to CSV Converter

Turn JSON into a CSV you can open in Excel or Google Sheets - nested data flattened - or convert CSV back to JSON.

Last updated:

JSON to CSV Converter
JSON ⇄ CSV · Excel · Nested data
Paste JSON (an array of objects works best) and press Convert.

How to Convert JSON to CSV (or Excel)

1
Paste JSON or upload a .json file
2
Press Convert and check the table preview
3
Download CSV, or Download for Excel so accents and symbols open correctly

For CSV to JSON, switch tabs; the first row is used as keys.

How Nested JSON Becomes Columns

JSONCSV 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 rowsEmpty cells

Open the CSV in Excel or Google Sheets

Which Delimiter Should I Use?

DelimiterUse when
Comma ,Default for most tools and US/UK Excel
Semicolon ;Excel in Europe (comma is the decimal mark)
TabPasting into Sheets or data with many commas (TSV)
Pipe |Legacy systems and data with commas and tabs

CSV to JSON Rules

Convert in Code

ToolExample
Python (pandas)pd.json_normalize(data).to_csv("out.csv", index=False)
jqjq -r '(.[0]|keys_unsorted) as $k | $k, (.[]|[.[$k[]]]) | @csv' in.json
Node.jsjson2csv / papaparse libraries
ExcelData → Get Data → From JSON (Power Query)

Converting Exports From Popular Tools

SourceTip
REST API responseIf the list is inside {"data": [...]}, it is picked up automatically
MongoDBmongoexport --type=csv also works; nested fields become dot columns here
Firebase / FirestoreExport the collection JSON, then convert
Stripe / ShopifyUse the API JSON when the built-in CSV lacks fields
Google Analytics / Search Console APIRows with dimension arrays become joined text

CSV Gotchas to Watch

Related Tools

Frequently Asked Questions

How do I convert JSON to CSV? +

Paste the JSON above and press Convert. Download the CSV or the Excel version.

How do I open JSON in Excel? +

Convert it here, then use Download for Excel and open the file - columns and special characters appear correctly.

Does it handle nested JSON? +

Yes. Nested objects become columns like address.city; simple arrays are joined with semicolons.

Can I convert CSV to JSON? +

Yes. Switch to CSV → JSON. The first row becomes the keys.

What if my JSON is an object, not an array? +

If it contains an array (like {"data":[...]}), that array is used; otherwise the object becomes one row.

Is my data uploaded? +

No. Conversion happens in your browser.

Why are my columns merged in Excel? +

Your Excel expects semicolons. Choose Semicolon as the delimiter and download again.

How big a file can I convert? +

Files of several megabytes and tens of thousands of rows work in a modern browser.

About the creator Prajwal Karkera, creator of ToolsFlow

Built and maintained by Prajwal Karkera, a digital product specialist with 8+ years of experience in digital products. Found a problem with this tool? Let us know through the Contact page.
Read more about me →