In Microsoft Outlook, how can I import address information from an Excel workbook into my Contacts list?
Follow the steps below to import Excel data into Outlook:
1. Arrange the Excel data in the traditional database format; i.e., give each column field titles and make each row a record.
2. Change the field titles in the worksheet so that they match those in your Outlook Contacts list.
3. To display the Name dialog box, press Ctrl-F3. Use this dialog box to assign the name Contacts to the entire range of contacts data.
4. Open Outlook, and from the File menu, select Import and Export… .
5. In Outlook 98, 2000, 2002, or 2003, select Import from another program or file. In Outlook 97, select Import from Schedule+ or another program or file. Click Next.
6. Select Microsoft Excel. Click Next.
Note: You may get the following prompt: “Microsoft Office Outlook cannot start the required translator. This feature is not currently installed. Would you like to install it now?”
If you do, click Yes to continue.
7. From the Import a File page, make your desired selections, depending on how you want to handle duplicates. To navigate to the Excel file you are importing, click Browse… .
8. Select the file, then click OK. Back in the Import a File dialog box, click Next.
9. In the Select a destination folder window, select the Contacts folder. Click Next.
10. On this last page, you will see two buttons:
* Map Custom Fields… : Click if you want to change the “field mapping”, i.e., the selection of which columns in your Excel file match up with which data in Outlook’s contacts. For example, one of your Excel file columns might read “Home”, and you’ll have to map that in Outlook to either “Home Address” or “Home Phone”, accordingly.
* Change Destination… : Click if you want to change the destination folder. Since you are importing contacts, and since you already selected the destination folder in the last step, you only need to click this button if you made a mistake or want to double-check that you’ve selected the right one. Otherwise, you can ignore it.
When you are done, click Finish, and wait for Outlook to complete the task. To check the results in Outlook, open your Contacts folder.