Avatar of jrmvt
jrmvt asked on

How to get Exchange Public Folder Contacts to CSV or XLSX File

I have many contacts in an Exchange (Online) Public Folder.  I would like to get these out to a CSV or XLSX file in order to import them into Constant Contact.  Outlook 365 only gives me the option of exporting the contents of a Public Folder to a PST file.  So I have questions:

1) Is there some way to easily export the Public Folder to a CSV through Exchange instead of through Outlook?  So far I have had no luck finding one.

2) Could I Export the Contacts in the Public Folder to a PST file, then Import that file into a subfolder in the Contacts of my personal Profile, and then Export that subfolder to a CSV file from there?

3) Any other solution I'm not thinking of?

4) If none of these will work, is there a third party app that anyone has had success with and would recommend?
ExchangeConstant ContactOutlook

Avatar of undefined
Last Comment

8/22/2022 - Mon
Scott Fell

Are you trying to do this for yourself or domain/company wide?

I'm not sure I understand the question.  It is just the one Public Folder that I need to get out to the CSV or XLSX if that is what you are asking.  I don't need to do it for every user on the network or anything like that.  Just a one time export.


Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Scott Fell

When you said, "Exchange (Online) "  I am assuming office365.  Since this is one user, going to outlook.com (or offic.eom and going to the Outlook web app) and exporting your contacts will be the easiest route.

Once in outlook web app, click on contacts and at the top right there is a, "Manage" link. Clicking on that will expose an Export option.

All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck

Copying to my personal Contacts folder and then exporting worked perfect!  Thanks!

Scott - I tried your solution through Outlook.com first as I thought it might be easier.  I got the Public Folder to show up by making it a Favorite, but the Export process would still only export the contacts in my personal contact list.  It would not give me the option to export from the Favorited Public Folder.  Worth a shot though - thanks for helping!