Identify and merge duplicate contact information

Find duplicate contact records across multiple lists and merge their information into one

Constant Contact takes steps to make sure that duplicate contacts aren't added to your account. For example, there can only be one contact record for each unique email address. If a contact gets added with a different name, but the same email address, we'll update the existing record with the new information.

There are times that duplicate contacts can slip through, because of different spellings or typos, or multiple email addresses for the same contact. When that happens, you can find them and merge their information together.

• Finding duplicate contacts
• Merging duplicate information
• Deleting the duplicate contact

Finding duplicate contacts

To find duplicate contacts in your account, all you have to do is search for them.

1. From the contacts dashboard, click the Contacts tab.
2. Use the Search field to find your duplicate contacts. The search is very flexible and lets you look across many different contact details:

• Name, Email Address, or Email Domain
• Job Title or Company Name
• City, State/Province, or Zip/Postal Code
• Custom Fields
  
  
  
  

Did you know? If you need to find multiple sets of duplicate contacts, you can also export all of your contacts and use the sort or filter features in your spreadsheet program.

Merging duplicate information

When you're ready to merge the duplicate information, you have a couple of options. Copying and pasting contact information is great for when you have just a single contact. If you have lots of contacts to update, you can export them, make your updates, and then import them again to automatically update all their contact records at once.

Copy and paste

1. Next to the contact with the email address you want to delete, click . . . > View.
   
   
   
   
2. Click Details and copy any of the contact information in the Basic Details, Physical addresses, Phone numbers, and Custom fields sections, that you want to add to the other contact record.
3. Click X to close the contact record.
   
   
   
   
4. Next to the contact you want to keep, click . . . > Edit.
   
   
   
   
5. Paste the contact information into the corresponding fields in the Basic Details, Physical addresses, Phone numbers, and Custom fields sections.
6. Click Save.
   
   
   
   

Repeat these steps until all the information is copied over and then you're ready to delete the outdated contacts from your account

Export and import

1. Export all of your contacts.
   
   
   
   
2. In your spreadsheet, use the sort or filter features to help you combine the information for each duplicate contact.
   
   
   
   
3. Import your spreadsheet with the corrected contact information.
   
   
   
   

The contact records you want to keep are automatically updated with the new information from your spreadsheet and you're ready to delete the outdated contacts from your account.

For help sorting or filtering your Excel spreadsheet, please see Microsoft's Support.

Deleting the duplicate contact

Important: When you delete a contact record, all of the email engagement information found in the contact record is deleted with it. Your email reporting isn't altered and the deleted contact appears with a strikethrough through their email address.

When your contact record for the contact you want to keep is updated with the correct information, it's time to delete the outdated contact.

1. Next to the contact you want to delete click . . . > Delete.
   
   
   
   
2. Click Delete to confirm the action.
   
   
   
   

You can also delete multiple contacts at one time by selecting all of them them and clicking Actions > Delete.

Any links we provide from non-Constant Contact sites or information about non-Constant Contact products or services are provided as a courtesy and should not be construed as an endorsement by Constant Contact.

Questions?