April 13, 2024
SOLOBIS

How To Add Contacts from Excel to Outlook 2007/2013 Application

excel to outlook

Need to Add Contacts from Excel to Outlook Profile
As Different Email clients are used be people all over the world. According to research data related to an Email client, a large number of Outlook user are still present and using different Outlook versions such as Outlook 2016/2013 and Older versions such Outlook 2010/2007/2003 etc.

In Outlook profile, a user can add contacts and other details a such as name First Name, Mobile Number, Company, Birthday, Business Telephone Number and other Personal and Professional details. If a user can try manually try to add contacts for each user, with all details, it consumes a lot of time and hard work. To save this effort, a user can go for another tricky method. If a user can store & maintain the information in Excel sheet format, then it is easy to add contacts from Excel sheet to Outlook. As Outlook provides an option to add the contacts list using the Import Export Wizard.

In this article, we try to explore the steps so that even a naive Outlook user can perform this Conversion task. The complete process to Add contacts to Outlook from excel file can be performed in few steps.

  • Save user Details in Excel Sheet
  • Add contacts to outlook with Excel
  • Preview Contacts in Outlook Application

Note: As different Outlook versions available, In latest Version, an option to add Excel file is not available, and user need to convert the Excel file into CSV(Comma Separated Value) so the contacts can be added.

Outlook 2016 & 2013: User need to Convert Excel file to CSV Format.
Outlook 2010 Version: Option available to Add Excel File but Microsoft 97-2003 format.
Outlook 2007: Option of to add File of Microsoft 97-2003 file format available.
Outlook 2003: Add File format of Microsoft 97-2003 available.

Save User Profile Details In Excel Spreadsheet Format
So prepare your Excel Data carefully, You can look on below example image, how you can store files in Excel Worksheet. After storing data, Open the Outlook Application and follow the steps to add contacts from Excel to Outlook 2013/2010/2007.

Before adding the contacts in Outlook configured profile, first user has to store the data in such way the, no error will appear while saving the information from excel sheet. As Different, error faced by Outlook user such as some field data of excel stored not stored in Contacts Book properly or some file data is missing, even mapping error occur.

Add contacts from Excel to Outlook
Now just use the Import Export utility to add contacts to Outlook using Excel spreadsheet add the contacts. In Different Outlook edition, path of Import and Export wizard could be change, So just follow the simple steps properly:

1) Open Outlook Application
2) Go to File menu and select Import/Export Wizard Option.
3) In Import/Export Wizard

  • Select Comma Separated Values (Windows) option: In Outlook 2013/2016, user need to select option to “Import File from another program file” and then select the CSV File, converted from Excel sheet in which contacts are added.
  • Select Microsoft Excel 97-2003 File option: In Older versions such Outlook 2010/2007/2003, a user can directly select option to import the Excel Worksheet file.

4) After selecting the desired file according to versions, select one of the option from 3 option given by Outlook, to avoid any kind of inconsistency in data.

  • Replace duplicates with items imported: Replace the duplicate field with the imported Contact field.
  • Allow Duplicates to be created: Duplicate Contacts filed stored in Outlook Address Book.
  • Do not import duplicates items: No Duplicates stored in Contacts Book

5) After selecting one of the above options, a user needs to select Destination Folder(Contacts), So that contacts file details for all those user added in Excel file is created. Click “Next” option.

6) During the Conversion process, after selecting the Destination location, Outlook allows mapping the Excel worksheet to the Contact field of the Outlook application. For this Map Custom Fields available.

7) In Map Custom Fields: In this section, a user just need to map or match the field of Excel sheet to the Outlook field. Just map the Left Pane field (Excel Workbook) to the Right pane(Outlook) by dragging the field in the dialogue box. At last, just click on Finish button to view the added contacts list from excel sheet.

Error During Adding contacts from Excel to Outlook
1) No Contacts appear in Outlook Application
2) MAP Translation Error
3) Empty or Missing field
4) Limited number of Excel contacts are added in Outlook
5) Duplicates Contacts Save in Contacts
6) Distribution List not created properly

As different error faced by Outlook customer, while adding contacts from Excel to Outlook 2007/2010/2013 versions, To avoid this kind of issues and without any manual steps, a user can directly add the contacts list into configured Outlook application using the Excel to Outlook Converter. Try the demo version of the tool and use the prominent feature configure and save Outlook contacts to Excel spreadsheet, add excel contacts to outlook distribution list excluding duplicate, preview the data during the conversion process.

Conclusion
To Add contacts From Excel to Outlook address book can be a tedious task if there are thousand of contacts are available. Empty or missing field error is a common error and user needs to edit the Excel sheet every time to add the contact to Outlook via excel or CSV file. An automated be the best choice for these kinds of situation, as the tool can directly, with selecting any option Outlook, save the contacts addresses, email, phone number perfectly.

You May Like To Read

Which One To Use Angularjs Or Angular?

Sahej Dharak

How to Choose a Logo Designing Firm?

Sahej Dharak

10 Best Adobe Reader Alternatives Tools Everyone Should Use

Etech Spider

How To Come Out of Digital Marketing Challenges

Etech Spider

Harnessing the Power of Social Media Analytics Guide for Driving Growth and Engagement

Sahej Dharak

Real Time Analytics Benefits: 3 Advantages Explained

Sahej Dharak

What is the Goal of IT Managed Service Providers?

Sahej Dharak

Exploring Innovative Chatbot Development Solutions: Unleashing Tomorrow’s Conversations

Sahej Dharak

Strengthening Your Website Security with Best Practices

Etech Spider

The Top 5 AI Advantages in Banking: Beyond Transactions

Sahej Dharak

Top 4 Artificial Intelligence Benefits for Business

Sahej Dharak

Why Customer Database Software is Important for Small Business?

Etech Spider

The Versatile Data Mining Applications in The World

Sahej Dharak

Tailored Process of Designing and Building Data to Achieve Business Goals

Sahej Dharak

The Power of SAP Success Factors: A Comprehensive Guide

Sahej Dharak

The Importance of NMiniature Precision Mechanical Components in Modern Technology

Sahej Dharak

Benefits of Hiring Business Intelligence Data Warehouse Consultant

Sandeep Dharak DS

15 Omegle App Alternatives: Random Video Chat Websites

Sahej Dharak

ShowBox Alternatives: Top 3 Alternative to Show Box

Etech Spider

The Ultimate Mac Maintenance Ritual

Sahej Dharak

10 Reasons You Need AI for Supply Chain Management

Sahej Dharak

6 Top Affordable Windows Professional Laptop

Sahej Dharak

Software Testing Factors: 4 Key Factors Remains Behind Testing

Sahej Dharak

AI-based Document Verification Services To Redefine Customer Security

Sahej Dharak

Advantages and Disadvantages of Key Performance Indicators

Sahej Dharak

How To Embed Interactive PDFs On A WordPress Site

Sahej Dharak

Benefits of Outsourcing IT Support for Your Business

Sahej Dharak

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More