Guides

How to remove duplicates from a mailing list before you import it

Most newsletter tools charge by the number of contacts, so duplicates cost money. They also send the same person two copies, which is a quick way to an unsubscribe.

Exact duplicate emails are usually caught on import. The ones that slip through are the same person with a work and a personal address, or with dots and plus tags in a Gmail address.

Step by step

  1. Gather the lists

    Export from every source you're combining: signup forms, events, old tools. Put them into one CSV or spreadsheet.

  2. Clean it

    Open the file in Contact Dedup. Gmail addresses are compared without dots and plus tags (j.smith+news@gmail.com is the same inbox as jsmith@gmail.com), and people are matched across addresses using names and phones.

  3. Choose which address to keep

    When a group is merged, all distinct emails are kept in the row. Decide which one to send to, usually the most recent or the personal one.

  4. Import

    Import the cleaned file into your newsletter tool. Its own duplicate check will catch anything that's still an exact repeat.

Things to watch out for

Questions

Doesn't my newsletter tool remove duplicates already?

It removes identical email addresses. The same person with two different addresses gets two emails.

Is it safe to process subscriber data this way?

The list is processed in your browser and never uploaded, so it doesn't go to another company.

More guides