How to Import Email Addresses From Excel to Outlook
Microsoft Outlook can take information from a Microsoft Excel spreadsheet containing a list of email addresses and transfer the data to the virtual address book. To import an Excel spreadsheet to Outlook, you must convert the spreadsheet to the comma-separated values file format. Once the spreadsheet is converted, Outlook's Import and Export Wizard will upload the data to your "Contacts" folder.
Open the Excel file where the email addresses are stored. Right-click "1" and select "Insert" from the context menu.
Enter a description for each column. For example, if the first column contains the names of the contacts, and the second column contains the email addresses for the contacts, enter "Name" into A1 and "E-mail Addresses" into B1.
Click "File." Click "Save As." From the "Save As Type" drop-down menu, select "CSV (Comma Delimited) (*.csv)." Save the file to the desktop.
Open Outlook. Click "File," then click "Open." Click "Import." Double-click "Import From Another File or Program."
Double-click "Comma Separated Values (Windows)." Click "Browse" and go to the desktop. Double-click the Excel spreadsheet where the email addresses are stored.
Select from the options which method you would prefer Outlook to use when handling duplicates. Click "Next."
Select the "Contacts" folder from your Outlook data file. Click "Next." Click "Finish" to import the addresses.
Tips & Warnings
- You don't need to insert a new row if your spreadsheet already contains categorized columns.
- It's recommended that you click the "Map Custom Fields" button on the last page before completing the Import and Export Wizard. Confirm the spreadsheet columns properly map to the Microsoft Office Outlook fields.