Paste a sample of a delimited file to detect which delimiter it uses, how many columns and rows it has, and preview the parsed result.
The detector tests four candidate delimiters — comma, semicolon, tab and pipe — against up to the first ten non-empty rows of the sample. For each candidate it counts the columns in every row, respecting quoted fields, and scores how consistently the rows agree on a column count greater than one. The best-scoring delimiter wins, and the first five rows parsed with it are shown as a preview. Detection is best-effort: a very small or irregular sample, such as a single-column file, has no delimiter to detect.
Why do some CSV files use semicolons instead of commas? In many locales the comma is the decimal separator, so spreadsheet programs in those regions export CSV with semicolons between fields to avoid ambiguity. The content is otherwise identical.
How accurate is the detection? It is a best-effort check based on column consistency across the first rows. More sample rows give a more reliable result; a sample of one or two lines, or data where the delimiter also appears inside unquoted text, can mislead it.
Does the preview handle quoted fields? Yes. Fields wrapped in double quotes may contain the delimiter itself, and the column counting and preview both respect that quoting.