JSON to CSV
JSON to CSV converts a JSON array of objects into a CSV spreadsheet. It auto-detects columns from keys and is the bridge between APIs (JSON) and spreadsheets (CSV).
Key Features
- Array of objects to rows and columns
- Header row from object keys
- Nested values flattened or joined
- Handles missing fields gracefully
- Download as .csv
- Browser-only
Use Cases
- Export an API list into Excel
- Turn a query result into a shareable table
- Feed JSON into a tool that only reads CSV
- Quick reporting from raw data
How to Use
- Paste a JSON array of objects
- Review the detected columns
- Adjust flattening if needed
- Convert and download the CSV
Practical Tips
- All objects should share the same key set for a clean table
- Deeply nested fields are flattened with dot paths
- Open the CSV in a spreadsheet to verify encoding
FAQ
- What if objects have different keys?
- Columns are the union of all keys; missing values become empty cells.
- How are nested objects handled?
- They are flattened using dot notation unless you choose to join them.