SharePoint Document Issues

How to Create a SharePoint Permissions Report for Files and Folders

Emma BrownEmma Brown Nov 13, 2026 869 views

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.

How to Create a SharePoint Permissions Report for Files and Folders
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.
Before you start

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.

Solution 1Recommended

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.

1
Install the PnP PowerShell module

Open Windows PowerShell or PowerShell 7 as administrator and run Install-Module PnP.PowerShell -Scope CurrentUser -Force.

2
Connect to SharePoint Online

Run Connect-PnPOnline -Url https://yourtenant.sharepoint.com/sites/yoursite -Interactive and sign in with an account that has site admin access.

3
Enumerate roles and inheritance

Run a PnP script that iterates through the document library, folders, and files and reads role assignments, users, groups, permission levels, and HasUniqueRoleAssignments.

4
Export the report

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 PowerShell with PnP to Enumerate SharePoint Permissions
Important: Test the script in a non-production site first. A report focused only on external sharing may omit files shared only with internal users unless internal role assignments are included explicitly.
Free Microsoft Office alternative

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. 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. 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. 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.
Open and filter exported SharePoint permission report CSV or XLSX files without losing formattingFull compatibility with Microsoft Excel, Word, and PowerPoint filesFree, lightweight office suite with a familiar ribbon interfaceSeamless migration from Microsoft Office for document viewing and editing
microsoft office alternative - wps office

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.