How To

Easy Method to Export Office 365 Distribution Group Members to CSV File

While migrating from One Office 365 to other Office 365 platform, organizations make sure that each and every information is transferred. Individuals working in Microsoft Teams have an important Office 365 Group Members features. When these groups are transferred it is necessary to transfer the related information too. User can export the office 365 distribution groups to CSV file 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 CSV file. Here we will know steps to convert the Office 365 Distribution Group Members to CSV file.

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 a like a select and click 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 dashboard, you will see Recipients
  • Now, click on the Recipients and then Groups
  • From the Group tab select 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.

office 365 export distribution list members

This is the easiest method to export 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 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 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 need to have technical knowledge of Exchange Server. To ease the process Kernel Office 365 to PST or 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 desired location.

Leave a Reply

Your email address will not be published. Required fields are marked *