• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Outlook Tips

Learning Microsoft Outlook One Tip At A Time

Diane Poremsky [Outlook MVP]

  • Home
  • Tips Archive
  • How to...
  • Beginner
  • Outlook.com

Tip 1088: Check for Duplicate Contacts

An Outlook user had this question:

We have a list of contacts saved in an Excel file containing more than 100 contacts. Some of these names are already in Outlook. How can we import these without importing the duplicates?

You can use one or more of these options:

1. Turn on Outlook's option to check for duplicate contacts. It's in Contact Options and when enabled, it checks the current folder for duplicates as you add new contacts. In Outlook 2013 and 2010, this option is at File, Options, People (or Contacts). In older versions, it's in Tools, Options, Preference tab, Contact Options.

check for duplicates

2. During Import, check for duplicates.

When you use the Import/Export Wizard, you can skip duplicate items.
don't import duplicates

3. Use a duplicate remover utility to remove duplicates after importing.

I have a list of contact duplicate remover at Delete Duplicate Outlook Contacts

Published May 21, 2013. Last updated on May 21, 2013.

Share this:

  • Twitter
  • Facebook
  • LinkedIn
  • More
  • Print
  • Tumblr
  • Reddit
  • Pocket
  • Pinterest

Related posts:

I’m seeing quite a bit of confusion over the Suggested Contacts folder in Outlook 2010. It’s a contacts folder containing addresseTip 828: Suggested Contacts How to move Contacts from Outlook to Outlook.com Do you use Windows or MSN Messenger? Newer versions of MSN Messenger allow you to import and export (save) your contacts lists, inTip 257: Sharing Messenger Contacts Tip 863: Duplicate Sent Messages in Outlook 2010
Subscribe
Notify of
0 Comments
Newest
Oldest Most Voted
Inline Feedbacks
View all comments

Primary Sidebar

Search OutlookTips

Training and one-on-one assistance

Do you need help setting up Outlook or want some one-on-one training? I'm available for hire. See Training and one-on-one assistance for fees and to check availability.

All-Time Most Popular Posts

  • Windows 7 and Vista Start Search field
    How to start Outlook in safe mode
  • outlook.com icon
    Delete a message stuck in Outlook's Outbox
  • How to use Outlook's Command line switches
  • Use Cleanviews switch to reset all views
    How to Reset the View on Outlook folders
  • Where are my Outlook Files?
  • Folder paths
    How to Find Folder Paths in Outlook Mailboxes
  • How to use Scanpst.exe to repair Outlook data files
  • Outlook's Missing Holidays
  • backstage page
    Where is File tab in Outlook?
  • Icons found in the Inbox, Message Headers, and Toolbars

Footer

Recent Posts

  • Log into multiple Outlook on the web accounts
  • Keeping Hackers out of Microsoft accounts
  • Microsoft Account Closure Email
  • Outlook on the web Quick Actions moved to the right
  • Automatically sign out of Outlook.com

Recent Bug List

Microsoft keeps a running list of issues affecting recently released updates at Fixes or workarounds for recent issues in Outlook for Windows.

Office Update History

Update history for supported Office versions is at Update history for Office

Resources

Ask questions and share your knowledge in Outlook Forums.

You Might Like

Where is File tab in Outlook?
Using Two-factor authentication
Where are my Outlook Files?
How to use Outlook's Command line switches

© 2003–2025 · Outlook Tips

wpDiscuz
You are going to send email to

Move Comment