How to dedupe a Google Contacts export
Google Contacts has a Merge & fix feature that suggests duplicates inside your account, and for a single personal address book that's often enough. It doesn't help when your contacts live in several places: two Google accounts, a work CRM and a phone backup.
In that case it's easier to export everything, clean it in one go and import a single list.
Step by step
- Try Merge & fix first
In Google Contacts, open Merge & fix and accept the obvious suggestions. It costs nothing and shrinks the list.
- Export
Select the contacts, choose Export and pick Google CSV or vCard. Do the same for your other accounts or tools.
- Combine and clean
If you have several CSV files with the same columns, paste them into one sheet. Then open the file in Contact Dedup and review the groups it finds.
- Import the result
Import the cleaned file into the account you want to keep, after removing or archiving the old contacts there.
Things to watch out for
- Google's export has many columns (E-mail 1, E-mail 2, Phone 1, Phone 2…). All email and phone columns are detected and used for matching.
- Merge & fix only sees one account at a time. Duplicates across accounts need an export.
Questions
Is Google's Merge & fix enough?
For one account with obvious repeats, often yes. For several sources, nicknames or numbers in different formats, you'll need something that compares more carefully.
Which export format should I choose?
Either works. Google CSV is easier to look at in a spreadsheet, vCard keeps photos when you import it back into a phone.
More guides
- What Contact Dedup understands, with examplesWhich pairs are the same person, and which are kept apart.
- How to remove duplicate contacts in Excel, including the ones Excel missesRemove Duplicates only catches identical rows. How to find the rest.
- How to find and merge duplicate contacts in a CSV fileWhat to compare, and how not to merge two different people.
- How to clean up duplicate contacts from your phone (vCard / .vcf)Export, merge without losing photos or notes, import back.
- Cleaning duplicate contacts out of a CRM exportCustomer data, sales history and why you shouldn't upload it.
- How to remove duplicates from a mailing list before you import itFewer double sends, cleaner stats, lower bills.
- How to find duplicate companies in a CRM or spreadsheetLegal forms, websites and branches in different cities.