Free CSV email list checker
Drop in a CSV and see which addresses are invalid, which are duplicates and which rows are blank, each with its spreadsheet row number. Then download a cleaned copy. It is free, needs no account, and the file never leaves your browser.
What it checks
- Invalid addresses: missing @, missing domain, spaces inside the address, or more than one address in a cell.
- Duplicates: the same address appearing more than once, ignoring capitals and stray spaces. The first is kept.
- Blank rows: rows with nothing in the email column.
- Row numbers match your spreadsheet, where the header is row 1, so each problem is easy to find and fix.
Why check before a mail merge
- Gmail rejects malformed addresses one at a time, in the middle of a send, when it is too late to fix the list.
- A duplicated address means someone receives the same email twice.
- Every send counts against Gmail’s daily limit, so sends wasted on bad rows are sends you cannot use.
Common questions
Is my contact list uploaded anywhere?
No. The file is read and checked by your own browser. It is never sent to Mailroom or to anyone else, which you can confirm by turning off your internet connection after the page has loaded: the tool still works.
What counts as an invalid address?
Anything that could not be used as a single recipient: no @ sign, no domain or no ending such as .com, spaces inside the address, or two addresses in one cell. These are the addresses Gmail rejects at send time.
Does it check whether the mailbox exists?
No. It checks that each address is correctly formed and appears once. It does not contact mail servers, so it cannot tell you whether an inbox is still active.
How are duplicates decided?
By the address alone, ignoring capital letters and surrounding spaces. The first row with an address is kept and later rows with the same address are reported as duplicates.
Does it work with Excel files?
It reads CSV. In Excel choose File, Save As, CSV UTF-8. In Google Sheets choose File, Download, Comma-separated values.