Permission & Access Issues

How to Export SharePoint Groups and Members for Sites and Folders

Amos GikundaAmos Gikunda Nov 3, 2026 870 views

Question details

Administrators need to export SharePoint group membership and permissions for sites and folders, but SharePoint Online lacks a native bulk export feature.

Export SharePoint Groups and Members for Sites and Folders
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.
Before you start

Ensure you have Site Owner or SharePoint Administrator privileges for the target sites before attempting to extract group membership and permission data.

Solution 1Recommended

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.

1
Open your Spreadsheet Application

Launch Microsoft Excel (or a compatible spreadsheet tool that supports OData). Go to the 'Data' tab on the ribbon.

2
Connect to the OData Feed

Click on 'Get Data' > 'From Other Sources' > 'From OData Feed'.

3
Enter the SharePoint API URL

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.

4
Authenticate your Account

When prompted for credentials, select 'Organizational account' from the left sidebar and click 'Sign In'. Enter your Microsoft 365 admin credentials.

5
Load the Data

Once authenticated, click 'Connect' and then 'Load' to import the SharePoint group data directly into your worksheet.

Export Groups for a Single Site Using an OData Feed
Organizational Account Required: You must authenticate using an organizational account. Choosing 'Anonymous' or 'Windows' authentication will result in an access denied error.
Free Microsoft Office alternative

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. 1. Download and Install WPS Office: Get the free WPS Office suite from the official website and install it on your device.
  2. 2. Open your Exported CSV: Launch WPS Spreadsheets and open the CSV file generated by your PowerShell script or OData export.
  3. 3. Analyze and Filter Data: Use WPS Spreadsheets' built-in data filtering, sorting, and pivot table features to audit your SharePoint groups effectively.
100% compatible with Microsoft Excel formats (.xlsx, .csv) for seamless report viewingLightweight design ensures fast loading of massive permission audit logsFamiliar spreadsheet interface means zero learning curve for administratorsFree to use with comprehensive data filtering and pivot table tools
microsoft office alternative - wps office

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.