How to remove duplicate contacts in Outlook

First, the correction that saves an hour: Outlook's Clean Up button works on email conversations, not on contacts, so it will not help here. For contacts, take the merge prompts Outlook offers as you save, and clear the backlog by exporting to CSV, deduping the file, and importing it back with a duplicate option that replaces rather than adds.

What Outlook actually gives you

Clean Up (Home → Delete group → Clean Up) removes redundant messages: replies whose text is quoted in full further down a thread. Worth running on a busy inbox, irrelevant to your People list. That mix-up is the single most common wasted step here.

For contacts, Outlook does two things. When you save a contact that matches an existing one on name or email, it shows a duplicate-contact prompt letting you update the existing entry instead of adding a new one. And on import, it asks how to handle duplicates. Outlook on the web also surfaces merge suggestions on the People page; the exact wording and menu placement move between releases, so look under the Manage menu rather than following a fixed path. Both of these are per-pair. Neither clears a list that already has hundreds of repeats.

Export, clean, import

  1. Export. Outlook for Windows: File → Open & Export → Import/Export → Export to a file → Comma Separated Values, pick your Contacts folder, and save the .csv. Outlook on the web or Microsoft 365: People → Manage → Export contacts, choose the folder, export.
  2. Clean. Open the CSV in the contacts dedupe tool. Dedupe on the email column, since that is the reliable key and it is exact; that pass happens in your browser, and no mailbox access is requested, which is the point of doing it through a file. Entries with no email or a different one need name matching, which is a second pass through the API's fuzzy matching at a 0.88 threshold; check the removed count before you accept it.
  3. Import. Outlook for Windows: File → Open & Export → Import/Export → Import from another program or file → Comma Separated Values. Outlook on the web: People → Manage → Import contacts. On the desktop, choose Replace duplicates with items imported, or import into a brand new empty contacts folder. Choosing Allow duplicates to be created here is how people end up with three copies instead of two.

Where fuzzy matching stops

Being straight about this, because it is oversold elsewhere: fuzzy matching compares how similar two strings are after normalising case, punctuation, and word order. That collapses "Smith, Jane", "jane smith", and a typo like "Jane Smyth". It will not pair Bob Miller with Robert Miller, because those names are not similar strings, they are a nickname and a given name. No similarity threshold fixes that without a nickname dictionary. In practice you catch those by matching on the shared email address, or by sorting the cleaned file by surname and merging the handful that remain by hand.

Before you start

Keep the original export until the import is verified: it is your only rollback. Duplicates usually arrive from a sync, so if contacts flow in from a phone, a CRM, or a second Microsoft account, expect them to come back unless you fix the source. If a CRM is that source, the CRM contact dedupe guide covers the same loop on the Salesforce and HubSpot side, and the email list guide covers normalising addresses before you match on them.

FAQ

Frequently asked questions

Does Outlook's Clean Up button remove duplicate contacts?

No. Clean Up works on email conversations: it deletes messages whose text is already quoted in full inside a later reply. It is genuinely useful for a cluttered inbox, but it never touches the People list.

How does Outlook handle duplicates when I save a contact?

If a new contact matches an existing one on name or email, Outlook shows a duplicate-contact prompt offering to update the existing entry or add a separate one. That catches new duplicates as they are created; it does nothing about the backlog.

Which import option should I choose to avoid making it worse?

Importing adds records, it does not replace them. Import a cleaned CSV into an empty contacts folder, or choose "Replace duplicates with items imported" when importing into the existing one. "Allow duplicates to be created" is what doubles your list.

Will fuzzy matching merge Bob and Robert?

No, and no similarity-based matcher will. Fuzzy matching scores how alike two strings are, and Bob and Robert are not alike, they are a nickname pair. Fuzzy matching does catch formatting and spelling variants such as "Smith, Jane" against "jane smith" or "Jane Smyth". For nicknames, match on the email address instead, or merge those by hand.

Last updated