SOLVED

Export the list of team members

%3CLINGO-SUB%20id%3D%22lingo-sub-1182794%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20the%20list%20of%20team%20members%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1182794%22%20slang%3D%22en-US%22%3EPowerShell%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fgallery.technet.microsoft.com%2Foffice%2FGet-Teams-details-c8d8cd93%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgallery.technet.microsoft.com%2Foffice%2FGet-Teams-details-c8d8cd93%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EHope%20that%20answers%20your%20question!%3CBR%20%2F%3E%3CBR%20%2F%3EBest%2C%20Chris%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1182748%22%20slang%3D%22en-US%22%3EExport%20the%20list%20of%20team%20members%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1182748%22%20slang%3D%22en-US%22%3E%3CP%3EI%20wonder%20how%20I%20can%20export%20the%20list%20of%20members%20of%20a%20team%20to%20an%20excel%20or%20csv%20file.%20When%20there%20are%20some%20assignments%2C%20there%20is%20an%20export%20option%20in%20Grades%20tab%20and%20I%20can%20delete%20the%20extra%20columns%3B%20but%20I%20do%20not%20have%20a%20solution%20for%20the%20teams%20with%20no%20assignments.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1182748%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-1336100%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20the%20list%20of%20team%20members%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1336100%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F169605%22%20target%3D%22_blank%22%3E%40Christopher%20Hoard%3C%2FA%3E%26nbsp%3BThis%20only%20works%20if%20you%20are%20a%20member%20of%20the%20team%20yourself.%20Cool%20script%20but%20not%20ideal.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1337259%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20the%20list%20of%20team%20members%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1337259%22%20slang%3D%22en-US%22%3EYeah%2C%20we%20need%20something%20better%20than%20this.%20I%20am%20not%20aware%20of%20anything%20else%20at%20the%20moment.%20An%20opportunity%20here%20for%20the%20member%20of%20the%20community.%20I%20would%20look%20to%20do%20one%20myself%20but%20the%20pattern%20is%20literally%20full%20for%20the%20forseeable%20future%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1337552%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20the%20list%20of%20team%20members%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1337552%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F169605%22%20target%3D%22_blank%22%3E%40Christopher%20Hoard%3C%2FA%3E%26nbsp%3BI%20was%20doing%20a%20lot%20of%20digging%20on%20this%20because%20a%20client%20requested.%20I%20found%20this%20awesome%20script%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fblog.admindroid.com%2Fmanaging-private-channels-in-microsoft-teams%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fblog.admindroid.com%2Fmanaging-private-channels-in-microsoft-teams%2F%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EOnly%20thing%20I%20noticed%20is%20before%20running%20the%20script%20(option%209)%20I%20had%20to%20manually%20run%20Connect-MicrosoftTeams%20for%20the%20script%20to%20successfully%20execute.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1337555%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20the%20list%20of%20team%20members%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1337555%22%20slang%3D%22en-US%22%3EAwesome%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1372130%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20the%20list%20of%20team%20members%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1372130%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F231432%22%20target%3D%22_blank%22%3E%40Farhad%20Mazlumi%3C%2FA%3E%26nbsp%3BNot%20the%20'prettiest'%20method%2C%20but%20if%20you're%20a%20member%20of%20the%20MS%20Team%2C%20you%20should%20see%20the%20group%20in%20your%26nbsp%3B%3CSTRONG%3EGroups%26nbsp%3B%3C%2FSTRONG%3Edrop-down%20in%20your%20left%20pane%20in%20Outlook.%26nbsp%3B%20Select%20the%20group%2C%20then%20create%20a%20new%20email.%26nbsp%3B%20This%20should%20populate%20the%20To%3A%20line%20with%20the%20group%20name.%26nbsp%3B%20Click%20on%20the%20group%20to%20expand%20its%20members%20(you%20may%20have%20to%20click%20on%20the%20%22%2B%23%23%23%20others)%20to%20fully%20expand%20the%20group.%26nbsp%3B%20Copy%20all%20the%20members%2C%20and%20you%20have%20a%20semicolon-delimited%20list%20that%20you%20can%20import%20into%20Excel...%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1388250%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20the%20list%20of%20team%20members%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1388250%22%20slang%3D%22en-US%22%3E%3CP%3ECheck%20my%20Script%20-%26nbsp%3B%3C%2FP%3E%3CH1%20id%3D%22toc-hId-387939607%22%20id%3D%22toc-hId-387939607%22%20id%3D%22toc-hId-387939607%22%20id%3D%22toc-hId-387939607%22%20id%3D%22toc-hId-387939607%22%20id%3D%22toc-hId-387939607%22%20id%3D%22toc-hId-387939607%22%20id%3D%22toc-hId-387939607%22%20id%3D%22toc-hId-387939607%22%20id%3D%22toc-hId-387939607%22%20id%3D%22toc-hId-387939607%22%3E%3CSPAN%3EExport%20all%20Teams%20Channels%20and%20all%20members%20in%20Office%20365%3C%2FSPAN%3E%3C%2FH1%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%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%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1408726%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20the%20list%20of%20team%20members%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1408726%22%20slang%3D%22en-US%22%3EHi%20and%20thanks%20for%20the%20answer.%20But%20why%20is%20it%20not%20possible%2C%20for%20someone%20who%20doesn't%20have%20admin%20rights%20(because%20running%20a%20power%20shell%20requires%20some%20privileges...)%20a%20Teams%20owner%2C%20for%20instance%2C%20to%20simply%20export%20the%20list%20of%20members%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1428725%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20the%20list%20of%20team%20members%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1428725%22%20slang%3D%22en-US%22%3EFair%20question%3CBR%20%2F%3E%3CBR%20%2F%3EUservoice%20for%20it%20here%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fmicrosoftteams.uservoice.com%2Fforums%2F555103-public%2Fsuggestions%2F39842815-want-to-export-teams-lists-to-files-in-the-gui%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmicrosoftteams.uservoice.com%2Fforums%2F555103-public%2Fsuggestions%2F39842815-want-to-export-teams-lists-to-files-in-the-gui%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EIt's%20a%20design%20restriction%20so%20unfortunately%20no%20way%20around%20it%3CBR%20%2F%3E%3CBR%20%2F%3EBest%2C%20Chris%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1513682%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20the%20list%20of%20team%20members%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1513682%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F452383%22%20target%3D%22_blank%22%3E%40ChristianRoy%3C%2FA%3E%2C%20I%20agree%20it%20would%20be%20nice%20to%20be%20able%20to%20%22manage%22%20your%20Team%20membership%20by%20export%20as%20just%20a%20Team%20owner%2C%20especially%20in%20the%20app%20(and%20not%20fully%20blown%20admin).%20But%20I%20also%20think%20it%20would%20be%20good%20to%20allow%20admins%20to%20have%20the%20ability%20to%20pull%20the%20membership%20data%20without%20having%20to%20use%20PS%20like%20from%20the%20Office%20365%20Admin%20or%20Teams%20Admin%20dashboards.%20I%20know%20the%20horrors%20most%20of%20you%20might%20have%20at%20this%20idea%2C%20but%20some%20of%20us%20are%20stuck%20on%20other%20OS's%20and%20PS%20isn't%20available.%20If%20MS%20is%20to%20move%20to%20truly%20cloud%20based%20applications%2C%20they're%20going%20to%20have%20to%20realize%20some%20of%20these%20requests%20should%20be%20handled%20on%20the%20GUI%20cross-platform%20applications.%20Of%20all%20the%20reports%20I%20can%20pull%20for%20user%20activity%20(which%20are%20great)%2C%20I%20can't%20pull%20a%20membership%20report%20for%20SharePoint%20or%20Teams%20for%20my%20entire%20organization%20(unless%20I'm%20missing%20something).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1521222%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20the%20list%20of%20team%20members%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1521222%22%20slang%3D%22en-US%22%3EThis%20doesn't%20seem%20to%20work%20in%20all%20cases%2C%20depending%20on%20how%20the%20groups%20are%20created%20and%20maintained%20in%20on%20prem%20AD%20or%20Azure%20AD%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1592872%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20the%20list%20of%20team%20members%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1592872%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F169605%22%20target%3D%22_blank%22%3E%40Christopher%20Hoard%3C%2FA%3E%26nbsp%3BWe%20shouldn't%20have%20to%20do%20any%20coding%20to%20get%20a%20list%20of%20members.%26nbsp%3B%20It%20should%20be%20part%20of%20the%20basic%20functionality%20of%20the%20software.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1654766%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20the%20list%20of%20team%20members%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1654766%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F231432%22%20target%3D%22_blank%22%3E%40Farhad%20Mazlumi%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3EIn%20the%20Grades%20section%20(education)%20you%20can%20download%20a%20CSV%20document%20with%20all%20members%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1940022%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20the%20list%20of%20team%20members%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1940022%22%20slang%3D%22en-US%22%3ECheers%20Chris%20for%20the%20link.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1940080%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20the%20list%20of%20team%20members%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1940080%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F422789%22%20target%3D%22_blank%22%3E%40UXjoelplas%3C%2FA%3EWhen%20I%20asked%20my%20question%2C%20there%20was%20no%20grades%20tab%20in%20Microsoft%20Teams.%20But%20exporting%20the%20list%20of%20grades%20may%20be%20the%20best%20answer%20to%20my%20question%20these%20days.%3C%2FP%3E%3CP%3EIt%20is%20noted%20that%20there%20is%20no%20grades%20tab%20in%20teams%20other%20than%20Class%20Teams.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I wonder how I can export the list of members of a team to an excel or csv file. When there are some assignments, there is an export option in Grades tab and I can delete the extra columns; but I do not have a solution for the teams with no assignments.

