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 to export O365 Group members to the CSV file.

Manual Methods to Export O365 Group Members 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.

1^st Method – 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.

Get-UnifiedGroup -ResultSize Unlimited

3. 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
  }}}

4. 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.

But, don’t worry!

We have an alternative option for this approach – using the Exchange Admin Center.

2^nd Method – Using the Exchange Admin Center

If you want to avoid the hassle of using PowerShell Script, then using the Exchange Admin Center is a simpler approach to export Office 365 Distribution list to CSV. But, there is one condition – you can only perform this process if you have administrative privileges. Now, follow the below steps to export distribution lists from 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 the distribution list from Office 365 Groups to CSV.

These two methods are a great way to export Office group members and distribution lists to CSV file. However, if you want to export Office 365 user mailboxes to CSV format, 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. While performing the PST to Office 365 restore, you can save the mailbox reports to CSV format. 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
• 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 members 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 Groups members to CSV.