Export contacts from Outlook to Excel

The Import and Export Wizard in Outlook makes it easy to export contact information from Outlook into an Excel worksheet.

Note Before you use the wizard, it helps to understand the difference between the Outlook Address Book and Outlook Contacts. Both are part of Outlook. However, the Address Book is a compilation of the different address lists you might have stored in Outlook, such as a Personal Address Book (.pab), LDAP (Lightweight Directory Access Protocol) Internet directories, the Global Address List (GAL) (Global Address List), or other third-party address books. Contacts is just one of the address lists that make up the Address Book. Only contacts can be exported directly from Outlook to Excel.

1.In Outlook, on the File menu, click Import and Export.
2.Click Export to a file, and then click Next.
3.Click Microsoft Excel, and then click Next.
4.In the folder list, click the Contacts folder, and then click Next.
5.Browse to the folder where you want to save the contacts as an Excel file (.xls).
6.Type a name for the exported file, and then click OK.
7.Click Next.
8.To add or remove fields to determine the way the contact information is saved in the new Excel worksheet, click Map Custom Fields.
9.Click Finish.