Delete items from SP2013 List using excel list as filter

Question

Is there possible a way to delete multiple items from a SharePoint 2013 list the details of which lie in an excel file.

We have an excel file of the SharePoint list data and would like to only delete those in the excel file.

How can we go about deleting it?

Michał Dem · Accepted Answer · 2015-10-27 14:02:43Z

0

Open your list as a Excel ( Ribbon option ) certin permissions will be needed use it as a Excel workbook sheet and publish your changes to SharePoint

answered Oct 27, 2015 at 14:02

Michał Dem

1271 silver badge10 bronze badges

Michal, from I see in Excel there doesnt seem to be an open from SharePoint option. I do have office 365 however we're using SharePoint On Premises
– Aadil Ganie
Oct 27, 2015 at 14:09
Just put your file url into File > Open. Or use the ribbon, List > Export to excel.
– Seb
Oct 27, 2015 at 15:28

Add a comment |

1 Answer 1