📊 JSON to CSV Converter
Turn API responses into a spreadsheet: nested fields become columns like address.city.
🔒 Runs in your browser · files never uploaded
Drop a JSON file here or click to browse An array of objects – nested objects become dot.keys. Stays on your device.
How to use the JSON to CSV Converter tool
- Paste a JSON array of objects or drop a .json file.
- Pick the delimiter and how arrays inside objects are handled.
- Copy the CSV or download a .csv (tick BOM for Excel).
Frequently asked questions
How are nested objects handled?
They are flattened with dot notation: {"address":{"city":"Pune"}} becomes a column named address.city. Arrays can be kept as JSON text, joined with "; ", or spread into tags.0, tags.1 columns.
What order are the columns in?
Keys appear in the order they are first seen, starting with the first object. Keys that only exist in later objects are appended at the end, and missing values are left empty.
Why do accented characters look wrong in Excel?
Excel on Windows assumes a legacy encoding for CSV unless the file starts with a UTF-8 byte-order mark. Tick "UTF-8 BOM" before downloading. Excel users in Europe may also prefer the semicolon delimiter.