Remove duplicate email addresses in Google Sheets
Clean a mailing list: normalise emails, find repeats and keep one row per address.
Unique, normalised email list from column B:
=UNIQUE(ARRAYFORMULA(LOWER(TRIM(FILTER(B2:B, B2:B<>"")))))Flag duplicate contacts while keeping all columns: helper key in G2 =LOWER(TRIM(B2)), then in F2 (fill both down):
=IF(COUNTIF(G$2:G2,G2)>1,"Duplicate","")With CleanRows: tick only the Email column, keep the most complete row, and move the rest to a new sheet for review.
Do it in two clicks inside Google Sheets. CleanRows highlights, deletes or moves duplicates by the columns you pick, ignores case/spaces/accents and compares two sheets. Free up to 1,000 rows. Get CleanRows →
More guides
- How to remove duplicates in Google Sheets (3 ways)
- How to highlight duplicates in Google Sheets
- Find duplicates based on two columns in Google Sheets
- How to compare two sheets in Google Sheets
- Remove duplicates but keep the last occurrence in Google Sheets
- How to count duplicates in Google Sheets
- Remove duplicates ignoring case and spaces in Google Sheets
- How to merge two sheets by a key column in Google Sheets
- How to remove blank rows in Google Sheets
- How to split full names into first and last name in Google Sheets
- How to fill blank cells with the value above in Google Sheets
- How to remove extra spaces in Google Sheets
- How to change text to uppercase, lowercase or proper case in Google Sheets
- How to find duplicates across two sheets in Google Sheets
- How to remove line breaks and hidden characters in Google Sheets