Explosion Tools

JSON ↔ CSV Converter

Convert between JSON arrays and CSV format. Free, no signup, works in your browser.

Output will appear here…

All conversion happens in your browser. No data is sent to any server.

About JSON ↔ CSV Converter

This converter transforms JSON arrays of objects into CSV format and parses CSV files back into JSON. When converting JSON to CSV, the tool automatically extracts all unique keys as column headers and handles special characters by quoting fields per the RFC 4180 standard. When converting CSV to JSON, it auto-detects the delimiter (comma, tab, or semicolon) and maps each row to a JSON object using the header row as keys. Useful for data migration, importing spreadsheet data into APIs, or exporting query results.

Frequently Asked Questions

What JSON format does this tool expect?
The JSON → CSV converter expects a JSON array of flat objects, like [{"name":"Alice","age":30},{"name":"Bob","age":25}]. Nested objects will be stringified into a single cell.
Does it handle commas and quotes in CSV values?
Yes. Fields containing commas, double quotes, or newlines are wrapped in double quotes per the RFC 4180 CSV standard. Existing double quotes are escaped as two consecutive quotes.
Can I convert tab-separated values (TSV)?
Yes. The CSV → JSON converter auto-detects tabs as delimiters, so you can paste TSV data directly.

Related Tools

Base64 Encode & Decode

Encode text to Base64 or decode Base64 to text

JSON Formatter & Beautifier

Format, beautify, and validate JSON data

URL Encoder Decoder

Encode and decode URL-encoded strings

Unix Timestamp Converter

Convert between Unix timestamps and human-readable dates

Markdown Table Generator

Build Markdown tables visually with an interactive editor

CSV to JSON Converter

Convert CSV data to JSON format