Forum Discussion
Solved
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 ...
- PowerShell
https://gallery.technet.microsoft.com/office/Get-Teams-details-c8d8cd93
Hope that answers your question!
Best, Chris
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!
Hi 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?
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.