What JSON format does this accept?

This tool accepts a JSON array of objects, where each object represents one row. Keys in the first object become column headers.

How are nested objects handled?

You can choose to flatten nested objects using dot notation (e.g., address.city), skip them, or stringify them as JSON strings.

How are arrays inside the JSON converted to CSV?

A top-level array of objects becomes one row per object, with object keys as the column headers. Arrays nested inside a row are typically serialised into a single cell, for example as a JSON string, because CSV has no native nested structure.

What delimiter does the CSV output use?

A comma by default, matching RFC 4180. You can switch to a tab (TSV) or semicolon, which helps in locales where Excel expects a semicolon because the comma is used as the decimal separator.

How are values containing commas or quotes escaped?

Per RFC 4180 any field that contains a comma, a line break or a double quote is wrapped in double quotes, and any double quote inside is doubled. That keeps the columns aligned no matter what the data contains.

Does the output include a header row?

Yes. The keys of the JSON objects become the first row of column headers so the file imports cleanly into Excel, Google Sheets or a database. The header is derived from the union of keys across all rows.

Can I convert CSV back into JSON?

Yes, the conversion works both ways. Each CSV row becomes a JSON object using the header row as keys, so you can round-trip data between spreadsheets and APIs without manual reformatting.

JSON to CSV Converter — Convert JSON Array to CSV

How to use JSON to CSV Converter

The JSON to CSV Converter transforms JSON arrays of objects into comma-separated values files that can be opened directly in Excel, Google Sheets or any data-analysis tool. It automatically infers column headers from object keys, handles nested properties via dot-notation flattening, and lets you customise the delimiter, quote character and line endings — making it the fastest way to get JSON API data into a spreadsheet.

Paste your JSON array (an array of objects) into the input field, or upload a .json file.
The tool inspects the first object to infer column headers — review and reorder them in the column picker.
Choose your output delimiter: comma (CSV), tab (TSV), semicolon or pipe.
Select line endings: CRLF (Windows) or LF (Unix/Mac).
Toggle whether to include the header row and whether to quote all fields or only fields containing the delimiter.
Click Convert and download the .csv file or copy the output.

Your data never leaves your device — 100% private processing.

Handling nested JSON objects

Real-world API responses often contain nested objects and arrays. The converter flattens one level of nesting by joining parent and child keys with a dot: {"user": {"name": "Alice"}} becomes the column user.name. Arrays within objects are serialised as JSON strings in a single cell, preserving the data while maintaining the flat structure required by CSV. For deeply nested data, consider restructuring the JSON before converting or using a dedicated ETL tool.

CSV format variations and gotchas

Despite the name, "comma-separated values" files do not always use commas. European locales where commas serve as decimal separators typically use semicolons instead. RFC 4180 defines a minimal CSV standard but is not universally observed — some tools expect double-quotes only around fields containing the delimiter, while others quote all fields. Field values containing newlines must be quoted, and embedded quotes are escaped by doubling them ("He said ""hello""."). Choosing the right dialect for your target application avoids import errors.

Common CSV dialects
Dialect	Delimiter	Quote char	Common use
RFC 4180 CSV	,	"	Excel (US), Google Sheets
TSV	Tab	None	Unix tools, R, Python pandas
Semicolon CSV	;	"	Excel (European locales)
Pipe-delimited	\|	"	Database exports, EDI

Worked examples

Array of objects to CSV

Inputs: [{"id":1,"name":"Al"},{"id":2,"name":"Bo"}]

Result: header id,name then rows 1,Al and 2,Bo

Value with comma is quoted

Inputs: {"city":"Paris, FR"}

Result: cell becomes "Paris, FR" (wrapped in quotes)

Nested object flattened

Inputs: {"user":{"name":"Al"}}

Result: column user.name = Al

Glossary

CSV: Comma-Separated Values — a plain-text format representing tabular data with one record per line.
TSV: Tab-Separated Values — a CSV variant using tab characters as delimiters, common in data science.
Flattening: Converting nested JSON objects into a flat key-value structure by joining key names with a separator.
RFC 4180: An informational IETF memo defining the most common CSV format with double-quote field enclosure.
Delimiter: The character (comma, tab, semicolon, pipe) used to separate fields within a CSV record.

Related Developer Tools

JSON Formatter & Validator

Format, validate, and minify JSON instantly. Includes syntax highlighting, error detection, and a collapsible tree view — free, private, in-browser.

URL Encoder / Decoder

Encode and decode URLs and URL components online. Convert special characters to percent-encoding and back instantly — free, private, and fast.

Table to HTML Converter

Paste CSV, TSV, or spreadsheet data and convert it to a clean HTML table instantly. Choose a delimiter and header row, then copy the markup — free and private.

HTML Table Generator

Build clean, semantic HTML tables visually. Set rows and columns, fill cells, toggle a header row, and copy ready-to-use HTML — free and in your browser.

Query String ↔ JSON

Parse a URL query string into JSON, or build a query string from JSON. Handles repeated keys as arrays and URL-encoding. Free, instant, in-browser.

Regex Tester

Test and debug regular expressions online. See live matches, capture groups, and replace output. Free, private, instant.

Explore all Developer Tools.

JSON to CSV Converter

How to use JSON to CSV Converter

Handling nested JSON objects

CSV format variations and gotchas

Worked examples

Glossary

Related reading

Frequently Asked Questions

Why use JSON to CSV Converter?

Common use cases

Get weekly tool tips & updates

Related Developer Tools