JSON to CSV Converter — Free Online Tool

JSON to CSV Converter — Turn JSON Arrays Into Clean Spreadsheet Files

Paste a JSON array and get clean CSV instantly — ready to open in Excel, Google Sheets, or any spreadsheet tool. The converter auto-detects all the columns, safely escapes special characters, and lets you pick your separator. Everything runs in your browser, nothing is uploaded.

How it works

• Array of objects → table: each object becomes a row, each key becomes a column
• Auto-detected headers: all keys across all objects are collected into the header row (first-seen order)
• Single object: automatically wrapped into a 1-row CSV
• Array of arrays: turned into a CSV with no header row
• Array of primitives: one value per line

Safe escaping

• Values containing the delimiter, a quote, or a line break are wrapped in double quotes
• Internal quotes are doubled (“”) per the CSV standard
• Nested objects and arrays inside a field are serialized as JSON strings
• Missing keys in some objects become empty cells (not skipped columns)

Delimiter choices

• Comma (,): standard CSV, the default
• Semicolon (;): often preferred in European locales where comma is a decimal separator
• Tab: produces TSV, great for direct paste into Excel/Sheets

Common uses

• Exporting API responses to a spreadsheet
• Converting JSON config or log files to a flat table
• Preparing data for non-technical colleagues who only use Excel
• Generating CSV for database imports

Privacy

This tool runs entirely in your browser. Your JSON is never uploaded to any server.