Smart Solutions
Need help?
  • 100% Free & MIT Licensed
  • No third-party data hosting
SharePoint PermissionsHow-toGovernance

The SharePoint permissions Excel export — how to turn it into decisions

7 min readBy Offered as a service by our team

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

Permissions tools

Free · MIT license · no sign-up

Get your first result in about 10 minutes

Visual permissions audit + Excel export. No PowerShell. Free, MIT licensed, no sign-up.

  1. Download the .sppkg package from the latest release.
  2. Upload it to your tenant App Catalog.
  3. Add the web part to a SharePoint page.
Install guide
Download the latest releaseView on GitHub
Email me when a new release ships
Get notified when SharePoint Smart Permissions updates

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.

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 feature

Related tool

SharePoint Smart Permissions

Visual permissions audit + Excel export. No PowerShell. Free, MIT licensed, no sign-up.

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.