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.

ewew

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.

ImprtOutlook2010_thumb

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

ImnportandExport_thumb

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

CSVFormatOutlook2010_thumb

Now browse and select the CSV file.

ImportExcel2010_thumb

Hit Next and select and choose the Destination Folder.

DestinationFolderOutlook2010_thumb

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

ImportOutlook2010FinalStep_thumb

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

Suggested Posts:

Leave a Reply