What JSON format is required?

The input must be a JSON array of objects. Each object becomes one CSV row. Keys across all objects are combined to form headers.

What happens with nested objects?

With the Flatten option, nested objects produce columns with dot-notation names. With Stringify, nested objects are JSON-encoded as a string in a single column.

What happens if objects have different keys?

The tool collects all unique keys across every object. Missing keys in some rows produce empty cells.

How do I open the CSV in Excel?

Save the file with a .csv extension. In Excel use File > Open and select the CSV. Use the semicolon delimiter if your locale uses semicolons as list separator.

Is there a row limit?

There is no hard row limit. Performance depends on your browser. Datasets up to 100,000 rows typically convert in under a second.

Can I convert arrays within objects?

Arrays within objects are JSON-stringified into a single cell since arrays cannot be represented as flat CSV columns.

What does Quote All Fields do?

Wrapping every cell in double quotes prevents delimiter characters inside cell values from breaking the column structure.

Can I use tab as delimiter to paste into Excel?

Yes. Select the Tab delimiter option and copy the output. Pasting directly into Excel with tab-delimited values will populate columns correctly.

Why does the tool say my JSON is not an array of objects?

The converter requires an array at the top level. If your JSON is a single object with a nested array, paste only the array value.

Does any data leave my browser?

No. All conversion happens in your browser using JavaScript. No data is uploaded to any server.

JSON to CSV Converter

NewPopular

Convert JSON arrays to CSV with delimiter options, nested object flattening, and a preview table.

Free Forever

No Signup Required

No Files Stored

JSON Input

CSV Output

Delimiter

Related Tools

CSV to JSON Converter

developer

Convert CSV files or pasted data to JSON with auto delimiter detection and multiple output formats.

Try it free

XML Formatter

developer

Format, minify, and validate XML with interactive collapsible tree view and XPath query support.

Try it free

JSON Formatter & Validator

developer

Format, validate, and minify JSON with live syntax highlighting and error detection.

Try it free

Embed this tool

Add this tool to your website or blog with a single iframe snippet.

<iframe src="https://dukotools.com/tools/json-to-csv?embed=1" width="100%" height="600" frameborder="0" allow="clipboard-write" loading="lazy" title="json-to-csv tool"></iframe>

About JSON to CSV Converter

JSON to CSV Converter transforms any JSON array of objects into properly formatted CSV in your browser with zero data leaving your device. Every JSON object in the array becomes a CSV row, and the combined set of all keys across all objects becomes the header row so even sparse or inconsistent JSON is handled gracefully with empty cells where keys are missing. Four delimiter options — comma, semicolon, tab, and pipe — cover every spreadsheet application. The quote all fields option wraps every cell in double quotes to prevent delimiter conflicts. Nested object flattening converts deep API responses into flat columns using dot notation. A live preview table shows the first 10 rows as a rendered HTML table so you can visually confirm the conversion is correct before downloading.

Key Features

Array of Objects Input
Accepts any JSON array of objects with mixed or inconsistent keys across rows.
Four Delimiter Options
Supports comma, semicolon, tab, and pipe delimiters for all spreadsheet apps.
Nested Object Flattening
Converts nested objects to dot-notation column names like address.city automatically.
Live Preview Table
Renders the first 10 rows as an HTML table for visual verification before download.
Download as CSV
Downloads the converted data as a properly named .csv file.
Inline JSON Validation
Parses JSON with 300ms debounce and shows error messages with line numbers.

How to Use

1
Paste your JSON
Paste a JSON array of objects into the input textarea. Validation runs automatically after 300ms.
2
Choose options
Select your delimiter, toggle headers, and choose how to handle nested objects.
3
Review the preview table
Check the rendered table below the output to verify columns and data look correct.
4
Copy or download
Click Copy to grab the CSV text or Download to save as a .csv file.

Real-World Use Cases

API to Spreadsheet

A developer fetches data from a REST API returning JSON and converts it to CSV to import into a Google Sheet for non-technical stakeholders.

Data Analysis Prep

A data analyst converts a JSON export from a SaaS tool to CSV before importing into Excel or Python pandas.

Report Generation

A business analyst exports JSON data from a dashboard and converts it to CSV for a monthly management report.

Frequently Asked Questions

Related Free Tools

Explore these tools that work great alongside JSON to CSV Converter:

CSV to JSON Converter

Convert CSV files or pasted data to JSON with auto delimiter detection and multiple output formats.

XML Formatter

Format, minify, and validate XML with interactive collapsible tree view and XPath query support.

JSON Formatter & Validator

Format, validate, and minify JSON with live syntax highlighting and error detection.