Feature
Remove duplicates from a contact list
Use this when the same contact appears twice with slightly different formatting. A common case is one row with JANE@EXAMPLE.COM and another with jane@example.com, or one phone number written three ways.
Each page covers one cleanup job: dedupe a list, clean an email column, or make phone numbers consistent enough to work with.
Use this when the same contact appears twice with slightly different formatting. A common case is one row with JANE@EXAMPLE.COM and another with jane@example.com, or one phone number written three ways.
Email columns usually fail because of small noise, not completely broken addresses. Stray spaces and mixed casing are enough to break matching and make the sheet harder to trust.
Phone columns often hide duplicates because the same number is written as `(555) 010-2000`, `555.010.2000`, and `555 010 2000`. The contact is the same, but the sheet does not read that way.