CSV Delimiter Detector
Not sure whether your export uses commas, semicolons, tabs or pipes? The detector compares all four candidates and shows the field-count distribution for each.
How the sniffing works
For every candidate delimiter the file is re-parsed and the number of fields per line is counted. The real delimiter produces a consistent field count above 1 on virtually every line — e.g. 48 lines × 5 fields, 2 lines × 4 fields. A wrong delimiter usually yields exactly one field per line, which immediately disqualifies it. The report shows the full distribution so you can also spot ragged files (rows with a stray extra separator).
FAQ
Why paste only a few lines?
Sniffing works on the whole file, but a sample of 20–100 lines is enough and keeps the distribution readable. Large files can also be opened directly.
What about files with quoted newlines?
The sniffing parses line by line, so a quoted field containing a line break counts as two lines. The recommended delimiter is still reliable; for exact parsing use the converter tools.