What JSON shape does it expect?

An array of objects, such as [{"name":"Ada","age":36}]. Each object becomes a row and each key becomes a column. Objects with different keys are fine: missing values are left empty. An object that wraps the array, such as {"items": [...]}, works too.

What happens to nested objects and arrays?

CSV is flat, so nested values are flattened into dot-path columns: {"address": {"city": "Oslo"}} gives a column named address.city, and array items get numbered columns such as tags.0 and tags.1.

Is my code or data uploaded anywhere?

No. Every tool runs in your browser, so your code, tokens, keys and files are processed on your device and are not sent to our server or stored. Reloading or closing the page clears them.

Yes. Every tool is free with no sign-up and no limits on use. Clearly labeled ads keep it that way.

Does it work on my phone?

Yes. The tools work in any modern browser on phones, tablets and computers, though large files and long code are easier to handle on a computer.

JSON to CSV Converter

Turn a JSON array into a spreadsheet-ready CSV.

100% Free
No Sign Up
Works in Your Browser

JSON to CSV

Turn a JSON array into CSV

Delimiter

Header rowFlatten nested objects (a.b)

JSON input

CSV output

id,name,email,role.title,role.level,active
1,Ada Lovelace,ada@example.com,Engineer,3,true
2,Alan Turing,alan@example.com,Researcher,4,true
3,Grace Hopper,grace@example.com,Admiral,5,false
4,"Hamilton, Margaret",margaret@example.com,Director,5,true

4 rows · 6 columns

Preview (4 rows)

id	name	email	role.title	role.level	active
1	Ada Lovelace	ada@example.com	Engineer	3	true
2	Alan Turing	alan@example.com	Researcher	4	true
3	Grace Hopper	grace@example.com	Admiral	5	false
4	Hamilton, Margaret	margaret@example.com	Director	5	true

Everything runs in your browser. Nothing is uploaded.

More Developer Tools

View all tools

Every everyday developer tool, right in your browser.

No installs. No uploads. No signup.

Browse all 36 tools

Developer tools: 36
Cheat sheets: 10
Bytes uploaded: 0

How to use the JSON to CSV

Three steps, all in your browser.

1
Paste your input
Type or paste your code or data. Press Sample to try an example.
2
Check the options
Adjust the options if you need to. The conversion updates instantly.
3
Copy the result
Copy the output in one click. Nothing is saved or sent anywhere.

JSON to CSV Converter: what to know

JSON to CSV turns an array of JSON objects into comma-separated values that open in Excel, Google Sheets, Numbers or any database import tool. Each object becomes a row, and the columns are the union of every key found, in the order they first appear, so objects with different keys line up and missing values are left empty. If the array is wrapped in an object, such as {"items": [...]}, the array inside is used.

CSV is flat and JSON isn't, so nested values need a decision. Flattening turns nested objects into dot-path columns, so {"address": {"city": "Oslo"}} becomes a column named address.city, and array items get numbered columns (tags.0, tags.1). The CSV to JSON tool can rebuild the nesting from those headers. Values containing commas, quotes or line breaks are quoted following RFC 4180, with quotes inside them doubled.

The output uses commas and a header row. Spreadsheets in some regions expect semicolons when opening CSV files directly; if columns don't split, use the spreadsheet's import option and choose comma as the delimiter.

Popular uses

Opening an API response in a spreadsheet
Exporting records for a report or a colleague
Preparing data for a database or CRM import
Turning log entries in JSON into a table

Tips for the best result

Arrays of arrays work too: each inner array becomes one row, with no header.
Leading zeros (ZIP codes, phone numbers) can be dropped by Excel on open; import the column as text to keep them.
Very deep or array-heavy data makes many columns when flattened; consider picking the fields you need first.

Read how JustYourDev works and our privacy details. Code, data and files you use here are processed in your browser and are never sent to our server.

More Developer Tools

Every everyday developer tool, right in your browser.

How to use the JSON to CSV

Paste your input

Check the options

Copy the result