[Solved] How to Export Outlook Contacts to Excel on Windows and Mac

Microsoft Outlook (formerly Hotmail) is a de facto email client used at many offices. Outlook.com is an email service used by numerous people. In this article, we will learn four ways of exporting Outlook contacts to Excel, covering both the email client and email service.

 Cisdem ContactsMate

Best Tool to Export Outlook Contacts to Excel

• Import contacts from CSV and vCard
• Export contacts to Excel, CSV, vCard, etc.
• Sync contacts from Outlook, iCloud, Mac Address Book, etc.
• Correct formatting errors, dedupe & merge contacts
• Easily filter the contacts & assign multiple tags to each contact
• Edit & add details for each contact, including birthday, job title, etc.
• Feel free to add new groups to manage contacts

Free Download macOS 10.11 or later Free Download Windows 10 or later

How to Export Outlook Contacts to Excel on Windows?

You may export your Outlook contacts to an Excel file to keep a backup or to import them to a certain service or app. Regardless of the purpose, Windows users can follow the steps in this part.

Export contacts from Outlook.com to Excel on PC

ContactsMate is a contacts management app for Windows. It's compatible with Windows 10 or later. With this tool, you can easily export contacts from Outlook.com to Excel, or other popular formats. It also offers some useful features to help you organize all contacts in one place. Such as merge duplicate contacts, teansfer contacts from Outlook to Gmail, etc.

1. Download and install ContactsMate on your PC.

Free Download Windows 10 or later

2. Open it. Click Add Account. Enter your Outlook email address and password. Allow it to access your contacts. Click Continue.

3. Go back to ContactsMate. You'll find your Outlook account in the sidebar. Click it.

4. Click the Manage contacts button. Select Export contacts.

5. Select XLSX as export format. Click Export. 

Now the Outlook contacts file are saved on your PC.

Export Contacts Outlook 2010 to Excel

1. Launch Microsoft Outlook 2010 on Windows.
2. Navigate to the File menu > Open > Import. Alternatively, you can Choose File Options > Advanced > Export. Both of them will take you to the “Import and Export Wizard” window.
3. Select “Export to a file” option in the following window, and press Next.
4. Choose “Microsoft Excel 91- 2003”, and click on Next.
5. In the next window, choose Contacts and go on.
6. In the next moment, select Browser.
7. Choose the destination to export, and then type the file name for your contacts file, and then press Next.
8. Now you can click on Finish button to complete the export. All your Outlook contacts will be saved as Excel.

What I want to emphasize is that all the fields of your Outlook contacts will export to Excel through this way, such as Car Phone, Government ID number. Even if your Outlook contacts didn’t add such contents, the Excel spreadsheet will also display lots of empty columns as instead.

It is not a great way to delete superfluous contacts fields in the Excel spreadsheet after export, as sometimes we may delete the important information by mistake.

Thus, you can click the "Map Custom Fields" button and go to clear all unnecessary fields before step 8 is executed.

Export Contacts Outlook 2013 & 2016 to Excel

1. Open the Microsoft Outlook 2013 or 2016 on your Windows PC
2. Click on People in the bottom column, and then you will be able to access your Outlook contacts.
3. To change your view to a table view, go to the View menu. In Current View menu group, click on Change View > Phone option.
4. Click on View Settings, choose Columns under “Advanced View Settings: Phone” window. And select available fields from the drop down list. In this step, you can remove or add fields you would like to export. Once finished, click OK and then click OK button again.
5. Press Ctrl + A key to select all of your Outlook contacts. Copy the same contacts you just selected.
6. Launch Excel on your Windows, and the paste all your copied Outlook contacts, and save them as Excel .xlsx format.

Can We Export Outlook Contacts to Excel on Mac?

The answer is yes. And below you can find step-by-step instructions.

Export contacts from Outlook.com to Excel on Mac

Cisdem ContactsMate is an awesome app to export Outlook (any version) contacts to Excel, TXT, CSV, VCF, Word, HTML, Numbers and Pages.

The software empowers you to keep contacts updated from various personal accounts, like Outlook, LinkedIn, Gmail, Facebook, etc. Also, it will update the contact details of the accounts along with addresses, phone numbers, profile photos and more.

Free Download

Unlike Windows, Outlook for Mac only supports exporting Outlook contacts to .txt and import them into excel for handling. If you need complete the whole process once for all, a third-party contacts management tool would address your issue thoroughly.

Export Contacts Outlook 2011 to Excel

One. Export from Outlook for Mac

1. Open Outlook 2011 for Mac.
2. Click on Contacts at the lower left corner.
3. Go to File menu > Export.
4. A small window pops up. You should choose the first option- “Contacts to a list (tab-delimited text)”. Then press the right arrow to continue.
5. A Save box appears. Create a name for your file and select a path to save.
6. Export your Outlook contacts to .txt on Mac.
7. Click the Done button.

Two. Import to Excel

1. Launch Microsoft Excel app on Mac.
2. Go to File menu > Open.
3. An open box shows up. You should pick “All Readable Documents” option from Enable drop down list.
4. Find and click the .txt contacts file you exported from Outlook, and try to open it in Excel.
5. You will get the “Text Import Wizard” window. Choose Delimited as the file type > click Finish > your contacts open up automatically in Excel.
6. To export Outlook contacts to excel format, go to File menu > Save As > choose Excel Workbook under Format.

Conclusion

4 workable solutions of exporting Outlook contacts to Excel have been introduced step by step above. You see, it is simple to export Outlook contacts to Excel on Windows. As for Mac, if you’re searching for a long-term way to export, import, sync, edit, tag, share and update your contacts across all your email or social media accounts, take a look at the Cisdem ContactsMate.