Ask the Expert

Exporting Exchange public folder contacts to Microsoft Excel

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

    Requires Free Membership to View


Good question.

  1. From within Microsoft Outlook, you'll want to navigate to the Exchange Server public folder that contains the contacts.

  2. Then select File -> Import and Export -> Export to a file -> Next -> Microsoft Excel -> Next -> and then select the appropriate contacts for export.

  3. Select Next once more and give the target file a path and name.

  4. Click Finish and you should be all set with the Excel file you're looking for.


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

  • FAQ: Exchange public folders
  • Tutorial: Indexing Exchange public folder content
  • Resource Center: Public folder management tips and resources
  • Resource Center: Contacts and calendars
  • This was first published in March 2006

    There are Comments. Add yours.

    TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

    REGISTER or login:

    Forgot Password?
    By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
    Sort by: OldestNewest

    Forgot Password?

    No problem! Submit your e-mail address below. We'll send you an email containing your password.

    Your password has been sent to: