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

%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%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%3CLINGO-SUB%20id%3D%22lingo-sub-1118872%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-1118872%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F47110%22%20target%3D%22_blank%22%3E%40Mike%20Boehm%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20now%20use%20the%20Microsoft%20powershell%20teams%20cmdlets%20to%20do%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETheyre%20pretty%20good%20and%20although%2C%20they%20dont%20have%20everything%20that%20we%20want%2Fneed...its%20certainly%20closer.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Econnect-microsoftteams%3C%2FP%3E%3CP%3Ethen%3C%2FP%3E%3CP%3Eget-team%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eor%20you%20can%20do%20more%20-%20refer%20to%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fnotbad.tech%2Fall-things-it%2Fmicrosoft-teams-list-all-external-team-members-with-team-owners-and-team-name-part-1%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fnotbad.tech%2Fall-things-it%2Fmicrosoft-teams-list-all-external-team-members-with-team-owners-and-team-name-part-1%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1388251%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-1388251%22%20slang%3D%22en-US%22%3E%3CP%3ECheck%20my%20Script%20-%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%224%22%3E%3CSTRONG%3EExport%20all%20Teams%20Channels%20and%20all%20members%20in%20Office%20365%20%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.azure365pro.com%2Fexport-all-teams-channels-and-all-members-in-office-365%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.azure365pro.com%2Fexport-all-teams-channels-and-all-members-in-office-365%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1423948%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-1423948%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F47110%22%20target%3D%22_blank%22%3E%40Mike%20Boehm%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20script%20helps%20you%20to%3CSPAN%3E%26nbsp%3Bto%20get%20Microsoft%20Teams%20related%20details%20like%20all%20teams%2C%20Channels%20in%20the%20team%2C%20Team%20members%2C%20Team%20owner%2C%20total%20member%20count%2C%20etc.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUsing%20this%20script%2C%20you%20can%20generate%208%20different%20Teams%20reports.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fo365reports.com%2F2020%2F05%2F28%2Fmicrosoft-teams-reporting-using-powershell%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fo365reports.com%2F2020%2F05%2F28%2Fmicrosoft-teams-reporting-using-powershell%2F%3C%2FA%3E%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%20image-alt%3D%22Microsoft%20Teams%20Reporting.png%22%20style%3D%22width%3A%20834px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F195059iF93808A6F0089529%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Microsoft%20Teams%20Reporting.png%22%20alt%3D%22Microsoft%20Teams%20Reporting.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1682149%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-1682149%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%26nbsp%3BThis%20worked%20for%20me%20thank%20you%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F295378%22%20target%3D%22_blank%22%3E%40Kathy_Cooper%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%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%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%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-2023914%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-2023914%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F47110%22%20target%3D%22_blank%22%3E%40Mike%20Boehm%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes!%20I%20have%20discovered%20it%20when%20I%20needed%20to%20download%20a%20list%20of%20over%20800%20users.%20From%20the%20Microsoft%20365%20Admin%20Center%2C%20Go%20to%20the%20Azure%20Active%20Directory%20admin%20center%2C%20then%20Select%20the%20Users%20Tab%20and%20Bulk%20Operation%20Feature%20to%20download%20as%20a%20CSV%20file.%20You%20can%20even%20select%20Users%20as%20Groups%20before%20downloading%20them%20as%20well.%20Hope%20it%20helps%20and%20good%20luck!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Super 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.

7 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

@Mike Boehm 

 

You can now use the Microsoft powershell teams cmdlets to do this.

 

Theyre pretty good and although, they dont have everything that we want/need...its certainly closer.

 

connect-microsoftteams

then

get-team

 

or you can do more - refer to https://notbad.tech/all-things-it/microsoft-teams-list-all-external-team-members-with-team-owners-an...

@Mike Boehm 

This script helps you to to get Microsoft Teams related details like all teams, Channels in the team, Team members, Team owner, total member count, etc.

 

Using this script, you can generate 8 different Teams reports.

https://o365reports.com/2020/05/28/microsoft-teams-reporting-using-powershell/

 

Microsoft Teams Reporting.png

Thank you This worked for me thank you @Kathy_Cooper 

@Mike Boehm 

 

Yes! I have discovered it when I needed to download a list of over 800 users. From the Microsoft 365 Admin Center, Go to the Azure Active Directory admin center, then Select the Users Tab and Bulk Operation Feature to download as a CSV file. You can even select Users as Groups before downloading them as well. Hope it helps and good luck!