Convert JSON to CSV

Get JSON from an API or export into a CSV that opens directly in Excel or Google Sheets. Nested objects are flattened for you, and your data stays in your browser.

Delimiter

JSON input

CSV output

Converted on your device. Your data never leaves your browser.

Turning JSON into CSV

1
Paste the JSON into the input box, drop a .json file onto it, or press Open file.
2
Choose a separator. Comma suits most tools; semicolon is better for Excel in many European regions.
3
Copy the CSV or press Download .csv, then open it in Excel, Numbers or Google Sheets.

What makes this JSON to CSV converter handy

Nested JSON flattened

Nested objects turn into dotted columns such as address.city, and arrays are kept as JSON text in a single cell.

No field left out

Objects with different fields are merged into one set of columns, so nothing goes missing.

Excel-friendly

Downloads include a UTF-8 byte-order mark, so accents and non-Latin characters show properly in Excel.

Private and instant

It converts as you type, entirely in your browser, with nothing uploaded.

What people use the JSON to CSV converter for

Open API responses in Excel

Turn JSON into rows and columns you can sort and filter.

Hand data to non-developers

CSV opens in every spreadsheet app.

Import into CRMs and email tools

Most import screens take CSV.

Flatten nested data

Nested objects become dotted columns automatically.

Also searched for as: JSON to CSV converter, JSON to Excel, JSON to spreadsheet and flatten JSON.

Quick data conversions in the browser

Switch between CSV, JSON and YAML, or turn images into Base64, without installing anything. Everything is processed in your browser, so exports, customer data and API keys stay on your machine rather than going to someone else's server.

Questions & answers

What shapes of JSON can it handle?

An array of objects (the usual API format), an array of arrays, an array of plain values, or a single object. Every object becomes one CSV row.

What happens to nested objects and arrays?

Nested objects become dotted column names, so {"address": {"city": "Paris"}} gives an address.city column. Arrays are written as JSON text in one cell so you can parse them back later.

How do I open the CSV in Excel?

Download it and double-click, or use Data → From Text/CSV in Excel. If everything lands in one column, your Excel region probably wants semicolons – switch the separator to Semicolon and download again.

Does it check my JSON is valid?

Yes. Invalid JSON shows the parser's error message so you can track down the problem.

Do my files get uploaded anywhere?

Never. The work is done by JavaScript running in your own browser, on your own device. Nothing is sent to a server or kept anywhere, which makes it safe for personal photos and sensitive data – and it carries on working even on a patchy connection.

You might also need

CSV ⇄ JSONBoth directions, one tool CSV to JSONSpreadsheet rows as JSON JSON to YAMLJSON as readable YAML YAML to JSONYAML configs as JSON Image to Base64Data URIs for your code Base64 to ImageTurn Base64 back into a file HEIC to JPGiPhone photos that open everywhere HEIC to PNGiPhone photos, no further loss WebP to JPGWeb images your apps can open WebP to PNGWebP to PNG, transparency kept PNG to JPGMuch smaller screenshots JPG to PNGEdit without more quality loss PNG to WebPLighter images, still transparent JPG to WebPQuicker photos for websites SVG to PNGCrisp PNGs at up to 8× size Image ConverterAny image to WebP, PNG or JPG Metadata RemoverWipe GPS and EXIF from photos JPG to PDFPhotos into a single PDF PNG to PDFScreenshots and scans as a PDF Reorder PDF PagesRearrange, rotate, delete pages Zip FilesBundle files into a ZIP Unzip FilesSee inside and extract ZIPs Extract TAR.GZUnpack .tar.gz, .tgz, .tar, .gz TAR.GZ to ZIPArchives that open on Windows Audio TrimmerCut audio on a waveform Word CounterWords, characters, reading time Text Diff CheckerSpot changes between two texts Image to Text (OCR)Copy text out of pictures Base64 Encoder / DecoderEncode and decode Base64 Code MinifierShrink or tidy CSS, HTML, JS Regex TesterTest patterns with live matches

Guides for this tool

See every guide →