Home › Tools

CSV to JSON and JSON to CSV converter

Paste CSV or JSON, or open a file, and convert in either direction. Detects comma, semicolon, tab and pipe delimiters, handles quoted fields with commas and line breaks, and flattens nested JSON objects into columns.

🔒 Runs entirely in your browser. Nothing you paste is uploaded or sent to a server.

CSV rules (RFC 4180) in short

Common surprises

Problem Cause Fix
Everything is in one column Excel in many European locales saves CSV with semicolons, because the comma is the decimal separator auto-detect, or choose ;
é instead of é the file is Windows-1252 or Latin-1, not UTF-8 re-save as UTF-8; in Python use open(f, encoding="cp1252") (see UnicodeDecodeError)
id as the first header a UTF-8 byte order mark stripped automatically here; in Python use encoding="utf-8-sig"
Zip codes lose their leading zero type inference turned 007 into a number this tool keeps numbers with leading zeros as strings, or untick inference
Rows split in the middle an unescaped quote or an unclosed quoted field check the warnings list

JSON to CSV

The input should be an array of objects ([{"id":1}, …]) or an array of arrays. The columns are the union of all keys, in the order they first appear, so objects with missing keys just get empty cells. Nested objects become dotted columns (address.city), and arrays are written as JSON text inside the cell. If you have an object like {"items": [...]}, the converter uses the array inside it.

In code: Python's csv.DictReader plus json.dumps, or pandas.read_csv(...).to_json(orient="records"). If the JSON side fails to parse, see JSONDecodeError: Expecting value and Unexpected token in JSON.

Last updated 2026-11-20.