JSON to CSV Converter
Paste a JSON array of objects to convert it to CSV format. The tool automatically extracts headers from object keys and flattens nested structures. Useful for data export, spreadsheet preparation, or converting API responses into formats that work with Excel or Google Sheets.
advanced options
returns
- body
- The CSV file, served as text/csv.
Fill in the fields and send a request. The response lands here.
Run it from your code
A temporary key takes one request and lasts seven days at 20 calls a day. Register and it becomes 75 a day, still free.
$ curl -sX POST "https://apixies.io/api/v1/json-to-csv" \ -H "X-API-Key: $APIXIES_KEY" \ -H "Content-Type: application/json" \ -d '{"data":"..."}'
questions
How does it handle nested JSON objects?
Nested objects are flattened using dot notation. For example, {"address": {"city": "NYC"}} becomes a column named "address.city" with value "NYC".
What if my JSON objects have different keys?
The CSV will include columns for all unique keys across all objects. Objects missing a key will have an empty value in that column.