CSV Delimiter Checker: what to check
Delimiter and field count problems are reviewed first. A consistent semicolon or tab separated file is supported, not treated as broken.
A separator is not always a comma
CSV is often used broadly for delimited text files. Exports from regional spreadsheet settings may use semicolons, while other systems use tabs or pipes. The auto-detection compares parsed record widths for these supported separators.
A comma inside a quoted cell belongs to the value. Replacing every comma with a semicolon can damage names, addresses, prices, and free text. CommaMend parses quoted values before deciding where fields end.
Override an incorrect delimiter guess
Open File format & scan options and select Comma, Semicolon, Tab, or Pipe. Re-scan Original reads the original file with that separator and resets edits. Confirm that the header and data line up before approving repairs.
Short files and single-column data can be ambiguous. If the preview looks like one long column, compare the source export settings with the delimiter selection. Auto-detection cannot know which of several plausible separators the receiving application requires.
Review a record that uses a different separator
A record that seems to use a different separator may be offered a split suggestion. Check every resulting value, especially if that separator also appears in an address or description. Approve the displayed split only when the resulting fields match the header. Exports use the currently selected delimiter with correct quoting.
Try a real CSV example
| Name | Team |
|---|---|
| Ada | Science |
| Sam;Arts |
The header and first record use commas, while the last record uses a semicolon. The split is a suggestion for review, not a reason to replace punctuation throughout the file.
Download the example CSVSelect the example in the tool above. Your file is processed locally, and changes require your approval.