How to Import Address Book from Microsoft Excel to Microsoft Outlook 2007?

Solution summary

If you are looking for the complete solution to import an address book from Microsoft® Excel® to Microsoft® Outlook® 2007, then follow the easy 7-step resolution to resolve the problem.

Microsoft® Excel® is one of the most popular spreadsheet applications and is part of the Microsoft® Office suite. It is the most convenient way of organizing databases..

Each step is accompanied by an indicative screenshot for the ease of mirroring the action.

Read Detailed Solution

Did you know that you can resolve more than 90% of technical problems, quickly and easily? Click on each step in the vertical menu to the left of this page or click on the ”Previous” or ”Next” buttons at the bottom of this section to navigate through the solution.

Step 1

Click ”Import and Export”
Open ”Microsoft Outlook”, go to ”File” in the main menu bar and then click on ”Import and Export”. An ”Import and Export Wizard” dialog box will appear.

Step 2

Select ”Import from another program or file”

In the ”Import and Export Wizard”, go to ”Choose an action to perform” list and select ”Import from another program or file” from the list.

Step 4

Select ”Microsoft Excel”
In the ”Import a file” from ”Select file type to import from:” window, select ”Microsoft Excel” and then click the ”Next” button. A ”File to import” Screen will appear.

Step 5

Select an appropriate option

In the ”File to import” box, enter the appropriate file path you want to import. From the ”Options” group, select the appropriate option and then click the ”Next” button. The ”Select destination folder” screen appears.

Step 6

Select ”Contacts”
From the ”Select destination folder” list, select ”Contacts” and then click the ”next” button. The ”The following actions will be performed” screen appears.

Step 7

Click ”Finish”
In the ”The following actions will be performed screen”, click the ”Finish” button.

You have successfully imported an address book from MS Excel® to MS Outlook® 2007.

If you face any problem related to your computer, operating system, software applications or peripheral devices like printers, MP3 players, digital cameras etc. then call iYogi and we”ll fix it.