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 SharePoint Online applies to any filtered or sorted view. Once a query would return more than 5,000 items, the view fails to load instead of showing a partial result. 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 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. That matters because it changes how much caution a first attempt actually needs: 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 List Items tool built for exactly this scenario: large lists, filter-driven cleanup, no scripting required.
- Connect Space Master to the site containing the target list.
- Select the list and build the filter condition (column, operator, value) that identifies the items to remove.
- Run the filter as a preview. Review the matched items and the total count before touching the delete button.
- Adjust the filter if the preview count looks wrong, then re-run it.
- Execute the bulk delete against the confirmed match set. The tool runs past the 5,000-item view threshold since it queries the list directly rather than rendering a browser view.
- Reload the list and spot-check a handful of remaining items to confirm the filter 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 every target item fits on a page or two. PnP PowerShell's Get-PnPListItem combined with a CAML query, piped into Remove-PnPListItem, handles any scale but needs a script written, tested against a small sample, and run with someone watching. 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 referenced any of the deleted items elsewhere in the tenant, check that dependent view or report still renders correctly; broken lookups after a bulk delete are rare but worth a five-minute check 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 but use a separate tool path; 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 SharePoint Online applies to any filtered or sorted list view. Past that count, the view fails to load rather than showing a partial result.
Do bulk-deleted SharePoint list items go to the recycle bin?
Yes. Whether the delete runs through the browser, a script, or Space Master, items land in the site's first-stage recycle bin and stay restorable for the retention window.
Can I undo a bulk delete if the filter was wrong?
Within the retention window, yes, by restoring from the recycle bin. That safety net goes away once the items age out of both recycle bin stages.