Deleting SharePoint list items one row at a time works fine until the list crosses a few hundred entries. Past that point, checkbox selection, page-by-page scrolling, and a 5,000-item view threshold turn a five-minute cleanup into an afternoon nobody budgeted for. This guide covers the filter-preview-delete pattern that keeps a large cleanup safe, plus every place a rushed bulk delete tends to go wrong.
What is the SharePoint list view threshold?
It's the 5,000-item limit on how many items a single database operation, such as a view's query, can process in SharePoint Online. A view that filters or sorts a larger list on a column that is not indexed fails with a threshold error instead of loading. That single limit is why the native browser approach, which relies on loading a view and checking boxes, stops scaling long before most real-world cleanup lists get emptied.
Before you delete anything
Confirm what "delete" actually does here
A standard SharePoint list item delete in the browser is not permanent. The item moves to the site's first-stage recycle bin and stays recoverable there, then in the second-stage bin, for the usual retention window. Scripts and tools are different: many delete outright unless told to recycle, so check that setting before you run anything. With recycling on, a wrong filter is a recoverable mistake, not a disaster, as long as someone notices before the retention window closes.
Build the filter, then run it alone first
Write the exact condition before opening any tool: a date range, a status value, a lookup column, or several combined. Run that filter by itself and look at what comes back. Skipping this step is the single most common cause of an oversized or wrong deletion, and it costs almost nothing to do properly.
A filter that returns the wrong 40 items is an inconvenience. A filter that returns the wrong 40,000 items, run without a preview, is a Monday morning nobody wants.
Step by step: bulk delete with Space Master
ShareMaster's Space Master includes a Bulk Delete File & Items tool that handles lists as well as libraries, with no scripting required. Its filters are deliberately simple: it clears a whole list, minus anything created or modified after the dates you set. If your condition is a status or lookup value, use a filtered view or PowerShell instead (see below).
- Open ShareMaster, go to Optimize Storage (Space Master), choose Bulk Delete File & Items and connect to the site containing the target list.
- Select the list.
- Optionally set Exclude files and items created after and Exclude files and items modified after. Everything older than those dates is in scope.
- Preview the scope before you run it: a list view filtered on the same Created or Modified dates shows what will go. The tool has no preview of its own, so this is the step not to skip.
- Leave Send to recycling bin ticked so the delete stays recoverable, then confirm and run. Without a date set, the tool pages through the list by item ID in batches rather than loading a view, so the list's size is not a problem. Date filters on a list well past 5,000 items can run into the threshold, so watch the run log for errors.
- Reload the list and spot-check a handful of remaining items to confirm the run caught exactly what was intended.
Doing it without a dedicated tool
Two other paths exist for a large list cleanup. The native browser view works for small, one-off jobs where the target items load in a batch or two. PnP PowerShell's Get-PnPListItem combined with a CAML query, piped into Remove-PnPListItem -Recycle, handles any condition at any scale but needs a script written, tested against a small sample, and run with someone watching. Leave out -Recycle and the items are deleted permanently. A full breakdown of all three approaches, including sample PowerShell, sits in the bulk delete list items comparison.
After the delete: verify, then move on
Reload the list and check the total item count against what the preview promised. If a lookup column in another list on the site pointed at any of the deleted items, check that dependent view or report still renders correctly. The lookup values on those items go blank, and if the lookup column enforces a relationship, the delete is either blocked or cascades to the items that point at it, so a five-minute check before and after is worth it on any list that other lists reference. If something looks off, the recycle bin is still the fastest way back to a known state.
Note: this covers list items specifically, not files or folders inside a document library. Those follow the same recycle bin mechanics and the same Space Master tool, with a folder option of their own; see the guide to bulk deleting files if that's the actual target.
Frequently Asked Questions
What is the SharePoint list view threshold?
It's the 5,000-item limit on what one database operation can process. A view that filters or sorts a larger list on a column that is not indexed fails with a threshold error instead of loading.
Do bulk-deleted SharePoint list items go to the recycle bin?
From the browser, yes, and they stay restorable for the retention window. Scripts and tools only recycle when told to: add -Recycle to Remove-PnPListItem, and keep Send to recycling bin ticked in Space Master, as it is by default.
Can I undo a bulk delete if the filter was wrong?
Within the retention window, yes, by restoring from the recycle bin, as long as the items were recycled rather than purged. That safety net goes away once the items age out of both recycle bin stages.