Skip to content
LogoTechnipages
LogoTechnipages
  • Topics
        • Android
        • Browsers
        • Gaming
        • Hardware
        • Internet
        • iPhone
        • Linux
        • macOS
        • Office
        • Reviews
        • Software
        • Windows
        • Definitions
        • All Recent Posts
  • Product Reviews
  • About

Microsoft Teams: Export the List of Team Members

Madalina DinitaFebruary 8, 2021 Comments (8)
microsoft teams export 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.

Categories: Software

Author Madalina Dinita

Madalina has been a Windows fan ever since she got her hands on her first Windows XP computer. She is interested in all things technology, especially emerging technologies -- AI and DNA computing in particular.

You Might Also Like

  • Setting up Houseparty Chrome App

    MonaSoftware
  • How to Always Make Microsoft Edge Open in Private Mode

    Judy SanhzSoftware
  • How To Integrate Monday.com Into Microsoft Teams

    MonaSoftware
  • 100+ Best Snapchat Lenses for Cool Selfies in 2023

    100+ Best Snapchat Lenses for Cool Selfies in 2023

    Tamal DasAndroid

Comments

  1. Mitch says:
    September 5, 2023 at 1:12 am

    Thanks – this was very helpful using the email and Excel method.
    1) Create new email, add the group email address.
    2) Click the + to expand the group.
    3) Copy the complete email list.
    4) Paste into Excel.
    5a) If the names and emails are on one row, select the cells, copy and paste transposed.
    5b) If the list is in one cell with semicolon separate. In Data ribbon, select Text to Columns. Select Delimeted > Next. Select Semicolon > Next. Change the Destination cell and select Finish. Select the cells, copy and paste transposed.
    If you would like to separate the email address to a separate column, the same process with Text to Column can be followed, changing the delimeted character.

  2. Lis says:
    June 25, 2023 at 8:21 pm

    Email option didn’t work. Not clear how (where) to run the script. Why does Microsoft not provide something SO basic as a core function? Kinda feels like they have second year uni students developing some of their software as a uni assignment!

  3. Scotty Shanks says:
    June 28, 2022 at 11:54 am

    Why are the simplest things unavailable? I am currently highlighting, copying and pasting member list html content for 46 teams into excel, then I have to remove all of the unwanted text and format the list. Just to get a list of names – why? No other option because as others have stated, the two solutions provided do not work. So many reasons to not like you today, Microsoft…

  4. Mike says:
    January 25, 2022 at 10:56 am

    Script isnt working. Trying to generate #8 or #9 and the same error occurs.
    Get-TeamChannel : A parameter cannot be found that matches parameter name ‘MembershipType’.
    At C:\XXXXX\PrivateChannelManagement.ps1:251 char:41
    + Get-TeamChannel -GroupId $GroupId -MembershipType Private | sel …
    + ~~~~~~~~~~~~~~~
    + CategoryInfo : InvalidArgument: (:) [Get-TeamChannel], ParameterBindingException
    + FullyQualifiedErrorId : NamedParameterNotFound,Microsoft.TeamsCmdlets.PowerShell.Custom.GetTeamChannel

  5. Thys Coetzee says:
    January 24, 2022 at 9:55 am

    This doesn’t get the job done. You can’t seriously expect the average user to get that script working. The email trick doesn’t work — doesn’t display all the teams/groups of which I am a member.

    Certainly, from any Teams post we can hit the ellipsis and create an email from the post. Good luck adding the relevant members to the email recipients! I can’t even open up multiple windows to eyeball the data.

    Come on people — this is the 21st century. Please get this done.

  6. Hervé says:
    January 19, 2022 at 3:37 am

    would be nice to explain how to run that command line

  7. Karen says:
    July 22, 2021 at 4:04 am

    Sorry, advice didnt work. As Angela points out, the email option doesnt work. Such a shame.

  8. Angela says:
    May 14, 2021 at 6:50 am

    The email option doesn’t work as it only enters the email address generated by Teams in the To line, which isn’t in the expandable group format

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Google Docs Header

How to Add a Text Watermark in Google Docs

How to Enable Dark Mode on WhatsApp Updated Methods for 2023

How to Send HD Pictures and Videos on WhatsApp

How to Share Files Using Google Nearby Share

How to Share Files Using Google Nearby Share

Android Battery Will Not Charge Fix

Android Battery Will Not Charge Fix

Turning on Triple Touch Zoom on Android

Turning on Triple Touch Zoom on Android

profile pic

The Experts Behind Technipages

My name is Mitch Bartlett. I've been working in technology for over 20 years in a wide range of tech jobs from Tech Support to Software Testing. I started this site as a technical guide for myself and it has grown into what I hope is a useful reference for all.

Learn More

technipages logo white
linkedin icon

Technipages is part of Guiding Tech Media, a leading digital media publisher focused on helping people figure out technology. Learn more about our mission and team here.

© 2023 Guiding Tech Media All Rights Reserved

  • About Us
  • Contact
  • Legal & Privacy

© 2023 Guiding Tech Media All Rights Reserved

Information from your device can be used to personalize your ad experience.
Do not sell my personal information.