The SharePoint permissions Excel export — how to turn it into decisions
Most SharePoint permission audits stall at the same place. Someone runs a report — Smart Permissions, a PowerShell script, whatever — hands the resulting Excel to the site owner, and then nothing happens for three months because the spreadsheet is 5,000 rows of "person X has Contribute on folder Y" and nobody knows which rows to touch first.
This post is the review workflow that turns a raw export into a defensible list of decisions. It assumes you already have the Excel — see Free SharePoint permission report (with Excel export) for how to generate it — and covers what to do with it.
Step 1 — Add four columns
Open the exported workbook. Add these columns to the right of whatever's there:
- Scope — Site / List / Folder / Item. Copy from the URL if it isn't already broken out.
- Deviation — Identical / Subset / Superset (how the unique ACL compares to the parent's).
- Owner — who signs off. Usually the site owner from SharePoint admin center.
- Decision — one of: Reset, Remove principal, Keep.
These four columns are the difference between a report and an action list.
Step 2 — Filter to unique-permission rows only
Every scope that inherits from its parent is a rounding error for cleanup — those permissions will collapse the moment you fix the parent. Filter to rows where HasUniqueRoleAssignments = true. That's typically 5–15% of the workbook, and it's the entire scope of the cleanup.
Step 3 — Pivot by principal to find stale accounts
Insert a pivot table on the filtered rows. Rows: Principal. Values: count of Scope. Sort descending.
Any principal appearing on 50+ scopes is almost always one of three things: a former employee whose account was never cleaned up, a vendor from a finished engagement, or a decommissioned service account. These are the fastest, safest wins in the entire audit — one Remove-PnPListItemPermission loop per stale principal can clear thousands of rows.
Cross-reference the top principals with your HR active-user list. Anything not on the list gets tagged Decision: Remove principal.
Step 4 — Tag every remaining row
- Identical to parent → Reset. Noise from an accidental Share click; the parent already grants exactly this.
- Subset of parent → Keep. Owner intentionally restricted this scope.
- Superset of parent → owner call. Tag Reset if the addition is stale, Keep with owner sign-off if not.
Step 5 — Execute in PowerShell
Save the tagged workbook as CSV and run two loops.
Reset rows
Import-Csv reset.csv | ForEach-Object { Set-PnPListItemPermission -List $_.List -Identity $_.ItemId -InheritPermissions }
Remove-principal rows
Import-Csv remove.csv | ForEach-Object { Remove-PnPListItemPermission -List $_.List -Identity $_.ItemId -User $_.Principal }
Run in batches of a few hundred with a small delay to stay under throttling. Both cmdlets are the scriptable equivalents of the SharePoint UI's Delete unique permissions and Manage access → Remove buttons.
Step 6 — Re-run and archive
Re-export the permissions report. The unique-permission count should have dropped by 60–90%. Save the before/after workbooks together — this is the audit evidence. Put the next re-run on the calendar for a quarter out.
Why this beats "clean up permissions" as a task
The reason permission audits stall is that "clean up permissions" is an infinite task. This workflow makes it finite: every row in the export ends the exercise with a written decision. If someone asks in six months why a particular principal was removed, the answer is a specific row in a saved spreadsheet with an owner's name against it.
Related
- SharePoint Smart Permissions (the reporter)
- Free SharePoint permission report (with Excel export)
- How to remove unique permissions in SharePoint Online
- SharePoint permissions inheritance: complete reference
- SharePoint governance: complete reference
Permissions tools
- SharePoint permissions audit tool — free, read-only, MIT-licensed SPFx web part.
- SharePoint permission reporting tool — what to look for when choosing one.
Get your first result in about 10 minutes
Visual permissions audit + Excel export. No PowerShell. Free, MIT licensed, no sign-up.
- Download the .sppkg package from the latest release.
- Upload it to your tenant App Catalog.
- Add the web part to a SharePoint page.
Email me when a new release ships
No marketing spam. One short email when a new release ships. You can unsubscribe anytime.
The SharePoint permissions guides
Understand how access is granted, report on who actually has it, then compare the tools that get you there.
Understand
How permission levels, groups, inheritance and sharing links actually fit together.
Where inheritance breaks, why it matters, and how to find every object with unique permissions.
Answer the question a manager asks most, down to a single folder or file.
Report
The free permissions report: every site, library, folder and file, exported to Excel.
What a permissions report should contain and how to run one without PowerShell.
A repeatable audit: scope, run, review, remediate, and re-check.
Find every guest with access before a Copilot rollout or a security review.
See the real people behind a group, not just the group name.
Was this page helpful?
One click. No form, no email address.
Missing something in SharePoint Smart Permissions? Feature requests and bug reports go straight to the developer on GitHub — no account needed to read, free account to post.
Request a featureRelated tool
SharePoint Smart Permissions
Visual permissions audit + Excel export. No PowerShell. Free, MIT licensed, no sign-up.
Keep reading
How to see every SharePoint site you have access to (and build a site directory)
SharePoint has no built-in page that lists every site a person can open. A PnP Modern Search results web part with a contentclass:STS_Site query gives you one — security-trimmed, self-updating, and free.
How to remove unique permissions in SharePoint Online (audit + reset workflow)
Every Share click in SharePoint Online quietly creates a unique permission. Here's how to find them all in Excel, then reset the safe ones from the SharePoint UI or PowerShell.
Why Can't I Access This SharePoint Site? "Access Denied" and "You Need Permission" Explained
Seven real causes behind "access denied" and "you need permission", how to tell which one you have from the message, and the fix for each, for users and admins.
Want a second set of eyes?
Get a SharePoint permissions audit from our team
We review who can see what across your sites, flag oversharing before you roll out Copilot, and help you put a cleanup plan and governance in place.
About the author
Sean Regan
SharePoint & Microsoft 365 consultant with 20+ years of hands-on experience building SPFx web parts, migration tooling and tenant-grade automation. Maintainer of the open-source SharePoint Smart Solutions suite.
