How to import contacts from excel to outlook. Click on the open export option and select importexport from the options. How to lock cells in excel to protect data. In the import contacts dialog box click import.
If the text is not displayed correctly select cancelyou will need a file in utf 8 encoding to continue. Now that we have our file ready its time to import contacts from excel to outlook. If you are not sure that the column names in the first row of the spreadsheet will map correctly to the outlook fields click map custom fields to verify them.
Close the excel workbook. Import contacts from excel. Enable the excel file which contains the contact list and click file save as browse and select a folder to save itthe in save as type drop down list select csvcomma delimited and click the save button.
Import contacts from a csv file into outlook. Import contacts from excel to outlook. When the process is finished click close.
To import the contacts from excel list you need to save the excel file as csv file first. Open microsoft outlook and go to the file menu. From there select open export importexport.
Select import from another program or file and then click the next button.