• About
  • Contact
  • Disclaimer
  • Privacy & Policy
  • Home
  • Technology
  • Business
  • News
  • Health
  • Travel
  • Education
  • Food
  • Games
No Result
View All Result
CRAZY SPEED TECH
No Result
View All Result
Home softwares

Import Contacts From Excel to Outlook Without Duplicate Items – Solution

in softwares, Technology
Reading Time: 14 mins read
0
download
Share on Twitter

Either you are a part of a start-up or any well-established organization, communication is a critical component that brings a major impact to the business. In order to establish any communication, it becomes essential to have contact information of the person. Most of the users who have a lot of business or personal contacts, use Excel workbooks to save contacts information. However, there come some circumstances when users get annoyed by duplicates in Excel file and want to import contacts from Excel to Outlook without duplicate items. Well, this can be done simply using the manual as well as automatic techniques. Both methods are easy to execute and only take a few steps to accomplish. After this, you can easily access the Excel file contacts from Microsoft Outlook application.

Contents

  • 1 Solution 1. Import Contacts from Excel to Outlook Without Duplicate Items
    • 1.1 Step 1. Save Excel Workbook as CSV File Format
    • 1.2 Step 2. Import Resultant CSV to Outlook
    • 1.3 Step 3. Map CSV Columns with Outlook Contact Fields
    • 1.4 Solution 2. Direct Way to Import XLS Contacts to Outlook
      • 1.4.1 Final Words

Solution 1. Import Contacts from Excel to Outlook Without Duplicate Items

If you have imported contacts from various sources or placed someone else’s contact list in your excel spreadsheet then, you might have several duplicate contacts. But, now if you want to import contacts from excel to Outlook manually even without duplicates then, follow the steps mentioned below:

Step 1. Save Excel Workbook as CSV File Format

MS Outlook does not provide any option to import excel workbook with multiple sheets. Instead of this, it allows importing comma separated value (.csv) files. Hence, first, you need to convert excel spreadsheet into CSV file format to import contacts from Excel to Outlook without duplicate items. Below are the steps to do so:

  • Open the Excel workbook that you want to import in Outlook

  • Click on File and select Save As option

  • Browse a destination location to save the file

  • From Save As type box, select CSV (Comma delimited) (*.csv) option

  • Hit the Save button

  • After this, the Excel will warn you that “The selected file type does not include workbook that comprises multiple sheets”. Well, ignore this as this is just a limitation of CSV file and it will not affect your original workbook (.xlsx file)

  • Hit the OK button

  • You will get a message “Some of the features in the spreadsheet may be lost after saving it as CSV”. Ignore it and click Yes

  • The original workbook will be closed automatically after this. Close the CSV file

Step 2. Import Resultant CSV to Outlook

Now you will be available with your Excel contacts in CSV format. To import contacts from Excel to Outlook without duplicate items, you need to export those CSV file contacts into your Outlook account. Follow the steps to see your contact items in Outlook address book.

  • Open Outlook application and click on File

  • Select Open & Export and click Import/ Export

  • Highlight Import from another program or file option

  • Choose Comma Separated Values (Windows)

  • Navigate to the location where you have saved CSV and select it

  • Now, select Do not import duplicate items option

  • Select the main contacts folder as destination folder and you will find that this is currently empty

  • Click Finish

Step 3. Map CSV Columns with Outlook Contact Fields

Transferring spreadsheet contacts into Outlook distribution list is not an easy task. You need to map the fields in your Excel sheet to Outlook contact attributes for moving the contacts exactly into your Microsoft Outlook 2019, 2016, 2013, 2010, 2007, 2003, 2002 versions. Map the required fields from the CSV contacts into Outlook account to import contacts from Excel to Outlook without duplicate items.

  • After importing CSV successfully to Outlook, click on Map Custom Fields

  • Map Custom Fields wizard will pop up now. Here, under From section, you will get a box with column names from CSV file you are importing

  • Under To, you will find standard fields that Outlook uses for the contacts. If any field matches a column in CSV file, you will get your column under-mapped from

  • The Name, First Name, Last Name etc., are the standard Outlook contact fields. Hence, if the contact information in the file has any of such contact names then, you can proceed

  • It might be possible that you need to do some manual mapping. For this, just scroll down until you get Other Addresses that have + sign next to it

  • Hit the + sign to expand it and you will get the match

  • From the left pane, drag Cell Ph and drop it into Mobile Phone in the right pane

  • You will find that Cell Ph is now displaying next to the Mobile Phone in Mapped from column

  • You can drag one at a time and repeat the steps to map the rest of the values to appropriate Outlook fields

  • Hit the Finish button

  • After this, you can simply access Excel contacts from Outlook application even without any mapping issues.

Solution 2. Direct Way to Import XLS Contacts to Outlook

