Work Around the SharePoint 5,000-Item List View Threshold
Question details
Find a way to query and manage a SharePoint list with approximately 500,000 records without triggering list view threshold errors.

- Product
- SharePoint lists
- Device & OS
- not provided
- Scenario
- A large list is accessed through views, lookups, filters, REST, JSOM, and CSOM.
- Observed behavior
- List operations produce threshold errors when they attempt to process too many items.
Confirm whether the list is in SharePoint Online or SharePoint Server, and identify the columns and queries that cause errors. Check how many items match each proposed filter before relying on it to narrow a query.
Use indexed columns and selective filters
Use this approach to make views and queries target a small subset of a large list.
The list can contain more than 5,000 items, but an operation can be throttled if SharePoint must process too many items to produce its result. Returning fewer than 5,000 items alone does not guarantee that a query will succeed.
In SharePoint Online, administrators cannot raise the List View Threshold. Creating an index on an already large list may itself be limited or take time, so check whether the index is available before relying on it.
Open the list and choose a column, such as a status or category, whose filter value matches a small portion of the records. Avoid relying on a value that matches most of the list.
Open Settings > List settings > Indexed columns, select Create a new index, and choose the column. If index creation is unavailable or fails, check the list's indexing limits and consider partitioning the data.
Open the list view menu, select Edit current view, and add a filter on the indexed column. Save the view and test whether it opens without a threshold error.
Update REST, JSOM, or CSOM queries to filter on the indexed column, then test each query with representative data. Use pagination where appropriate, but do not rely on a page size or REST $top value alone to bypass throttling.

Partition the list or move the data to another platform
Use this approach when indexed filters cannot support the required operations across the full dataset.
Work with SharePoint-related spreadsheets in WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface for working with compatible documents and spreadsheets. It can help you migrate everyday file work, but it does not change SharePoint list thresholds or fix SharePoint queries.

Frequently Asked Questions
Do I have to reduce the entire list to fewer than 5,000 items?
No. A SharePoint list can contain more than 5,000 items. Instead, design views and queries to process a selective subset, typically using indexed columns and filters.
Can I increase the threshold in SharePoint Online?
No. SharePoint Online administrators cannot raise the List View Threshold. Use selective indexed queries, partition the data, or consider another data platform.
Why does a query fail when it returns fewer than 5,000 items?
SharePoint may need to process more than 5,000 items to find those results. Check the indexed columns and filters used by the view or query; a small result set or page size alone does not guarantee success.
Where can I add an index to a SharePoint list?
Open the list, go to Settings > List settings > Indexed columns, and select Create a new index. On a large existing list, index creation may be limited or take time.
Will folders automatically prevent threshold errors?
No. A view or query must be scoped to an appropriate folder and may still need selective indexed filters. Test the folder-scoped operation with the actual data.




