JSON to CSV

Convert a JSON array of objects to CSV for Excel, Google Sheets, no-code tools, and data imports.

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 that transforms a JSON array of objects into a CSV table for Excel, Google Sheets, no-code tools, data imports, API responses, tests, and documentation. The tool runs in your browser and does not send data to the server.

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 a CSV delimiter: comma, semicolon, tab, or custom.
Configure headers, column collection, nested object flattening, array handling, and null treatment.
Copy or download the CSV for Excel, Google Sheets, no-code tools, data imports, scripts, or documentation.

More about this tool

JSON to CSV converts a JSON array of objects into a CSV table for Excel, Google Sheets, no-code tools, data imports, API responses, tests, and documentation. The tool can take column names from the first object or collect all keys across the entire array, add a header row, flatten nested objects using dot notation, handle arrays and null values, and correctly escape quotes, delimiters, and line breaks within values.

You can copy the result or download it as a data.csv file.

All processing is done locally in the browser. Your data is not sent to the server.

Runs in the browser
Data is not sent to the server
Converts JSON to CSV
Supports arrays of objects
Collects columns from all objects
Can flatten nested objects
Correctly escapes quotes and line breaks
Can download the CSV file
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 a CSV with a header row and data rows.

What kind of JSON works best for CSV?

An array of objects works best, for example [{"name":"Alice","email":"alice@example.com"}]. A single object can be converted to a single-row CSV.

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 different objects have different keys.

What can be done with nested objects?

Nested objects can be flattened using dot notation (user.name, user.email), serialized as a JSON string, or nested fields can be ignored.

What happens to arrays inside JSON?

Arrays can be serialized as a JSON string, joined with a separator, or replaced with the element count. For arrays of objects, serializing to JSON is usually the safest option.

Which delimiter should I choose for Excel?

Different Excel locales may open CSV files better with a comma or a semicolon. Choose the delimiter that matches your target locale in the settings.

How are quotes and commas inside values escaped?

If a value contains the delimiter, quotes, or a newline, it is wrapped in double quotes, and any double quotes inside the value are doubled.

Can I download the 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: it converts a CSV table into JSON.

Is my data sent to the server?

No. JSON is processed locally in the browser and is not sent to the server.

Do I need to register?

No. The tool works immediately without registration.

How to use

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

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

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

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

More about this tool

You can copy the result or download it as a data.csv file.

All processing is done locally in the browser. Your data is not sent to the server.

Runs in the browser
Data is not sent to the server
Converts JSON to CSV
Supports arrays of objects
Collects columns from all objects
Can flatten nested objects
Correctly escapes quotes and line breaks
Can download the CSV file
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 a CSV with a header row and data rows.

What kind of JSON works best for CSV?

An array of objects works best, for example [{"name":"Alice","email":"alice@example.com"}]. A single object can be converted to a single-row CSV.

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 different objects have different keys.

What can be done with nested objects?

Nested objects can be flattened using dot notation (user.name, user.email), serialized as a JSON string, or nested fields can be ignored.

What happens to arrays inside JSON?

Arrays can be serialized as a JSON string, joined with a separator, or replaced with the element count. For arrays of objects, serializing to JSON is usually the safest option.

Which delimiter should I choose for Excel?

Different Excel locales may open CSV files better with a comma or a semicolon. Choose the delimiter that matches your target locale in the settings.

How are quotes and commas inside values escaped?

If a value contains the delimiter, quotes, or a newline, it is wrapped in double quotes, and any double quotes inside the value are doubled.

Can I download the 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: it converts a CSV table into JSON.

Is my data sent to the server?

No. JSON is processed locally in the browser and is not sent to the server.

Do I need to register?

No. The tool works immediately without registration.