How do I export an Outlook for Mac Contact List to a CSV file that can be imported into Excel for Mac?

Currently, the only export option available at this time is the .olm archive file in Outlook for Mac. See Export items to an archive file in Outlook for Mac

Hello,

Were you able to get this resolved? I am having the same issue. Any help you can provide is appreciated. Thanks.

Any other thoughts on how to solve this? Frankly I am dumbfounded that this is such a hard thing to do, given the integration of Microsoft Office products and the maturity of them on the Mac platform. Hoping that you have some other ideas or someone else in the community has a solution. Thank you!

Hello, thanks for your help. I am using Outlook for Mac 16.68 and I am running it on Office 365 with an Exchange server. I am using Excel for Mac v 16.68 as well. My Mac OS is 12.6.1

I don't want to archive my contacts. I just want to extract 121 names and emails as a Contact List from my overall contacts so I can load them into another application as a CSV file.

So I created the Contact List, highlighted the names in it and exported it to my desktop. However, when I tried to use the Open function in Excel, there was no option for All Readable Documents and the .olm archive file is greyed out.

What do you suggest next?

Thanks for your help.

Hello andrewrowe1362,

Good day!

Thank you for posting to Microsoft Community. We are happy to help you.

Before we proceed, I would require more information to assist you accurately.

1. What is the type of account? Is it a POP, IMAP, Exchange account?

2. May i know your outlook for Mac version?

3.Did you try those steps via this KB How to export contacts via OWA - Outlook | Microsoft Learn

4.Did you try to export contacts from Outlook for Mac to Excel, you need to perform a two-step process.

First, you need to extract Mac Outlook contacts in OLM file and then export it into CSV file format to access in Excel. (Convert OLM to csv)

Or i don't know your version but base on my test version you can do below steps:

Part 1: Export from Outlook for Mac

1. Open Outlook for Mac and click on Contacts.
2. From the File menu, choose Export.
3. A box pops up, asking you “What do you want to export?” Choose “Contacts to a list (tab-delimited text).” Then click the right arrow at the bottom.
4. A Save box appears. In the “Save As” field, put the name you want to give your file. Make sure the “.txt” extension is at the end of your file name. Under “Where” choose your desktop. Then click the Save button.
5. Outlook then exports your contacts. When the export is complete, click the Done button.

Part 2: Import to Excel

1. Open Excel.
2. From the File menu, choose Open…
3. When the Open box appears, go to the bottom of the box and under “Enable” make sure it’s set to “All Readable Documents.” then in the top part of the window, find the .txt file you exported from Outlook to your desktop, and choose it. Then click the Open button.
4. The Text Import Wizard opens up. Choose Delimited and click Finish. Your contacts open up in an Excel spreadsheet.
5. Save it as Excel by going to the File menu and choosing Save As; under Format choose Excel Workbook.

In the meantime, we have our outlook for Mac support team you can also raise support to them and It will be best if you reach out to them so you can be assisted accurately. Please check this link to see how to reach them https://support.microsoft.com/en-us/office/contact-support-within-outlook-for-mac-d0410177-8e65-4487-93f7-206a3a3d71a8 

For other concerns, please do not hesitate to add you post in the Microsoft Community Team.

Thank you for choosing Microsoft as your partner in business.

Appreciate your patience and understanding and thank you for your time and cooperation.

Sincerely,

Eben Ezer Tres | Microsoft Community Moderator