In this article you will learn how to merge duplicate contacts in Outlook 2010 and 2013 without using any third-party tools, and how to keep your contact list clean in the future.
Microsoft Outlook provides loads of handy tools that we use and love and even more features that we are unaware of. But regrettably, an option to dedupe the address book and combine multiple duplicate contacts into one is not on board.
Luckily, we are not limited to use only those tools that Outlook provides explicitly. With just a little creativity you can figure out a way to solve any, or nearly any, task you are faced with. Further on in this article you will find how you can check your Outlook contacts for duplicates and merge them without using any third-party software.
Why duplicate contacts appear in Outlook
The most common reason that leads to duplication is dragging a message to the Contacts folder in the Navigation pane in order to have a contact created automatically. Of course, this is the fastest way to add a new contact in Outlook and there's nothing wrong about it. However, if you also create contacts manually once in a while, you may end up having multiple contacts for the same person, e.g. if you misspell the contact's name or enter it in a different way.
Another scenario that leads to contact duplication is when a person emails you from different accounts, e.g. using his or her corporate email address and a personal Gmail address. In this case, no matter how you create a new contact, by dragging a message to the Contacts folder or by clicking the "New Contact" button on the ribbon, an additional contact for the same person will be created anyway.
Synchronization with a laptop or mobile device as well as with social platforms such as LinkedIn, Facebook and Twitter, may also produce duplicate contacts. For example, if the same person is listed under different names in different address books, say Robert Smith, Bob Smith and Robert B. Smith, nothing prevents multiple contacts from being created in your Outlook.
If you work in a corporate environment, duplicate contacts may emerge in case your company maintains several address books on its Exchange servers.
I think there's no need to explain what problems you might have when important details are scattered across several duplicated contacts in your Outlook. If you are reading this article, then most likely you are looking for a solution to sort it out. And below you will find a number of solutions to choose from.
How to merge duplicate contacts in Outlook 2010 and 2013
In most cases Outlook is smart enough to prevent duplication when you are trying to create a contact that already exists. However, if you already have a number of duplicate contacts in your address book, you need to apply a special technique to clean up the mess. Okay, let's get started!
- Create a new Contacts folder. In Outlook Contacts, right click on your current Contacts folder and select New Folder... from the context menu.
Give a name to this folder, let's call it Merge dupes for this example.
- Move all your Outlook contacts to the newly created folder. Switch to your current contacts folder and press CTRL+A to select all the contacts, then hit CTRL+SHIFT+V to move them to the newly created folder (Merge dupes folder).
Tip: If you are not very comfortable with shortcuts, you can simply right-click the selected contacts and choose Move from the context menu. - Export the contacts to a .csv file using "Import and Export" wizard.
In Outlook 2010 and Outlook 2013, go to File > Open > Import.
In Outlook 2007 and Outlook 2003, you will find this wizard under File > Import and Export...
The wizard will walk you through the export process, and you choose the following options:
- Step 1. "Export to a File".
- Step 2. "Comma Separated Values (Windows)".
- Step 3. Select the Merge dupes folder you created earlier.
- Step 4. Choose the destination folder to save the .csv file.
- Step 5. Click Finish to complete the export process.
Tip: If you have multiple contact cards for the same person, personal details may be scattered across all those duplicate contacts, e.g. one contact contains business phone number, another contact includes a private phone number and so on. In this case, the Combine Rows Wizard may come in very handy. This Excel add-in will quickly merge unique data from multiple duplicate rows in your .csv file. To better understand what I'm talking about, see how the data in the original .csv file looks like:
And here is what we have after using the Combine Rows Wizard.
If you are interested to try the Combine Rows Wizard on your own data, you can download a fully-functional trial version here. - Import contacts from the CSV file to your default Contacts folder.
Start the Import wizard again as described in step 3 and select the following options:
- Step 1. "Import from another program or file".
- Step 2. "Comma Separated Values (Windows)".
- Step 3. Browse to the exported .csv file.
- Step 4. Be sure to select "Do not import duplicate items". This is the key option that makes the trick!
- Step 5. Select your main Contacts folder, which is currently empty, as the destination folder to import the contacts to.
- Step 6. Click Finish to complete the import process.
- Merge the deduped contacts with the original ones.
Now you need to merge the deduped contacts that are currently in your main Contacts folder with the original contacts that reside in the Merge dupes folder, so that no contact details will get lost.
Open the Merge dupes folder and press CTRL+A to select all the contacts. Then press CTRL+SHIFT+V and choose to move the contacts to your main Contacts folder.
When a duplicate is detected, Outlook will throw a pop-up message suggesting that you update information of the existing contact and display a preview of data that will be added or updated, as shown in the screenshot below.
Note: If you've used the Combine Rows Wizard to merge duplicated rows in the CSV file, this step is not actually needed, because all contact details were merged in a CSV file and are already in your main Contacts folder.
- Choose Update if these are duplicate contacts and you want to merge them.
- Choose Add new contact if they are, in fact, two different contacts.
- If you want to expedite the process, click Update All and all changes will be accepted automatically in all duplicate contacts.
- If you want to review a particular contact later, click Skip. In this case the original contact item will remain in the Merge dupes folder.
When Outlook detects a duplicate contact with a different email address and you choose to update a contact, the current email address of the contact will be moved to the "E-mail 2" field, as shown in the screenshot above.
Note: If your Outlook does not show this dialog when you are adding duplicate contacts, then most likely the duplicate contact detector is off. See how to enable Check for Duplicate Contacts feature.
Merge duplicate Outlook contacts using Gmail
If you have a Gmail email account (I guess most people do these days), you can use it to merge duplicate Outlook contacts. In a nutshell, the procedure is as follows. Export your Outlook contacts to a .csv file, import that file to your Gmail account, use "Find and merge duplicates" function available in Gmail, and finally import the deduped contacts back to Outlook.
If you want more detailed instruction, here you go:
- Export your Outlook contacts to a CSV file, as described in step 3 above (File tab > Open > Import > Export to a file > Comma Separated File (Windows)).
- Log into your Gmail account, navigate to Contacts, and then click Import Contacts...
- Click the Choose File button and browse to the CSV file you created in step 1.
Gmail creates a new contact group for each imported file so that you can easily access and review it later.
- After importing is complete, click the Find & merge duplicates link.
- A list of found duplicate contacts is displayed and you can click the expand link to review and verify the contacts to be merged.
If everything is Okay, click Merge.
A word of caution: Regrettably, Gmail is not as smart as Outlook (or maybe just overcautious) to detect duplicate contacts with slight differences in a contact's names. For example, it failed to identify our fake contact Elina Anderson and Elina K. Anderson and one and the same person. That is why, don't be disappointed if you spot a couple of duplicates after importing the merged contacts back to Outlook. It's not your fault, you did everything right! And there's still room for improvement for Gmail : )
- In Gmail, click More > Export... to transfer the merged contacts back to Outlook.
- In the Export contacts dialog window, specify 2 things:
- Under "Which contacts do you want to export", choose whether to export all the contacts or a particular group only. If you want to export only those contacts that you imported from Outlook, it stands to reason to select the corresponding Imported group.
- Under "Which export format", select Outlook CSV format.
Then click the Export button to finish the export process.
- Finally, import the merged contacts back into Outlook, as described in step 4 of the previous method. Remember to select "Do not import duplicate items"!
Tip: Before importing the merge contacts from Gmail, you can move all contacts from your main Outlook folder to a backup folder to avoid creating more duplicates.
Link duplicate contacts in Outlook 2013
If you are using Outlook 2013, you can quickly combine several contacts related to the same person using the Link Contacts option.
- Open your contacts list by clicking People at the bottom of the Navigation pane.
- Click on the contact you want to merge to select it.
- Then click the small dots button next to Edit to open the drop-down menu, and choose Link Contacts from the list.
- Under the Link Another Contacts section, start typing a name of the person you want to link in the search field, and as you type Outlook will display all contacts that match your search.
- Choose the needed contact(s) from the result list and click on it. The selected contacts will be merged straight away and you will see their names under the Linked Contacts heading. All you need to do is click OK to save the changes.
Of course, the Link Contacts feature is not the best choice to clean up a large contacts list cluttered with duplicates, but it will definitely help you quickly merge a few identical contacts into a single one.
How to prevent duplicate contacts in your Outlook
Now that you've cleaned up the mess in Outlook contacts, it makes sense to invest a few more minutes and lean how to keep your contact list clean in the future. This can be easily achieved by enabling the automatic Outlook duplicate contact detector. See how to do this in Microsoft Outlook 2010 and 2013:
- Go to the File tab > Options > Contacts.
- Under "Names and filing", select Check for Duplicate Contacts When Saving New Contacts and click OK.
Yep, it's as easy as that! From now on, Outlook will suggest merging a new contact you're adding with the existing one, if they both have a similar name or identical email address.
Hopefully, now you have a clean and neat contacts list in your Outlook and know how to maintain the order. Thank you for reading!
Worked like a charm. Especially liked your shortcuts! Thanks.
Hi Bob,
I am glad to know it worked for you. Thanks for your comment!
Worked great!
Hi Svetlana, I have to tell you how grateful I am for finding this piece, it was so helpful. I'll share the link with colleagues who will be very happy to find it's not a dreadful process after all. Simply fantastic, thank you again.
Thank you very much!
Great information.
I am wondering how this all works with contacts containing a contact photo.
The photo will not export to an Excel csv file.
Hi Mike,
You are right, photos won't be exported. But when you are merging the deduped contacts imported from Excel with the original ones (step 5 in the article), Outlook will pull a photo from the existing contact and add it to the merged contact. Anyway, you can backup the contacts before merging, just in case : )
Hi Svetlana
I have had a problem running the Merge Data Add in. I get an exception report and have copied the details. Will email it to you if you give me your email address.
Many thanks
Brian
Hi Brian,
Please send the details at support@ablebits.com and we'll do our best to fix the problem as soon as we can.
do you know of a consolidate addin for excel 2007 please?
Hi John,
We have the Consolidate Worksheets Wizard for Excel that works with all Excel versions including Excel 2007. You can find more details about this add-in and download a trial here. Hopefully this tool will prove useful to you.
I followed the aforementioned instruction. The file(s) will not import as they show not to be supported.
Hi Tom,
This is very strange. Please let me know which Office version you use and what exactly the error message says (a screenshot of the error message would be very helpful).
This is sick. It's 2014. You used to click a button to merge contact. Now you need a degree to do it.
I cannot say I disagree with you. Some features tend to become more and more complicated as Office evolves...
how to syncronize contacts from gmail to outlook
Hi Lipe,
A new version of Google Apps Sync (available in paid accounts) syncs contacts as well as calendars and other items.
As a free alternative, you can check out one of the third party tools: gSyncit (described in this article), GO Contact Sync Mod (open source tool to synchronize Outlook contacts with Google Mail), Local Sync, Contacts Sync (paid and free versions are available).
Hi,
how can upload the Bulk photo to outlook contacts?
Hi Ajish,
To my best knowledge, this is not possible.
Hi Svetlana,
Very useful article. One thing that still troubles me is what happens to phone numbers when re-importing them. This seems to give mixed results.
Do you have suggestions?
Hi Ivo,
It's hard to say when may cause this without seeing your entries. Can you please send us a screenshot of the "mixed results" at support@ablebits.com so that I understand the problem better?
I am trying to find a way of mass deleting all duplicates in my contacts. I have too many to try to do this one by one or by clicking all the way through. What a mess! and I also have to switch cell phones so it may happen again! Can you help me with any suggestions? Thanks so so much.
Hello Catharine,
You can consider using the ODIR add-in. Please check out this article for full details - Remove duplicate emails in Outlook 2010 and 2013.
ANONYMOUS !!!!!!!!!
February 23, 2014 at 8:38 pm
"This is sick. It’s 2014."
Your comment is not needed thank you very much !
You are obviously surfing to get something for free, so if you don't like it go somewhere else !!!
Pity I cannot see your E-mail address!!
Svetlana, thanks very much for this much needed "program", I will definitely use it and are keeping your address so I can purchase some other programs from you!
Kind Regards
Joe.
Hello Joe!
Thank you very much for a thumb up, I really appreciate it!
In fact, most of the solutions described in this article are free and can be accomplished using built-in Outlook tools. The only third-party add-in used in the first solution is Combine Rows Wizard for Excel. But this is just an optional time-saving alternative to quickly merge duplicate rows into one. I thought it might be helpful to those who work with large Excel spreadsheets. You can merge duplicate Outlook contacts without it, as described further in the article, this will simply take a bit more time : )
Hi Svetlana,
This really helped. Thanks. More so for making the steps so simple and easy to apply!
For some reason I was not able to download the excel add-in (trial version).
I have another problem. My office uses MS Exchange (hosted server). I am being told that the contact detail fields in Exchange are far limited in comparison to that in the Outlook. SO there is no way to have my colleague's second (personal) email address saved or even their personal mobile number. We used to have all this earlier where the Admin would circulate details of the new joiness.
I find this pretty retarded. The only solution my IT is offering is that of manually adding these details in Outlook after the contacts are imported from Exchange's Global Address Book.
Have you come across this issue and any thoughts?
Thanks in advance.
Have a great day.
Best Regards
Jayesh
Hi HJ,
Of course, MS Exchange has some limitations compared to Outlook, but as far as I know the limitations are not that strict. It's hard to say anything more specific without seeing your Exchange Server settings. I am afraid the only person who knows all the details is your administrator : (
I downloaded the trial version of the combined rows wizard and it worked great! Easy to use, and I needed it badly. I had a lot of cross-linked records (corrupt data) that caused a ton of duplicates. It took 2,451 rows and merged them down into 36! Then I just searched the spreadsheet for semicolons and made decisions of what to keep vs. trash.
One thing I'm unsure of is which "wins" between the Office 365 Exchange Server and Outlook. Hopefully Outlook wins, so all those duplicates will be deleted from my contacts on Office 365. Taking it further, I then hope that Exchange wins and pushes the changes down to iPad & iPhone, which also have those 2,000+ dupes. Any idea how those syncs work?
Thanks for a great article and great Excel add-in! Every time I try to scroll through my iPhone's contacts there are literally hundreds of entries for the same person, so hopefully this will resolve it...?
Chris
Hello Chris,
I am really glad to know the Combined Rows Wizard has been helpful to you, thank you very much for your feedback!
Sorry, I cannot state anything with certainly regarding iPad & iPhone because I have different sets of contacts in Outlook and iPhone (business vs. personal : ) Usually, there is a setting to mark the main contacts, so in theory, syncing contacts with Outlook should resolve the issue. Anyway, I would strongly advise to backup the iPhone right before syncing the contacts in case something goes wrong.
Hi
Great stuff, used the merge duplicate contacts in 2013 and it worked a treat. Not sure why you need "merge the dupecontacts with the original" stage but i followed every step and it worked just great.
Thank you.
Giff
Microsoft Outlook 2013 is showing my personal contacts from my iphone. what can i do to revert this. My outlook is for business only and don't want my personal contacts to show there. thanks
Hi Adan,
Sorry, we are not able to help with this issue. I can only advise contacting the Microsoft support service.
I found that dragging all of my contacts to the newly created folder to move them and then repeating that to move them all back, Outlook checks for duplicates. It's an even simpler method than what you have outlined here.
Thank you. Works like magic.
I have Outlook 2010 for windows and also use icloud. Under Outlook I have "Outlook" files listed under My Contacts and "iCloud" files. I prefer to use the iCloud files so that info will go to my iphone. I also have folders created for different types of contacts, i.e. Christmas Card, Teams, etc. Is there a way that my contacts won't be duplicated if they are in more than one folder?
Hello, Mary,
Sorry, we cannot help you with this. Looks like your task can be fulfilled only with a custom solution.
Thank you - very clever 'indirect' way of merging duplicate contacts!
Baffled! I am trying to follow the 2013 instructions, I click on People and the list appears, I click on the first of the contacts to link, but nowhere that I can see is there something that says edit or the three dots. Where on the screen should I be looking? Thank you for any assistance.
Hello, Karol,
Please make sure you have the Reading pane visible for the Contacts folder you selected.
1. Select the View tab on the ribbon.
2. Go to the Layout group.
3. Reading Pane - the Right value should be selected.
Then you can find the "Edit" and "..." buttons to the right of Outlook Reading Pane.
Hope this helps.
Thanks! The .csv trick worked great, and saved me a lot of time.
You are definitely my new best friend! Thank you! :)
I had a mess of duplicates in my Outlook. I followed the procedure above and tried the Excel Add-in and it worked beautifully. Thank you very much!
There is a problem with notes in each contact that make the csv file use more than a row for each contact and does not have a category. Not usefull for excel. Any other idea? :-(
Hello, Gustavo,
Looks like you need a custom VBA function to generate the correct CSV file.
Sorry we cannot assist you better.
I stumbled on what I think is a lot simpler/easier method: Just select and drag the duplicate contacts to another contact folder and hit undo (ctl-z). When Outlook is moving the contacts back it triggers the "Duplicate Contact Detected" dialog where you click update and it merges the two.
Extremely helpful! Thank you so much!
Quite complicated method described above.
In newest Android phones I found merge command. There are also external apps for deduplication, some other contact managers offer merge function on selected contacts.
Shame that Outlook doesn't have these very desired functions (merge and remove duplicates).
I'm using freeware ODIR to remove duplicates, but ODIR doesn't work in Outlook 2013 anymore. On Android there are also some apps for duplicate removal.
Hello, Marek,
Thank you for your comment. Hope Microsoft will implement these helpful options one day.
Hello,
I just merged a backed up PST with the OST recently.Now some contacts does not show up.I shows up on the phone,I checked its not in the Phone memory.
Also some emails does not show up, I checked the Indexing status it shows completed.
Please help..
Hello,
I deleted the company email in my GM's mobile as we migrated our mails from Managed Microsoft email services(POP3) to Microsoft Exchange.
After some time he came to me and said that his contacts are lost.
I checked his outlook but he did not have any contacts in it.
Can this contacts be retrieved?
Please Assist..
I don't normally do this, but I wanted to comment just to say thank you. This process and the Combine Rows Wizard worked great.
excellent post ! i know now some app on the android phone can eliminate contacts on the phone. this is a solution for the duplicated contacts on the outlook. Also the mostly common that people duplicate their contacts due to copy the same contact to different folders in order to group or organize the contacts. If you don't want to create duplicate contacts the most acceptable way is to add a "category" for your outlook contacts. you can then view if by grouping the category .
Thank you so much for your helpful comment, Tom!
First method worked for me on Outlook 2013, with the exception that CTRL-SHIFT-V didn't do anything, but CTRL-V did.
Brilliant tutorial and method! Thanks.
It may have been said before above, but Microsoft, would you please
1. set the duplicate checkbox on as default (der)
2. give this duplicate check capability on import...like the old days.
Thanks,
slc
Hi,
How i can merge duplicate contact in outlook 2013? m trying to do it but its not worked out.
Hi this works great for Contacts i went through the whole tutorial and it worked perfectly, now how do i put all these contacts into the separate ms outlook "address book" which appears to be the old contacts with all the duplicates in it?
please advise.
thanks
steve
Hello, Steve,
For us to be able to help you better, please give us more details about your task. Please clarify what you mean by "appears to be the old contacts with all the duplicates in it"?
Is there a way to determine which Folder Group a contact belongs to? For example, I have about 15 folder groups. If I look at a listing of all of my contacts from the Contacts group, I see several duplicates. I do not see a "Field" at the top to list what "Folder Group" a contact belongs to and what happens is if I delete a duplicate contact, it deletes the one from a Folder Group and I don't want to delete the ones from Folder Groups, only the duplicates that aren't in any Folder Group. Thanks for your help!
Hello, Floyd,
As a workaround you can create a custom category for the contacts from each Folder Group and assign it to all contacts from this group. The Categories field will be exported with all information and you will see which group a contact belongs.
To add a category:
1. Go to the Tags ribbon group.
2. Click Categorize - All Categories...
3. Click New...
4. Enter the Name and select the color.
6. Click OK.
Hope this helps.
Hi guys,
Also You can easily resolve your problem with >>>>> DuplicateFilesDeleter
so lets try it.
Thanks
When I tried to import the .csv file back into my Contacts folder, I got an error message indicting "The file D:\Documents...." is locked. This could be because the disk is locked, the file is read only, in use by another program, or because you do not have permission to use a network path." How do I fix this?
Works great! I stumbled onto this through a google search and then I realized that this company is located just up the street from where I was born and grew up!
Hi My name is Neo sherman and we can fairly quickly promote your website to the top of the search rankings with no long term contracts!We can place your website on top of the Natural Listings on Google, Yahoo and MSN. Our Search Engine Optimization team delivers more top rankings than anyone else and we can prove it. We do not use ""link farms"" or ""black hat"" methods that Google and the other search engines frown upon and can use to de-list or ban your site. The techniques are proprietary, involving some valuable closely held trade secrets. Our prices are less than half of what other companies charge.We will also provide you with a checklist to show you the strengths and weaknesses of your current website.If you would like to have a no-obligation discussion with me, please reply with your phone number?Can I call you this week to discuss your campaign?Best regards, Neo Sherman Online-Manager
First page rankings on Google
We can put your website on 1st page of Google to drive relevant traffic to your site. Let us know if you would be interested in getting detailed proposal. We can also schedule a call & will be pleased to explain our services in detail. We look forward to hearing from you soon. Thanks!