JSON to CSV
Convert a JSON array of objects into a CSV table for Excel or Google Sheets.
How it works
- 1Paste a JSON array of objects.
- 2Pick the delimiter.
- 3Copy or download the CSV.
Features
- Columns from every key found in any row.
- Nested objects flattened to dotted columns (address.city).
- Quotes and commas escaped correctly.
- Comma, semicolon, tab or pipe delimiter.
Frequently asked questions
How are nested values handled?
Objects become dotted columns like address.city. Lists of simple values are joined with "; "; lists of objects are kept as JSON text.
Which delimiter for Excel?
Comma in most regions; semicolon where the decimal separator is a comma (much of Europe).
Is my data sent anywhere?
No. Everything runs in your browser; nothing is uploaded.
Related tools
CSV to JSONConvert CSV data into a JSON array, with automatic delimiter detection.JSON Formatter & ValidatorFormat, validate and minify JSON with clear error messages.JSON ValidatorCheck whether JSON is valid and see exactly where it breaks.Base64 DecoderDecode Base64 (standard or URL-safe) back to text.