JSON to CSV Converter

🔒 Runs in your browser — nothing you enter is uploaded.

Turn a JSON array of objects into a CSV file you can open in Excel or Google Sheets.

JSON input:

Open .json file

Delimiter:

Options: Flatten nested Excel-friendly (UTF-8 BOM)

CSV output

You may also need

HEIC to JPG Converter — Turn iPhone HEIC photos into JPG files that open everywhere — batch convert without uploading.
Unit & Currency Converter — Convert length, weight, temperature, volume and live currency exchange rates.
Color Converter (HEX ⇄ RGB ⇄ HSL) — Convert color codes between HEX, RGB and HSL with a live preview and shades.
Number to Words Converter — Spell out any number in words, including currency and check-writing formats.
Markdown to HTML Converter — Write Markdown and see the rendered preview and clean HTML side by side.
Salary Converter & Planner — Convert pay between hourly, daily, weekly, monthly and yearly amounts.

Popular next tools

Image Compressor QR Code Generator & Scanner Image Resizer & Cropper Age Calculator Video Converter

All Converters » Search all tools »

How to use the JSON to CSV Converter

Paste JSON or open a .json file.
Choose a delimiter and whether to flatten nested objects.
Copy the CSV or download it as a file.

Common use cases

Open an API export in Excel or Google Sheets
Share database records with non-developers
Flatten nested JSON for reporting

Example

[{"name":"Ada","address":{"city":"London"}}] becomes the columns name,address.city with the row Ada,London.

Converting JSON to CSV

APIs and databases export JSON, while spreadsheets want rows and columns. This converter reads an array of objects, finds every key used by any object and turns each key into a column. Nested objects such as address.city are flattened into dotted column names, and arrays are joined with a vertical bar, so nothing is lost.

Values containing commas, quotes or line breaks are quoted according to RFC 4180. If Excel in your region expects semicolons, pick the semicolon delimiter. Need the other direction? Use CSV to JSON.

Frequently Asked Questions (FAQ)

Q: What JSON shapes are supported?

A: An array of objects (most common), a single object (becomes one row), an array of arrays (rows) and an array of plain values (one column). If your data sits inside a wrapper such as {"data": [...]}, the first array found is used automatically.

Q: Why do accents look wrong in Excel?

A: Keep Excel-friendly (UTF-8 BOM) ticked. It adds an invisible marker so Excel reads characters such as é, ç and ğ correctly.

Q: Is my data sent anywhere?

A: No. The conversion runs in JavaScript in your browser.