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.
