Forum Discussion
Farhad Mazlumi
Feb 19, 2020Brass Contributor
Export the list of team members
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.
- PowerShell
https://gallery.technet.microsoft.com/office/Get-Teams-details-c8d8cd93
Hope that answers your question!
Best, Chris
- Yuxin_LinCopper ContributorIt is 2022 Oct and I am still fighting at this issue.
It is just **bleep** that Microsoft Teams doesn't provide such a basic function!
Why this software doesn't allow team/group owners to export members list simply by a few clicks? Why we need to learn how to coding/scripting in order to know who are in our team/group?
The designers & developers of the functions shall feel shamed.
Go back to my condition. I only have Teams without apps like Grades, Insights... and in my company we don't have rights to open the consoles. What can I do to export the member list, except to manually copy from members and then remove the useless text one by one? - Paul__M_Brass Contributor
You can do this in Power Automate. This user shows how: https://www.youtube.com/watch?v=HeI3GH77kXw&t
For me I wasn't able to connect excel so I took the output from the first part and copied and pasted into a text document and used a Python script to loop through the dictionary to pull the names
- natascham3985Copper Contributor
Farhad Mazlumi i found the answer on youtube: https://youtu.be/IN6IHZoPEWo
- Annie_seymourCopper ContributorFor some reason the scripts didn't extract all of the members. Only 49 / 340. I used portal.azure.com instead which someone else recommending below.
- sfothersCopper Contributor
Farhad Mazlumi You could try doing this from portal.azure.com as a standard user without needing to use PowerShell. Select Azure Active Directory, browse to Groups and search for the Team name. You can view members and owners from there, and should be able to download the memberlist to csv using the bulk operations drop down. Having said that, an option within the Team client itself would be a much better option!
- Dani_ArgCopper Contributor
I tried this and it worked like a charm. Easy. Thank you.
- Annie_seymourCopper ContributorThank you for this. I tried some of the scripts others suggested and only ever got a quarter of the members in the download. Using the portal.azure.com was the simplest method.
- ssantossCopper Contributor
Farhad Mazlumi Maybe it´s too late, but here´s how I´ve just managed: go to your team and open Insights. Once in Insights, open "more options" at the top right corner of the app and choose Export to Excel. What you´ll get is a xls file with names and emails of all team members.
Customize and rename this file and you´ll be able to use it in any other application.
Cheers!
- missyllaneCopper ContributorHi there - it's never too late! 😉 I'd love to try this, but how do you open Insights? Could you provide a screenshot or 2?
- ssantossCopper Contributor
missyllane Hi, Insights is an additional app that I added to the Team´s menu.
I discovered it some time ago and I have to admit that it is more suitable for school environments that the regular tracking tab of Teams. You can see who visited the Team, how long and what they worked on. Besides, the app gathers information like the number of tasks completed by each student, etc. This information can be very useful at the time of grading.
Anyway, once you get it added to your Team as an extra tab (use the + sign to do that)...
... this is the kind of general information it provides about the Team:
... and when you click on "Student activity" it shows a chart with the activity of each of the students in the Team (from the image you can see that my students are not using it much these days).
In the "Student activity" section you´ll also find an ellipsis (yellow highlight in the image) that will allow you to export this information, together with the names and emails of all the students, to an xls. file.
And that would be it!
I hope it helps.
Cheers.
- PDuganCopper Contributor
This was a brilliant and easy way to export the member list. Took me 10 seconds 🙂
https://developers.salestim.com/blog/export-microsoft-teams-team-members/
- missyllaneCopper Contributor
PDugan This was perfect! So simple and I don't have to be a developer to do it!
- UXjoelplasCopper Contributor
Farhad Mazlumi
In the Grades section (education) you can download a CSV document with all members- tmangiaracinaCopper Contributor
UXjoelplas GREAT IDEA, thanks so much
- farhad74Copper Contributor
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.
- Satheshwaran ManoharanCopper Contributor
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/
- EDubYaCopper Contributor
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...
- ModupeOfficialCopper ContributorThanks for this suggestion. It's the simplest option in my opinion.
- tadamsCopper ContributorThis doesn't seem to work in all cases, depending on how the groups are created and maintained in on prem AD or Azure AD
- PowerShell
https://gallery.technet.microsoft.com/office/Get-Teams-details-c8d8cd93
Hope that answers your question!
Best, Chris- mh7777Copper Contributor
Broken link now? ChrisHoardMVP
- mtkonoCopper Contributor
ChrisHoardMVP the link provided no longer works.
- cjmcqueenCopper Contributor
ChrisHoardMVP seems like this script example doesn't exist anymore. When you click the link, it goes to the generic docs page and searching "get Teams details" pulls up nothing. ¯\_(ツ)_/¯
Thanks for bearing with me as I get back to the Teams Community
Can now do this in the Teams Admin Centre. Go to Teams > Manage Teams > Select a Team and it's on the right hand side 😄
Best, Chris