How are nested JSON objects handled in CSV?

Nested objects are flattened with dot notation. {"user":{"name":"Alice"}} becomes a column named user.name. This keeps every value in a flat, spreadsheet-friendly table.

What happens to arrays?

Arrays of simple values (strings, numbers) are joined with commas inside one cell. Arrays of objects are written as JSON text in the cell so no data is lost.

Will my large IDs and leading zeros stay intact in the CSV?

Yes. The CSV is plain text, so values are written exactly as they appear in the JSON. Note that opening a CSV in Excel can still reformat such values: if you need guaranteed preservation, download as XLSX instead, which writes them as text cells.

Can I paste JSON instead of uploading?

Yes. Use the Paste tab, paste your JSON, and convert. Useful for quick one-off conversions of an API response.

Completely. The conversion runs in your browser with JavaScript. Nothing is uploaded to any server.

Convert JSON to CSV

Turn any JSON file into a clean CSV in seconds. Nested objects are flattened into dot-notation columns, arrays of scalars are joined, and the result downloads as a comma-separated file (or Excel, if you prefer). Everything runs in your browser, so your data never leaves your device.

100% private, runs in your browserFree, no sign-up required

Nested fields

Nested fields become their own columns, like user.name and user.address.city.

Drag and drop your file here

or click to browse. Accepts .json up to 50 MB.

Your data never leaves your browser. Example: data.json

How accurate is this? This converter parses your file using deterministic rules (no AI or guessing). The output matches the source data exactly. If you notice any issue, please report it using the link below.

How to Export and Convert JSON Data

1
Get your JSON
Export from an API, database, or app, or copy it from a text editor. An array of objects works best.
2
Upload or paste
Drag and drop the .json file, or switch to the Paste tab and paste the JSON directly.
3
Review the preview
Check that nested fields became columns (for example user.address.city) and values look right.
4
Download CSV
Click Download CSV. The file opens cleanly in Excel, Google Sheets, or any tool that reads CSV.

Read the full guide Report a problem with this conversion

Frequently Asked Questions

How are nested JSON objects handled in CSV?: Nested objects are flattened with dot notation. {"user":{"name":"Alice"}} becomes a column named user.name. This keeps every value in a flat, spreadsheet-friendly table.
What happens to arrays?: Arrays of simple values (strings, numbers) are joined with commas inside one cell. Arrays of objects are written as JSON text in the cell so no data is lost.
Will my large IDs and leading zeros stay intact in the CSV?: Yes. The CSV is plain text, so values are written exactly as they appear in the JSON. Note that opening a CSV in Excel can still reformat such values: if you need guaranteed preservation, download as XLSX instead, which writes them as text cells.
Can I paste JSON instead of uploading?: Yes. Use the Paste tab, paste your JSON, and convert. Useful for quick one-off conversions of an API response.
Is my data private?: Completely. The conversion runs in your browser with JavaScript. Nothing is uploaded to any server.

CSV to JSON

Free, private, instant

JSON to Excel

Free, private, instant

CSV to Excel

Free, private, instant

NDJSON / JSONL to Excel

Free, private, instant

This tool is not affiliated with or endorsed by JSON or its parent company. All trademarks belong to their respective owners.

Convert JSON to CSV

How to Export and Convert JSON Data

Frequently Asked Questions

Related Converters