What is JSON to CSV Converter?

JSON to CSV Converter turns JSON arrays of objects into CSV files. It reads column headers from JSON keys, flattens nested objects, and lets you pick a custom delimiter. Useful when you need that data in a spreadsheet or database.

The converter handles arrays of objects, picks column headers from the first record, and merges any keys that show up later so no field gets dropped. Nested objects flatten into dot-notation columns (address.city, address.zip), or you can stringify them into a single JSON column. Pick comma, semicolon, tab, or pipe as delimiter.

How to use

1. Step 1 — Paste a JSON array of objects (e.g., [{"name": "Alice", "age": 30}, ...]), drag a .json file onto the input, click Choose File, or load JSON straight from a URL. JSON Lines (NDJSON, one object per line) works too.
2. Step 2 — Pick a delimiter (comma, semicolon, tab, or pipe), decide whether to include a header row, and choose how nested objects are handled (flatten with dot notation or stringify).
3. Step 3 — The CSV updates live as you edit. Preview it in a table view, then copy it or download as CSV, TSV, or a ready-to-open Excel (.xlsx) file.

When to use

• Importing API exports (user lists, order history) into Excel, Google Sheets, or a database.
• Sharing tabular data with someone who works in spreadsheets rather than JSON.
• Feeding records into a tool that only accepts CSV, like a bulk-upload form or an analytics import.

Result

You export 500 user records from an API as JSON. Paste the array, choose comma delimiter with flattened nested objects, and download a clean CSV ready to open in Excel with columns like 'address.city' and 'address.zip'.

FAQ

What happens to nested objects when I convert them to CSV?

With flatten on, an object like {address: {city: 'X', zip: 'Y'}} becomes two columns: address.city and address.zip. With flatten off, the whole object becomes a single JSON string in one column, which keeps the structure but is less spreadsheet-friendly.

Why does my output have extra columns I didn't expect?

If different records in your array have different keys, the converter unions them all so no data is lost. The records that lack a particular key get an empty cell in that column. Pre-clean your JSON if you want a strict shared schema.

Which delimiter should I pick — comma, semicolon, tab, or pipe?

Use comma for English-locale Excel and most tools. Semicolon for European Excel where commas are decimal separators. Tab for pasting straight into a spreadsheet cell or for files that contain commas inside text fields without needing quotes. Pipe (|) suits legacy database dumps and log pipelines that expect bar-separated values.

How are commas, quotes, and newlines inside values handled?

The converter follows RFC 4180: fields with commas, quotes, or newlines get wrapped in double quotes, and inner double quotes are doubled (" → ""). Excel and most CSV parsers read this correctly without extra setup.

Can I reorder columns before downloading?

Yes. The preview table shows the current column order with left/right arrows on each header. Click them to nudge a column into a different position, then download the .csv file with that exact ordering.

Related Tools