In Exchange EDB file format used to store Exchange mailboxes, details but few scenarios arise when a user does not need to export complete mailbox details but just want to save the mailboxes details such as user exchange mailboxes detail such as usernames, email address, department into text file format. In Exchange, all these information of mailboxes exported into CSV file format offered to save details.

When Thousands of employees are working in our Organization and as an admin to manage to check the details of my Exchange mailboxes user can become a hard task. Since various scenarios occur when Admin need to inspect the current mailbox size & other detailed, even need to save for document purposes. Since This situation can be handled via CSV file format, used to store all Exchange Mailboxes email, contacts details. Alternatively, Exchange Admin Centre in 2016/2013 is available and for Exchange 2010/2007, Exchange Management Console used.

Since a CSV File similar to a text file but each entity separated to each other via Comma (‘) character. This file easily converted into Excel file format for easy understand via naive or Expert Exchange user.

Note: If any User wants to Export Exchange Mailbox to PST file format, they can also go SysTools Exchange Export, not need any kind of Powershell shell Commands, just provide the Administrator Credentials to Access Mailbox.

This section deal with the situation where Admin wants to export Exchange mailboxes list to CSV format and easy commands are used for this purpose to solve issues.

Export Exchange Mailboxes List to CSV Format

Since Expert Administrator goes for Powershell command to export all user mailbox details such as First Name, Last Name, Department, SMTP Address information to save into CSV format, for that they follow below procedure:

Open Exchange Management Shell (on-premises Exchange).

  • Case 1: To acquire the list of complete mailboxes of your Exchange Server, run the following cmdlet:
  • $mailboxes = Get-Mailbox -resultSize unlimited
  • Case 2: Now to Export all details of Exchange user into CSV file via Powershell.Command: $mailboxes | foreach { Get-User $_ | select FirstName, LastName, DisplayName, WindowsEmailAddress } | export-csv -NoTypeInformation .\Mailboxes.csv -Delimiter “;” -Encoding unicode
  • Case 3: To View Only Exchange Mailbox DetailsCommand: Get-MailboxStatistics -Server dc | Select Displayname,TotalItemSize,ItemCount|Export-csv c:\csv\mailboxdetails.csv
  • Case 4: To view Only Email Address with Distribution Group DetailsCommand: Get-Recipient| select name -ExpandProperty emailaddresses | select name,smtpaddress |Export-csv c:\csv\mailboxdetails.csv
  • Case5: To Save Only Email Address from Distribution Group Details into CSV file format.Command: Get-DistributionGroup -Identity <“DistributionGroup Name”| Get-DistributionGroupMember | select name,primarysmtpaddress >C:\Powershell-Exports\distributiongroup.csv 

Export Exchange Mailbox List to CSV by Exchange Admin Center

  • To begin the procedure, the first login to Exchange Admin Center.

  • Select the recipients from features section then, you will get a list of all user mailboxes on the Exchange Server

  • Now, to export this list as a CSV, click on 3 verticle dots icon/ellipsis. From the drop-down menu list, choose Export data to a CSV file format.

  • In Export Data window, select the Desired data to export.

  • Eventually, hit the Export button and just after that a CSV file will start downloading on your system.

Final Observation

Now to Export Exchange mailboxes to CSV file now become very easy, just follow the above procedure. Even you can convert CSV File into Excel File as it becomes easy to understand all details perfectly. Depond which method (Powershell, Exchange Management Console, Exchange Admin Center ) selected via Exchange Administrator.