Paste JSON array
Delimiter:
CSV Output
What This Tool Does
The JSON to CSV Converter transforms JSON arrays into comma-separated values format, which can be opened in Excel, Google Sheets, or any spreadsheet application. It handles nested objects by flattening them to dot-notation column names, and converts nested arrays to JSON strings so no data is lost.
How to Use
1. Paste a JSON array into the input box, or click Sample to try an example.
2. Choose your preferred delimiter (comma is standard CSV).
3. The CSV output generates automatically as you type.
4. Click Download CSV to save the file, or Copy Output to paste it elsewhere.
Frequently Asked Questions
What JSON structure does this tool support?
The tool supports JSON arrays of objects (the most common API response format). Each object becomes a row, and the keys of the first object become the column headers. Nested objects are flattened using dot notation (e.g. "address.city").
Can I change the delimiter?
Yes — you can switch between comma (standard CSV), semicolon (common in Europe), tab (TSV), and pipe delimiters using the options above the output.
What happens with nested objects or arrays?
Nested objects are flattened to dot-notation keys. Nested arrays are converted to a JSON string representation within the cell so no data is lost.
Is my data sent to a server?
No. Everything runs in your browser using JavaScript. Your JSON data never leaves your device.
Can I download the result?
Yes — click the Download CSV button to save the file directly to your device.