Feb 19 2020 10:06 AM
Feb 19 2020 10:06 AM
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.
Feb 19 2020 10:19 AMSolution
Apr 25 2020 01:40 AM
Apr 25 2020 06:54 AM
@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.
May 07 2020 02:58 PM
@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...
May 13 2020 10:10 PM
Check my Script -
May 21 2020 07:01 AM
May 30 2020 09:14 AM
Jul 09 2020 11:04 PM
@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).
Jul 14 2020 08:38 AM
Nov 30 2020 03:16 AM - edited Nov 30 2020 03:19 AM
@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.
Feb 26 2021 02:12 AM
@Christopher Hoard wrote:
@Christopher Hoard unfortunately, this link is not valid anymore
Feb 26 2021 03:27 AM
yeah Technet is no more. Moved to github.
Export all Teams Channels and all members in Office 365 (azure365pro.com)
Mar 09 2021 06:32 AM