Paste a JSON array, get CSV output. Download or copy.
JSON and CSV are the two most common data interchange formats, but they serve different audiences. JSON is structured, supports nesting, and is native to APIs and JavaScript. CSV is flat, tabular, and opens directly in Excel, Google Sheets, and database import tools.
Converting JSON to CSV is essential when you need to share API data with non-technical stakeholders, import records into a spreadsheet or database, generate reports from JSON-based data sources, or migrate data between systems that expect different formats.
The main challenge is flattening nested objects. A JSON field like {"address": {"city": "NYC"}} needs to become a flat column — either address.city or stringified. Arrays within objects are typically joined or stringified. This tool handles both cases and properly escapes CSV values that contain commas, quotes, or newlines.
This tool in other languages:
Français:
Convertisseur JSON en CSV
Español:
Convertidor de JSON a CSV
Deutsch:
JSON-zu-CSV Konverter
Português:
Conversor de JSON para CSV
日本語:
JSONからCSVへの変換
中文:
JSON 转 CSV 工具
한국어:
JSON을 CSV로 변환
العربية:
محول JSON إلى CSV
Paste your JSON array into the input box and click Convert. The tool extracts object keys as column headers and each object becomes a row. Click Download .csv to save the file or Copy CSV to paste into Excel or Google Sheets.
Yes. Nested keys are flattened using dot notation — {user: {name: "Ada"}} becomes a column user.name. Arrays inside objects are serialized as JSON strings. For deeply nested data, consider restructuring before converting.
If some objects have keys others don't, the header row includes all keys found across objects, and missing values become empty cells. Consistent JSON shapes produce cleaner CSV output.
Yes. The generated CSV uses standard comma separators with quoted values where needed. Excel may prompt you about the delimiter on open — choose comma. For non-English locales where Excel expects semicolons, you may need to import via Data → From Text.
Use the CSV to JSON tool — it does the reverse conversion with header detection and auto type inference (numbers, booleans, strings).