A client recently wanted to copy and paste hyperlinks with friendly descriptions from Excel in to the Hyperlink column of a list in SharePoint online.

This used to work back in SharePoint 2010 with Datasheet view because it used an ActiveX control that provided rich functionality. Since SharePoint 2013, the Datasheet view has been replaced with the Quick Edit view, which is HTML and JavaScript only. While this is great for browser compatibility, it does mean that the Quick Edit view has less functionality than the ActiveX control used to have. Continue reading →