Manage the SharePoint 5,000-Item View Threshold During File Migration
Question details
Plan a file server migration and make large SharePoint document libraries easier to browse without triggering the list view threshold.

- 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.
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.
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.
Open the document library in SharePoint, select Settings, and choose Library settings. If necessary, select More library settings.
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.
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.
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.

Organize and migrate files into suitable libraries and folders
Use this approach when planning a migration from a file server or restructuring a large collection.
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.

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.




