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.
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.
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.
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.
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.
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.
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.
Something not working? Report a bug
