JSON to CSV Converter
Convert a JSON array of objects to CSV format (Excel-compatible) and back. Choose the delimiter and how to handle nested fields.
Conversion
Result (0 rows)
Paste your JSON to convert it.
How to use: JSON ↔ CSV
- 1Pick the direction: JSON to CSV or CSV to JSON.
- 2Choose the delimiter (comma, semicolon or tab) and paste the data.
- 3Copy or download the result.
What is it for?
- Open data exported from an API in Excel or Google Sheets.
- Turn a spreadsheet into JSON for an application.
- Prepare data for bulk imports.
Converting between JSON and CSV
Different structures
CSV is flat (rows and columns) while JSON supports nested objects and lists. When converting JSON to CSV, nested objects are flattened with keys like address.city, and lists are serialized into a single cell.
Commas, quotes and line breaks
A field containing commas, quotes or line breaks must be wrapped in double quotes, and inner quotes are doubled (""). This is the most frequent reason Excel shows shifted columns.
Separator and encoding
In some regional settings (including Spanish and German) Excel expects a semicolon as separator. Save the file as UTF-8 to keep accents.
Related tools
Frequently asked questions
What does it do with nested objects?+
It flattens them by serializing to JSON inside the cell, so no information is lost.