Free SharePoint stale-file & archival report (no PowerShell)
"How much of this site can we archive?" is the single most useful question in a SharePoint storage-quota conversation — and until recently there was no free, first-party way to answer it. You either bought a governance tool, or you wrote PowerShell to walk every library and check ModifiedDate against a threshold. This post shows a third option: a free, open-source SPFx web part that answers it directly on the page.
What "stale" means (and why last-modified)
SharePoint does not expose a reliable last-accessed signal at scale via REST. The most practical proxy is last-modified date — a file that hasn't been changed in a year is very likely a candidate for archive. The Smart Storage Analyzer web part classifies every file against two configurable thresholds:
- Stale — not modified in at least 180 days (default). Worth a look.
- Very stale — not modified in at least 365 days (default). A strong archival candidate.
Both thresholds are configurable in Settings, and the legend on every screen reflects your current values — not the defaults — so what you see is always accurate to your setup.
Running the report
- Open the page with the Smart Storage Analyzer web part on it, and switch to the Storage Report tab.
- Optionally tick Include subsites to walk every subsite beneath the current site.
- Optionally tick Include hidden/system libraries if your audit needs to cover Style Library, Form Templates, Site Assets, and similar.
- Click Run scan. A live progress bar shows the current library, files scanned, and elapsed time. Cancel any time and keep the partial results.
Reading the results
Once the scan completes you get:
- Four summary tiles — total size scanned, total files, Stale count & size, Very-stale count & size.
- A full sortable file-level table — library, name, size, modified date, author, archival status.
- "Show archival candidates only" toggle — filters both the table and the exports down to Stale and Very-stale files, hiding Active ones.
Exporting for the site owner
Two export buttons live above the table:
- Export Excel — a color-coded
.xlsxworkbook with a Summary sheet (totals + tiers) and a Details sheet with every file. Highlighting matches the on-screen legend, so a site owner opening the workbook cold can immediately see what's Very stale. - Export CSV — a plain-text alternative for scripted processing or importing into another tool.
The typical hand-off is: filter to archival candidates only, export the workbook, send it to the site owner with the question "can we archive these?". Because the tool never deletes anything itself, you're just producing evidence — the action stays with the owner.
Track cleanup over time
Every completed scan is saved to your browser (IndexedDB, 10 most recent). Scroll down to Scan history to see past scans by date. Check any two, and a Comparison panel appears showing:
- Size change between the two scans (e.g.
+1.5 GB,−3.2 GB). - New archival candidates — files that became Stale since the last scan.
- Resolved items — files that are no longer stale (touched or removed).
- File-count change — good for spotting mass uploads and mass cleanups.
Run a scan on a schedule (monthly is a good starting point) and compare each new one against the previous. That paired export is the auditor-ready evidence that a cleanup effort actually moved the numbers.
Where this fits vs paid tools
Full governance suites (ShareGate Protect, AvePoint P&I, Syskit Point) will do this too — plus lifecycle policies, automatic archival, and centralized dashboards. If you need those, buy them. Smart Storage Analyzer is the free middle ground for the very common case of "I own three sites, I need to defensibly reclaim space, and I don't have a governance budget."
Prerequisites and limits
- Site Owner access required. Storage totals rely on the same right as classic Site Settings → Storage Metrics.
- Read-only. The tool never moves, archives, or deletes anything. Remediation happens in SharePoint, Records Management, or your archival process — you stay in control.
- Local-only history. Scans live in browser IndexedDB (10 most recent). Clearing browser data removes them.
Related
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.
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 Fix SharePoint Oversharing Before Copilot: A Step-by-Step Remediation Plan
Finding oversharing is the easy part. This plan covers what to fix first, how to contain it while you work, and how to confirm the fix held.
Restricted Access Control and Overshared Sites: Preparing SharePoint for Microsoft 365 Copilot
Copilot exposes oversharing that is already there. Here is how the three SharePoint restriction controls differ, when to use each, and how to set up Restricted Access Control with PowerShell.
How to Find Overshared SharePoint Sites with Data Access Governance Reports and the Content Management Assessment
How to run the Content Management Assessment and Data Access Governance reports to find overshared SharePoint sites, and how to fix what they find.
Running out of storage?
Let our team build your storage cleanup plan
We find what is driving your storage use, set version-history and retention policies that fit your organization, and help you avoid buying extra storage.
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.
