What This Tool Does
This tool converts JSON data (including deeply nested objects and arrays) into a flat CSV format suitable for spreadsheets, databases, or data analysis.
How It Works
1Upload or paste your JSON data.
2The tool flattens nested objects using dot notation (e.g., contact.email).
3Arrays can be stringified, expanded to multiple rows, or reduced to first element.
4Download the resulting CSV file.
Input Format
JSON files or pasted JSON data (arrays of objects or single objects).
Output Format
Flat CSV file with one row per object.
When to Use This Tool
- Exporting API responses to Excel.
- Converting MongoDB/NoSQL exports to relational format.
- Flattening nested data for data analysis.
Frequently Asked Questions
Nested objects are flattened using dot notation. For example, {contact: {email: 'a@b.com'}} becomes column 'contact.email'.
You can choose to stringify arrays as JSON, expand them to multiple rows, or take only the first element.