Affiliate Disclosure: Some links mentioned below are affiliate links, we may earn some amount if you make a purchase.
While migrating from One Office 365 to another Office 365 platform, organizations make sure that each and every information is transferred. Individuals working in Microsoft Teams have important Office 365 Group Members features. When these groups are transferred it is necessary to transfer the related information too. Users can export the office 365 distribution groups to CSV files using Powershell and Exchange Admin Center.
In addition to Distribution group migration, the information of members, their ownership details, and other particulars are needed to be transported. So, if moving from Office 365 then remember to migrate the Office 365 Distribution Group Members Information. As to provide reports it is presented in the CSV file. Here we will know the steps to convert the Office 365 Distribution Group Members to the CSV file.
Third-Party Options
There are two free methods by which the Office 365 Distribution Group Members can be converted to CSV file i.e. PowerShell commands and Exchange Admin Center. As dealing with PowerShell is somewhat technical we will go with the Exchange Admin Center.
Export Office 365 Distribution List Members to CSV
This is like a select and clicks method, unlike the PowerShell which involves commands, however, to use this feature user must have Administrative rights
- Open the Exchange Admin Center and log in with admin username and password
- On the left-hand side of the dashboard, you will see Recipients
- Now, click on the Recipients and then Groups
- From the Group tab select the distribution group which is to be exported
- Click on the More option and select ‘Export Data to CSV File’
- You will see the Export Data Window
- Select the column name of Office 365 Group members and click ‘Export’
- The data will be exported to CSV format.
This is the easiest method to export the Office 365 Distribution list, another method is by using PowerShell script.
Using PowerShell to Export Office 365 Group Members
- PowerShell Script is an efficient method to move group members to CSV file
- Connect to Exchange Online Remote PowerShell
- Now, check the list of Office 365 Groups in Office 365 by the following command
Get-UnifiedGroup -ResultSize Unlimited
- Now use the –Identity and LinkType parameters to select the members from the Office 365 Distribution list
Get-UnifiedGroupLinks – Identity’>group-name<’ – LinkType Members – ResultSize Unlimited
- To select all the members first select a unified group and then get the members’ details of that group in Office 365. Use the given PowerShell Script to get the result
$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
}}}
- As the list of the Office 365 Group members is available export it to CSV by the following method
$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 the PowerShell scripts the data will export in CSV format. However one needs to have technical knowledge of Exchange Server. To ease the process Kernel Import PST to Office 365 tool gives the option to save recovered file in multiple options. In this way, while exporting Office 365 select ‘CSV’ option and save it at the desired location.
Download Office 365 Backup and Restore 