CSV Formatter & Validator

Auto-detect delimiter, validate quoting, and align CSV columns.

Paste a CSV (or TSV / pipe-separated) file and the tool auto-detects the delimiter, validates quoting, and shows row and column counts. Get a normalised, well-quoted CSV plus a monospace-aligned preview to spot ragged columns at a glance.

Common use cases

Validate exports from spreadsheets before importing into a database
Spot ragged rows or unescaped commas in vendor data feeds
Re-emit semicolon-separated EU CSV as comma-separated for US tools
Generate a tidy aligned preview to share in tickets or reviews

Frequently asked questions

Which delimiters are detected?▾

Comma, semicolon, tab and pipe — chosen by which appears most often in the first row.

Does it handle quoted fields with commas?▾

Yes — it follows RFC 4180 quoting rules: double-quoted fields can contain commas, and a literal quote is escaped as two quotes ("").

Can I download the cleaned CSV?▾

Use the Copy button and paste into a new .csv file. Browser-only by design — nothing is uploaded.

Related tools

{}

JSON Formatter & Validator

Beautify, validate and minify JSON instantly in your browser.

↔

JSON ↔ CSV Converter

Convert JSON arrays to CSV and CSV back to JSON.

B64

Base64 Encoder & Decoder

Encode and decode Base64 strings, including UTF-8 and binary.

URL Encoder & Decoder

Percent-encode and decode URL components safely.