What JSON format works best for CSV conversion?

An array of objects with consistent keys works best: [{"name":"John","age":30},{"name":"Jane","age":25}]. Single objects are also supported and will create a one-row CSV.

How are nested objects handled?

Nested objects are flattened using dot notation. For example, {"user":{"name":"John"}} becomes a column named "user.name" with value "John".

What happens to arrays within the JSON?

Arrays can either be stringified (converted to JSON strings) or expanded into multiple columns. Use the "Array handling" option to choose your preferred method.

Can I change the delimiter?

Yes, you can choose comma (default), semicolon, or tab as your delimiter. This is useful for regional CSV formats or specific application requirements.

Free Tool

JSON to CSV Converter

Free online tool to convert JSON to CSV format. Flatten nested objects, customize delimiters, and download your CSV instantly.

Convert JSON arrays to CSV format
Flatten nested objects automatically
Customizable delimiter (comma, semicolon, tab)
Optional header row
Handle arrays within objects
Download CSV directly
Copy to clipboard
Free and unlimited conversions

Drop a JSON file or click to upload

Input JSON

Delimiter

Include header rowFlatten nested objects

CSV output will appear here

How It Works

JSON Array or Object

An array of objects with consistent keys works best. Single objects create one-row CSVs. Nested objects are automatically flattened.

OUT

CSV File

Comma-separated values file compatible with Excel, Google Sheets, and databases. Shows row/column counts and allows custom delimiters.

Paste or Upload JSON

Enter your JSON array or object directly in the text area or drag and drop a .json file to upload it.

Configure Options

Choose your delimiter (comma, semicolon, tab), enable/disable header row, and toggle nested object flattening.

Convert

Click "Convert to CSV" to transform your JSON data into tabular CSV format.

Download or Copy

View row/column statistics, copy the CSV to clipboard, or download it as a .csv file ready for Excel or other tools.

Frequently Asked Questions

What JSON format works best for CSV conversion?: An array of objects with consistent keys works best: [{"name":"John","age":30},{"name":"Jane","age":25}]. Single objects are also supported and will create a one-row CSV.
How are nested objects handled?: Nested objects are flattened using dot notation. For example, {"user":{"name":"John"}} becomes a column named "user.name" with value "John".
What happens to arrays within the JSON?: Arrays can either be stringified (converted to JSON strings) or expanded into multiple columns. Use the "Array handling" option to choose your preferred method.
Can I change the delimiter?: Yes, you can choose comma (default), semicolon, or tab as your delimiter. This is useful for regional CSV formats or specific application requirements.