SharePoint Document Issues

Manage the SharePoint 5,000-Item View Threshold During File Migration

John WilsonJohn Wilson Nov 14, 2026 868 views

Question details

Plan a file server migration and make large SharePoint document libraries easier to browse without triggering the list view threshold.

Manage the SharePoint 5,000-Item View Threshold During File Migration
Product
Microsoft SharePoint document libraries
Device & OS
not provided
Scenario
A user is moving files from a local file server to SharePoint and needs to organize and access a large collection.
Observed behavior
A library can store millions of items, but views or queries involving more than 5,000 items can trigger the list view threshold.
Before you start

Review the number of files and folders in the source and identify useful categories, such as department or project, for organizing the destination. Make sure you have permission to manage the SharePoint library and its views.

Solution 1Recommended

Create indexed columns and filtered library views

Use indexed metadata and selective views to make large libraries easier to browse.

The 5,000-item threshold limits certain operations, not the total number of files a library can store. A filter that returns fewer than 5,000 items can still encounter the threshold if SharePoint must scan too many items to process it.

1
Open the library settings

Open the document library in SharePoint, select Settings, and choose Library settings. If necessary, select More library settings.

2
Index a useful column

Under Columns, select Indexed columns, then Create a new index. Choose a column such as Department or Project that you can use to narrow the library.

3
Create a filtered view

Return to the library, open the view menu, and select Create new view or Edit current view. Add a filter using the indexed column so that each view returns fewer than 5,000 items, then save the view.

4
Test the view

Select the saved view from the view menu and check that it opens. If it still triggers a threshold error, make the indexed filter more selective and review sorting, grouping, and other filters that may increase the work required.

Create indexed columns and filtered library views
Index columns early: Create indexes before the library becomes large when possible. Index creation or changes in an existing large library can itself be subject to restrictions. The modern experience can improve usability but does not remove the threshold.
Free Microsoft Office alternative

Review Migration Planning Files with WPS Office

WPS Office is a free, lightweight, easy-to-use Office alternative with a familiar interface. Open compatible Microsoft Office files to review migration inventories and planning documents while moving your everyday editing workflow to WPS. It does not change SharePoint's view threshold.

Review file inventories and migration plans in WPS SpreadsheetCompatible with Microsoft Excel XLSX and Word DOCX formatsFamiliar interface for an easier transition from Microsoft OfficeFree and lightweight tools for everyday document editing
microsoft office alternative - wps office

Frequently Asked Questions

Can a SharePoint document library hold more than 5,000 files?

Yes. A library can store up to 30 million items, but the list view threshold can affect views and operations that need to process more than 5,000 items.

Does the modern SharePoint experience remove the 5,000-item threshold?

No. The modern experience can make libraries easier to use, but threshold restrictions still apply. Use indexed columns and selective views to help manage large collections.

Why does my filtered view still show a threshold error?

SharePoint may need to scan too many items even if the final results contain fewer than 5,000. In the view settings, use a more selective indexed-column filter and review sorting, grouping, and other filters.

Can I use folders instead of indexed views?

Folders can help organize files, but they do not eliminate the threshold. Use reasonably sized folders along with indexed columns and filtered views, and test how users will browse the library.

Does using Microsoft Teams bypass the SharePoint threshold?

No. Files in standard Teams channels are stored in SharePoint, so the underlying SharePoint library limits still apply. Organize and manage the library in SharePoint when needed.