JSON to CSV

Open API responses and JSON exports in a spreadsheet. Paste a JSON array and get a CSV with one column per field — nested objects flattened into columns like address.city, and every value escaped so it opens correctly in Excel, Numbers or Google Sheets.

Delimiter
Options

This tool runs entirely in your browser. Your files and text are processed on your own device and are never uploaded to our servers.

How to use the JSON to CSV

  1. Paste a JSON array of objects (or an array of arrays), or open a .json file. Use “Example” to try it.
  2. Choose the delimiter. Use semicolon if your Excel uses commas as the decimal separator.
  3. Keep “Flatten nested objects” on to turn nested fields into separate columns; optionally quote every value or protect against spreadsheet formulas.
  4. Copy the CSV or download it. Tick “Excel-friendly download” if accented characters look wrong in Excel.

Examples

Nested objects become columns

Input
[{ "id": 1, "user": { "name": "Ann", "city": "Oslo" } }]
Result
id,user.name,user.city
1,Ann,Oslo

Objects with different fields

Every key that appears in any object becomes a column; missing values are left empty.

Input
[{ "a": 1 }, { "b": 2 }]
Result
a,b
1,
,2

Opening the CSV in Excel

Excel sometimes misreads UTF-8 files, turning “é” into “é”. The Excel-friendly option adds an invisible byte-order mark that tells Excel the file is UTF-8. In regions where Excel expects semicolons, choose the semicolon delimiter so columns split correctly.

Values that start with =, +, - or @ can be treated as formulas by spreadsheet apps. If the data comes from untrusted sources, turn on formula protection: such values get a leading apostrophe so they are always shown as text.

Frequently asked questions

Is my JSON uploaded?

No. The conversion runs in your browser and nothing is sent to a server.

What JSON shapes are supported?

An array of objects (the most common), an array of arrays, a single object (one row), or an object with one property that holds the array, such as {"items": [...]}.

How are arrays inside objects handled?

Arrays and objects that can’t be flattened into columns are written into the cell as JSON text, for example ["a","b"], so no information is lost.

Why does my CSV show a value with an apostrophe in front?

That happens when formula protection is on and the value starts with =, +, - or @. Turn the option off if your data is trusted and you need the exact text.

Everything you need. One simple place.

Free, fast online tools for text, PDFs, images, data and everyday maths. Every tool runs entirely in your browser, so your files stay on your device.

  • Privacy-first processing
  • No sign-up required

© 2026 Toolora. All rights reserved.

Built for speed and privacy