Thursday, January 5, 2017

How to Create an Export to Excel Link on Any List or Library for 2010 and 2013

Generate the below URL for any list / library

SiteURL/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={List ID}&View={View ID}&CacheControl=1



Note : For List ID and View ID, you could get it from List Setting page and View page respectively