SharePoint Document Issues

How to Sort and Manage More Than 5,000 SharePoint List Items

Khadija Khan Sep 25, 2026 869 views

Question details

The user needs to sort and manage a large SharePoint list (e.g., 28,000 items) by date, bypassing the standard 5,000-item list view limit.

How to Sort and Manage Over 5,000 Items in a SharePoint List

Product: SharePoint
Device & OS: not provided
Scenario: Organizing and managing massive SharePoint lists into distinct folders based on date values without triggering threshold errors.
Observed behavior: SharePoint blocks list views, sorting, and bulk management operations when a view attempts to load or process more than 5,000 items.

Before you start

Ensure you have Site Owner or Full Control permissions, as modifying list settings and creating indexed columns requires administrative access.

Solution 1Recommended

Index Columns and Create Filtered Views

Bypass the view threshold by indexing the date column and creating filtered views that display fewer than 5,000 items at a time.

SharePoint lists can hold up to 30 million items, but a single view cannot retrieve more than 5,000 items at once. To work around this, you must index the columns you want to filter or sort by, and then break the data down into smaller, viewable chunks.

Navigate to List Settings

Open your SharePoint list, click the Gear icon (Settings) in the top right corner, and select 'List settings'.

Create an Index

Scroll down to the Columns section and click 'Indexed columns'. Click 'Create a new index' and select the Date column (or the primary column you wish to sort by) to optimize database queries.

Create a Filtered View

Return to the List settings and select 'Create view'. In the Filter section, set parameters (e.g., 'Date is greater than [Date 1]' and 'Date is less than [Date 2]') so that the resulting view contains fewer than 5,000 items.

Sort and Move Items

Open your newly created filtered view. Because it now falls under the threshold, you can freely sort the items by Date and move them into the appropriate folders in batches. Modify the view filters and repeat until all 28,000 items are processed.

Indexing Limits: SharePoint prevents the manual creation of indices if your list already exceeds 5,000 items. If this happens, you may need to temporarily delete items to drop below the threshold, apply the index, and restore the deleted items from the Recycle Bin.

Solution 2

Automate Organization Using PowerShell

Use PowerShell to programmatically fetch list items in batches and move them into date-based folders, completely avoiding the web interface limits.

Free Microsoft Office alternative

Analyze Massive Datasets Offline with WPS Office

If SharePoint's strict web view limits continually disrupt your workflow, consider exporting your large lists to an Excel (.xlsx) format. WPS Office Spreadsheet effortlessly handles massive datasets, allowing you to sort, filter, and organize hundreds of thousands of rows offline without encountering online thresholds.

1. Export from SharePoint: Open your SharePoint list and click the 'Export to Excel' or 'Export to CSV' button in the top command bar.
2. Open with WPS Spreadsheet: Launch WPS Office on your computer and open the newly downloaded file.
3. Sort and Filter Without Limits: Use the Data tab in WPS Spreadsheet to apply filters and sort all 28,000 items instantaneously, bypassing server-side view restrictions entirely.

Fully compatible with Microsoft Excel (.xlsx) and CSV file formats.Process, sort, and filter datasets with millions of rows without threshold errors.Lightweight desktop installation ensuring high performance on large files.Free to use with a highly familiar, easy-to-learn user interface.

microsoft office alternative - wps office

Frequently Asked Questions

Why does SharePoint enforce a strict 5,000-item view limit?

The threshold exists to protect the backend SQL Server database from performance degradation. Queries that return more than 5,000 items can cause row-level locking to escalate to table-level locking, which can block other users across the entire SharePoint tenant.

Can my administrator increase the 5,000-item threshold in SharePoint Online?

No, in Microsoft 365 (SharePoint Online), the 5,000-item list view threshold is a hard limit designed to maintain shared server performance and cannot be modified or increased by site administrators.

What happens if I try to index a column after my list already has over 5,000 items?

SharePoint restricts manual index creation on lists that have already crossed the 5,000-item limit. You must either rely on modern lists' automatic indexing features or temporarily delete items to drop below the threshold, create the index, and then restore the items from the recycle bin.

Document & File Issues