JSON to CSV
Turn API responses and JSON exports into a spreadsheet-friendly CSV. Columns are collected from every object, nested objects can be flattened into dotted columns, and values are quoted where needed.
CSV output
How to convert JSON to CSV
- Paste a JSON array of objects (or a single object) into the input.
- Choose the delimiter and how nested values should be handled.
- Check the preview and any conversion errors.
- Download the .csv file or copy the text.
Frequently asked questions
How are nested objects and arrays handled?
With Flatten on, nested objects become columns like address.city. Arrays, and nested objects when Flatten is off, are written as JSON text in a single cell.
Will the CSV open correctly in Excel?
Yes. Turn on the UTF-8 BOM option so Excel detects UTF-8 and shows accented characters correctly.
Related tools
- CSV to JSONConvert CSV rows into a JSON array.
- JSON FormatterPretty-print or minify JSON with clear error locations.
- JSON ValidatorCheck JSON syntax and see exactly where it breaks.
More in Code & Data.