JSON to CSV

Online JSON to CSV converter for object arrays for Excel, Google Sheets, no-code, and data import.

Обработка выполняется локально в браузере. Данные не отправляются на сервер.

For this tool, processing runs locally in your browser and data is not sent to the server.

JSON to CSV is a free online converter for turning JSON object arrays into CSV tables for Excel, Google Sheets, no-code, and data import. Processing runs locally in your browser.

What it does

Output

Processing

Continue working

Choose a related tool for the next step.

Data passed between tools is kept only in the current browser session.

How to use

Paste a JSON array of objects or a single JSON object.
Choose CSV delimiter: comma, semicolon, tab, or custom.
Configure headers, column collection, nested object flattening, array handling, and null values.
Copy or download CSV for Excel, Google Sheets, no-code, data import, scripts, or documentation.

More about this tool

JSON to CSV converter transforms JSON object arrays into CSV tables for Excel, Google Sheets, no-code, data import, API responses, tests, and documentation.

The tool can take columns from the first object or collect all keys from the array, add a header row, flatten nested objects with dot notation, handle arrays, null values, quotes, delimiters, and line breaks inside values. CSV can be copied or downloaded as data.csv.

Processing runs locally in your browser.

Converts JSON to CSV
Supports array of objects
Collects columns from all objects
Can flatten nested objects
Escapes quotes and line breaks correctly
Can download CSV file
Runs in the browser
Data is not sent to the server
No registration required

Frequently Asked Questions

How do I convert JSON to CSV?

Paste a JSON array of objects, choose CSV settings, and click Convert. The tool creates CSV with headers and data rows.

Which JSON works best for CSV?

An array of objects works best, e.g. [{"name":"Ivan","email":"ivan@example.com"}]. A single object can become one CSV row.

Where do column headers come from?

Headers can come from the first object or be collected from all objects in the array. The second option is safer when objects have different keys.

What about nested objects?

Nested objects can be flattened with dot notation, e.g. user.name and user.email, saved as a JSON string, or ignored.

What happens to arrays inside JSON?

Arrays can be saved as a JSON string, joined with a separator, or replaced with element count. For object arrays, saving as JSON string is often safer.

How do I choose a delimiter for Excel?

Different Excel locales may prefer comma or semicolon CSV. Choose the delimiter that fits your region in settings.

How are quotes and commas escaped?

If a value contains a delimiter, quotes, or line breaks, it is wrapped in double quotes and internal quotes are doubled.

Can I download a CSV file?

Yes. The tool lets you download the result as data.csv.

How is JSON to CSV different from CSV to JSON?

JSON to CSV turns JSON objects into a table. CSV to JSON does the reverse: converts a CSV table to JSON.

Is my data sent to the server?

No. Processing runs locally in your browser and data is not sent to the server.

Do I need to register?

No. The tool works without registration.

How to use

Paste a JSON array of objects or a single JSON object.

Choose CSV delimiter: comma, semicolon, tab, or custom.

Configure headers, column collection, nested object flattening, array handling, and null values.

Copy or download CSV for Excel, Google Sheets, no-code, data import, scripts, or documentation.

More about this tool

JSON to CSV converter transforms JSON object arrays into CSV tables for Excel, Google Sheets, no-code, data import, API responses, tests, and documentation.

Processing runs locally in your browser.

Converts JSON to CSV
Supports array of objects
Collects columns from all objects
Can flatten nested objects
Escapes quotes and line breaks correctly
Can download CSV file
Runs in the browser
Data is not sent to the server
No registration required

Frequently Asked Questions

How do I convert JSON to CSV?

Paste a JSON array of objects, choose CSV settings, and click Convert. The tool creates CSV with headers and data rows.

Which JSON works best for CSV?

An array of objects works best, e.g. [{"name":"Ivan","email":"ivan@example.com"}]. A single object can become one CSV row.

Where do column headers come from?

Headers can come from the first object or be collected from all objects in the array. The second option is safer when objects have different keys.

What about nested objects?

Nested objects can be flattened with dot notation, e.g. user.name and user.email, saved as a JSON string, or ignored.

What happens to arrays inside JSON?

Arrays can be saved as a JSON string, joined with a separator, or replaced with element count. For object arrays, saving as JSON string is often safer.

How do I choose a delimiter for Excel?

Different Excel locales may prefer comma or semicolon CSV. Choose the delimiter that fits your region in settings.

How are quotes and commas escaped?

If a value contains a delimiter, quotes, or line breaks, it is wrapped in double quotes and internal quotes are doubled.

Can I download a CSV file?

Yes. The tool lets you download the result as data.csv.

How is JSON to CSV different from CSV to JSON?

JSON to CSV turns JSON objects into a table. CSV to JSON does the reverse: converts a CSV table to JSON.

Is my data sent to the server?

No. Processing runs locally in your browser and data is not sent to the server.

Do I need to register?

No. The tool works without registration.