Need the reverse conversion?
CSV to JSON ConverterJSON Input
CSV Output
Settings
Conversion Options
Enter JSON data to convert to CSV
Your converted data will appear here
JSON to CSV Converter
Why Use JSONSwiss’s JSON to CSV Converter?
- 1
Turn arrays and objects into copyable or downloadable CSV in the browser.
- 2
Flatten nested objects into dot-notated columns when you need tabular fields.
- 3
Set headers, quoting, and comma, semicolon, tab, or pipe delimiters for the next system.
JSON to CSV Converter is for moving structured JSON into a simple tabular file without a spreadsheet setup step. It keeps the conversion local while giving you output settings that match the importer, database tool, or reporting workflow receiving the CSV.
Convert JSON to CSV Online
JSON to CSV Converter turns valid JSON arrays and objects into text rows and columns in the browser. You can copy the generated CSV for a quick paste into another tool or download it when you need a portable file for import, review, or handoff.
The cleanest source is an array of objects with consistent fields, but the converter also handles a single object and other supported JSON shapes. Validate the source first when a malformed document would otherwise make the exported columns hard to interpret.
Convert a JSON Array to CSV
An array of similarly shaped objects maps naturally to a header row followed by one data row per object. For example, an array of orders can create id, status, and total columns, while absent properties remain empty for the rows that do not have them.
Before you export, use the JSON to CSV Converter output to check whether the fields form a useful table. You can also review JSON in a table when you want to scan rows and sparse values before producing a CSV file.
Convert Nested JSON to CSV
With nested-field flattening enabled, JSON to CSV Converter creates dot-notated columns such as customer.name and shipping.city. This preserves the path to a nested value while making it possible to use the field in a conventional CSV header.
When flattening is off, nested objects and arrays are represented as JSON strings in a cell rather than being expanded into multiple columns. Use the JSON Formatter to format JSON before conversion when you need to inspect a nested source before choosing the output shape.
Choose CSV Headers, Quotes, and Delimiters
CSV is not always comma-separated: the target system may expect semicolons, tabs, or pipes. JSON to CSV Converter lets you choose the delimiter and set header and quoting behavior so the output does not need a second cleanup step in a text editor.
Quoting is useful when string values contain a delimiter, a line break, or text that should remain visibly separate from a number. Choose settings based on the receiving application rather than assuming every CSV import uses the same defaults.
JSON to CSV Converter Examples
Reference demo
Flatten a nested customer field
With nested-field flattening enabled, each object becomes a CSV row and nested values become dot-notated headers.
JSON input
1
[
2
{
3
"name": "Maya",
4
"address": { "city": "Zurich" }
5
}
6
]
CSV output
1
name,address.city
2
Maya,Zurich
Change the delimiter, header, and quote settings to match the system receiving the CSV file.
Reference demo
Turn an order array into CSV rows
A consistently shaped JSON array becomes a header row followed by one CSV row per order.
JSON array
1
[
2
{ "id": "ord_101", "status": "paid", "total": 29 },
3
{ "id": "ord_102", "status": "pending", "total": 14 }
4
]
CSV rows
1
id,status,total
2
ord_101,paid,29
3
ord_102,pending,14
When a later object has no value for a header, its exported cell is left empty.
Reference demo
Use a semicolon delimiter for regional imports
Choose the delimiter expected by the receiving system instead of assuming every CSV import uses a comma.
JSON input
1
[
2
{ "id": "u_01", "email": "maya@example.com", "active": true }
3
]
Semicolon-delimited CSV
1
id;email;active
2
u_01;maya@example.com;true
Use the quote setting when a string contains the chosen delimiter, a line break, or other text that must stay in one cell.
How to Convert JSON to CSV
- 1Paste or import valid JSON into the JSON to CSV Converter.
- 2Choose nested flattening, headers, quotes, and the delimiter required by the next system.
- 3Review the CSV text, then copy it or download the file.
If you need a workbook rather than plain-text output, use JSON to Excel to export as an Excel workbook.
Related JSON Tools
Frequently Asked Questions
How do I convert JSON to CSV online?
Paste or import valid JSON, choose conversion options, then copy or download the generated CSV. Arrays of similarly shaped objects produce the clearest table output.
Can I convert a JSON array to CSV?
Yes. An array of objects becomes a header row plus one CSV row for each object. A single object and primitive values can also be converted into a usable table.
How are nested JSON objects handled?
With Flatten Nested Objects enabled, nested object fields use dot notation such as user.name. When it is disabled, nested objects and arrays are kept as JSON strings inside a CSV cell.
Can I open the CSV in Excel?
Yes. Download the CSV and open it in Excel or another spreadsheet application. Choose the delimiter that matches the application or region where you will import it.
Can I choose CSV headers, quotes, and delimiters?
Yes. You can include or omit headers, choose comma, semicolon, tab, or pipe delimiters, and control quoting. Leaving quotes enabled is safer when fields contain delimiters or newlines.