How to Find and Fix Typos in Your Email List

A typo in an email address is a quiet problem. Nobody gets an error on the signup form, the address looks fine at a glance, and then every message you send to it bounces or disappears. If Jane typed jane@gmial.com when she joined your newsletter, she will never hear from you, and she probably thinks you forgot about her.

The good news: most typos follow a handful of predictable patterns, and you can find nearly all of them in a spreadsheet in about fifteen minutes. This guide shows you what to look for, how to fix the safe ones, when to check with the person instead, and how to stop new typos from getting onto your list.

The typo patterns that show up again and again

People make the same slips on the same keyboards, so the same mistakes repeat across almost every list. Learn to recognize these and you will spot most problems instantly.

Notice the last two rows. The big free mail providers (Gmail, Yahoo, Hotmail, Outlook) use well-known domains, so when you see one of their names with a broken ending, the intended address is obvious.

Step 1: Pull the domain into its own column

Typos almost always live in the part after the @, so the fastest way to find them is to look at domains instead of full addresses. Say your emails are in column A, starting in row 2, with a header in row 1.

1. Type Domain in cell B1.
2. In B2, enter this formula (it works in both Excel and Google Sheets):
   =IFERROR(LOWER(TRIM(MID(A2,FIND("@",A2)+1,100))),"NO @")
3. Copy it down the whole column. In Excel, double-click the small square at the bottom-right corner of B2. In Google Sheets, you can do the same or drag the square down.

Here is what the formula does: FIND locates the @, MID grabs everything after it (up to 100 characters, which is plenty), TRIM strips stray spaces from the ends, and LOWER makes Gmail.com and gmail.com look identical. If a cell has no @ at all, IFERROR labels it "NO @" so it stands out instead of showing an error.

Step 2: Count each domain to find the rare ones

This is the trick that makes typos jump out. On most lists, real domains like gmail.com show up dozens or hundreds of times. A misspelling like gmial.com shows up once or twice. So count how often each domain appears and look at the rarest ones.

1. Type Count in C1.
2. In C2, enter =COUNTIF(B:B,B2) and copy it down.
3. Sort the sheet by column C from smallest to largest. In Excel, click any cell in your data and choose Data > Sort, then sort by Count, Smallest to Largest. In Google Sheets, select your data and choose Data > Sort range > Advanced range sorting options (older versions open this dialog straight from Data > Sort range), check "Data has header row," and sort by Count, A to Z.

Now the top of your sheet holds every domain that appears only once or twice. Most of these will be perfectly real business domains, like a single contact from northwind.com. That is fine. You are scanning for names that look almost like a popular provider: gmial.com, yahooo.com, hotmial.com, outlok.com. Sitting next to each other in a short list, they are easy to spot.

Step 3: Catch spaces, commas and other broken formats

Some problems are not misspellings but formatting accidents. A few quick checks find them. Put each formula in a new column next to your list and filter for the flagged rows (in Excel, Data > Filter; in Google Sheets, Data > Create a filter).

• Spaces inside the address: =IF(ISNUMBER(FIND(" ",TRIM(A2))),"space","") flags any address with a space in the middle after the edges are trimmed.
• Commas: =IF(ISNUMBER(FIND(",",A2)),"comma",""). Look at each one. Some are a comma typed instead of a dot (sam@gmail,com). Others are two addresses squeezed into one cell (sam@gmail.com, pat@gmail.com), which need to be split into separate rows, not "fixed."
• Wrong number of @ signs: =LEN(A2)-LEN(SUBSTITUTE(A2,"@","")) counts the @ signs. Anything other than 1 is broken.
• Missing dot in the domain: =IF(ISNUMBER(FIND(".",B2)),"","no dot") uses the Domain column from Step 1 and catches entries like gmailcom.

Watch for invisible characters too. Addresses copied from websites or PDFs sometimes carry a non-breaking space, which TRIM does not remove. =SUBSTITUTE(A2,CHAR(160),"") clears it out.

Step 4: Fix the safe ones

Always fix in a copy or a new column, and keep the original column untouched. If something goes wrong, you can compare and undo.

For provider misspellings, use Find and Replace. In Excel, press Ctrl+H (or go to Home > Find & Select > Replace). In Google Sheets, press Ctrl+H or choose Edit > Find and replace. Include the @ in what you search for: replace @gmial.com with @gmail.com, not just gmial with gmail. The @ anchors the match to the start of the domain, so you only change what you mean to change.

Endings like .con need more care, because a plain search for ".con" would also hit a legitimate domain such as brightpath.consulting and turn it into nonsense. Two safe ways to handle it:

• Excel or Sheets formula: =IF(RIGHT(A2,4)=".con",LEFT(A2,LEN(A2)-4)&".com",A2) only changes addresses that end in .con. Swap ".con" for ".cmo" or ".cpm" to handle those.
• Google Sheets regular expression: in Find and replace, check "Search using regular expressions," search for \.con$ and replace with .com. The $ means "only at the very end."

If you would rather skip the formulas, paste your list into the free email typo fixer. It catches the common domain misspellings and bad endings like .con, shows you each suggested change, and runs entirely in your browser, so the list never leaves your computer.

When to fix it yourself and when to ask the person

A domain typo on a big free provider is a safe fix. Jane meant gmail.com; nobody uses gmial.com on purpose. Anything less certain deserves a second look:

• Business domains you don't recognize. Is northwnd.com a typo for northwind.com, or a different company? If you know the person works at Northwind, fix it. If you don't, ask.
• .co addresses. Check the company's website or ask. Many are real.
• Mistakes before the @. If someone typed jonh@ instead of john@, no formula can tell. You only find these through bounces or by asking.
• High-stakes messages. If you are a realtor sending a contract, or a nonprofit sending a donation receipt, confirm the address by phone or text before relying on your "fix," even for an obvious one.

A simple way to ask: send a short note to the corrected address, or reach out through another channel you already have, saying "We think your email may have been entered with a typo. Is this the right one?" People are usually glad you caught it.

Find the addresses a spreadsheet can't judge

Spreadsheet checks catch typos you can see. They can't tell you whether pat@northwind.com is a real, working mailbox, or whether a perfectly spelled gmail.com address was closed years ago. For that, the mail server has to be asked. You can check every address on your list with Veml, which looks at format, typos, whether each domain can receive email, throwaway addresses, and whether each mailbox actually exists, all without sending a single email. Every address comes back Passed, Risky, Unknown or Invalid with a plain-English reason.

Stop typos at the signup form

Cleaning is easier when fewer typos get in. There are two common approaches, and they solve different problems.

For most lists, double opt-in is the stronger choice, because it confirms the address actually reaches someone. Many email marketing services offer it as a setting. A helpful extra is an inline "Did you mean gmail.com?" hint that appears when someone types a known misspelling, which catches the mistake before the form is even submitted. For more ways to keep junk off your list, read our guide on stopping fake signups.

Make it a habit

Typos don't arrive all at once. They trickle in with every event signup sheet, every form, and every business card someone types in by hand. Run the domain count from Step 2 whenever you add a batch of new contacts, and give the whole list a full check a few times a year. Our guide on how often to clean an email list can help you pick a schedule that fits how fast your list grows.