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 ...
Thanks Melinda Morales - unfortunately when I go to Get Data > From Online Services, the only option I see is 'From Facebook'. I'm signed in to Excel using my Office 365 account and we have everything on O365 online. Do you know if something has to be configured to show SharePoint Online as an option please as it sounds like just what I'm looking for.
Thanks again, Oz
Looks like it might be dependent on Power Query (Get & Transform for Excel 2016). Found these articles: https://support.office.com/en-us/article/Connect-to-a-SharePoint-List-Power-Query-3226f248-f8b3-4777-82ce-b4ed04dedaaf and https://support.office.com/en-us/article/Get-Transform-in-Excel-2016-881c63c6-37c5-4ca2-b616-59e18d75b4de?ui=en-US&rs=en-US&ad=US