JSON to CSV Converter
Convert a JSON array of objects to CSV format. The tool extracts all unique keys across the objects to form the header row, then writes each object as a CSV row. Handles nested objects by flattening them with dot notation, and properly quotes fields that contain commas, quotes, or newlines.
What it does
- ▸Converts a JSON array of objects to CSV with a header row
- ▸Flattens nested objects using dot notation (user.name, user.address.city)
- ▸Properly quotes fields containing commas, quotes, or newlines
- ▸Supports custom delimiters (comma, semicolon, tab)
- ▸Collects all unique keys across objects for a complete header row
Use cases
- ▸Exporting JSON API data to CSV for analysis in a spreadsheet
- ▸Converting database query results to CSV for reporting
- ▸Preparing JSON data for import into a system that expects CSV
- ▸Creating a CSV template from a JSON sample
How it works
Paste your JSON array into the input pane
The tool extracts all unique keys and flattens nested objects
Each object is written as a CSV row with proper quoting
The CSV output appears in the output pane, ready to copy or save
Frequently asked questions
1How does it handle nested objects?
Nested objects are flattened using dot notation. For example, {"user": {"name": "Ada"}} becomes a column named user.name with the value Ada. Arrays are converted to JSON strings in the cell.
2What if objects have different keys?
The tool collects all unique keys across all objects in the array. Objects missing a key get an empty value in that column. This ensures the CSV has a consistent structure.
3Does it handle special characters in values?
Yes. Values containing commas, double quotes, or newlines are wrapped in double quotes, and any double quotes inside the value are escaped by doubling them. This follows RFC 4180 CSV specification.
Related tools
Use JSON to CSV offline in Devinity
All 95 tools run locally on your Mac. No internet required, no data sent to servers.
Download Devinity →