JSON ↔ CSV Converter
Convert JSON arrays to CSV and CSV back to JSON.
JSON is the language of APIs and CSV is the language of spreadsheets.
About JSON ↔ CSV Converter
Turn a JSON array of objects into CSV for spreadsheets, or convert CSV into clean JSON with optional number and boolean detection. Nested objects are flattened into dotted columns and the delimiter can be a comma, semicolon, tab or pipe.
JSON is the language of APIs and CSV is the language of spreadsheets. This converter moves data between them: a JSON array of objects becomes rows and columns, and CSV becomes a clean array of JSON objects.
How to use JSON ↔ CSV Converter
- Choose JSON → CSV or CSV → JSON.
- Paste your data.
- Pick the delimiter and, for CSV → JSON, whether to detect numbers and booleans.
- Copy or download the result.
Key features
- Flattens nested objects into dotted column names.
- Comma, semicolon, tab or pipe delimiters, auto-detected for CSV.
- Correct handling of quotes, commas and line breaks inside cells.
Common use cases
- Exporting API data to Excel or Google Sheets.
- Importing spreadsheet data into an application as JSON.
- Cleaning and reshaping small datasets.