JSON to CSV Converter
Paste a JSON array and get a clean CSV file instantly.
About the JSON to CSV Converter
This tool converts JSON to CSV, flattening an array of objects into rows and columns. Nested objects become dotted column names and keys are collected across every record, so an API response opens straight in Excel, Sheets or Numbers without any hand-editing first.
Convert JSON to CSV when structured data has to reach someone who works in a spreadsheet. An API response, a log export or a database dump is fine as JSON for code, but a colleague in finance or ops wants columns they can sort and filter.
Nesting is the awkward part. An object inside an object is flattened to a dotted column name — user.address.city becomes one column — so nothing is lost and no cell contains raw JSON. Keys are collected across every record, so objects with different fields still line up into a consistent header row.
Fields containing commas, quotes or line breaks are escaped to the CSV standard, which means the file opens cleanly in Excel instead of splitting a description across three columns.
How to use the JSON to CSV Converter
- Paste your JSON. Provide a JSON array of objects, or upload a .json file.
- Convert. Run the conversion. Keys are collected across all records to build the header row.
- Review the columns. Check the flattened column names, including dotted names from nested objects.
- Download the CSV. Save the file and open it in Excel, Sheets or Numbers.
JSON to CSV Converter features
- Handles nested objects
- Array support
- Auto-detects structure
- Custom delimiters
- File upload support
- Real-time preview
Frequently asked questions
How are nested objects handled?
They are flattened into dotted column names, so user.address.city becomes a single column rather than raw JSON in a cell.
What if my objects have different keys?
Keys are collected across every record to build one header row. Missing values are left as empty cells.
Are commas inside values escaped?
Yes. Values containing commas, quotes or line breaks are quoted and escaped so the CSV opens correctly in Excel.
Does it accept a single object rather than an array?
An array of objects is the expected input. Wrap a single object in square brackets to convert it as one row.
How are arrays inside records handled?
Array values are serialised into the cell so no data is lost. Split them beforehand if you need one row per item.