JSON to CSV Converter
Convert a JSON array to a CSV spreadsheet — auto-detects columns and missing fields.
What JSON format is supported?
The converter expects a JSON array of objects at the top level — [{"key": "value"}, ...]. Each object becomes a CSV row, and the union of all keys across all objects becomes the column headers. If an object is missing a key that another object has, the cell is left empty.
Frequently asked questions
What happens to nested objects or arrays?
Nested values (objects and arrays) are JSON-stringified into a single cell value. For example, {"tags": ["a","b"]} becomes a cell containing ["a","b"]. If you need flat output, pre-process your JSON to flatten nested structures first.
Can I open the CSV output in Excel?
Yes. Copy the output and paste it into a text editor, save as .csv, and open in Excel or Google Sheets. Alternatively, paste directly into a Google Sheets cell using “Paste special → Values only” and then use Data → Split text to columns.
Why must the input be an array?
CSV is inherently a tabular format — rows and columns. A JSON array maps directly to rows, and each object's keys map to columns. A plain JSON object (non-array) doesn't have a natural row structure, so it cannot be meaningfully represented as CSV without an explicit schema.