15 Replies
Best Response confirmed by adam deltinger (MVP)
Solution
PowerShell

https://gallery.technet.microsoft.com/office/Get-Teams-details-c8d8cd93

Hope that answers your question!

Best, Chris

@Christopher Hoard This only works if you are a member of the team yourself. Cool script but not ideal.

Yeah, we need something better than this. I am not aware of anything else at the moment. An opportunity here for the member of the community. I would look to do one myself but the pattern is literally full for the forseeable future

@Christopher Hoard I was doing a lot of digging on this because a client requested. I found this awesome script: https://blog.admindroid.com/managing-private-channels-in-microsoft-teams/

Only thing I noticed is before running the script (option 9) I had to manually run Connect-MicrosoftTeams for the script to successfully execute.

Awesome

@Farhad Mazlumi Not the 'prettiest' method, but if you're a member of the MS Team, you should see the group in your Groups drop-down in your left pane in Outlook.  Select the group, then create a new email.  This should populate the To: line with the group name.  Click on the group to expand its members (you may have to click on the "+### others) to fully expand the group.  Copy all the members, and you have a semicolon-delimited list that you can import into Excel...  

Check my Script - 

Export all Teams Channels and all members in Office 365

https://www.azure365pro.com/export-all-teams-channels-and-all-members-in-office-365/

 

 

