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?Thanks!
Scott Fell
Are you trying to do this for yourself or domain/company wide?
ASKER
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
ASKER
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!
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!