SharePoint Document Issues

SharePoint Online List Limits, Column Limits, and Thresholds Explained

Steve KSteve K Nov 3, 2026 870 views

Question details

The user needs a comprehensive understanding of SharePoint Online limits, specifically regarding maximum list capacities, column restrictions, and view thresholds.

SharePoint Online List Limits, Column Limits, and Thresholds Explained
Product
SharePoint Online
Device & OS
not provided
Scenario
Planning or managing large datasets, document libraries, and custom metadata in SharePoint Online.
Observed behavior
Users need to navigate Microsoft's maximum limitations (like the 5,000-item view threshold and the 30 million items capacity) and implement proper indexing to maintain list performance.
Before you start

Before structuring a new SharePoint list or migrating large datasets, estimate your total item count and determine which columns will be frequently used for filtering or sorting.

Solution 1Recommended

Implement Indexed Columns and Filtered Views

Use indexed columns combined with filtered views to bypass the 5,000-item List View Threshold and manage large lists effectively.

While a SharePoint list can hold up to 30 million items, you will encounter errors if a single view attempts to retrieve more than 5,000 items at once. To prevent this, you must index specific columns and use them to filter your views.

1
Access List Settings

Navigate to your SharePoint list, click the Gear icon in the top right corner to open Settings, and select 'List settings'.

2
Create an Index

Scroll down to the 'Columns' section and click on 'Indexed columns'. Click 'Create a new index' and select the column you intend to use for filtering (e.g., Status, Date).

3
Modify the List View

Return to the main List settings page, scroll down to the 'Views' section, and click on the view you want to update.

4
Apply the Filter

In the view configuration, scroll to the 'Filter' section. Set it to 'Show items only when the following is true', select your indexed column, and specify the criteria to ensure the results remain under 5,000 items.

Implement Indexed Columns and Filtered Views
Pro Tip for Large Lists: Always create indexes before your list exceeds 5,000 items. If the list is already over the threshold, you may need modern indexing features or IT administrative assistance to apply new indexes.
Free Microsoft Office alternative

Analyze Exported SharePoint Data Easily with WPS Office

When dealing with massive SharePoint lists that exceed view thresholds, exporting the data to Excel or CSV is a standard workaround. WPS Office provides a free, highly compatible, and lightweight suite to open, analyze, and manage these large datasets without the heavy resource usage of Microsoft Office.

  1. 1. Export List from SharePoint: Click 'Export to Excel' or 'Export to CSV' in your SharePoint list command bar.
  2. 2. Open in WPS Spreadsheet: Right-click the downloaded file and select 'Open with WPS Office' to load your data instantly.
  3. 3. Filter and Analyze: Use WPS Spreadsheet's built-in filtering and pivot tables to analyze list items beyond the 5,000-item SharePoint limit.
Fully compatible with Microsoft Excel (.xlsx) formats exported directly from SharePoint OnlineLightweight architecture handles large CSV exports and thousands of rows with easeFamiliar spreadsheet interface means zero learning curve for data analysisFree alternative to Microsoft Office, saving licensing costs for offline data processing
microsoft office alternative - wps office

Frequently Asked Questions

What is the SharePoint List View Threshold?

The List View Threshold is a performance limit set at 5,000 items. It prevents server performance degradation by blocking standard views from displaying or querying more than 5,000 items simultaneously.

How many items can a single SharePoint list hold?

A single SharePoint Online list or document library can accommodate up to 30 million items or files, provided that you manage views properly using indexed columns.

Why am I getting a column limit error when adding fields?

SharePoint has a hard limit on underlying database row sizes (8,000 bytes per row). If you add too many data-heavy columns, such as 'Multiple lines of text', you will hit the row size limit even if you have fewer total columns than the theoretical maximum.

Can I increase the 5,000 List View Threshold in SharePoint Online?

No, Microsoft does not allow administrators to increase the 5,000-item List View Threshold in SharePoint Online multi-tenant environments. You must use modern views, folders, or indexed columns to work around it.