How to Export SharePoint Groups and Members for Sites and Folders
Question details
Administrators need to export SharePoint group membership and permissions for sites and folders, but SharePoint Online lacks a native bulk export feature.

- Product
- SharePoint Online
- Device & OS
- not provided
- Scenario
- Auditing access controls, reviewing security policies, or migrating permission structures across various SharePoint sites and folders.
- Observed behavior
- Users cannot find a built-in tool or one-click option in the SharePoint Online interface to extract all group and member permissions across multiple sites or specific folders.
Ensure you have Site Owner or SharePoint Administrator privileges for the target sites before attempting to extract group membership and permission data.
Export Groups for a Single Site Using an OData Feed
Use the built-in OData feed connector in Excel or Power BI to extract user and group data for a specific SharePoint site.
While SharePoint doesn't have a direct 'Export' button for permissions, you can leverage its REST API via OData feeds. This method is highly effective for auditing a single site's group memberships directly into a spreadsheet.
Launch Microsoft Excel (or a compatible spreadsheet tool that supports OData). Go to the 'Data' tab on the ribbon.
Click on 'Get Data' > 'From Other Sources' > 'From OData Feed'.
In the URL box, enter your site's API endpoint in this format: https://[yourtenant].sharepoint.com/sites/[yoursite]/_api/web/sitegroups and click OK.
When prompted for credentials, select 'Organizational account' from the left sidebar and click 'Sign In'. Enter your Microsoft 365 admin credentials.
Once authenticated, click 'Connect' and then 'Load' to import the SharePoint group data directly into your worksheet.

Automate Bulk Export for Multiple Sites Using PowerShell
For multiple sites or granular folder permissions, utilize PnP PowerShell scripts to automate the extraction across your SharePoint environment.
Analyze Your Exported SharePoint Data with WPS Office
While extracting SharePoint permissions requires Microsoft tools or PowerShell, analyzing the resulting CSV or Excel reports shouldn't tie you to an expensive subscription. WPS Office offers a free, lightweight alternative with full Microsoft Excel compatibility to seamlessly review your data.
- 1. Download and Install WPS Office: Get the free WPS Office suite from the official website and install it on your device.
- 2. Open your Exported CSV: Launch WPS Spreadsheets and open the CSV file generated by your PowerShell script or OData export.
- 3. Analyze and Filter Data: Use WPS Spreadsheets' built-in data filtering, sorting, and pivot table features to audit your SharePoint groups effectively.

Frequently Asked Questions
Can I export permissions for a specific SharePoint folder directly from the web interface?
No, SharePoint Online does not offer a native 'Export' button for folder-level permissions in the web UI. You must use PowerShell scripts or third-party administration tools to extract folder-specific access logs.
Why do I get an 'Access Denied' error when connecting to the OData feed?
This usually happens if you attempt to sign in with 'Anonymous' or 'Windows' credentials instead of selecting 'Organizational account'. It can also occur if your account lacks Site Owner or Administrator permissions for the target site.
Is there a built-in report in the SharePoint Admin Center for group memberships?
Currently, the SharePoint Online Admin Center does not provide a one-click, comprehensive report that exports all site and folder group memberships across your entire tenant. Scripting or external reporting tools are required.
What formats can PowerShell export SharePoint group data into?
PowerShell can easily export SharePoint group, member, and permission data into standard formats like CSV, XML, or JSON, which can then be opened and analyzed in any standard spreadsheet application.




