How to Find What Is Taking Up Space in SharePoint Online (Without TreeSize or PowerShell)
"Why is this SharePoint site so big?" is one of the most common storage-quota questions in Microsoft 365 — and SharePoint's out-of-the-box UI is unusually bad at answering it. You get a total. You get a flat list of top-level folders. You don't get a picture, you can't see individual files at scale, and there's no way to answer "what one file is 2 GB?" without clicking your way in.
Measuring is step one of a full storage audit-and-reduce loop: find the space here, size the possible saving with the version history storage calculator, then reclaim it by trimming version history with Automatic limits.
This post walks through a free, open-source alternative — the SharePoint Smart Storage Analyzer SPFx web part — that gives you the interactive size treemap SharePoint always should have had.
What SharePoint gives you by default
The classic Site Settings → Storage Metrics page shows a table: name, item count, size, last modified. It's one level at a time — click a folder to descend, click a breadcrumb to go back. It hasn't changed in a decade. There's no visualization, no whole-site view, no export, and no way to see individual files ranked by size unless you're already inside the folder that contains them. If you want a fuller comparison, see the free Storage Metrics alternative page.
The one-time setup (site admins only)
- Download the latest
.sppkgfrom the Smart Storage Analyzer GitHub releases page. - Upload it to your tenant App Catalog (or the site's own catalog) and click Deploy when prompted.
- On any SharePoint page, click Edit → add the Smart Storage Analyzer web part → Republish.
That's it — no service account, no external service, no PowerShell. The web part inherits your session and runs read-only against the standard SharePoint REST API.
Reading the treemap
Open the page and choose Tree View from Home. The root treemap shows every document library on the site, sized by storage. Select a library or drill into a folder to investigate it.
- Rectangle size = storage weight. A big square is a big folder or a big file.
- Folders are blue. Files are colored by staleness (Active green, Stale amber, Very stale red).
- Click any square to zoom into it. The breadcrumb up top gets you back.
- Library switcher at the top jumps between every document library on the site without leaving the view.
Most sites reveal one or two "one enormous file" or "one archive folder" offenders in the first few seconds — the pattern jumps out visually in a way a flat table can't.
Switch to List when you want exact numbers
The List tab shows the same folder's contents as a sortable table: name, size, item count, modified date, and archival status. Click a column to sort; click again to reverse. Use Export Excel or Export CSV to hand the current folder's listing to a site owner.
Switching between Treemap and List keeps you in the same folder — you don't lose your drill state.
Whole-site view: the Storage Report
The Explorer is for one library at a time. For a full picture — every library on the site, and optionally every subsite — switch to the Storage Report tab, tick Include subsites if you want it, and hit Run scan. You'll get four summary tiles (total size, files scanned, Stale count, Very-stale count) and a full, sortable file-level table you can export to Excel or CSV. Every scan is saved to your browser so you can compare next month's run against this one and prove a cleanup effort actually worked. There's a dedicated walkthrough at the free SharePoint stale-file archival report.
Permissions caveat
Rolled-up folder and library sizes rely on the same underlying right as classic Site Settings → Storage Metrics. That means you need Site Owner access (or the Manage Web / Manage Permissions right). Members, Visitors, and guests will see the web part with a clear warning banner instead of numbers.
What it doesn't do
Smart Storage Analyzer is deliberately read-only. It reports and helps you browse — it never moves, archives, or deletes anything. Once you know what's safe to remove, the actual action happens in SharePoint itself, Records Management, or whatever archival process you use. That's a feature, not a limitation: governance tools that also delete things need paperwork; a reporting tool does not.
Related
Get your first result in about 10 minutes
Download SharePoint Smart Storage Analyzer, follow the step-by-step install guide, and run it against a real site the same afternoon. Nothing to license, nothing to renew.
- 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
Trim SharePoint Version History: Automatic Limits That Reclaimed 30–40% Storage
The two-step change that cut our SharePoint storage by roughly a third: turn on Automatic version limits for new sites, then run one PowerShell command per existing site. Exact retention schedule and script included.
Cut your SharePoint bill: pick M365 Archive candidates with Smart Storage Analyzer
Microsoft 365 Archive is ~75% cheaper than active SharePoint storage — if you archive the right sites. Here's how to pick them with a free web part.
SharePoint Version History Settings: Manual vs Automatic
Version history settings live in three places and the defaults changed in 2025. Here's every option — organization defaults, library-level limits, Manual vs Automatic — and what each one does to your storage bill.
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.
