Guides

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

  1. Try Merge & fix first

    In Google Contacts, open Merge & fix and accept the obvious suggestions. It costs nothing and shrinks the list.

  2. Export

    Select the contacts, choose Export and pick Google CSV or vCard. Do the same for your other accounts or tools.

  3. 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.

  4. 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

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