How to export Office 365 group members using PowerShell

The following is a comparison between exporting Office 365 group members with Windows PowerShell and ADManager Plus:

Windows PowerShell

Steps to get a list of Office 365 group members using PowerShell:

  • Identify the Office 365 tenant from which you want to retrieve the report.
  • Identify the PowerShell cmdlet you need to fetch the report.
  • Compile the script.
  • Execute it in Windows PowerShell.
  • The report will be exported in the given format.
  • To obtain the report in a different format, modify the script according to the needs of the user.

Sample Windows PowerShell script:

Get-UnifiedGroup -ResultSize Unlimited | Select DisplayName,GroupType,PrimarySmtpAddress
Click to copy entire script

ADManager Plus

Steps to get the report using ADManager Plus:

  • Click Office 365 -> Group Reports -> Group Members.
  • Select the desired Office 365 account and groups.
  • Click Generate and export the report in any of the preferred formats.


export list office 365 group members using ADManager Plus

» Start 30-day Free Trial

Following are the limitations to obtain Office 365 groups members using native tools like Windows PowerShell:

  • Adding even minor details to the report—such as adding additional attributes—require scripts to be modified and executed again, which is time consuming.
  • Exporting a report in a specific format requires a script to be modified accordingly, which increases the complexity of the scripts.
  • Troubleshooting is not easy in case of errors.

ADManager Plus can retrieve Office 365 group members list in CSV, PDF, HTML, or XLSX format in a simple and intuitively designed UI.

Find information on all Office 365 groups from preconfigured reports.

  Get 30-day free trial.
  • Embark on your script-free AD management, reporting, and automation journey with ADManager Plus.
  • By clicking 'Start your free trial now', you agree to processing of personal data according to the Privacy Policy.
  • Thanks
  • Your download should begin automatically in 15 seconds. If not, click here to download manually.

Related Powershell How-to Guides:

The one-stop solution toActive Directory Management and Reporting

Email Download Link