📊
JSON ↔ CSV Converter
Convert JSON arrays to CSV and back. Custom delimiter, flatten nested objects, auto-detect types. Runs 100% in your browser.
Convert between JSON and CSV — runs 100% in your browser. Your data never leaves the page. Useful for exporting to Excel, importing to DB, or sharing with teammates.
When to convert JSON ↔ CSV
- Export API data: API returns JSON, your boss/client needs Excel/CSV — convert fast, no code needed.
- Import into Google Sheets / Excel: pasting CSV is easier than parsing JSON.
- Database migration: dump JSON from MongoDB → CSV for MySQL/PostgreSQL import.
- Data cleaning: convert back and forth to inspect structure.
- Sharing datasets: CSV is smaller and opens in any text editor.
Features
- Auto-convert: type JSON on the left, CSV appears on the right after 200ms.
- Flatten nested objects:
{"user":{"name":"a"}}→ columnuser.name. - Custom delimiter: comma (default), semicolon (European Excel), tab, pipe.
- Quote all values: forces every cell to be wrapped in
"— safe for fields with commas or newlines. - Auto type parsing: CSV → JSON automatically converts
"123"→123,"true"→true. - Download .json / .csv: click ⬇ to save the file.
CSV gotchas
- European Excel uses semicolon
;instead of comma — good for data with decimal commas. - Cells with commas / newlines: the tool wraps them in
"automatically (RFC 4180). - Cells with quotes: doubled to
""per RFC 4180. - BOM for Excel: if non-ASCII characters look wrong, re-save the file with UTF-8 + BOM in a text editor.
Related
- JSON Formatter — clean JSON before converting
- JSON Schema Generator — schema from sample
- JSON ↔ YAML — different format
- All tools
Related tools
See all tools →NEW
🔐
JWT Decoder
Decode JWT tokens — header, payload, claims with readable timestamps.
NEW🎨
JSON Formatter
Format / minify / validate JSON. Sort keys A-Z, custom indent, Ctrl+Enter shortcut.
NEW🔍
Regex Tester
Test regex live with match highlighting. 7 ready presets including Vietnamese.
NEW🔑
UUID / Hash / Base64 / URL
Bundle: UUID v4, SHA-256/512 hash, Base64 (URL-safe), URL encode.