CSV Dialect Detector

Detect the delimiter, quote character, line ending, header row and encoding hints of pasted CSV data.

Detect the dialect of a CSV sample

Delimiter: — · Quote: — · Line ending: —

Header row: — · Encoding: — · Confidence: 0%

Rows: 0 · Columns: 0

Detection inspects only your sample text, on the device, and never uploads the file.

Common questions about the free online csv dialect detector.

It counts candidate separators outside quoted fields on each line and prefers the character that splits the sample most consistently.

Comma, semicolon, tab, pipe and colon are all tested, and the winner is reported with the confidence percentage for the sample.

The tool counts double and single quotes in the sample. A file with only single quotes is reported as single quote delimited text.

It reflects how consistently the delimiter appears on every line, with bonuses for a clear header row and a byte order mark.

The first line is treated as a header when its cells are non-numeric, unique, and later rows contain numbers in the same columns.

The tool reports a UTF-8 byte order mark, non-ASCII text and the classic mojibake pattern of UTF-8 data that was read as Latin-1.

No. Detection uses the pasted sample, so paste a representative block of rows for the quickest and most accurate verdict.

Yes. A preview table shows the first ten rows parsed with the detected delimiter and quote character, so you can confirm the split.

No. Detection and parsing run in your browser, so your data never leaves your device.

Yes. It is completely free with no account, no sign-up and no limit on how many samples you check.

Last updated: October 10, 2026