JSON to CSV

Convert JSON arrays to CSV format instantly. Supports comma, semicolon, and tab delimiters. Handles nested values, null fields, and special characters. Free, private, no signup.

100% private · runs locally

Paste a JSON array of objects and get a properly formatted CSV file in seconds. All keys from the first object become headers, missing fields are left blank, and values containing the delimiter or quotes are automatically escaped per the RFC 4180 standard.

JSON input (array of objects)
CSV output CSV
CSV rows will appear here…

Related tools

Frequently asked questions

What JSON structure does this tool expect?

The input must be a JSON array of objects, for example {'[{"name":"Alice","age":30}]'}. Each object becomes a row. Keys are collected from all objects, so rows with missing keys get an empty cell rather than causing an error.

How are special characters handled?

Any value that contains the chosen delimiter, a double-quote, or a newline is automatically wrapped in double-quotes and internal double-quotes are doubled, following RFC 4180. This ensures the CSV can be imported into Excel, Google Sheets, or any standards-compliant parser without corruption.

What delimiter should I use?

Use comma for most applications — it is the universal default. Switch to semicolon if your data contains decimal numbers with commas (common in European locales) or if you are targeting Excel in a locale that uses semicolons as the list separator. Tab-separated values (TSV) work best when the data contains many commas or semicolons naturally.

Are nested objects and arrays supported?

Nested values are converted to their string representation. CSV is a flat format, so there is no native way to represent hierarchy. If you need to preserve nested structure, consider flattening the JSON before converting, or use a format like JSON or YAML that supports nesting.