Micrsoft Teams. Add bulk of team members from CSV file. Not all of the users were added


I'm a teacher at a university in Viet Nam. Our leaders propose us to use Microsoft Teams to organize online classes. I'm granted rights to create teams. I did some searches and found the way (mainly here: https://medium.com/@joaquin.guerrero/adding-bulk-users-from-a-csv-file-to-a-microsoft-teams-team-374414b9d8c9) to add bulk of team members from a CSV file.

Everything seems OK, but... there's a problem:

  • The result of Powershell command "Get-TeamUser" show that all of the users were added (20/20).
  • The GUI of the Microsoft Team application shows that not all of the users were added (only 15/20)

I then manually added the "left" users (via the GUI of the application), and there was NO messages like "user is existing" as usual.

My system info: Windows 10 version 1909 64-bit + Powershell ISE + NuGet + MicrosoftTeams module.

The content of the CSV file:

The result of Powsershell command "Get-TeamUser -GroupId xxxxxx":

The result of bulk addition in the UI of Microsoft Teams application:


Hi Nguyễn Tuấn Anh (KMA),


Thank you for the post.


Please be aware that 3rd party scripting is not in our support scope.


To bulk add users to your team, the most recommended way is to create an office365 group or distribution list by your admin. Once you have those members in it, at teams client, instead of adding individual members, you add to as group, so you could achieve adding multiple users at the same time.


If you need to using PowerShell command to add team users, you could refer to   https://docs.microsoft.com/en-us/powershell/module/teams/add-teamuser?view=teams-ps.


For importing the csv file to create a new dg, we need to use a PowerShell command as below:

Import-Csv “D:\list.csv” | foreach{Add-DistributionGroupMember -Identity “GroupName” -Member $_.alias}

Please replace “GroupName” with your actual distribution group email address.


If you have more suggestions on Teams, please share your idea with us via this link: https://microsoftteams.uservoice.com/.


Best Regards,

Sherry Chen

4 people found this reply helpful

Was this reply helpful?


Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.


Question Info

Last updated September 8, 2021 Views 17,568 Applies to: