Identify Duplicate Email Addresses

Identify duplicate email addresses using a custom query.

You can identify duplicate email addresses by exporting your list and sorting it in a spreadsheet program.

  1. Create a query with criteria such as Email is not blank.
  2. Click Show Results.
  3. Near the top of the page, click the print options icon, and select List (csv).
  4. Select Individual List and Only export columns displayed in query results.
  5. Click Run.

Once you import the results into your spreadsheet program, you can sort the email addresses alphabetically. From there, use the tools available to you to check for duplicates in the list.

Visit the online help for your spreadsheet program for steps on how to view duplicates.