What this tool does
Converts a JSON array of objects to CSV. Object keys become column headers. Nested objects are flattened with dot notation.
Data and text tool
JSON to CSV Converter
Convert JSON arrays to CSV format for use in Excel, Google Sheets, or data analysis tools. Handles nested objects and arrays.
Complete guide
How to use JSON to CSV Converter
Developer tools guide for json to csv converter users.
JSON is the output format of most APIs. CSV is what spreadsheets and data tools expect. Converting between them is a daily task for data analysts, backend developers, and anyone exporting API data to a spreadsheet.
This tool flattens JSON arrays of objects into CSV rows, using the object keys as column headers. Nested objects are dot-notated (e.g. address.city). Arrays within objects are serialised as strings.
How to use it
Paste a JSON array. Click Convert. Download the CSV or copy it. The first row contains the keys as headers.
Edge cases
Nested objects: flattened to 'parent.child'. Arrays in values: serialised as a quoted string. Missing keys: output as empty cells.
Quick checklist
- Input must be a JSON array (starts with [). Object input is not supported directly.
- Nested objects become dot-separated columns: address.city, address.zip.
- Check the output in your spreadsheet tool — some tools need the delimiter set to comma.
- For the reverse, use the CSV to JSON tool.
Answers
JSON to CSV Converter FAQs
What JSON structure does this accept?
An array of objects: [{}, {}, ...]. Each object becomes a row; the keys of the first object determine the columns.
What happens to nested JSON objects?
They are flattened using dot notation. {address: {city: 'London'}} becomes a column named 'address.city'.
What happens to array values inside objects?
They are serialised as a quoted JSON string in the CSV cell.
Can I convert a single JSON object (not an array)?
Wrap it in an array: [{...}]. The tool requires an array of objects.