What happens if objects have different keys?

The converter uses the union of all keys as columns. Objects missing a key will have an empty cell in that column.

Are nested objects flattened?

Nested objects are serialized as JSON strings in the CSV cell. Use the JSON tree viewer to flatten the structure first if you need individual columns.

Can I download the CSV?

Yes. The tool provides a download button that saves the result as a .csv file you can open directly in Excel or Google Sheets.

Convert JSON Array to CSV

A JSON array of objects is the most common format for tabular data returned by APIs. This example shows a user list with consistent keys across all objects. The JSON to CSV converter reads the keys from the first object as column headers and maps values row by row. This is the fastest way to get API data into Excel or Google Sheets without writing any code.

Example

[
  { "id": 1, "name": "Alice", "email": "[email protected]", "role": "admin", "active": true },
  { "id": 2, "name": "Bob", "email": "[email protected]", "role": "user", "active": true },
  { "id": 3, "name": "Carol", "email": "[email protected]", "role": "user", "active": false },
  { "id": 4, "name": "Dave", "email": "[email protected]", "role": "editor", "active": true },
  { "id": 5, "name": "Eve", "email": "[email protected]", "role": "user", "active": false }
]

[ open in JSON to CSV → ]

FAQ

What happens if objects have different keys?: The converter uses the union of all keys as columns. Objects missing a key will have an empty cell in that column.
Are nested objects flattened?: Nested objects are serialized as JSON strings in the CSV cell. Use the JSON tree viewer to flatten the structure first if you need individual columns.
Can I download the CSV?: Yes. The tool provides a download button that saves the result as a .csv file you can open directly in Excel or Google Sheets.

Related Examples

Format a REST API Response

REST APIs return compact JSON that is hard to read at a glance. Paste this examp...

Explore Deeply Nested JSON

Deep nesting is common in configuration files, CMS payloads, and analytics event...

Format a CSV User List

User lists exported from databases, CRMs, or admin panels are among the most com...