Free SharePoint Permissions Reporting Tools Compared: Admin Center, PowerShell and SharePoint Essentials Toolkit Community Edition

Last updated: 2026-10-21

The free ways to report on SharePoint permissions are SharePoint's site permissions pages, the per-site sharing report, PowerShell (PnP or Microsoft Graph), and SharePoint Essentials Toolkit Community Edition. The admin center's tenant-wide reports mostly need SharePoint Advanced Management. The options differ in depth, setup time and export. For file-level reports with sharing links and an Excel export, Community Edition is free on up to 20 sites.

The free ways to report on SharePoint permissions are SharePoint's site permissions pages, the per-site sharing report, PowerShell (PnP or Microsoft Graph), and SharePoint Essentials Toolkit Community Edition. The admin center's tenant-wide reports mostly need SharePoint Advanced Management. The options differ in depth, setup time and export. For file-level reports with sharing links and an Excel export, Community Edition is free on up to 20 sites.

Why compare free permissions tools?

Most permissions questions do not come with a budget. An auditor wants evidence next week. A manager asks who can see a folder. IT wants a baseline before Microsoft 365 Copilot. The first question is always "can we do this with what we have?"

Often you can. The trade-off is time: the free options range from instant but shallow to deep but slow to build. This page compares them honestly so you can pick.

The comparison table

Site permissions pagesSite sharing reportAdmin center reportsPowerShell (PnP / Graph)SharePoint Essentials Toolkit Community
ScopeOne site at a timeOne site per runTenantWhatever you scriptUp to 20 site collections per tenant
DepthSite and list; one item at a timeFiles and folders sharedSite level; item level for Everyone groupsDown to items if you loop themSite, list, folder and file
Sharing linksPer item, in Manage accessYes, except Anyone links28-day activity countsHidden groups, or per-file callsEvery link, plus a dedicated report
Nested group membersOne group at a timeNoCounted in user reportsWith Graph codeOptional expansion
ExportNoCSVCSVCSVExcel, CSV, SharePoint library
Setup timeNoneNoneNone; snapshots need a first baseline runHours: app registration, modules, scriptMinutes: install, free key, connect
On-premises 2016/2019YesNoNoYes, with a different moduleYes
LicensingIncludedIncludedSnapshot reports need SharePoint Advanced ManagementFree, open sourceFree, no trial period
Fix from the reportManualManualSome actions with SAMMore scriptingSmall fixes free; bulk fixes paid

Option 1: SharePoint's site permissions pages

Every site and file has built-in permission pages. Microsoft explains the levels they show in Understanding permission levels.

  1. Site: Settings > Site permissions > Advanced permissions settings lists every group and person with access and their level. Select a group to see its members.
  2. Unique permissions: if a yellow bar says some content has different permissions, select Show these items to list the lists and libraries that break inheritance.
  3. One person: Check Permissions on the ribbon shows what a named person can do on the site and through which group.
  4. One file or folder: select it, open the Details pane and select Manage access to see people, groups and links.

Best for: a quick answer about one site or one file. Limits: no cross-site view, no list of folders and files with unique permissions, no export.

Option 2: The site sharing report

Site admins can open Settings > Site usage and select Run report under Shared with external users. SharePoint saves a CSV to a library you choose and emails you when it is ready. Per Microsoft Learn, it has a row for each unique file, user, permission and link on the site.

Best for: a free, file-level CSV of one site's sharing. Limits: one site per run; SharePoint groups are listed but not their members; Anyone links are not included.

Option 3: SharePoint admin center reports

In the SharePoint admin center, Reports > Data access governance has several reports, documented in Data access governance reports:

  • Site permissions across your organization: which sites have the broadest access.
  • Site permissions for users: every site a named person can reach, with counts of items shared with them.
  • Sites and files shared via special SharePoint groups: every item open to Everyone or Everyone except external users.
  • Sharing links and Shared with 'Everyone except external users': activity in the last 28 days.

Best for: a tenant-wide view and deciding which sites to look at first. Limits: the snapshot reports need SharePoint Advanced Management; Microsoft notes that E5 admins without it get the activity reports only. Snapshot data can be up to 48 hours old, and most reports can be rerun every 30 days. SharePoint Online only.

Option 4: PowerShell

PnP PowerShell reads role assignments at site, list and item level, and Microsoft Graph PowerShell expands Entra ID groups. A minimal site-level report looks like this:

