Paste a JSON array of objects and get a clean CSV file for Excel, Google Sheets or a database.
Conversion happens in your browser and nothing is uploaded. Arrays inside a record are kept as JSON text in a single cell. Downloads are UTF-8 with a byte order mark so Excel shows accents and £ signs correctly.
APIs, exports and config files often hand you data as JSON, but spreadsheets and many databases want rows and columns. This JSON to CSV converter turns a JSON array into a clean CSV file in one step, flattening nested objects into their own columns and quoting values exactly as the RFC 4180 CSV format describes. Preview the table, then copy the result or download a file ready for Excel or Google Sheets.
Quick answer: Converting JSON to CSV turns every object in a JSON array into one row and every key into one column, under a header row of column names. Nested objects such as address become columns like address.city, and any value containing the delimiter, a quote mark or a line break is wrapped in double quotes.

In This Guide
What Does Converting JSON to CSV Do?
JSON stores data as objects made of key and value pairs, and those objects can contain further objects and lists. CSV is flat: a header row of column names, then one line per record, with values separated by a delimiter. Converting means turning every object in your array into one row and every key into one column.
The tool collects every key it finds across all records, so a field that appears in only some objects still gets a column and is left blank where missing. With flattening on, a nested object such as address becomes columns like address.city and address.postcode. Any value containing the delimiter, a quote mark or a line break is wrapped in double quotes, and quotes inside are doubled, so spreadsheets read it correctly.
How Do You Use the JSON to CSV Converter?
Step 1: Paste Your JSON
Paste a JSON array of objects into the box, and if your JSON is an object that wraps an array, such as an API response, the tool finds that array for you. Paste a JSON array of objects into the box. A sample customer list is loaded so you can see how it works. If your JSON is an object that wraps an array, such as a typical API response with a data list, the tool finds that array for you.

Step 2: Choose Your Options
Pick a comma for most tools, a semicolon if your Excel uses a comma as the decimal separator, or a tab for pasting straight into a spreadsheet. Untick the header row if you are appending to an existing file, and untick flattening to keep nested objects as JSON text.

Step 3: Check the Output
The CSV updates as you type. The preview table shows the first five rows so you can confirm the columns line up. If a field holds Unix dates, the Unix timestamp converter turns them into readable dates before you share the sheet. If the JSON has a mistake, a message explains what went wrong instead.

Step 4: Copy or Download
Press Copy CSV to paste it elsewhere, or Download .csv to save a file. Need test records with IDs first? The UUID generator creates unique keys you can add to each object before converting. The stats show how many rows and columns were created.

What Are Common JSON Errors and How Do You Fix Them?
| Problem | Example | Fix |
|---|---|---|
| Single quotes | {'name': 'Olivia'} | Use double quotes for keys and text |
| Trailing comma | {"id": 1,} | Remove the comma after the last item |
| Unquoted key | {name: "Olivia"} | Wrap every key in double quotes |
| Several objects, no array | {...} {...} | Wrap them in [ ] and separate with commas |
Common JSON errors are single quotes, trailing commas, unquoted keys and several objects without an array, fixed by using double quotes, removing the last comma and wrapping objects in [ ]. JSON is stricter than JavaScript, which is why these small slips cause errors. The official JSON syntax reference shows exactly which characters and structures are allowed.
JSON to CSV Terms You Should Know
These terms explain the data formats and rules the JSON to CSV converter applies, so your exported rows open cleanly in spreadsheets and databases.
- JSON array of objects
- A list of records in JavaScript Object Notation, each made of named keys and their values. It is the shape most APIs return, and each object maps naturally to one spreadsheet row.
- Comma separated values (CSV)
- A plain text table format with one record per line and fields split by a delimiter. It has no data types or nesting, which makes it readable by almost any spreadsheet or database import tool.
- Delimiter
- The character that separates fields on each CSV line, usually a comma, semicolon or tab. A semicolon suits regions where the comma is the decimal separator, so numbers are not split across columns.
- Flattening
- Turning nested objects into separate columns whose names join the parent and child keys with a dot, such as address.city. It keeps related values in their own cells instead of storing a block of JSON text.
- Field quoting
- Wrapping a value in double quotes when it contains the delimiter, a quote mark or a line break, and doubling any quotes inside it. Defined in RFC 4180, it stops a single value spilling into neighbouring columns.
- Byte order mark (BOM)
- A short invisible marker at the start of a text file that signals its encoding. Adding it to UTF-8 output helps Excel display accented letters and currency symbols such as the pound sign correctly.
</>Embed this calculator on your website
Add the free JSON to CSV Converter to your own site or blog. Copy the code below and paste it into an HTML block. It resizes itself and works on phones.
How we checked this tool: the Tools Veria Editorial Team built this tool by hand, checked it against the official rules or published standards where they apply, and tested it against worked examples. Results are estimates for planning, not personal financial or tax advice. Read our editorial policy and disclaimer, or report an error.
Frequently Asked Questions
How do I convert JSON to CSV?
Paste your JSON array into the converter, choose a delimiter and copy or download the CSV. Each object becomes a row and each key becomes a column.
How are nested JSON objects handled?
With flattening on, nested keys become columns joined with a dot, such as address.city. With it off, the whole nested object is kept as JSON text in one cell.
Why does my CSV open in one column in Excel?
Your Excel may expect a semicolon because your region uses a comma for decimals. Choose the semicolon delimiter and download again.
What happens to arrays inside my JSON?
Arrays inside a record are written as JSON text in a single cell, so no data is lost and you can split them later if needed.
Is there a size limit?
There is no fixed limit, but very large files depend on your device's memory. Files of a few megabytes convert almost instantly.
Is my JSON uploaded anywhere?
No. The conversion runs entirely in your browser and your data never leaves your device.