Forum Discussion
Export document library meta-data to Excel
Hi all - how do I export meta-data from a document library in SharePoint online to Excel? It used to be easy in previous versions of SharePoint when you had the ribbon, but I can't find the 'Export ...
... and we have a solution! It looks like the Get Data > From Online Services > From SharePoint is the simple option for those who have an Enterprise license. Unfortunately, I believe it only appears for those with Power Query which is not included for Essentials / Premium licenses.
For those who don't have the required license, the same result can be achieved by following the steps in this excellent article:
http://www.sptechcon.com/news/sharepoint-dashboard-excel
Hope this helps as it's taken me far too long to work out how to achieve something which required the click of a single button in SharePoint 2010!