Input JSON — object or array of objects
About JSON to CSV Conversion
This tool converts JSON arrays into CSV (Comma-Separated Values) format. It's useful for:
- Importing JSON data into Excel or Sheets
- Database bulk imports
- Data analysis and reporting
- Data migration between systems
Example — nested object flattened automatically:
Input JSON:
{
"name": "John",
"address": { "city": "NYC", "country": "US" },
"roles": ["admin", "editor"]
}
Output CSV:
name,address.city,address.country,roles John,NYC,US,admin | editor
Frequently Asked Questions
What JSON format does this tool accept?
This tool accepts a JSON array of objects or a single JSON object. Each array item becomes one CSV row. Nested objects are flattened automatically using dot notation.
Can I convert nested JSON?
Yes. Nested objects are flattened automatically using dot notation — address.city, address.country, etc. Array values inside objects are joined with | .
Why is my CSV missing fields?
CSV rows are built from object keys. If some objects have different keys, missing values will appear as empty cells.