JSON to CSV Converter
Convert a JSON array of objects into CSV — columns are the union of all keys in first-appearance order, missing values stay blank, and rows use CRLF line endings per RFC 4180.
Paste your JSON
How it works
- Parses the input and requires a JSON array at the top level
- Walks every element and collects the union of all keys in first-appearance order as the header row
- Serializes each value: null and undefined become empty cells, objects and arrays become JSON strings, and strings containing commas, quotes or newlines are wrapped in double quotes with inner quotes doubled (
"") - Joins rows with CRLF (
\r\n) line endings and appends a trailing newline, per RFC 4180
About JSON to CSV Converter
A JSON array of objects and a CSV table describe the same shape: each element is a row, each key is a column, and the value fills the cell. Converting between the two lets you move data out of APIs and scripts and into spreadsheets, or hand tabular data to tools that only speak CSV.
Reach for this tool when you need to export data to Excel or Google Sheets, or migrate records between systems. A few caveats: nested objects and arrays are serialized as JSON strings inside the cell rather than flattened; columns are the union of all keys in first-appearance order, so elements with missing keys simply leave those cells blank; and null or undefined values become empty cells — a null and an empty string look identical after conversion.