Paste a JSON array and get clean CSV output instantly — no server, no sign-up.
JSON Input
CSV Output
About JSON to CSV
JSON (JavaScript Object Notation) is the standard data format for APIs and web applications. CSV (Comma-Separated Values) is the universal tabular format for spreadsheets and databases. Converting from JSON to CSV is a common task when exporting API data to Excel, Google Sheets, or a database.
This tool converts your JSON array of objects to CSV entirely in the browser — no data is sent to any server. All keys across all objects are collected and used as headers, so sparse arrays are handled correctly.
Frequently asked questions
What JSON input is supported?
A JSON array of objects, e.g. [{"a":1},{"a":2}]. Each object becomes one CSV row.
What happens with nested objects or arrays?
Nested values are serialized as JSON strings inside the CSV cell. If you need flat data, pre-process your JSON to flatten it before converting.
Are null or missing fields handled?
Yes. Null values produce empty CSV cells. Missing keys also produce empty cells, so mismatched objects are handled safely.
How are special characters handled?
Fields containing the delimiter, double quotes, or newlines are automatically wrapped in double quotes and internal quotes are escaped per RFC 4180.