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

How to Find What Is Taking Up Space in SharePoint Online (Without TreeSize or PowerShell)

Updated 6 min readBy Offered as a service by our team

"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)

  1. Download the latest .sppkg from the Smart Storage Analyzer GitHub releases page.
  2. Upload it to your tenant App Catalog (or the site's own catalog) and click Deploy when prompted.
  3. 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

Free · MIT license · no sign-up

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.

  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 Storage Analyzer updates

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 feature

Related tool

SharePoint Smart Permissions

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

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.