Skip to content
Developer Tools

JSON to CSV Converter

Convert JSON arrays to CSV — preview data, pick columns, flatten nested objects

Free in browser No sign-up required Immediate results
JSONBase64URL EncodeHashRegexDiffColor
JSON Input
CSV Output
How it works

Run this tool in three short steps.

01

Paste JSON array

Paste a JSON array of objects or upload a .json file. Single objects are automatically wrapped in an array.

02

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.

03

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.

Questions

What people ask before they use this tool.

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. Conversion happens in your browser using JavaScript, and your JSON data is not uploaded to our servers during processing.
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="/json-formatter">JSON Formatter</a> to validate your JSON before converting. If you need the reverse direction, the <a href="/csv-to-json-converter">CSV to JSON Converter</a> converts CSV files back to JSON arrays.
Related

Continue the workflow.

CSV to JSON

Convert CSV to JSON

Open
JSON Formatter

Format & validate JSON

Open
Text Diff

Compare two texts

Open
Markdown Editor

Write & preview Markdown

Open

AI-powered writing tools

10 writing tools free to try — humanize, rewrite, summarize, translate, and more.

AI Humanizer
Make AI text undetectable
AI Detector
Check if text is AI-generated
Email Writer
Generate professional emails
View all plans — from $9.99/mo 3 free uses/day, no signup

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. Conversion runs in your browser, and data is not uploaded to our servers during processing.

More:  All Dev Tools  · JSON  · Base64  · Hash  · Regex