Home

How can I export file information to an Excel Spreadsheet

%3CLINGO-SUB%20id%3D%22lingo-sub-303985%22%20slang%3D%22en-US%22%3EHow%20can%20I%20export%20file%20information%20to%20an%20Excel%20Spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-303985%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3EI%20need%20to%20download%20a%20list%20of%20all%20our%20files%20uploaded%20into%20MS%20Teams%2C%20into%20an%20Excel%20Spreadsheet.%20Is%20this%20possible%3F%20if%20so%2C%20how%20would%20I%20do%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-303985%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdministrator%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAnalytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EHow-to%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-304039%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20export%20file%20information%20to%20an%20Excel%20Spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-304039%22%20slang%3D%22en-US%22%3E%3CP%3EYeah%2C%20the%20option%20to%20export%20goes%20for%20the%20whole%20library!%20BUT%20in%20the%20excel%20file%20you%20can%20sort%20on%20the%20pathes..Just%20filter%20on%20the%20folders%20you%20want%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20477px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F63192i375A2862CBDA0A88%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Sk%C3%A4rmklipp.PNG%22%20title%3D%22Sk%C3%A4rmklipp.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eadam%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-304009%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20export%20file%20information%20to%20an%20Excel%20Spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-304009%22%20slang%3D%22en-US%22%3EWhat%20you%20can%20do%20is%20create%20a%20SPO%20view%20that%20shows%20the%20information%20you%20want%20and%20them%20use%20the%20Export%20option%20to%20export%20that%20View%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-303991%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20export%20file%20information%20to%20an%20Excel%20Spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-303991%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Adam%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20very%20much%20for%20your%20prompt%20response.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20now%20clicked%20the%20button%20in%20Teams%20on%20the%20top%20menu%20bar%20which%20says%20%22Open%20in%20SharePoint%22.%20I%20then%20get%20the%20folder%20I%20was%20looking%20at%20displayed%20in%20a%20SharePoint%20UI.%20However%2C%20when%20I%20click%20the%20%22Export%20to%20Excel%22%20button%20as%20pointed%20out%20in%20your%20reply%20(for%20which%20%22thanks%22!)%20I%20get%20the%20entire%20file%20system%20of%20MS%20Teams%20(for%20our%20private%20project)%20not%20just%20the%20folder%20I%20was%20in.%3C%2FP%3E%3CP%3EHmmm.%20Is%20this%20right%3F%20I%20just%20want%20to%20export%20file%20info%20from%20a%20few%20folders%2C%20not%20everything.%20Can%20this%20be%20done%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-303987%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20export%20file%20information%20to%20an%20Excel%20Spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-303987%22%20slang%3D%22en-US%22%3E%3CP%3EI%20know%20you%20can%20use%20%22export%20to%20excel%22%20from%20the%20libraries%20in%20SharePoint%22%3C%2FP%3E%3CP%3EAlso%20using%20flow%20to%20do%20this%20automatically%20each%20time%20files%20are%20added!%3C%2FP%3E%3CP%3ETo%20get%20all%20teams%20(libraries)%20including%20new%20ones%20Im%20not%20sure%20how%20to%20do%20it%20%2C%20but%20it%20will%26nbsp%3B%20require%20some%20scripting%20if%20possible%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
paulricot
New Contributor

Hi there,

I need to download a list of all our files uploaded into MS Teams, into an Excel Spreadsheet. Is this possible? if so, how would I do it?

 

Thanks

4 Replies

I know you can use "export to excel" from the libraries in SharePoint"

Also using flow to do this automatically each time files are added!

To get all teams (libraries) including new ones Im not sure how to do it , but it will  require some scripting if possible

Hi Adam,

 

Thanks very much for your prompt response. 

I have now clicked the button in Teams on the top menu bar which says "Open in SharePoint". I then get the folder I was looking at displayed in a SharePoint UI. However, when I click the "Export to Excel" button as pointed out in your reply (for which "thanks"!) I get the entire file system of MS Teams (for our private project) not just the folder I was in.

Hmmm. Is this right? I just want to export file info from a few folders, not everything. Can this be done?

 

Thanks

What you can do is create a SPO view that shows the information you want and them use the Export option to export that View

Yeah, the option to export goes for the whole library! BUT in the excel file you can sort on the pathes..Just filter on the folders you want:

 

Skärmklipp.PNG

 

adam

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies