Skip to content
Really Cool Online Tools logoReally Cool Online Tools

DEV-006

CSV Email List Cleaner

Most email list cleaners sort addresses into good and bad, which is a promise the format cannot support. An address either breaks the rules of what an address looks like, or it does not, and plenty of addresses that look perfect do not exist. This one uses three categories instead of two, shows you every flagged row in a table you can work through, and lets you accept or refuse each suggested correction before anything is written out.

  • Free
  • No signup
  • Private · runs locally

Your list is read in your browser and never uploaded. No address is sent anywhere, and nothing is kept after you close the tab.

How to clean a list

  1. Drop your CSV onto the upload area. The column holding the addresses is detected automatically, and you can change it if the guess was wrong.
  2. Read the counts. They cover duplicates, possible typos, disposable providers and shared mailboxes.
  3. Work through the review table. Fix a typo, keep an address as it is, or leave a row out, one at a time or in bulk. Every decision can be undone.
  4. Download the cleaned CSV, and the suspicious, invalid, duplicate or full analysis files if you want them. All of your original columns come with it.

What gets flagged, and why

An address can carry more than one flag at once. info@mailinator.com is both a role address and a disposable one, and it is still a single row in the totals.

FlagWhat it meansWhat happens to it
Possible typoThe domain is a known misspelling of a mailbox provider, or close enough to one to be worth a lookA correction is offered. Nothing changes until you accept it
DisposableA throwaway mailbox provider such as mailinator.com or yopmail.comFlagged. Kept in the clean file unless you say otherwise
Role addressA shared mailbox such as info@, sales@ or noreply@ rather than a personFlagged. Kept in the clean file unless you say otherwise
DuplicateThe same address as an earlier row, ignoring capitals and surrounding spacesThe first one is kept and the rest are left out
Unusual endingA two letter ending that is not a country code, which is usually a truncated .comFlagged for a look

The three buckets

Suspicious is the category that earns the tool its place. An address ending gmial.com is almost certainly meant to be gmail.com, but deleting it loses a real subscriber and silently correcting it invents one. Offering the correction and waiting for an answer is the only honest option.

Corrections are deliberately conservative. A short domain is far more often a real company than a misspelling, so the tool will not suggest that x.com should have been me.com. It only offers a fix when the domain is a misspelling it knows by name, or close enough to a mailbox provider that the resemblance cannot be a coincidence.

BucketWhat it meansWhat to do
ValidCorrect shape, ordinary domainSend to these
SuspiciousCorrect shape, but something about it is worth a look: a likely typo, a throwaway provider, a shared mailbox, an unusual endingDecide row by row. Suspicious is not a verdict, it is a question
InvalidBreaks the rules: no at sign, two at signs, no dot in the domainCannot receive mail as written

What this cannot tell you

Whether a mailbox exists. Finding that out means opening a conversation with the receiving mail server, which a browser is not allowed to do and which is the service that verification companies sell.

That matters because the most common bad address on any list is not malformed at all. A name typed wrong in front of a real domain is a perfectly valid address that belongs to nobody, and nothing short of sending to it will reveal that. If a tool claims to verify deliverability without sending anything, it is either charging you for a server-side check or guessing.

Reviewing, correcting and exporting

Nothing in the table is applied to your file on its own. Fix accepts a suggestion, Keep says the address is right as it is, Exclude leaves the row out of the clean file, and Undo takes any of those back. The original address stays visible next to the corrected one, and the counts and the downloads move as you work.

Corrections are applied before duplicates are worked out, which matters more than it sounds. Fixing ana@gmial.com to ana@gmail.com can turn two rows into the same person, and a cleaner that deduplicated first would hand back a file with that pair still in it.

Five files can be downloaded: the cleaned list, the addresses still worth a look, the invalid ones with the reason, the duplicate groups, and a full analysis carrying the status, the issues, the original address, the suggestion and your decision for every row. Each one keeps all of your original columns in their original order.

Deduplication, and the Gmail question

Addresses are compared without regard to capitals, which is always safe: the domain is defined as case insensitive and no real provider treats the part before the at sign as case sensitive either.

Gmail goes further and ignores dots entirely, so the same person reaches you as two different strings. It also treats anything after a plus sign as a label on the same mailbox. Folding those is correct for Gmail and wrong for nearly everyone else, so it is a checkbox, it is off by default, and it only applies to gmail.com and googlemail.com.

Frequently asked questions

Is my list uploaded?

No, and on this tool that matters more than most. An email list is personal data, and under GDPR and similar laws sending it to a third party is a processing decision you would have to account for. Here it never leaves your device.

Does this verify that an address works?

No. Verifying deliverability requires contacting the receiving mail server, which only a server can do. This checks the shape of the address and flags likely typos. The page says so rather than implying more.

Why are some valid-looking addresses marked suspicious?

Because something about them is worth a second look: the domain is a near miss against a mailbox provider, it belongs to a throwaway mail service, it is a shared mailbox such as info@, or the ending is unusual. None of that makes an address wrong. Nothing is deleted and nothing is corrected until you say so.

What counts as a disposable address?

A mailbox from a service that hands out temporary addresses, such as mailinator.com or 10minutemail.com. The list of those domains is built into the page and checked on your device. It covers the well known ones and cannot cover all of them, because new ones appear constantly, so treat it as a useful signal rather than a complete answer.

Why flag info@ and sales@ if they are real addresses?

They usually are real, which is why they are flagged rather than removed. A shared mailbox is read by whoever is on duty, rarely belongs to the person who signed up, and tends to mark marketing mail as spam at a much higher rate than a personal address. Worth knowing how many you have before you send.

Can a correction create a duplicate?

Yes, and the tool expects it. Duplicates are worked out after your corrections are applied, so fixing a typo that turns one address into another one already on the list leaves exactly one of them in the clean file.

Does it keep the other columns?

Yes. Every download contains the complete original rows in their original column order, so names, phone numbers, companies and anything else travel with the address. Files are written as UTF-8 with a byte order mark so Excel reads accented names correctly, and any value a spreadsheet would run as a formula is written as plain text instead.

How big a file can it handle?

Fifty thousand rows are analysed in well under a second on an ordinary laptop, and the table shows a page at a time rather than drawing thousands of rows at once. The practical limit is your browser's memory rather than any cap we impose.

Should I turn on the Gmail option?

Only if the list is mostly Gmail and you are seeing the same person twice with different dots. It is wrong for other providers, which is why it is off unless you ask for it.

Read more

Background on when and why to use this.

Other tools people use alongside the Email Cleaner.

Browse all developer tools or see every tool.