Exporting Exchange public folder contacts to Microsoft Excel

SearchExchange.com expert David Sengupta gives step-by-step instructions on how to export Exchange Server public folder contacts to a Microsoft Excel spreadsheet.

Published: 15 Mar 2006

We have a Windows 2000 server and an Exchange 2000 server. How can we export Exchange public folder contacts to a Microsoft Excel spreadsheet?

VIEW MEMBER FEEDBACK TO THIS ASK THE EXPERT Q&A.

Good question.

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

From within Microsoft Outlook, you'll want to navigate to the Exchange Server public folder that contains the contacts.
Then select File -> Import and Export -> Export to a file -> Next -> Microsoft Excel -> Next -> and then select the appropriate contacts for export.
Select Next once more and give the target file a path and name.
Click Finish and you should be all set with the Excel file you're looking for.

MEMBER FEEDBACK TO THIS ASK THE EXPERT Q&A:

When I select File -> Import and Export -> Export to a file -> Microsoft Excel -> Next, it doesn't allow me to select the contacts for any public folders. It only gives me the option to select contacts from my mailbox.
—Daniel R.

******************************************

I'm sorry, I forgot that the export user interface only lists personal contacts data sources. Unfortunately, that means you'll need to create a temporary folder in your mailbox that contains contact items, drag the public folder contacts into that folder, and then export from there instead.

I hope that helps. Thanks for writing back in.
—David Sengupta, Server Administration Expert

Do you have comments on this Ask the Expert Q&A? Let us know.

Related information from SearchExchange.com:

FAQ: Exchange public folders

Tutorial: Indexing Exchange public folder content

Resource Center: Public folder management tips and resources

Resource Center: Contacts and calendars

Dig Deeper on Exchange Server setup and troubleshooting

Preparing for the inevitable move off Exchange 2010 public folders Even you're even considering migrating public folders off of Exchange Server, pulling data reports will help you understand which folders are most important and which ones are just wasting space.

Centralize Outlook contact lists in an Exchange 2003 public folder Global access lists store contact info for co-workers, but not for anyone outside your organization. Making a public folder an address list keeps external contacts in one location.

ExMerge gotchas to watch for when migrating Exchange 2003 mailboxes When migrating mailboxes in Exchange 2003, ExMerge is a good option because of its flexibility. However, you may encounter a few issues, such as Outlook rules breaking and attachments getting lost during the migration process. In this tip, Microsoft Exchange Server expert Brien Posey explains a few ExMerge gotchas to watch out for and their workarounds.

Importing a public folder contact list into an Exchange 2007 public folder Find out how to troubleshoot importing an Exchange 2003 .PST file containing a public folder contact list into an Exchange 2007 public folder.

Microsoft Outlook .PST file FAQs Troubleshoot Outlook .PST file issues -- from importing and exporting data to .PST file repair and recovery -- with this collection of Outlook .PST FAQs.

Export Exchange public folder calendar to Outlook .PST file Move Exchange Server public folder data, including Exchange public folder calendars, to Microsoft Outlook .PST files with these step-by-step instructions.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our Windows Server experts

View all Windows Server questions and answers

Please create a username to comment.

Understand and deploy IBM Cloud for VMware Solutions

How AppDefense works to detect app and VM anomalies

Import and export Hyper-V VMs with Hyper-V Manager and PowerShell

A primer on Alibaba Cloud for Western enterprises

AWS, Azure and Google peppered with outages in same week

Google to unveil post-Chronicle cloud cybersecurity plans

SQL Server database design best practices and tips for DBAs

SQL Server in Azure database choices and what they offer users

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

Project Limitless' 5G PC and what desktop admins need to know

Jamf Protect offers visibility, protection for macOS admins

Compare Windows 10 OS editions to determine the best fit

Compare offerings from 3 major desktop-as-a-service providers

How to use VMware Horizon Performance Tracker

10 Microsoft Ignite 2019 sessions for VDI admins

Dig Deeper on Exchange Server setup and troubleshooting

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.