JSON to CSV Converter – Convert JSON Online (Free Tool)

JSON to CSV converts a JSON array of objects into a comma-separated-values document with one row per object and one column per key. Quoting is RFC 4180 compliant (double-quote any field containing commas, quotes, or newlines). Useful for handing API data to non-technical colleagues, importing into Excel/Sheets, or preparing data for a BI tool.

• Works on desktop, tablet, and mobile in any modern browser
• Stable behavior across visits — no surprise version drift
• Your data stays private — all processing happens locally in the browser
• Strict and lenient parser modes for handling messy real-world data
• Handles UTF-8 BOM, mixed delimiters, and other edge cases that break simpler converters

1. Paste your source data into JSON to CSV Converter, or upload a file
2. Confirm the parsed preview looks correct
3. Click Convert to produce the output in the new format
4. Copy the result or download as a file ready for the consuming system

• Handing API data to analysts who work in spreadsheets
• Generating an export feature in a web app (Download as CSV button)
• Preparing data for a BI tool (Looker, Tableau) that ingests CSV
• Backing up a JSON dataset in a more universally readable format
• Quickly diffing two JSON arrays — convert both to CSV, sort, diff

Some rows have missing columns.

Objects have different keys. The converter takes the union of all keys; rows without a key get an empty cell. Pre-normalise the objects in your code if you want strict columns.

Excel shows "1.23E+45" instead of my long number.

Excel auto-formats large numbers. Add a leading apostrophe ('1234567890123) or import as Text column to preserve the literal value.

Unicode characters look broken in Excel.

The tool prepends a UTF-8 BOM so Excel detects the encoding correctly. If still broken, check Excel's import settings or use "Data → From Text/CSV" with explicit UTF-8.