Connect-PnPOnline -Url "https://contoso.sharepoint.com/sites/Finance" -Interactive -ClientId "<your-app-id>"
$web = Get-PnPWeb
Get-PnPProperty -ClientObject $web -Property RoleAssignments | Out-Null
foreach ($ra in $web.RoleAssignments) {
    Get-PnPProperty -ClientObject $ra -Property RoleDefinitionBindings, Member | Out-Null
    [pscustomobject]@{
        Principal = $ra.Member.Title
        Type      = $ra.Member.PrincipalType
        Levels    = $ra.RoleDefinitionBindings.Name -join "; "
    }
}

Our SharePoint permissions report article has a full tenant-wide version with site admins and unique list permissions.

Best for: teams who already maintain scripts and want full control. Limits: PnP PowerShell needs your own Entra ID app registration and admin consent. Item-level loops are slow and throttled on large libraries, sharing links need decoding, and a CSV has no drill-down. Scripts break when modules change and need someone to own them.

Option 5: SharePoint Essentials Toolkit Community Edition

A Windows desktop app for SharePoint Online and SharePoint on-premises (2016/2019). You install it, get a free license key, connect, and pick a task such as Permissions report, Everything one person can access, Who has Full Control or Sharing links report.

Free SharePoint permissions tool: SharePoint Essentials Toolkit task areas
Pick an area, then a task. Each task walks you through site selection and options.

On one test site, the permissions report covered 48 lists and 2,796 items in 1.8 minutes and found 721 grants, 24 Full Control accounts and 9 external users. The grid can be grouped, filtered and exported to Excel.

Free SharePoint permissions report results grouped by scope with totals
A free permissions report: 721 grants across site, list, item and folder scopes.

Best for: file-level audits, sharing links, external users and one-person access checks without scripting. Limits: 20 site collections per tenant, shared by everyone in the organization who uses Community Edition, and up to 20 sites per job. Bulk edits need a paid edition. Requires Windows and an online license check.

Which free tool should you use?

  • "Who can see this one file?" Use Manage access on the file.
  • "Which sites are riskiest?" Use the admin center reports, if you have the licensing.
  • "I need a file-level report for an audit, by Friday." Use Community Edition. See the SharePoint permissions report guide.
  • "What can this leaver open?" Use Community Edition's everything one person can access.
  • "Find every Anyone link." Use the sharing links report.
  • "We need this every month, across hundreds of sites." Either maintain a script or move to a paid edition with more sites.

Frequently asked questions

Is there a free SharePoint permissions report tool?

Yes, several. SharePoint's own site permissions pages and Check Permissions are free on every site. PnP PowerShell is free and open source. SharePoint Essentials Toolkit Community Edition is a free desktop app that runs a full permissions report, down to the file, on up to 20 sites per Microsoft 365 tenant with no item caps.

Are the SharePoint admin center permissions reports free?

Partly. The snapshot reports in Data access governance, such as site permissions, permissions for users and items shared with Everyone groups, need SharePoint Advanced Management. Microsoft notes that Microsoft 365 E5 admins without it can use the 28-day activity reports. The per-site sharing report under Site usage is included. Check Microsoft Learn for current licensing.

Which free option is best for a one-off audit?

For one or two sites with simple permissions, SharePoint's site permissions page may be enough. For an audit that needs file-level detail, sharing links and an Excel export across up to 20 sites, a desktop tool such as SharePoint Essentials Toolkit Community Edition saves the most time. PowerShell suits teams who already maintain scripts.

What does the free Community Edition not include?

Community Edition runs every read-only report at full depth on up to 20 site collections per tenant. Paid editions add more sites and bulk edits, for example removing sharing links or resetting permissions across many libraries at once. Community Edition can apply small fixes from a report so you can see how they work.

Can free tools report on SharePoint on-premises?

SharePoint Server has its own site permissions pages and Check Permissions. The SharePoint Server PowerShell module and PnP PowerShell can script reports. The admin center Data Access Governance reports are SharePoint Online only. SharePoint Essentials Toolkit Community Edition reports on SharePoint on-premises (2016/2019) and SharePoint Online.

Run a permissions report free on up to 20 sites

SharePoint Essentials Toolkit Community Edition is free. Run permissions, sharing links and one-person access reports on up to 20 sites per Microsoft 365 tenant, with no item caps and no trial period. Get your free Community Edition license key.