What JSON structure does this tool expect?

An array of objects: [{"name": "Alice", "age": 30}, {"name": "Bob", "age": 25}]. The keys of the first object are used as column headers. If later objects have additional keys not present in the first object, those values will be missing from the output. Nested objects and arrays are converted to their JSON string representation in the CSV cell.

How are nested JSON objects handled in CSV output?

CSV is a flat format — it doesn't support nested data. Nested objects are serialized to their JSON string representation and placed in a single cell. For example, {"address": {"city": "NYC"}} would produce a cell containing {"city":"NYC"}. For deeply nested JSON, you may want to flatten the structure first.

What happens if my JSON values contain commas?

Values containing commas, double quotes, or newlines are automatically wrapped in double quotes in the CSV output. Double quotes within the value are escaped as two double quotes (""). This follows the RFC 4180 CSV standard, which is supported by Excel, Google Sheets, and all major data tools.

My CSV has garbled characters when opened in Excel. Why?

Excel on Windows expects CSV files in a system-specific encoding (often Windows-1252). This tool outputs UTF-8, which is the correct standard but can cause encoding issues in older Excel versions. Try: open Excel, go to Data → From Text/CSV, and select the file with UTF-8 encoding in the import wizard rather than double-clicking the file.

Can I convert a JSON object (not an array) to CSV?

This tool requires a JSON array as input. If you have a single JSON object, wrap it in an array: [{"key": "value", ...}]. If you have a nested JSON object with arrays as values, you'd need to restructure it manually or use a specialized tool that understands your specific JSON schema.

JSON to CSV — Convert Arrays to Spreadsheet Format

Convert a JSON array of objects into a CSV file ready for Excel, Google Sheets, or any data analysis tool. The JSON must be an array of objects with consistent keys — the keys become the CSV header row and each object becomes a row. Values containing commas or quotes are automatically escaped. Works entirely in your browser with no data uploaded.

Input

Output

How to use this tool

Paste your JSON array
The input must be a JSON array: [{...}, {...}, ...]. Each object in the array becomes one row in the CSV. Property names must be consistent across objects.
Click Convert
Property names from the first object become the CSV header row. Each object's values are extracted in header order. Missing values become empty cells. Values with commas, double quotes, or newlines are automatically wrapped in quotes and escaped.
Download the CSV
Click Download to save a .csv file. Open it directly in Excel, Google Sheets, Numbers, or any data tool.
Import into a spreadsheet
In Excel: File → Open → select your CSV and follow the import wizard. In Google Sheets: File → Import → Upload CSV.

Frequently asked questions

CSV to JSON JSON Formatter YAML to JSON XML to JSON Word Counter Case Converter

JSON to CSV — Convert Arrays to Spreadsheet Format

How to use this tool

Frequently asked questions

You might also need