JSON to CSV Converter

JSON to CSV Converter — Free JSON to CSV converter. Paste a JSON array of objects and convert it to CSV instantly. Supports nested objects (dot-notation keys), custom delimiters (comma, semicolon, tab), and header row toggle. No signup required.

Delimiter

—Rows

—Columns

,Delim

JSON Input

CSV Output

JSON Input

CSV Output

How to convert JSON to CSV

Paste a JSON array of objects into the input field. The first row of the CSV output will be headers derived from the object keys. Each subsequent row is one JSON object. Nested objects are flattened using dot notation — {"address":{"city":"London"}} becomes a column named address.city.

Keys are collected from all objects in the array, so missing fields in some rows produce empty cells rather than errors. This handles inconsistent JSON gracefully.

CSV delimiter options

Delimiter	Character	Use when
Comma	,	Opening in Excel (US/UK), Google Sheets, most tools
Semicolon	;	European locale Excel, where commas appear in data
Tab	→	TSV format, pasting into spreadsheets without import dialog

Common use cases

Exporting API responses to Excel or Google Sheets
Converting database query results (returned as JSON) to CSV for reports
Preparing data for import into tools that only accept CSV
Transforming webhook payloads for spreadsheet analysis

Frequently Asked Questions

What JSON format does this tool accept?

This tool expects a JSON array of objects — the most common format for tabular data. Example: [{"name": "Alice", "age": 30}, {"name": "Bob", "age": 25}]. Single objects are also supported (wrapped automatically). Arrays of primitives (strings, numbers) are not supported.

What happens to nested objects?

Nested objects are flattened using dot notation. For example, {"address": {"city": "London"}} becomes a column named "address.city". This makes deeply nested JSON readable as flat CSV columns.

Can I change the delimiter?

Yes — choose comma (standard CSV), semicolon (common in European locale), or tab (TSV format). The delimiter affects how values are separated in the output.

How do I open CSV in Excel or Google Sheets?

Copy the CSV output and paste it into a new spreadsheet. In Excel, use File → Import or paste into a blank cell. In Google Sheets, File → Import, or simply paste — Sheets auto-detects the comma delimiter.