Excel contacts are not readily accessible into MS Outlook; in fact they need to be exported to Outlook or other email applications that access Windows Address Book. This section resolves the associated query on how to import contacts from Excel and CSV file into Outlook 2010 as this version is widely popular among users.

Need to Convert Excel or CSV Contacts to Outlook 2010? Read Further to Know More.

This section illustrates information on exporting contacts from Excel or CSV file; and then importing them further to Outlook application. Since the given procedure applies to Outlook 2010 but can be implemented in another versions as well; with minimal modifications.

Export Contact from Excel: To export XLS contacts to Outlook 2010, it is required to under go several manual methods. This can be done by referring to the following procedure. If the contacts are saved in Excel file, they can straightaway be transferred to MS Outlook 2010, as the latter provides the option to import contacts from MS Excel. Therefore, the contacts can be imported using “Import Export Wizard” in Microsoft Outlook.

Export Contacts from CSV: In order to import CSV contact file into Outlook, it first needs to be converted to CSV from Excel and the task can be done by following the below mentioned concept. The initial step includes exporting XLS file containing contacts details to CSV format by using the Excel spreadsheet “File” menu. Further, by selecting the CSV (Comma delimited) option, from the drop-down list of options in “Save as type” column; all the contacts can be saved in this format. Afterward, the CSV file can be imported into Outlook 2010 by implementing the concept defined in the next section.

Import Contacts into Outlook 2010: To import the CSV into Outlook, simply go to “Import” option available in the “Open” tab of “File” menu. Further select the program or file to be imported and then provide the destination location for saving the file on machine. Following the instructions in a correct manner will help storing CSV information into “Contacts” folder in Outlook 2010.

Caution: Do carefully select among the options given in the wizard as any mistake can leads to duplication of contacts.

Some Related Facts!

Though, the procedures to convert excel contacts folder to outlook contacts address book and CSV to Outlook are quite similar; but both the procedures involves several drawbacks as well.

If you need to edit particular fields or its attributes; the manual conversion approach will not allow you to do so. It could result in replication of data and is time taken too; so, it is recommended to use third party tool while converting contacts to Outlook.

Convert Large Volume of Contacts to Outlook 2010 in Batch!

On the contrary, Excel to Outlook Converter not only allows you to convert contacts to Outlook; but also enables mapping the fields as per your requirement while delivering supplementary conversion benefits. Files with any number of contacts can be converted in an instant way using the tool. Apart from creating a single contact, it allows creating ‘Distribution List’ as well, that stores entire contacts altogether into one list. In addition, it provides option to include or exclude conversion of duplicate contacts. Summary report for the converted contacts is also displayed within the tool panel that let you know about the total counts of contacts that has been successfully converted.

The tool also enables exporting contacts from CSV to Outlook, hence providing complete resolution for the query on how to import contacts from Excel and CSV file into Outlook 2010.