Export document library meta-data to Excel

To export document libraries to excel, click on the "..." to the right of the "Download" heading. There you will see "Export to Excel".  I have attached a screen shot.

Good Luck,

Karen

... 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! 

I was coming up against this same issue and was able to get my metadata into Excel by connecting to the library from inside Excel.  

For those with SharePoint Online/Office 365, to access your SharePoint library, in Excel go to the Data tab and click Get Data, then select From Online Services, and From SharePoint Online List. 

There is also an option for just SharePoint List under From Other Sources in the same menu -- perhaps this will work for on-prem users?

This may become an issue for the recordkeeping people of the world who want to keep a record (in the metadata) of what was destroyed at the end of the retention period.

Traditionally, records were destroyed by the container/(paper) file, rather than the document but I've had records people ask me since 2012 how to keep a record of what was destroyed from a document library. Excel was the only real way to do this.

Retention policies in SharePoint and the new ones in Office 365 change the nature of disposal, from containers (document libraries mostly) to individual documents that 'fall off a cliff' into the digital void when they reach the end of their retention period (unless subject to a legal hold). It still raises the question, how do you know what's been destroyed, and when.

Quick Edit is still available, so you can copy and paste from that to Excel as a workaround.

I hadn't noticed this was gone! While I don't *need* this (at least, not yet), I see its value and hope Microsoft can add this in to the Modern experience. In the meantime, I guess we'll have to switch between Classic/Modern view to accomplish this?