JSON to CSV Converter
100% PrivateData & JSON ToolsConvert a JSON array of objects into a spreadsheet-ready CSV file.
Runs entirely in your browser. Your input is not uploaded to Ovatly or anywhere else.
- 1Paste a JSON array of objects, or upload a .json file.
- 2Press Convert to CSV.
- 3Check the record and column counts above the result.
- 4Copy the CSV or download it as converted.csv.
Input: [{"name":"Ana","address":{"city":"Lisbon"}},{"name":"Ben","address":{"city":"Porto"},"age":31}] Output: name,address.city,age Ana,Lisbon, Ben,Porto,31 Columns are the union of all keys, in the order they first appear. Missing values stay empty.
- Nested objects are flattened with dot keys. Arrays of simple values are joined with a semicolon and a space; arrays containing objects are written as JSON text in the cell.
- A single JSON object is treated as a one-row table. Scalars and mixed arrays are rejected with an explanation, because they have no clear columns.
- All values are written as they appear in the JSON; no dates or numbers are reformatted.
The column list is the union of keys across every record. A key present in only one record still gets a column, and the other rows leave it blank.
About this tool
The JSON to CSV Converter turns a JSON array of objects into a spreadsheet-ready CSV file. Nested objects are flattened into dot-style columns such as address.city, which keeps the conversion predictable when records have different shapes.
Related tools
Part of Ovatly's free tools in Data & JSON Tools.