How to Export Exchange Mailbox to CSV? (Complete 2026 Guide)

To export Exchange mailbox to CSV, use the Exchange Admin Center (EAC) for basic lists and PowerShell or a specialized tool for detailed IT reports.

1. Method 1: Fastest & Easiest: You can use RecoveryTools Exchange to CSV Export tool to avoid coding and easily export Exchange mailbox to CSV without the need to write any PowerShell scripting. You can convert Exchange mailbox, Exchange mailbox size, email addresses, contacts, and Exchange distribution group members to CSV in just a few clicks.
2. Method 2: Use PowerShell Commands: If you’re familiar with coding, then open the Exchange Management Shell and run this quick PowerShell script, as needed:
   • Basic Mailbox List: Export Exchange mailbox to CSV with names and emails:

     Get-Mailbox -ResultSize Unlimited | Select-Object DisplayName, PrimarySmtpAddress | Export-CSV "C:\output\mailboxes.CSV" -NoTypeInformation -Encoding UTF8

   • Storage Check: To export Exchange mailbox size to CSV to check how full accounts are:

     Get-Mailbox -ResultSize Unlimited | Get-MailboxStatistics | Select-Object DisplayName, TotalItemSize | Export-CSV "C:\output\mailbox-sizes.CSV" -NoTypeInformation -Encoding UTF8

   • Contact List: To export Exchange contacts to CSV to see external users:

     Get-MailContact -ResultSize Unlimited | Select-Object DisplayName, ExternalEmailAddress | Export-CSV "C:\output\Exchange-contacts.CSV" -NoTypeInformation -Encoding UTF8

   • Team Lists: To export Exchange group members to CSV or export Exchange distribution group members to CSV (just change “SalesTeam” to your group’s name):

     Get-DistributionGroupMember -Identity "SalesTeam" -ResultSize Unlimited | Select-Object DisplayName, PrimarySmtpAddress | Export-CSV "C:\output\group-members.CSV" -NoTypeInformation -Encoding UTF8

3. Method 3: Use the Exchange Admin Center (EAC): To create a simple list without PowerShell, log into the EAC and navigate to Recipients > Mailboxes > Click the … (More actions) button > Choose Export to .CSV.

This article will provide you with step-by-step instructions to export Exchange mailbox to CSV. We will discuss how to convert Exchange mailboxes, mailbox size, contacts, and Exchange groups, as well as export Exchange distribution group members to CSV. Although you can use PowerShell scripts manually, you’ll also learn that it’s best to use the dedicated tool to make the task a lot easier.

Why Export Exchange Mailbox to CSV?

There are many valuable reasons as to why administrators must convert Exchange mailboxes to CSV:

• User-Friendly Format: CSV files open easily in Microsoft Excel, which makes it easy to search and manipulate the data.
• Monitor Storage Space: You can easily track which users are consuming too much space and approaching their limits.
• Team Management: It becomes easy to understand who belongs to what distribution group or department.
• Migration Preparation: Users may want to export Exchange distribution group members to CSV when they are migrating to another server or Microsoft 365.
• Audit Security: CSV files are easy to use, as it allows only the permitted and authorized individuals retain access.

How to Convert Exchange Mailbox to CSV? Step-By-Step Instructions

Follow the steps mentioned below to import Exchange Mailboxes, mailbox size, contacts, email addresses, and group members into CSV:

Method 1: Use RecoveryTools Exchange to CSV Export Tool

Writing PowerShell scripts is complicated and limited to simple text lists. PowerShell is not sufficient to export actual emails, folders, and attachments.

The best and easiest option for performing this task is to use the RecoveryTools Exchange Migration Tool.

Why is this tool better than PowerShell?

• No need for PowerShell: The tool comes with an easy-to-navigate GUI, which means that you do not need to enter complex PowerShell commands to operate the tool.
• All-in-One CSV Reports: One feature of this tool is that you can easily convert Exchange mailbox size, Exchange contacts, Exchange group members, and Exchange distribution group members into CSV without much effort.
• Export Real Emails: While PowerShell generates a simple list only, the tool connects to your server to convert real emails, calendars, and contacts in CSV, PST, PDF, and other formats.
• Work with Multiple Users Simultaneously: By loading multiple user accounts into the tool, you will save hours of work.
• User-Friendly Filters: The program offers user-friendly filters allowing you to get exactly needed information without any additional configuration.

Detailed PowerShell Steps (Alternative Method)

You should consider the following scripting options if you want to export Exchange Mailbox to CSV using scripts.

1. How to Export Exchange Mailbox Size to CSV

It is crucial to understand whether the users have enough space. A PowerShell command will export Exchange mailbox size to a CSV so its output will contain the exact count of items and size.

Get-Mailbox -ResultSize Unlimited | Get-MailboxStatistics | Select-Object DisplayName, ItemCount, TotalItemSize, Database | Export-CSV "C:\output\DetailedMailboxSizes.CSV" -NoTypeInformation -Encoding UTF8

2. How to Export Exchange Contacts to CSV

When your system has been properly maintained, you can run a PowerShell command to export exchange contacts to CSV so that you have all external addresses and names in your directory.

Get-MailContact -ResultSize Unlimited | Select-Object Name, DisplayName, Alias, ExternalEmailAddress | Export-CSV "C:\output\DetailedExchangeContacts.CSV" -NoTypeInformation -Encoding UTF8

3. How to Export Exchange Distribution Group Members to CSV

Sometimes your boss may request that you run the process of exporting members of groups in Exchange or exporting distribution group members to the CSV format. However, in this case, a simple command cannot be used. You have to make use of a special loop-based PowerShell script.

$Groups = Get-DistributionGroup -ResultSize Unlimited
$GroupMembers = foreach ($Group in $Groups) {
    Get-DistributionGroupMember -Identity $Group.Identity -ResultSize Unlimited | Select-Object @{Name="GroupName";Expression={$Group.DisplayName}}, DisplayName, PrimarySmtpAddress, RecipientType
}
$GroupMembers | Export-CSV "C:\output\AllDistributionGroupMembers.CSV" -NoTypeInformation -Encoding UTF8

The script will add the “GroupName” column to your CSV file, which will allow you to sort the result in Excel easily.

Final Thoughts

It is crucial to write effective directory reports in the IT world. Even if it is possible to export Exchange mailbox to CSV manually using PowerShell or using loops to generate membership lists of distribution groups, doing these tasks manually consumes a lot of time. Therefore, it is recommended to use software like RecoveryTools Exchange to CSV export tool to convert Exchange mailbox data to a CSV file faster and without any possible mistakes.