How to Transfer Outlook Contacts to Excel

by Angela M. Wheeland

All of the productivity applications included in the Microsoft Office Suite work together. While Excel is a spreadsheet application and Outlook is an email program, you can synchronize your Outlook Contacts to Excel by exporting them. Synchronizing your email contacts is essential when you have more than one email account. By exporting the contacts from your Outlook email account, you can add additional entries and share your contacts with your other email accounts and computers.

1

Click the "File" tab and click "Options."

2

Click "Advanced," then click the "Export" button. The "Import and Export Wizard" opens on your screen.

3

Click "Export to File," then click the "Next" button.

4

Click "Comma Separated Values (Windows)," then click "Next."

5

Click "Contacts," then click "Next.

6

Choose a destination folder to save the Excel file and click "OK."

7

Click "OK," then click "Map Custom Fields." The Map Custom Fields dialog box shows which fields Outlook is exporting. Add any additional fields like "Company" or "Address" by dragging and dropping the fields. Click "OK" to proceed.

8

Click the "Finish" button to being the exportation process. Double-click the contacts file to open it in Excel.

About the Author

Angela M. Wheeland specializes in topics related to taxation, technology, gaming and criminal law. She has contributed to several websites and serves as the lead content editor for a construction-related website. Wheeland holds an Associate of Arts in accounting and criminal justice. She has owned and operated her own income tax-preparation business since 2006.