If you are finding manual method lengthy and time-taking then, use SysTools Excel to Outlook Contacts Converter to .xls file contacts to Outlook address book excluding duplicate items. It is designed in such manner that it can export excel file contacts to Outlook in batch mode and eliminate duplicates. The software provides an option to Create a Distribution List in Outlook for the ease of users. Follow the steps mentioned below to import contacts from Excel to Outlook without duplicate items:

  • Open Excel to Outlook Converter and click on the Browse button

1

  • Select the excel file from which you want to import the contacts to Outlook. Click Open

1.2

  • After previewing excel file contacts, hit the Next button to proceed with the conversion

2

  • Match Excel file fields with Outlook attributes. For this, select the Excel fields from the left pane and select the corresponding Outlook attributes from the right side

3

  • Once all the fields are matched, hit the Add button and the tool will list matched attributes. Click Next.

4

  • In the next window, check all the appropriate option but leave Do you like to allow duplicate contacts based on Email Address uncheck.

4.1

  • Hit the Convert button, to begin with, the conversion process.

5

You are done now and you can access all your excel file contacts from Microsoft Outlook address book even without encountering any duplicate contacts issue.

Final Words

In this article, we have disclosed two different techniques to import contacts from excel to Outlook without duplicate items. The manual method, mentioned here might be complex for some users and they may feel it tedious as well. In order to overcome such limitations of the manual method, we have also recommended an automatic and quick solution for the same.

Tags: excel contactsexcel to outlookmicrosoft excelxls file

Related Posts

Frontend vs. Backend Development: Main Differences

Frontend vs. Backend Development: Main Differences

May 9, 2022
10 Reasons why automation tests can end in failure

10 Reasons why automation tests can end in failure

May 3, 2022
Are Certifications Required to be a SOC Analyst?

Are Certifications Required to be a SOC Analyst?

April 7, 2022
What Is Spider Web In Cloud Computing?

What Is Spider Web In Cloud Computing?

March 17, 2022

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recommended.

Download IMO For PC Without Bluestacks

Download IMO For PC Without Bluestacks

July 6, 2021
Myrtle Beach Weddings - Plan Your Perfect Wedding

How To Choose The New Wedding Destination

August 9, 2021
The Bovada Review

The Bovada Review

January 5, 2021
Here are 5 Industries Getting Valley Funding

Here are 5 Industries Getting Valley Funding

January 8, 2021

About – CRAZY SPEDD TECH

CRAZY SPEED TECH

Crazy Speed Tech is a company that provides the latest news and updates on mobile, android, apps, health, business, tech and softwares. crazy speed tech's mission is to provide people with information that they can use in their everyday lives

Follow Us

Other Categories

  • Digital Marketting
  • Games
  • Home Appliances
  • Lifestyle
  • Marketing
  • Refer & Earn
  • Fashion
  • Android
  • Entertainment
  • Currency
  • GADGETS
  • Social
  • Education
What Is The Best Way To Choose Quality Delta 8 THC Carts Wholesale?

What Is The Best Way To Choose Quality Delta 8 THC Carts Wholesale?

May 17, 2022
How to Make the Most Out of Private Duty Homecare Software for Your Agency

How to Make the Most Out of Private Duty Homecare Software for Your Agency

May 13, 2022
How Do Pure Delta 8 Flowers Make You Feel High - You Must Know

How Do Pure Delta 8 Flowers Make You Feel High – You Must Know

May 12, 2022
Bons Official Website for Online Cricket Betting | India

Bons Official Website for Online Cricket Betting | India

May 12, 2022

Get more stuff

Subscribe to our mailing list and get interesting stuff and updates to your email inbox.

Thank you for subscribing.

Something went wrong.

we respect your privacy and take protecting it seriously

  • About
  • Contact
  • Disclaimer
  • Privacy & Policy

Crazy Speed Tech Copyright © 2015-2021. All rights reserved.

No Result
View All Result
  • 4 Harmful Medical Cannabis Myths Debunked
  • 5 Best Backpacks To Buy – Read Before You Buy One
  • 6 Things You Should Know About Oral Drug Testing
  • Appvn APK Download for Android
  • Contact Us
  • CRAZY SPEED TECH – Latest News, Apps for PC, Windows, MOD APK, APK Download & Alternatives.
  • Disclaimer
  • Facejjang Apk Download | Facejjang App Foe Android
  • Google Pixel 3 and 3 XL coming in October 2018
  • Met deze accessoires laat je de moeder van de bruid schitteren
  • Newsletter
  • Privacy Policy
  • Skønne festkjoler som aldrig går af mode
  • Tästä näet kuinka paljon morsiamet käyttävät rahaa häihin
  • Things to See and Do in Maremma, Italy
  • Truth About CBD Gummies For Sleep, Calmness, And Exercise Recovery

Crazy Speed Tech Copyright © 2015-2021. All rights reserved.