Delete data from sharepoint list

Frequent Contributor
I have a SP list with about 40k rows. I need to clean this and delete old rows.

But I can not find an good way to delete large amounts.
I basically can only work with 100-200 posts at a time and it lags very much.

Can I sync it to excel and then update it to SP?

Other solutions?
1 Reply

@Oskar Kuus I believe PowerShell is your savior. You can use it in any way you want to fulfill your needs.


Delete a single item:


Delete multiple items: 


Just a thought - You can create a view based off the certain condition (e.g. SP view for older items), and delete the items manually by selecting all.


Hope it helps.