How to merge and remove duplicated contact people in Outlook 365?


Here’s a question we got the other day:

“I have many duplicated entries in my Outlook 2016 people list, can you provide me a solution to consolidate the list and get rid of any dups?”

Good question, there is a little trick to find those redundant contacts and remove or merge it. In this post, We will learn the way to do it. Keep reading.

Move your contacts to the new folder:

  • Open outlook 2016, click contacts and select the folder which contains all your contacts (Gmail contacts).

2016-01-13 21_12_22-Cortana



  • Now create a new folder by right click on some folder, select New folder and name it (Dupcontacts).

2016-01-13 21_12_59-Cortana

  • Then select all the contacts (ctrl+A) and move it to the created folder (Ctrl+Shift+V).

Export your contacts:

  • Go to file, select Open&Export and click on Import/Export.

2016-01-13 21_13_48-Start

  • Select Export to a file and click Next.

2016-01-13 21_14_35-Import and Export Wizard

  • Select Comma separated values and click Next.

2016-01-13 21_15_08-Export to a File

  • Now select the created folder and click Next.

2016-01-13 21_16_27-Export to a File

  • Click on to choose the location to save .csv file and name it.

2016-01-13 21_17_21-Export to a File

  • Click next and hit finish to save your contacts in .csv file.

2016-01-13 21_17_45-Export to a File

Import your contacts:

  • Go to file, select Open&Export and click on Import/Export.

2016-01-13 21_13_48-Start

  • Select Import from another program or file and click Next.

2016-01-13 21_18_26-Import and Export Wizard

  • Select Comma separated values and click Next.

2016-01-13 21_18_58-Import a File

  • Select the .csv file to import and check on Do not import duplicate items.

2016-01-13 21_19_33-Import a File

  • Click next and select the folder where our contacts was previously in (Gmail contacts).

2016-01-13 21_20_14-Import a File

  • Click next and hit finish to import the contacts into the selected folder.

2016-01-13 21_21_36-Import a File

Merge your contacts:

  • Now click on Dupcontacts and select all the contacts (Ctrl+A).
  • Move your contacts from Dupcontacts to Gmail contacts (Ctrl+Shift+V).

2016-01-13 21_22_40-Move Items

  • For each duplicate that is being found, you’ll receive a dialog box and it will show a preview of which data will be added or updated.
  • Select Update to update contacts one by one, Update all to update all the contacts or skip to review it later.
  • Check on Add new contacts to add the contacts as a new one.

2016-01-13 21_23_50-Duplicate Contact Detected (362 contacts more to add)

That’s it. Thanks for reading. :)

Leave a Comment:

1 comments
Add Your Reply