Paste a JSON array of objects or upload a .json file. Single objects are automatically wrapped in an array.
2
Select fields and options
Click "Parse & Preview" to see your data in a table. Pick which columns to include, choose a delimiter, and enable nested object flattening if needed.
3
Download CSV file
Click "Convert to CSV" then download the .csv file or copy it to clipboard — ready for Excel, Google Sheets, or any data tool.
FAQ
What JSON format is supported?
The tool accepts an array of objects (e.g., [{"name": "Alice", "age": 30}, ...]). Each object becomes a CSV row, and object keys become column headers. Single objects are automatically wrapped in an array.
How are nested objects handled?
When "Flatten Nested" is enabled, nested objects and arrays are automatically flattened using dot notation. For example, {"address": {"city": "NYC"}} becomes a column named "address.city" with value "NYC". Nested arrays use index notation like "items.0", "items.1". You can disable flattening to serialize nested values as JSON strings instead.
Can I select which columns to export?
Yes. Click "Parse & Preview" to see your data as a table. Column checkboxes appear above the editor — uncheck any column you want to exclude from the CSV output. Use the "All" and "None" buttons to quickly toggle selections.
Can I change the delimiter?
Yes. Choose between comma (default), tab, semicolon, or pipe delimiters. Tab-separated values (TSV) are useful for pasting into spreadsheets. Semicolons are common in European locales. Pipe-delimited files are used in some data interchange formats.
How are special characters handled?
Values containing the delimiter, double quotes, or newlines are automatically wrapped in double quotes per RFC 4180. Any existing double quotes inside values are escaped by doubling them ("").
Is my data sent to a server?
No. All conversion happens entirely in your browser using JavaScript. Your JSON data never leaves your device. Nothing is uploaded or stored anywhere.
Does this tool work on mobile devices?
Yes. The interface is fully responsive. You can paste JSON, upload a .json file, preview data in the table, and download the CSV — all from your phone or tablet.
How does this compare to using jq or pandas for JSON to CSV conversion?
jq (command line) and pandas (Python) give you full scripting control for complex transformations and pipelines. This tool is faster for one-off conversions — paste your JSON, click Convert, and download the CSV. No code, no dependencies, no setup.
Can I convert deeply nested JSON to CSV?
Yes. Enable "Flatten Nested" to automatically expand nested objects and arrays into dot-notation columns (e.g., address.city, items.0.name). Without flattening, nested values are serialized as JSON strings in the CSV cell.
Does the CSV file work with Excel and Google Sheets?
Yes. The downloaded .csv includes a UTF-8 BOM for proper character display in Excel. Both Excel and Google Sheets open the file correctly. Use tab or semicolon delimiters if your data contains many commas.
Is there a row or column limit?
No hard limit. The tool handles thousands of rows and dozens of columns without issue. The preview table shows up to 50 rows for quick inspection. For very large datasets (50K+ rows), command-line tools like Miller or csvkit may be faster.
What other Coda One tools pair well with JSON to CSV?
Use the <a href="/ai/dev/json">JSON Formatter</a> to validate your JSON before converting. If you need the reverse direction, the <a href="/ai/dev/csv-to-json">CSV to JSON Converter</a> converts CSV files back to JSON arrays.
Coda One's JSON to CSV Converter transforms JSON arrays into clean CSV files. Preview your data in an interactive table before converting. Select which columns to include, choose your delimiter (comma, tab, semicolon, or pipe), and flatten nested objects with dot notation. Upload a .json file or paste directly. Download as .csv or copy to clipboard. 100% client-side — your data never leaves the browser. Free, unlimited, no signup.