Export Microsoft 365 Group Owners and Members to CSV - WPS Office
Question details
The user needs to export all Microsoft 365 groups, members, and owners to a CSV file because a standard PowerShell script returns members but omits group owners.
- Product
- Microsoft 365 Groups and PowerShell
- Device & OS
- not provided
- Scenario
- Administrative reporting or auditing of Microsoft 365 group membership and ownership.
- Observed behavior
- The current PowerShell script returns group members but omits owners, so the CSV file is incomplete for auditing or reporting.
Before running any script, confirm that the Microsoft Graph PowerShell SDK or Exchange Online PowerShell module is installed and that your admin account has read permissions for Microsoft 365 groups. Also plan your CSV columns so owner and member fields are captured separately for each group.
Export Both Microsoft 365 Group Owners and Members with a PowerShell Script
Use this approach when your standard PowerShell script returns members but leaves owner columns blank; it retrieves both owner and member relationships before exporting to CSV.
The script must query both the members and owners relationship for each Microsoft 365 group. Community scripts can serve as a starting point, but you may need to adjust them for your tenant and CSV layout.
Open Windows PowerShell or PowerShell 7 as administrator, or start an automation host that has access to your Microsoft 365 tenant.
Run Install-Module Microsoft.Graph -Scope CurrentUser or Import-Module Microsoft.Graph, then connect with Connect-MgGraph -Scopes Group.Read.All.
Adapt the community script so it expands both members and owners for each Microsoft 365 group, and stores owner names or email addresses in separate columns.
Pipe the output to Export-Csv -Path M365GroupsOwnersMembers.csv -NoTypeInformation, then open the CSV in Excel or WPS Office Spreadsheets.
Use WPS Office as a Free, Lightweight Alternative for Excel and CSV Reporting
WPS Office cannot query Microsoft 365 group directories, but it is a free, lightweight Microsoft Office alternative for opening, editing, and sharing exported Excel and CSV files. It provides high compatibility with Microsoft 365 formats, a familiar ribbon interface, and seamless everyday migration.
- 1. Download and install WPS Office: Go to the official WPS Office website and click Download WPS Office Free, then install it on your Windows or macOS computer.
- 2. Open an exported Excel or CSV file: Launch WPS Office, click Menu > Open, and select the CSV or XLSX file you exported from PowerShell or Microsoft 365.
- 3. Review and format the exported data: Use WPS Spreadsheets to filter rows, sort columns, and confirm that owner and member fields are correct.
- 4. Save or share the workbook: Click Menu > Save As to keep the file in .xlsx or .csv format, or share it with your team.
Frequently Asked Questions
Why does my PowerShell script export members but not group owners?
Many sample scripts only expand group members. You need to explicitly query the owners relationship for each group and include owner names or email addresses in the CSV output.
Do I need admin rights to export Microsoft 365 group owners and members?
Yes. The account running the script needs at least read permission for Microsoft 365 groups, such as Group.Read.All in Microsoft Graph, and may require admin consent in some tenants.
Can I export Microsoft 365 group owners and members from the admin center instead of PowerShell?
The Microsoft 365 admin center lets you view groups individually, but exporting all groups, members, and owners to CSV usually requires PowerShell, Microsoft Graph, or another automation tool.
Can WPS Office export Microsoft 365 group owners and members?
No. WPS Office is a spreadsheet and office suite and cannot query Microsoft 365 group directory data. Use PowerShell or Microsoft Graph to create the CSV, then open or edit that CSV in WPS Office Spreadsheets.