Hi and thanks for the answer. But why is it not possible, for someone who doesn't have admin rights (because running a power shell requires some privileges...) a Teams owner, for instance, to simply export the list of members?
Fair question

Uservoice for it here

https://microsoftteams.uservoice.com/forums/555103-public/suggestions/39842815-want-to-export-teams-...

It's a design restriction so unfortunately no way around it

Best, Chris

@ChristianRoy, I agree it would be nice to be able to "manage" your Team membership by export as just a Team owner, especially in the app (and not fully blown admin). But I also think it would be good to allow admins to have the ability to pull the membership data without having to use PS like from the Office 365 Admin or Teams Admin dashboards. I know the horrors most of you might have at this idea, but some of us are stuck on other OS's and PS isn't available. If MS is to move to truly cloud based applications, they're going to have to realize some of these requests should be handled on the GUI cross-platform applications. Of all the reports I can pull for user activity (which are great), I can't pull a membership report for SharePoint or Teams for my entire organization (unless I'm missing something).

This doesn't seem to work in all cases, depending on how the groups are created and maintained in on prem AD or Azure AD

@Christopher Hoard We shouldn't have to do any coding to get a list of members.  It should be part of the basic functionality of the software.

@Farhad Mazlumi 
In the Grades section (education) you can download a CSV document with all members

Cheers Chris for the link.

@UXjoelplasWhen I asked my question, there was no grades tab in Microsoft Teams. But exporting the list of grades may be the best answer to my question these days.

It is noted that there is no grades tab in teams other than Class Teams.