Forum Discussion

Raphael Duck's avatar
Raphael Duck
Copper Contributor
Nov 14, 2017
Solved

List of Files on Sharepoint O365

Hello,

 

I have recently encountered a person in my company who created an O365 group, and subsequently a Sharepoint site. He was wondering if there was a way to create a csv or text file that listed the contents(the actual files themselves) of the document library in the share point site. I tried to find some ways online, and nothing really was what I was looking for. Any help anyone could provide would be appreciated.

 

Thanks!

6 Replies

  • Anonymous's avatar
    Anonymous

    The easiest way, without using powershell, is to use PowerBI or PowerQuery in Excel.

     

    From the data source, select "SharePoint Folder" option.

     

    Then enter the name of the site, top level.

     

    When the query returns it will list all files. Done!

    • Raphael Duck's avatar
      Raphael Duck
      Copper Contributor

      Dude you are a lifesaver. Worked like a charm. Thank you so much!

      • Anonymous's avatar
        Anonymous
        My pleasure ... enjoy!
    • Raphael Duck's avatar
      Raphael Duck
      Copper Contributor

      Small question, cant seem to get it to work? I have very limited powershell experience, which command sequence would work?

Resources