JSON to CSV
Convert a JSON array of flat objects into quoted CSV rows.
Your workspace
Processed in your browserThis utility transforms a JSON array of objects into a comma-separated values (CSV) format. It is designed to help you prepare structured data for spreadsheet software or database imports.
How to convert JSON to CSV
- Paste your JSON array into the input field. Ensure the JSON is an array of objects where each object represents a row.
- The tool automatically extracts unique keys to create the CSV header row and maps object values to the corresponding columns.
Handling complex data
If your JSON contains nested objects or arrays, the tool serializes these nested structures into a single string within the CSV cell. This ensures no data is lost during the conversion, though you may need to parse these cells further if you intend to perform calculations on nested values.
Conversion example
[{"id": 1, "name": "Widget"}, {"id": 2, "name": "Gadget"}]
"id","name" "1","Widget" "2","Gadget"
Questions about conversion
What happens if objects have different keys?
The tool identifies the union of all keys present across all objects in the array. If a specific object is missing a key, that cell will be left empty in the resulting CSV.
Can I import this directly into Excel?
Yes. The output is standard CSV format with quoted fields, which is compatible with Excel, Google Sheets, and most database import tools.
Continue your workflow
Explore more tools in this category for your next step.
CSV Delimiter Converter
Rewrite CSV using a selected delimiter with correct field quoting.
CSV to SQL Inserts
Generate quoted SQL INSERT statements from CSV headers and values; the result is text and is not executed.
CSV Validator
Inspect CSV rows for inconsistent field counts, duplicate column headings and malformed quoting.
SQL Inserts to CSV
Parse simple literal INSERT INTO VALUES statements into CSV; SQL expressions and queries are not executed.