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 ...
Quick Edit is still available, so you can copy and paste from that to Excel as a workaround.
.. and I've just stepped back you the 1980's! Why such a massive step backwards - if you can't export to excel and update automatically one may aswell just keep all this stuff in Excel in the first place. What's going on???
What is missing for you with the Quick Edit view? (not troling, just asking)
Hi Carsten - when you export it creates a link in Excel to the source information in SharePoint. When you update any info. in SharePoint it automatically updates in Excel. Using copy & paste from Quick Edit doesn't have this link so you'd need to go through all the manual steps every time you wanted to report on the current situation.
