Home

Is there any nice way to get a list of all our Teams and their info?

%3CLINGO-SUB%20id%3D%22lingo-sub-388933%22%20slang%3D%22en-US%22%3EIs%20there%20any%20nice%20way%20to%20get%20a%20list%20of%20all%20our%20Teams%20and%20their%20info%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-388933%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20go%20to%20the%20Admin%20area%20in%20O365%20I%20can%20go%20to%20the%20Teams%20page%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fadmin.teams.microsoft.com%2Fteams%2Fmanage%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fadmin.teams.microsoft.com%2Fteams%2Fmanage%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20gives%20me%20a%20list%20of%20all%20my%20teams%2C%20how%20many%20people%20are%20on%20them%2C%20etc.%26nbsp%3B%20However%2C%20there's%20no%20way%20to%20Save%20or%20Export%20that%20list.%26nbsp%3B%20The%20list%20only%20loads%20as%20you%20scroll%20down%20the%20page%20so%20it%20takes%20a%20while%20to%20bring%20them%20all%20up.%26nbsp%3B%20Then%20if%20I%20do%20a%20Select%20All%20or%20try%20to%20click%20and%20drag%2C%20it%20doesn't%20select%20all%20the%20teams%20as%20it%20scrolls.%26nbsp%3B%20I'd%20love%20to%20get%20the%20information%20that%20on%20that%20page%20but%20in%20a%20CSV%2Fspreadsheet%20file%20so%20I%20can%20go%20through%20it.%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-388933%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-388940%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20any%20nice%20way%20to%20get%20a%20list%20of%20all%20our%20Teams%20and%20their%20info%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-388940%22%20slang%3D%22en-US%22%3EThere%E2%80%99s%20no%20way%20doing%20this%20from%20the%20admin%20center%20for%20now!%20I%E2%80%99m%20sure%20this%20feature%20and%20others%20will%20be%20added%20eventually%20!%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20may%20use%20the%20Microsoft%20graph%20for%20now%20to%20list%20teams%20and%20use%20a%20flow%20or%20script%20to%20export%20them!%3CBR%20%2F%3E%3CBR%20%2F%3EGeneral%20info%20about%20the%20teams%20graph%20API%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fgraph%2Fapi%2Fresources%2Fteams-api-overview%3Fview%3Dgraph-rest-1.0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fgraph%2Fapi%2Fresources%2Fteams-api-overview%3Fview%3Dgraph-rest-1.0%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EThere%E2%80%99s%20also%20powershell%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowershell%2Fmodule%2Fteams%2Fget-team%3Fview%3Dteams-ps%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowershell%2Fmodule%2Fteams%2Fget-team%3Fview%3Dteams-ps%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EAdam%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-824873%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20any%20nice%20way%20to%20get%20a%20list%20of%20all%20our%20Teams%20and%20their%20info%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-824873%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F72542%22%20target%3D%22_blank%22%3E%40adam%20deltinger%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20just%20use%20a%20Chrome%20Extension%20like%20Table%20Capture%20for%20it%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fchrome.google.com%2Fwebstore%2Fdetail%2Ftable-capture%2Fiebpjdmgckacbodjpijphcplhebcmeop%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fchrome.google.com%2Fwebstore%2Fdetail%2Ftable-capture%2Fiebpjdmgckacbodjpijphcplhebcmeop%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Mike Boehm
Regular Contributor

When I go to the Admin area in O365 I can go to the Teams page:

https://admin.teams.microsoft.com/teams/manage

 

This gives me a list of all my teams, how many people are on them, etc.  However, there's no way to Save or Export that list.  The list only loads as you scroll down the page so it takes a while to bring them all up.  Then if I do a Select All or try to click and drag, it doesn't select all the teams as it scrolls.  I'd love to get the information that on that page but in a CSV/spreadsheet file so I can go through it.

 

Thanks.

2 Replies
There’s no way doing this from the admin center for now! I’m sure this feature and others will be added eventually !

You may use the Microsoft graph for now to list teams and use a flow or script to export them!

General info about the teams graph API:

https://docs.microsoft.com/en-us/graph/api/resources/teams-api-overview?view=graph-rest-1.0

There’s also powershell:


https://docs.microsoft.com/en-us/powershell/module/teams/get-team?view=teams-ps

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