Export document library meta-data to Excel

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.