What should the JSON input look like?

The input should be a JSON array of objects: [{...}, {...}, ...]. Each object becomes a row. The union of all keys across all objects becomes the column headers.

What happens if some objects are missing certain keys?

Missing keys result in empty cells for that row. All unique keys across all objects are included as columns.

Can it handle nested JSON objects?

Nested objects are serialised as JSON strings within their cell. For deeply nested data, flatten the JSON first before converting.

Can I choose which columns to include?

Yes. A column selector lets you choose which keys become columns and set their order. This is useful when the JSON has many fields but you only need a subset for the CSV.

Does it quote fields with commas automatically?

Yes. Any field value that contains a comma, double quote, or newline is automatically wrapped in double quotes in the CSV output, ensuring correct parsing by all CSV readers.

JSON to CSV Converter

Converts a JSON array of objects to a CSV file, automatically extracting all unique keys across all objects as column headers. Handles missing fields with empty cells. Output is ready to open in Excel, Google Sheets, or any CSV-compatible application.

Runs entirely in your browser — your input is never uploaded, stored, or logged.

Turn API response data or database exports into spreadsheet-ready CSV without writing a script. To go the other way, use the CSV to JSON converter.

How to Use

1Paste your JSON array into the input box.
2The CSV output appears automatically with headers from the keys.
3Copy the CSV or download it as a .csv file.

Common Uses

→Export JSON API response data to a spreadsheet
→Convert JSON config arrays for review in Excel or Google Sheets
→Flatten a JSON array for import into a database
→Share API response data with non-technical team members

Examples

JSON array to CSV

Input

[{"name":"Alice","score":95},{"name":"Bob","score":87}]

Output

name,score
Alice,95
Bob,87

Frequently Asked Questions

Related Tools

CSV to JSON

Convert CSV data into a JSON array of objects.

JSON Formatter & Validator

Beautify, minify, and validate JSON with syntax highlighting.

CSV Formatter

Format and validate CSV data with custom delimiter options.

New

JSON to YAML

Convert JSON to YAML format instantly.

Markdown to HTML

Convert Markdown to HTML instantly.

HTML to Markdown

Convert HTML markup to clean Markdown syntax.