JSON to CSV Converter

Delimiter

Include header row

Quote all fields

Flatten nested objects

JSON Input

CSV Output Rows

Columns detected:

Rows · Columns detected

JSON arrays to CSV in seconds

Paste any array of objects and get a properly formatted CSV file. Column headers are detected automatically from your JSON keys.

Handles nested objects

Nested JSON objects can be flattened using dot-notation (e.g. address.city) or stringified inline. Arrays within objects are always stringified.

Ready for Excel and Google Sheets

Choose comma or semicolon delimiter to match your regional settings. Quoting options ensure fields with commas or line breaks are handled correctly.

Frequently asked questions about JSON to CSV conversion

Arrays, nested data, Excel import and delimiter choices

The tool expects a JSON array of objects — a list starting with [ where each item is a { } object. For example: [{"name":"Alice","age":30},{"name":"Bob","age":25}]. A single object {…} is not supported because CSV needs rows, and a single object is just one row with no consistent structure to iterate.

You have two choices. "Flatten nested objects" expands each nested object into separate columns using dot notation — {"address":{"city":"Berlin"}} becomes an address.city column. "Stringify nested" keeps the nested object as a JSON string in a single cell, which is safer when nesting is deep and you don't want dozens of new columns.

This depends on your regional settings. In most English-speaking countries Excel expects comma (,) as the delimiter. In Germany, France and other countries that use comma as the decimal separator, Excel expects semicolon (;) instead. If your CSV opens with all data in one column, try switching the delimiter. Tab-delimited files (TSV) are universally supported and avoid delimiter conflicts altogether.

By default, fields are only quoted when necessary — when they contain the delimiter character, a double quote, or a line break. Enabling "Quote all fields" wraps every value in double quotes, even simple numbers and short strings. This produces larger files but maximises compatibility with older or stricter CSV parsers that expect quoted fields.

Convert JSON arrays to CSV

The JSON-to-CSV converter turns an array of JSON objects into a table in CSV format that opens in Excel, Google Sheets or any spreadsheet program. The keys become column headers and each object becomes a row. That saves manual retyping and suits anyone who wants to process data from APIs or exports further. The conversion runs locally in the browser.

Common use cases

API data in Excel: Export an API's JSON response as CSV and open it directly in your spreadsheet.
Build reports: Prepare records for analysis, charts or handover to non-technical colleagues.
Data import: Create CSV files that import into CRM, shop or mailing systems.
Quick visual check: Flatten nested lists into a table to scan values row by row.

How to convert JSON to CSV

1 Paste a JSON array of objects into the input field.
2 The tool detects the fields and creates the matching columns.
3 Review the CSV preview.
4 Copy the CSV or download it as a file.

What to watch out for

The conversion is cleanest when all objects share the same fields; differing keys produce empty cells. Nested objects are flattened as needed – check the result when your data is deeply structured. Also mind the delimiter, since some programs expect semicolons instead of commas by region. Because processing happens in the browser, your data stays private.

Free tools that pair well with this one – right in your browser, no sign-up.

Base64 Converter Convert images to Base64 JSON Formatter Format & validate JSON JSON Minifier Minify & compress JSON SQL Formatter Format & beautify SQL queries