JSON to CSV Converter

What this tool does

Convert a JSON array of objects into CSV rows and columns for spreadsheet workflows. Each JSON object becomes one CSV row, and each key becomes a column header. This is useful for API responses, exports, spreadsheet review, and quick tabular analysis. Nested objects are flattened into dot-notation columns such as `user.name` and `user.email`, so nested values can map to spreadsheet columns. If records use inconsistent keys, missing values appear as empty cells.

• Each object becomes one row
• Keys become column headers
• Missing keys result in empty cells

Tool interface

Example input

Primary example (flat JSON):
[
  { "name": "Ana", "email": "ana@example.com", "age": 28 },
  { "name": "Bob", "email": "bob@example.com", "age": 34 }
]

Nested JSON example (flattened output):
[
  { "user": { "name": "Ana", "email": "ana@example.com" }, "age": 28 },
  { "user": { "name": "Bob", "email": "bob@example.com" }, "age": 34 }
]

Missing keys example (empty cells):
[
  { "name": "Ana", "age": 28 },
  { "name": "Bob" }
]

Example output

Primary example (flat JSON):
name,email,age
Ana,ana@example.com,28
Bob,bob@example.com,34

Nested JSON example (flattened output):
user.name,user.email,age
Ana,ana@example.com,28
Bob,bob@example.com,34

Missing keys example (empty cells):
name,age
Ana,28
Bob,

• Keys become column headers and each object becomes one CSV row.
• Nested object keys are flattened into dot-notation columns such as `user.name` and `user.email`.
• If some objects do not contain every key, the converter leaves those CSV cells empty.

Step-by-step instructions

1. Paste a valid JSON array of objects.
2. Check that each object contains the fields you want as CSV columns.
3. If your data is not an array of objects, fix the structure before converting.
4. If the JSON includes nested arrays or complex nested data, flatten it first so values map to usable columns.
5. Run the conversion.
6. Review the generated header row and values.
7. Copy or download the CSV for Excel, Google Sheets, or imports.

Common use cases

• Exporting API response data into spreadsheets.
• Preparing JSON datasets for reporting or CSV imports.
• Sharing tabular data with non-technical teams.
• Checking records before loading data into downstream systems.

Use this converter to quickly validate tabular output before loading data into reporting tools, spreadsheets, or downstream imports.

Common mistakes to avoid

• Pasting a single JSON object instead of an array. The converter expects an array of records.
• Using invalid JSON syntax (missing commas, quotes, or brackets).
• Expecting nested arrays to automatically flatten into clean spreadsheet columns.
• Using inconsistent keys across records, which leads to empty cells in output.
• Pasting NDJSON (newline-delimited JSON) instead of a standard JSON array.
• Expecting deeply nested arrays to become clean spreadsheet columns without preprocessing.

Frequently Asked Questions

Related tools

• JSON Flatten / JSON to CSV
• CSV to JSON Converter
• JSON Validator
• JSON Formatter
• NDJSON to CSV Converter
• CSV Cleaner

Related guides

• How to Convert JSON to CSV
• How to Flatten JSON

Related categories

Looking for other utilities in this area? CSV Tools, JSON Tools