How To Import an Excel CSV Contacts File into Outlook 2010
If you have a list of contacts saved as an Excel CSV file spreadsheet, you can use the Import feature inside Microsoft Outlook 2010 to import these contacts. CSV stands for Comma Separated Value. In a CSV file, there is one record per line, and each field within a record is separated from the previous field by a comma. This format allows Outlook 2010 to recognize records and fields so that they can be imported correctly. Most email applications provide an option allowing you to export your contacts into a CSV file. If you have an Excel spreadsheet listing your contacts you can save it as a CSV file and import it into Outlook 2010 as well.
Follow these simple steps to import an Excel CSV format file into Outlook 2010.
How to Convert an Excel Sheet in to the CSV (Comma Separated Values) Format
In Excel, click the File menu and choose the Save As option. Browse and select the location where you want to save the file, type in a name for the file and choose CSV from the Save as Type drop down box.
Importing a CSV File in to Outlook
If the CSV file you are importing contains more up to date contacts then you have in Outlook 2010, or if you do not have any contacts, select Replace Duplicates with Items Imported.
If you want to import contacts without affecting any existing contacts you already have in Outlook 2010, select Allow Duplicates to be Created.
If your contacts in Outlook 2010 are more up to date then the contacts you are importing, select Do Not Import Duplicate Items.
If you are unsure if the fields you have set up in the CSV correctly map to Outlook contacts format, click the Map Custom Fields button. To map fields, drag the fields from the From section and drop into the appropriate field into the To section on the right. When you have finished mapping all of the fields, click OK.
Your CSV contacts fill will then be imported into Outlook.