Forum Discussion

Oz Oscroft's avatar
Oz Oscroft
Iron Contributor
Sep 12, 2017

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 ...
excel
export
SharePoint Online
Melinda Morales's avatar
Melinda Morales
Copper Contributor
Nov 17, 2017

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?

  • Oz Oscroft's avatar
    Oz Oscroft
    Iron Contributor
    Nov 20, 2017

    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

    • Melinda Morales's avatar
      Melinda Morales
      Copper Contributor
      Nov 20, 2017

      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

       

       

Resources