Delete data from sharepoint list

%3CLINGO-SUB%20id%3D%22lingo-sub-2511487%22%20slang%3D%22en-US%22%3EDelete%20data%20from%20sharepoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2511487%22%20slang%3D%22en-US%22%3EI%20have%20a%20SP%20list%20with%20about%2040k%20rows.%20I%20need%20to%20clean%20this%20and%20delete%20old%20rows.%3CBR%20%2F%3E%3CBR%20%2F%3EBut%20I%20can%20not%20find%20an%20good%20way%20to%20delete%20large%20amounts.%3CBR%20%2F%3EI%20basically%20can%20only%20work%20with%20100-200%20posts%20at%20a%20time%20and%20it%20lags%20very%20much.%3CBR%20%2F%3E%3CBR%20%2F%3ECan%20I%20sync%20it%20to%20excel%20and%20then%20update%20it%20to%20SP%3F%3CBR%20%2F%3E%3CBR%20%2F%3EOther%20solutions%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2511487%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2013%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3E2016%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFiles%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUsage%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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: 

https://www.sharepointdiary.com/2016/01/sharepoint-online-delete-list-item-using-powershell.html

 

Delete multiple items:

https://www.sharepointdiary.com/2015/10/delete-all-list-items-in-sharepoint-online-using-powershell.... 

https://social.technet.microsoft.com/wiki/contents/articles/17895.powershell-script-to-delete-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.