DevPad

JSON ↔ CSV Converter — Free Online Converter

Convert between JSON arrays and CSV spreadsheets

All processing happens locally. No data is sent to any server.

JSON and CSV are the two most common data exchange formats, but they don't interoperate natively. Our JSON ↔ CSV Converter bridges the gap, converting between the two formats with proper handling of quoted fields, special characters, and custom delimiters. For JSON to CSV, paste a JSON array of objects. The converter extracts all unique keys as column headers, handles nested values by stringifying them, and properly quotes fields containing commas, quotes, or newlines. For CSV to JSON, paste CSV with a header row — each row becomes a JSON object keyed by the header names. Choose your delimiter: comma (default for CSV), tab (for TSV), or semicolon (common in European locales). The converter handles quoted fields correctly, including escaped quotes (doubled "" inside quoted fields). This makes it compatible with exports from Excel, Google Sheets, and most database tools. All processing happens in your browser. Your data never leaves your device. For related tools, try our [JSON Formatter](/tools/json-formatter) to clean up JSON before conversion, or [JSON ↔ YAML](/tools/json-yaml) for other format conversions.

FAQ

What JSON format is expected?

A JSON array of objects, like [{"name":"Alice","age":30},{"name":"Bob","age":25}]. Each object becomes a CSV row.

Does it handle nested JSON?

Nested objects are stringified as JSON text in the CSV cell. For complex nested structures, consider flattening your JSON first.

Can I use this with Excel exports?

Yes. Excel exports CSV with comma delimiters and quoted fields. Our parser handles this format correctly. For tab-separated exports, select the Tab delimiter.