Skip to main content

Bulk add members to Microsoft Teams team from CSV file

Inspired by: Rakesh Pandey

Add users to a Microsoft 365 group linked to Teams.
This script will add users in existing Teams contained in your .csv file.
PS C:\> .\add-users-teams.ps1
This script will add users in existing Microsoft Teams teams from your .csv file
Inputs (if any)
Output (if any)
Your .csv file must contain headers called UPN, teamName, teamId, and role. If you change those headers then make sure to amend the script.

#Check if connected to M365
$m365Status = m365 status --output text
if ($m365Status -eq "Logged Out") {
m365 login

#Import csv
$usersCsvFile = Import-Csv -Path "<YOUR_CSVFile_PATH_HERE.csv>"

#Add users to the Team
foreach ($row in $usersCsvFile) {
Write-Host "Adding $($row.UPN) to the $($row.teamName) Team" -ForegroundColor Magenta
m365 entra m365group user add --groupId $row.teamId --userName "$($row.UPN)" --role $row.role