ShareMaster is shaped by your feedback. Tell us what to build next →
Features All features overview
Migration Tools Overview Structure and content OneDrive ↔ SharePoint Content only Structure only Move / Copy Upload from this computer Download to this computer Dropbox to SharePoint Copy a team Resume and incremental runs
Recycling Bin Overview Browse a site's recycle bin Empty recycle bins in bulk Restore and purge history
Archive Overview Configure the tenant On Demand Archive Restore Archived Files Archive Savings Report Blob Viewer
Optimise Storage Tools Overview Delete all items in a list Delete all files and folders in a library Remove empty folders Remove duplicate files Reduce image sizes Delete sites and subsites
SharePoint Tools Overview Tenant Explorer SharePoint Explorer Easy Settings Fix renamed groups List Explorer Search the Preservation Hold Library
Search & Indexing Overview Search query Item search properties Reindex Crawl log
Replace Overview Replace in SharePoint Replace in local files Find password-protected files
Shared Links Overview Report shared links Report unique permissions Remove a person from sharing links Remove shared links Remove unique permissions
Version History Overview Version trimming Version trimming report Reset file version
Reports Overview Inventory report Folder inventory Site and subsite storage Storage growth Security matrix Teams permissions Pre-migration analysis Compare items Dropbox to Microsoft 365 compare Duplicate file report Empty folder report Image size report Recycle bin report Unused licences Report history
Developer Tools Overview Query Builder PnPjs Console Property Bags SPFx Customizers Webhooks Customisation audit
V2 Pricing Services Demos Blog Guides Use cases Compare Tools Alerts FAQ Contact
  1. Home
  2. Guides
  3. Find Large Files

5 Ways to Find Large Files in SharePoint Online

The average Microsoft 365 tenant stores hundreds of gigabytes in files no one has opened in over a year. Most of it hides in corners: deep document libraries, forgotten project sites, and five years of version history on a single 200 MB CAD file. This guide covers five methods for locating large files across SharePoint Online, from the admin center down to scripted queries, so you can find the waste before it becomes a quota crisis.

What counts as a "large file" in SharePoint Online?

A large file is any item whose size, multiplied by its version count, meaningfully dents a site's quota. A single 2 GB video with no versioning is easy to spot. Harder to catch: a 15 MB PowerPoint presentation with 400 versions consuming 6 GB for a single document. The methods below surface both patterns: individual oversized items and libraries where version bloat has quietly overtaken the current file sizes.

SharePoint Online's base tenant storage is 1 TB plus 10 GB per licence purchased. Unmanaged versioning and forgotten large files are the two fastest ways to exhaust that allocation without realising it.

Method 1: Find large files with the SharePoint admin center

The SharePoint admin center gives you a per-site-collection view of storage consumption. It is the fastest starting point when you do not know which sites are the problem.

  1. Sign in to the Microsoft 365 admin center and open SharePoint admin center.
  2. Go to Sites > Active sites.
  3. Click the Storage used column header to sort descending. The heaviest site collections rise to the top.
  4. Export the full list to CSV using the download icon if you need to analyse it in Excel or share it with the team.

This gives you the ranking of sites by total storage. It does not tell you which specific files or libraries inside those sites are responsible. That requires the next two methods.

Method 2: Site storage metrics page

Once you know which site is the heaviest, drill into its per-library breakdown:

  1. Open the SharePoint site in question.
  2. Go to Site settings > Storage metrics (listed under Site Collection Administration in the settings menu).
  3. The page shows a folder tree with storage totals at each level. Navigate into the document libraries consuming the most quota.
  4. Click a library to see per-folder detail, then navigate to individual files.

Each file's Total Size on this page includes all of its stored versions, while the File Size column in the library itself shows only the current version. A file whose total here is many times its size in the library is a version-bloat flag worth investigating.

Note: the Storage Metrics page is per-site. If you manage dozens of sites, working through each one individually is not practical for a tenant-wide audit. Methods 3 and 4 cover cross-site approaches.

Method 3: Excel storage reports with ShareMaster

ShareMaster's Reports narrow a heavy tenant down in two steps, and both are read-only and free on every plan.

  • Site and subsite storage ranks every site collection and nested subsite in one Excel report. Each web's own storage is shown apart from the site collection's inclusive total, so the figures compare without counting anything twice.
  • Folder inventory then takes the sites, libraries or folders you pick and gives one row per folder, indented by depth, with its subfolder count, total size and file count. The sizes include version history, which is the part the browser hides.

Together they get you from "I know the tenant is heavy" to "I know which folder on which site holds the storage" without a script. They stop at the folder: neither ranks individual files. Once you know the folder, the site's Storage Metrics page in Method 2 shows the files inside it with their sizes.

Method 4: Version history audit with the version trimming report

Version bloat is a distinct problem from single large files. A library full of Word documents averaging 3 MB each sounds modest until unmanaged versioning has run for five years and each document carries 300 versions.

Using ShareMaster's version trimming report

ShareMaster's Version trimming report is a dry run. You set a keep rule, for example keep the newest 10 versions, or only remove versions before a date you choose, and it downloads an Excel report of exactly what that rule would trim from each file and how much storage it would reclaim. Nothing is removed, and the report is free on every plan.

When the numbers justify it, Version trimming applies the same rules for real, across the sites, libraries or folders you pick or the whole tenant, and shows a preview of what it will remove first. Use the folder reports to find the heaviest libraries, then the trimming report to see how much of that weight is history rather than live files.

See also: How to trim SharePoint Online version history for a step-by-step walkthrough of the trimming process.

Method 5: PnP PowerShell (scripted approach)

When a GUI tool is not available, PnP PowerShell can pull file sizes from a single library. It works, but it requires scripting knowledge, a PnP app registration in Entra ID, and care around the list view threshold.

  1. Connect: Connect-PnPOnline -Url https://<tenant>.sharepoint.com/sites/<site> -Interactive
  2. Pull items: Get-PnPListItem -List "Documents" -Fields "FileLeafRef","File_x0020_Size","Modified"
  3. Export to CSV, open in Excel, and sort by File_x0020_Size.

Limitations to be aware of: the File_x0020_Size field returns the current file size only. Version storage is not exposed through that field; you need a separate Get-PnPFileVersion loop per file to total it, which becomes slow and throttle-prone across a large library. Across a tenant with many sites, this script can run for hours and will hit Microsoft 365 throttling limits without a retry mechanism.

For occasional one-library checks, PowerShell is adequate. For tenant-wide or repeated audits, the folder-level Excel reports in Method 3 are faster and avoid the scripting overhead entirely.

Frequently Asked Questions

What is the maximum file size in SharePoint Online?

250 GB per file. In practice the bigger concern is volume: thousands of medium-sized files accumulating years of version history contribute far more to quota overruns than any single large upload.

Do file versions count against SharePoint storage quota?

Yes. Every stored version counts against your storage quota at its full size, and that applies to Office documents as much as to PDFs, images and video. A 15 MB presentation with 400 versions accounts for about 6 GB, which is why heavily edited large files are the first place to look.

Does the SharePoint admin center show file-level storage?

No. The admin center shows storage only at the site collection level. Below that you need the per-site Storage Metrics page, a folder-level Excel report such as ShareMaster's Folder inventory, or a PnP PowerShell query against individual libraries.

How can I find large files across multiple SharePoint sites at once?

The native admin center stops at the site level. ShareMaster's Site and subsite storage report ranks every site and subsite in one workbook, and Folder inventory then shows which folders on the sites you pick hold the storage, version history included. The Version trimming report shows what a trim would free. For a ranked list of individual files, use the Storage Metrics page or PowerShell.

Last updated