In so many situations, one needs to import contacts to Outlook from an Excel spreadsheet. Follow these simple steps to import contacts from an Excel Sheet in to Outlook 2010, the only pre-requisite is that your Excel sheet should be in the Comma Separated format.
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!