Which separator does your CSV use?
Paste a header and a few complete rows. Check whether a comma, semicolon, tab or pipe separates the fields.
Your result will appear here.
Check that the fields make sense
A consistent column count is a clue. Confirm the preview keeps notes together and puts values under the right headers. The example should give three columns and three records, including the header. The semicolon inside the quoted note stays in one field.
The preview shows up to five records and eight columns, with each value shortened to 120 characters. The check uses your whole pasted sample.
What this checker can tell you
It checks four separators, ignores blank lines, and handles double-quoted fields, doubled quotes and line breaks inside quotes. It reports a likely separator only when one candidate gives the same column count on every nonblank record.
Ambiguous samples need more context. This tool cannot determine your file's encoding, repair malformed CSV, or tell whether Excel will change dates and identifiers. It checks pasted text; it does not change your original file.
Continue with your import
- Find the fix for your CSV import problem
- Choose the delimiter in your spreadsheet import
- Download synthetic CSV examples
Testing notes
Automated JavaScript checks cover all four separators, quoted punctuation, escaped quotes, multiline fields, ambiguous input and malformed records. The result is a heuristic, not an Excel or Google Sheets import test.