About the JSON ↔ CSV
Export API data to a spreadsheet or import a spreadsheet into your app. Nested objects are flattened into dot-notation columns (address.city) and expanded back when converting CSV to JSON. Quoting, embedded commas and new lines are handled per RFC 4180.
Features
- Flattens nested objects to dot columns
- Union of all keys as header
- RFC 4180 quoting
- Comma, semicolon, tab or pipe delimiters
- Number/boolean detection on import
- Download as .csv
How to use it
- Choose the direction and delimiter.
- Paste JSON (an array of objects) or CSV with a header row.
- Download or copy the output.
Frequently asked questions
Excel shows everything in one column
Some locales use semicolons as the list separator. Choose Semicolon as the delimiter, or use Excel’s Data → From Text/CSV import.