How to Create a SharePoint Permissions Report for Files and Folders
Question details
The user needs to generate a single SharePoint report that lists every file and folder in a document library together with users, groups, inherited permission status, and permission levels.

- Product
- Microsoft SharePoint Online document libraries
- Device & OS
- not provided
- Scenario
- The user manages a SharePoint document library and needs an audit-style permissions report for files and folders.
- Observed behavior
- SharePoint does not provide one standard report containing every file, folder, user or group, inherited-permission status, and permission level. Built-in sharing reports may only show external sharing.
Confirm you have SharePoint Online admin or site collection admin access and install the SharePoint Online Management Shell or PnP PowerShell module before running any reporting script.
Use PowerShell with PnP to Enumerate SharePoint Permissions
Choose this solution when you need a complete, exportable permissions report that includes files, folders, users, groups, permission levels, and inheritance.
A PnP PowerShell script can enumerate lists, folders, and files and then read role assignments and unique permission settings. This is the most flexible way to create a report that matches the exact file and folder permission requirements.
Open Windows PowerShell or PowerShell 7 as administrator and run Install-Module PnP.PowerShell -Scope CurrentUser -Force.
Run Connect-PnPOnline -Url https://yourtenant.sharepoint.com/sites/yoursite -Interactive and sign in with an account that has site admin access.
Run a PnP script that iterates through the document library, folders, and files and reads role assignments, users, groups, permission levels, and HasUniqueRoleAssignments.
Export the results to CSV or Excel with Export-Csv or Export-Excel, then open the file in WPS Office Spreadsheets to filter unique permissions and internal or external accounts.

Use the SharePoint Site Usage Sharing Report
Use this built-in report when you only need a quick overview of external sharing instead of a full file and folder permission audit.
Use a Third-Party SharePoint Reporting Tool
Choose a tool such as ShareGate when you need a scheduled, comprehensive permission audit without maintaining a custom PowerShell script.
Open and Filter Exported SharePoint Permission Reports in WPS Office
WPS Office cannot generate SharePoint permission reports directly, but it is a free, lightweight Microsoft Office alternative that opens the exported CSV or XLSX reports with full format compatibility and familiar spreadsheet tools.
- 1. Download and install WPS Office: Go to https://www.wps.com and click Download WPS Office Free, then install the version for your Windows, macOS, Linux, iOS, or Android device.
- 2. Open the exported permission report: Launch WPS Office and click Open to choose the CSV or XLSX permission report exported from PowerShell, SharePoint site usage, or a third-party tool.
- 3. Filter and review permissions: Use WPS Spreadsheets to apply filters, conditional formatting, and sorting to identify unique permissions, internal users, or external sharing entries.

Frequently Asked Questions
Does SharePoint provide a built-in permission report for all files and folders?
No. SharePoint does not include one standard report that shows every file, folder, user, group, inherited permission status, and permission level. You can use the site usage sharing report for limited external sharing data, or run a PowerShell/PnP script or third-party tool for full reporting.
What permissions do I need to generate a SharePoint permissions report?
You need at least site collection administrator or SharePoint Online admin access. For tenant-wide reporting, SharePoint Online admin or Global Admin roles may be required, and the PowerShell or PnP account must have sufficient permissions.
Why does my SharePoint sharing report not show files shared with internal users?
The built-in sharing report focuses on external sharing. To include internal users, use a PowerShell script that enumerates role assignments and includes both internal and external accounts, or use a third-party audit tool.
Can WPS Office create SharePoint permission reports?
No. WPS Office cannot connect to SharePoint to generate permission reports. Use it to open, filter, and review the exported CSV or XLSX reports after you generate them with PowerShell, SharePoint site usage, or a third-party tool.
What is the easiest way to export a SharePoint permissions report to Excel?
Use PnP PowerShell to export results with Export-Csv or use a tool such as ShareGate to export to Excel. Then open the exported file in WPS Office Spreadsheets to filter and review permissions.




