MailroomSign in
Mailroom / Guides / Tools

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

Why check before a mail merge

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.

Related