How to Remove Invalid Emails From an Excel Spreadsheet
A step-by-step way to find and delete invalid, risky and duplicate addresses in an Excel file without breaking the rest of your columns.
Most mailing lists start life in a spreadsheet: a CRM export, a sign-up sheet, an event file. Excel can sort, filter and remove duplicates, but it cannot tell you whether [email protected] has a mailbox. That needs a check against the receiving mail server. This guide shows a clean way to combine both so you end up with one file that only contains addresses worth mailing.
Step 1: Prepare the file
Work on a copy. Put the addresses in one column with a header such as Email. Then do three quick fixes that save credits and avoid false alarms:
- Trim spaces. In a helper column use
=TRIM(A2)and paste the values back. Trailing spaces make valid addresses look broken. - Lower-case everything.
=LOWER(TRIM(A2))makes duplicates easier to spot. - Remove obvious duplicates. Data → Remove Duplicates on the email column. Mailcut also counts a repeated address only once, but cleaning first keeps your own file tidy.
Step 2: Verify the list
Save the sheet as .xlsx, .csv or .txt and upload it on the bulk verification page after signing in. Mailcut reads every sheet of an Excel file and finds the column that holds the addresses, so you do not need to export a special format. Each address uses one credit, and a single upload can hold up to 20,000 addresses.
Step 3: Read the report
When the run finishes you download one Excel report. The first sheet lists every address with its result, what to do with it and why. The results you will see are:
- Valid: the mailbox exists. Keep it.
- Invalid: the mailbox or domain does not exist. Remove it.
- Accept-all: the domain accepts every address, so the mailbox cannot be confirmed. Mail it with care.
- Disposable: a throwaway address. Usually skip it.
- Unknown: the server did not answer. Try again later.
Step 4: Bring the results back next to your data
Your original file has more columns than the report (names, companies, tags). Do not copy and paste by hand. Open the report and your file side by side and look the result up with a formula. In a new column of your original file, if the report is in a sheet called Report with addresses in column A and results in column B:
=XLOOKUP(LOWER(TRIM(A2)), Report!A:A, Report!B:B, "not checked")
On older versions of Excel use =VLOOKUP(LOWER(TRIM(A2)), Report!A:B, 2, FALSE). Now every row of your own data carries its result.
Step 5: Filter and delete
- Select the result column and apply Data → Filter.
- Tick only Invalid and Disposable.
- Select the visible rows, right-click and choose Delete Row.
- Clear the filter. What is left is your clean list.
Keep the Accept-all and Unknown rows in a separate sheet instead of deleting them. You can send to them in a small first batch and watch the bounces, or check the unknown ones again later.
Mistakes to avoid
- Deleting rows while the filter shows everything. Always filter first so you only remove what you meant to remove.
- Sorting one column only. It scrambles your data. Select the whole table before sorting.
- Verifying the same file again and again. Verify once, then keep the result column. Credits are valid for 12 months, but there is no reason to spend them twice on the same unchanged addresses.
New accounts start with free credits, so you can try this on a small slice of your file first. See the credit packs when you are ready for the whole list.
