I have a list in SharePoint 2013 which contains old hyperlinks which I want to change. I want to do it in excel 2013 but I cannot find a way to update the already modified hyperlinks in excel to the list.

My goal is to edit the hyperlinks in excel and to somehow apply those changes to the SharePoint list. I do not want to do it in access as I have to write a query to modify the links but in excel this can be done with a formula.

  • Excel can only Read SharePoint ListData, Excel can not write back to SharePoint (but MS-Access can) So if you know how to write an Access SQL-Query then MS-Access is the way to go. Altnernative methods are Powershell or JavaScript(JSOM) code Oct 17, 2016 at 9:52

1 Answer 1


You want to do it in Excel 2013?? Thats bit confusing. If you are looking to edit in Datasheet view. Please select Datasheet View from the ribbon and the items will be displayed in Excel format which i guess you can copy paste in an excel document.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.