JSON to CSV Converter
Convert JSON arrays to CSV online and download as a .csv file ready for Excel or Google Sheets. Flattens nested objects and exports all keys as column headers.
About the JSON to CSV Converter
The DevToolHeaven JSON to CSV Converter transforms JSON arrays into CSV format instantly. JSON arrays returned by APIs and databases can be converted to spreadsheet-compatible CSV files in seconds — no scripting required.
The converter automatically extracts the union of all unique keys across every object in the array as column headers. Objects missing a key get an empty cell in that column, handling real-world API responses where the schema varies across records. Values containing commas, quotes, or newlines are escaped per the RFC 4180 CSV specification.
Nested object flattening converts deep JSON structures into flat columns using dot notation. A nested field like {"address":{"city":"London","zip":"EC1A"}} becomes two columns — address.city and address.zip — making the output directly importable into Excel, Google Sheets, or pandas without cleanup.
Choose your delimiter to match the target application: comma for standard CSV, semicolon for European versions of Excel that use semicolons as the list separator, or tab for TSV format. The Download CSV button saves the file with the correct extension and MIME type.
Common use cases include: exporting API data for analysis in spreadsheets, loading JSON records into pandas or R data frames, converting database exports for bulk editing, migrating data between systems that expect different formats, and creating reports from JSON log or analytics files.
All processing is 100% client-side — your data never leaves your browser. There is no file size limit imposed by the tool; performance depends on your device memory.
Frequently Asked Questions
The converter accepts a JSON array of objects — the most common format returned by APIs. Each object in the array becomes one row in the CSV. If you have a single object, wrap it in square brackets: [{"key": "value"}]. Nested objects are automatically flattened using dot notation.
When the Flatten Nested Objects option is enabled, nested objects are flattened into dot-notation columns. For example, {"address": {"city": "New York"}} becomes a column named "address.city". Arrays within objects are converted to JSON strings in a single cell.
Yes. Choose comma (,) for standard CSV files, semicolon (;) for European Excel compatibility, or tab for TSV (tab-separated values) format. The selected delimiter is used for both the headers and all data rows.
Values containing the delimiter character, double quotes, or newlines are automatically wrapped in double quotes. Any double quotes within the value are escaped by doubling them ("). This follows the RFC 4180 CSV specification.
If an object in the array is missing a key that exists in other objects, the corresponding cell is left empty. The converter collects all unique keys across all objects, so every possible column is represented.
Yes. Download the CSV file and open it in Excel or Google Sheets. If you are using a semicolon delimiter, the file opens correctly in European versions of Excel that use semicolons as the list separator. For Google Sheets, use File > Import to control delimiter settings.
The converter scans every object in the array and collects the union of all unique keys as column headers. Objects missing a particular key have an empty cell in that column. This handles real-world API responses where the schema is inconsistent across records.
Yes — use the CSV to JSON converter for the reverse operation. It reads the first row as headers and converts each subsequent row into a JSON object, producing an array of objects that mirrors the original JSON-to-CSV transformation.
Paste your JSON array here, click Convert, then download the CSV file. Open Excel and use File > Open to open the CSV, or drag and drop it. Excel auto-detects the comma delimiter. If your values contain commas, use semicolon delimiter for European Excel versions that use semicolons as list separators.
Enable the Flatten Nested Objects option before converting. Nested objects are flattened using dot notation — for example {"user": {"name": "Alice"}} becomes a column named "user.name". Arrays within objects are serialized as JSON strings in a single cell, since spreadsheets cannot represent arrays as a single cell value.
CSV (Comma-Separated Values) uses commas to separate values. TSV (Tab-Separated Values) uses tab characters instead. TSV is useful when your data contains commas — for example addresses, sentences, or prices with decimal separators. Select the Tab delimiter option to produce TSV output that avoids quoting issues with comma-heavy data.
In Google Sheets, go to File > Import, upload your CSV file, and choose the separator type (comma or auto-detect). Alternatively, drag the CSV file directly onto the Google Drive page to create a new Sheet from it. For programmatic import, use the Google Sheets API or the IMPORTDATA() function with a publicly accessible CSV URL.