If you have ever managed a growing digital workspace, you know that "infinite cloud storage" is a myth. Every platform has its boundaries. In the Microsoft 365 ecosystem, SharePoint Online is the powerhouse that stores your files, data, and intranets. However, as your data grows, you eventually hit walls—whether it's an upload error, a slow-loading list, or a "storage full" notification.
As a software professional who has spent years migrating data to the cloud, I’ve seen projects stall because these limits weren't planned for. In this guide, we will break down every critical limit in SharePoint Online, from tenant-wide storage to the granular thresholds of a single list.
1. Understanding Tenant-Level Storage Capacity
Before we look at individual files, we have to look at the "Big Container"—your Microsoft 365 Tenant. Your organization’s total storage isn't a random number; it is calculated based on your licensing.
How Storage is Calculated
Microsoft provides a base amount of storage plus an additional allocation for every licensed user.
- Base Storage: 1 TB (This is fixed for the whole organization).
- Per-User Allocation: +10 GB per licensed user.
For example, if you have a small company with 100 users, your total storage is: total.
Site Creation and Hierarchy Limits
SharePoint allows for a massive amount of structure, but there are ceilings to prevent performance degradation:
- Total Site Limit: You can create up to 2,000,000 sites (including both Communication and Team sites).
- Subsite Limit: You can create up to 2,000 subsites within a single site collection.
Expert Tip: Modern SharePoint architecture favors a "flat" structure. Instead of creating 2,000 subsites, it is much better to create 2,000 separate site collections and connect them using Hub Sites. This prevents permission inheritance issues and makes navigation much smoother.
2. SharePoint Lists: The 30 Million Item Reality
SharePoint lists are often used like mini-databases. While they are incredibly resilient, they are the most common place where users run into technical "thresholds."
The 5,000 Item Threshold
You might have heard that you can only have 5,000 items in a list. This is a common misconception. * True Limit: A list can hold up to 30 million items.
- The Threshold: The "5,000 limit" is actually the List View Threshold. SharePoint cannot "see" or "query" more than 5,000 items at one time without crashing the database performance for other users.
- The Solution: You must use Indexed Columns. You can have up to 20 indexes per list. If you index your columns, you can filter through 30 million items and display only the specific ones you need, staying under the 5,000-view limit.
Column and Lookup Limits
Every list has "weight." If you add too many complex columns, the list becomes slow to load.
- List Creation Limit: 2,000 lists per SharePoint site.
- Total Columns: Up to 276 columns per list.
- The Lookup Limit: This is the one that catches everyone off guard. You can have a maximum of 12 lookup columns per list view. This includes "Person or Group" columns, "Managed Metadata," and "Workflow Status" columns because they all trigger a lookup to another table.
3. Document Library and File Upload Limits
Libraries are specialized lists designed to handle the heavy lifting of document management. With the shift to remote work, file size limits have become more generous.
- Total Files per Library: Up to 30 million files and folders.
- Individual File Size Limit: You can now upload a single file up to 250 GB. This is perfect for high-res video files or large CAD drawings.
- File Path Limit: The total length of the URL (including the site name, folder path, and filename) cannot exceed 400 characters. If your folder structure is too deep (e.g., Documents/Project/2026/Invoices/January/ClientA/Drafts/Final/Version1.docx), you will get sync errors.
4. Advanced Boundaries: Permissions and Versions
As a technical blogger, I always tell my readers to look at the "invisible" limits that affect security and auditing.
Unique Permission Limit
By default, everything in a site inherits permissions from the top. If you "Break Inheritance" to give specific people access to specific folders, you create a "Unique Permission."
- The Limit: 50,000 unique permissions per list or library.
- The Performance Reality: Once you cross 5,000 unique permissions, the list becomes significantly slower. It is always better to manage access at the site or library level rather than the individual file level.
Versioning Limits
SharePoint Online is great at keeping history.
- Major Versions: You can keep up to 50,000 versions of a single document.
- Warning: Versions consume storage space. If you have a 1 GB file and 10 versions, it might be using much more of your quota than you think.
5. Common Mistakes to Avoid
- Syncing too many files: While you can store 30 million files, the OneDrive Sync client starts to struggle after 300,000 files across all synced libraries. If you try to sync more, your PC's CPU usage will spike, and files might not update correctly.
- Using List Lookups for everything: If you need more than 12 lookups, you should reconsider your data structure. Perhaps it's time to move that data into Microsoft Dataverse or SQL Server.
- Naming files with special characters: Even though SharePoint is modern, avoid using characters like
* : < > ? / \ |. Also, avoid starting file names with a space or a period.
6. Best Practices for M365 Admins
- Monitor Quotas: Regularly check the SharePoint Admin Center to see which sites are consuming the most space. You can set specific limits on "hungry" sites to prevent one department from eating the entire tenant's storage.
- Empty the Recycle Bin: Remember that deleted items stay in the Recycle Bin for 93 days and count against your storage quota during that time.
- Use Hub Sites: Instead of nesting subsites, use Hub Sites to join disparate site collections. This bypasses the subsite limit and makes the architecture "future-proof."
FAQ Section
1. What happens if I reach the 5,000 item threshold?
You will see a "Large List" error. You won't be able to filter, sort, or even delete items in that view unless you have already indexed the columns you are trying to filter by.
2. Can I buy more storage if I run out?
Yes. Microsoft allows administrators to purchase "Extra File Storage" add-ons in 1 GB increments if the organizational limit is reached.
3. Does the 250 GB file limit apply to OneDrive too?
Yes, OneDrive for Business is built on top of SharePoint technology, so it shares many of the same file size and path length limitations.
Conclusion
Building a successful SharePoint environment is like building a house; you need to know the dimensions of your plot before you start pouring the foundation. By understanding that you have a 12-lookup limit, a 400-character path limit, and a 5,000-item view threshold, you can design a system that remains fast and reliable for years.
SharePoint is an incredibly flexible platform, but it rewards those who respect its boundaries. Plan ahead, keep your architecture flat, and monitor your storage—your users will thank you for it!
0 Comments
Thanks!