What JSON format works best?

An array of flat objects with consistent keys, e.g. [{"name": "A", "price": 10}, ...] — this maps cleanly to spreadsheet rows and columns.

What happens with nested objects?

With Flatten objects on, nested keys become dotted columns such as team.name. Turn it off to keep nested values as JSON text in a single cell. Arrays are written as JSON, or joined with semicolons when you tick Join arrays.

Is my data uploaded anywhere?

No, conversion happens entirely in your browser.

Can I choose which fields get exported as columns?

Every key found in any object becomes a column. To drop some, delete them from the JSON first.

How are commas or quotes inside values handled?

Values containing the delimiter, quotes, line breaks or leading and trailing spaces are wrapped in quotes with inner quotes doubled, following RFC 4180. Quote all forces quotes everywhere.

Does column order match the order of keys in my JSON?

Columns follow the order in which keys first appear across the objects, so keep keys in a consistent order for predictable columns.

Can I download the result directly as a .csv file?

Yes, a dedicated download button saves the converted output as a .csv file.

Will Excel open the file correctly?

Tick Excel BOM to add a byte-order mark so accents display properly, choose Semicolon if your region uses it, and tick Formula guard to stop values starting with = + - or @ from being run as formulas.

Processed 100% locally in your browser

JSON to CSV Converter

Convert JSON to CSV with delimiter, nesting, arrays, Excel and formula-safety options, and a table preview.

Loading tool…

Quick Answer

JSON to CSV Converter lets you: Convert JSON to CSV with delimiter, nesting, arrays, Excel and formula-safety options, and a table preview. To start, paste a JSON array of objects into the editor.

How to use this tool

1
Paste your JSON
Paste a JSON array of objects into the editor.
2
View the CSV output
See the converted CSV appear instantly, with columns from your object keys.
3
Copy or download
Copy the CSV text or download it as a .csv file.

Format & Performance Scorecard

Feature	JSON	CSV
Structure	Nested key-value objects	Flat, tabular rows
Best for	APIs, config files, nested data	Spreadsheets, tabular data
Readability	Structured, self-describing	Simple, compact
Common use	Web apps, data interchange	Excel, databases imports

Frequently Asked Questions

JSON Formatter

A full-screen JSON editor: format, validate, repair, sort keys, and explore as a tree, table or JSONPath query — 100% local.

CSV to JSON

Convert CSV to JSON and back, with delimiter detection, type detection and a table preview — 100% local.

JSON to CSV Converter

How to use this tool

Paste your JSON

View the CSV output

Copy or download

Format & Performance Scorecard

Frequently Asked Questions

What JSON format works best?

What happens with nested objects?

Is my data uploaded anywhere?

Can I choose which fields get exported as columns?

How are commas or quotes inside values handled?

Does column order match the order of keys in my JSON?

Can I download the result directly as a .csv file?

Will Excel open the file correctly?

Related Tools

JSON Formatter

CSV to JSON

JSON to CSV Converter

How to use this tool

Paste your JSON

View the CSV output

Copy or download

Format & Performance Scorecard

Frequently Asked Questions

What JSON format works best?

What happens with nested objects?

Is my data uploaded anywhere?

Can I choose which fields get exported as columns?

How are commas or quotes inside values handled?

Does column order match the order of keys in my JSON?

Can I download the result directly as a .csv file?

Will Excel open the file correctly?

Related Tools

JSON Formatter

CSV to JSON