JSON to CSV
Convert a JSON array of objects into a spreadsheet-ready CSV file.
Related Tools
Convert CSV to JSON with delimiter detection and header toggle.
Convert CSV rows into SQL INSERT statements.
Beautify and pretty-print JSON with configurable indentation.
Generate TypeScript interfaces or type aliases from JSON.
Convert JSON to YAML while preserving key order.
Convert YAML to JSON with instant syntax validation.
Documentation
What is JSON to CSV?
It converts a JSON array of objects into a spreadsheet-ready CSV file — the most common shape for exporting API responses into Excel or a database import tool.
Example
Input: [{"name":"Alice","age":30},{"name":"Bob","age":25}]
name,age Alice,30 Bob,25
Common errors
The input must be a JSON array at the top level — a single object or a deeply nested structure without a flat array of records won't convert cleanly.
Frequently Asked Questions
What JSON shape does this expect?▾
An array of flat-ish objects, like [{"name":"Alice","age":30}]. Each object becomes a row; the union of all keys across every object becomes the column headers.
What happens to missing fields?▾
If an object is missing a key that other objects have, that cell is left blank in the output row — the column still exists.
What happens to nested objects or arrays?▾
A nested value is serialized as a compact JSON string inside its cell, so no data is lost, though it won't be split into further columns.
Can I open the output in Excel or Google Sheets?▾
Yes — the output is standard RFC 4180 CSV. Download it as a .csv file and open it directly in any spreadsheet application.
Does this tool upload my data?▾
No. The conversion runs entirely in your browser; nothing is sent to a server.