How to Export Office 365 Distribution Group Members To CSV?

Himanshu Goyal Himanshu Goyal Updated On - 25 Oct 2019

When organizations decide to migrate from Office 365, they need to consider moving every bit of information from their Office 365 account. Office 365 Groups is one such crucial feature for services like Microsoft Teams. But, extracting information from Office 365 Group is not enough, you’ll also have to retrieve information about Group members and their owners.

For instance, if you’re performing tenant to tenant Office 365 migration, then to provide reports on current Group memberships and update the target groups, you’ll have to export Group membership information. The Group members information is often presented in a CSV file. So, the main concern of organizations is how to export Office 365 Group members to CSV file.

In this article, we will discuss the most effective methods methods to export O365 Group data to a CSV file.

Instant Solution

Download Kernel Office 365 Backup & Restore tool to export Office 365 distribution group member to CSV.

Manual Methods to Export O365 Group Data to CSV

There are two effective manual methods that can be used to export Office 365 Group members to CSV. The first method involves using the Exchange PowerShell Script and cmdlet, and the second method involves using the Exchange Admin Center. So, let’s have a clear look at all these methods.

1st Method – Export Office 365 Group Members Using PowerShell Script

Using PowerShell script is one of the best ways to export Office 365 group members to CSV file. The Exchange Online PowerShell can be used to collect Office 365 Group information, and after accessing the list of groups in your tenant, you can retrieve group members information easily. Here is the script that can be used to export group members information to CSV.

  1. Connect to Exchange Online Remote PowerShell.
  2. Now, use the below command to list all the Office 365 groups in Office 365.
  3. Get-UnifiedGroup -ResultSize Unlimited

  4. After the groups are listed, use the below command to select the members of an existing single Office 365 group with the following parameters – Identity and LinkType.
    Get-UnifiedGroupLinks – Identity’<group-name>’ – LinkType Members – ResultSize Unlimited

    • However, if you want to list the members of all the Office 365 Groups, then first you’ll have to get the results of Get-UnifiedGroup, and then you can get the list of all Office 365 group members. Use the below command to achieve this:
    Groups = Get-UnifiedGroup -ResultSize Unlimited
    $Groups | ForEach-Object {
    $group = $_Get-UnifiedGroupLinks -Identity $group.Name -LinkType Members -ResultSize Unlimited | ForEach-Object {
    New-Object -TypeName PSObject -Property @{
    Group = $group.DisplayName
    Member = $_.Name
    EmailAddress = $_.PrimarySMTPAddress
    RecipientType= $_.RecipientType
    }}}
    
  5. Once you get all the information related to every Office 365 Group member, you can use the Export-CSV cmdlet to export the group members to CSV file. Below is the cmdlet that you’ll have to achieve this.
    $Groups = Get-UnifiedGroup -ResultSize Unlimited
    $Groups | ForEach-Object {
    $group = $_
    Get-UnifiedGroupLinks -Identity $group.Name -LinkType Members -ResultSize Unlimited | ForEach-Object {
    New-Object -TypeName PSObject -Property @{
    Group = $group.DisplayName
    Member = $_.Name
    EmailAddress = $_.PrimarySMTPAddress
    RecipientType= $_.RecipientType
    }}} | Export-CSV "C:\\Office365GroupMembers.csv" -NoTypeInformation -Encoding UTF8
    

Using this script, the list of Office 365 Group members will be exported to CSV file. But, this approach require good knowledge of Exchange PowerShell Scripts, so a normal user cannot perform this method easily.

2nd Method – Export Distribution Group to Using the Exchange Admin Center

Using the Exchange Admin Center, you can export Office 365 Groups to CSV. Now, follow the below steps to export O365 Groups to CSV.

  1. Login to Exchange Admin Centre, you’ll see Recipients in the left pane.
  2. Select Recipients > Groups.
  3. In the Group tab, select the distribution group that you want to export. Click More button and choose Export data to a CSV file.
  4. The Export data window will appear on the screen, select the column name and click Export.

Hence, you can easily export Office 365 Groups to CSV.

These two methods are a great way to export Office Group data to CSV file. However, if you want to export Office 365 user mailboxes, archive mailboxes, and public folders along with Office 365 Group data, then you can use Kernel Office 365 backup & restore tool.

Kernel Office 365 Backup and Restore

Kernel Office 365 Backup & Restore allow users to backup their O365 mailboxes to PST format as well as to restore mailboxes from PST to Office 365. It helps to backup and restore shared mailboxes as well as Office 365 Groups too. It is an amazing tool that offers selective backup of Office 365 mailboxes based on date, mailbox type, item type, etc. Some of the extensive features of Kernel Office 365 Backup & Restore are:

  • Backup multiple mailboxes to PST file format
  • Allow backup of the archive, shared, public folders, and distribution groups
  • Restore Office 365 mailboxes from PST file
  • Use CSV file to add multiple mailboxes
  • Back up shared mailboxes, Office 365 Groups, etc.
  • Advanced filtering options to backup & restore specific data
Conclusion

When you’re performing tenant to tenant or any other Office 365 migration from Office 365, it’s necessary to export the Office 365 group data as well. But, the process to export Group members is very challenging. So, in this article, we have covered the effective approaches to export Office 365 data.