How To Import Contacts From Excel File To Outlook 2010

Convert an Excel Sheet in to the CSV (Comma Separated Values) Format

Click the File Menu and choose the Save As option, browse and select the location to save the file, specify the name of the file and choose CSV from the Save as Type drop down box.

Importing a CSV File in to Outlook

Lets assume that we have converted the Excel sheet to the CSV format as mentioned above, now launch Outlook 2010, and click the Office button(File menu). Then click the Open option and choose Import.

Now in the Import and Export Wizard, choose the Import from another program or file option.

Click the Next button and choose the file type Comma Separated Values (Windows) and then click Next.

Now browse and select the CSV file.

Hit Next and select and choose the Destination Folder.

Finally confirm the action and hit the Finish button. Here you can change the destination as well.

Your Excel sheet contacts will be imported to your destination folder. Enjoy!