Format CSV

This tool reads your pasted CSV and writes it back cleanly normalised. It understands quoted fields (including ones with the delimiter or line breaks inside) and doubled quotes as escaping, then produces a consistent, rule-conformant format.

Each field is stripped of surplus surrounding spaces. Fields that contain the delimiter, a quote or a line break are quoted correctly (inner quotes are doubled); all others stay unquoted. A messily quoted or pasted-together CSV becomes a tidy file.

All processing happens entirely locally in your browser - no upload, even offline. Your data never leaves your device, which matters especially for tables with contact or business data. The delimiter is auto-detected by default (comma per RFC 4180, semicolon - the German Excel default - or tab/TSV); you can also pin it explicitly via the option.

Specifications

In 3 steps

1. Paste the CSV and choose the delimiter if needed.
2. Fields are trimmed and quoted correctly.
3. Download the cleaned CSV.

Limitations: Detects the delimiter (comma, semicolon or tab) automatically from the pasted lines by default; the option also lets you pin it explicitly. Quoted fields with doubled inner quotes, and the delimiter or breaks inside fields, are understood. Each field is trimmed and re-quoted only when it contains the delimiter, a quote or a break. A single document can only use one delimiter - mixed delimiters within the same file are not recognised.

FAQ

Related tools

CSV to JSON · Find & replace · Word counter · Check a BSN (11-proef) · Check an EGN · Egyptian National ID decoder · Extract Numbers · Extract URLs · Color converter · Decode HTML