Microsoft Teams: Export the List of Team Members

Microsoft Teams doesn’t have a built-in option that allows users to export the list of team members. If you want to get a clear list of all the people who are part of a team, you need to use a workaround. But the good news is that Microsoft Teams users are resourceful people and managed to find some workarounds to get the job done.

How to Export the List of Team Members in Microsoft Teams

Use a Special Script

There’s a very handy and versatile script that you can run to export the list of your team’s members. You can download the script from GitHub.

If you want to export the list of the members of private channels, run this command: ./PrivateChannelManagement.ps1 -Action 9.

On the other hand, if you want to get the list of all the members and owners of Private Channel, run this command: ./PrivateChannelManagement.ps1 -Action 10.

Send an Email

To use this method, you need to be a member of that team.

1. Launch Outlook and use the Groups drop-down option (left-hand pane) to display more details about the group.
2. Then select the group and create a new email.
3. Check the To: line. It should now be populated with the group name.
4. Now, click on the group to expand the list of its members. Click on +### others to fully expand the list, if necessary.
5. Then, you can copy all the team members and import the list into an Excel file.

Conclusion

To sum up, there two main ways to export the list of your team members: you can either run a script or create a new email and add the members of that team as recipients.

Microsoft Teams does not currently support this feature natively. Hopefully, the company will soon add a GUI feature that allows users to export teams’ lists to files. Let us know if you found other workarounds to get the job done. Hit the comments below.