Deploy frontline static teams at scale with PowerShell for frontline workers


Does your organization use a large number of teams to drive communication and collaboration among your frontline workforce? This article is for you if you need to create and manage teams at scale.

You can use PowerShell to deploy up to 500 teams and add up to 25 users per team at a time. You can also add and remove users from existing teams at scale. Use this solution to meet your organization's scale needs and significantly reduce deployment time.

Deploying Teams at scale enables you to:

  • Create teams using prebuilt templates or your own custom templates.
  • Add users to teams as owners or members.
  • Manage teams at scale by adding or removing users from existing teams.
  • Stay notified through email, including completion, status, and errors (if any). You can choose to notify up to five people about the status of each batch of teams you deploy. Team owners and members are automatically notified when they're added to a team.

This article walks you through how to deploy Teams at scale.

Overview of steps for how to deploy Teams at scale.

Set up and deploy your teams


Team owners must have a Teams license. Before you use these steps to deploy your teams, make sure that all teams owners have a license.

Follow these steps to deploy up to 500 teams at a time.

Step 1: Prepare your CSV files

Create two CSV files for each batch of teams that you deploy:

  • A CSV file that defines the teams you're creating. This file must have a title line, and must contain these required columns, in the following order, starting with the first column:

    Column name Description
    Team Name The name of the team.
    Existing Team ID If you're adding or removing users from an existing team, specify the team ID of the team.
    Visibility Whether the team is public (anyone in your organization can join) or private (users need approval from the team owners to join). Options are Public and Private.
    Team Template ID If you're creating a team from a prebuilt or custom template, specify the team template ID. See Get started with team templates in the Teams admin center for a list prebuilt team templates and IDs. If you want to use the standard default team template, leave this blank.
  • A CSV file that maps the users you're adding to each team. This file must have a title line, and must contain these required columns, in the following order, starting with the first column:

    Column name Description
    User Full Name The display name of the user.
    User UPN or ID The user principal name (UPN) or ID of the user. For example,
    Team Name The name of the team.
    ActionType Whether you're adding or removing the user from the team. Options are AddMember and RemoveMember.
    Owner or Member Whether the user is a team owner or team member. Options are Owner and Member.


    In this CSV file, you can also assign multiple users as team owners for any team, including dynamic frontline teams that you created in the Teams admin center through the deploy frontline dynamic teams experience.


Use the following examples to help you create your CSV files. Here, we named the files, Teams.csv and Users.csv.


Team Name Existing Team ID Visibility Team Template ID
Contoso Store 1 Public
Contoso Store 2 Public
Contoso Store 3 Public
Contoso Store 4 Public
Contoso Store 5 Public
Contoso Store 6 Public
Contoso Store 7 Public
Contoso Store 8 Private
Contoso Store 9 Private
Contoso Store 10 Private


User Full Name User UPN or ID Team Name ActionType Owner or Member
Avery Howard Contoso Store 1 AddMember Owner
Casey Jensen Contoso Store 2 AddMember Owner
Jessie Irwin Contoso Store 3 AddMember Owner
Manjeet Bhatia Contoso Store 4 AddMember Owner
Mikaela Lee Contoso Store 5 AddMember Owner
Morgan Conners Contoso Store 6 AddMember Member
Oscar Ward Contoso Store 7 AddMember Member
Rene Pelletier Contoso Store 8 AddMember Member
Sydney Mattos Contoso Store 9 AddMember Member
Violet Martinez Contoso Store 10 AddMember Member

Step 2: Set up your environment

Follow these steps to install and connect to the latest version of the Teams PowerShell module.

  1. Install PowerShell version 7 or later. For step-by-step guidance, see Installing PowerShell on Windows.

  2. Run PowerShell in administrator mode.

  3. Run the following to uninstall any previously installed Teams PowerShell module.

    Uninstall-module -Name MicrosoftTeams -Force -Allversions

    If you get an error message, you're already set. Go to the next step.

  4. Download and install the latest version of the Teams PowerShell module. You must be running version 4.7.0 (preview) or a later version.

  5. Run the following to connect to Teams.


    When you're prompted, sign in using your admin credentials.

  6. Run the following to get a list the commands in the Teams PowerShell module.

    Get-Command -Module MicrosoftTeams

    Verify that New-CsBatchTeamsDeployment and Get-CsBatchTeamsDeploymentStatus are listed.

Step 3: Deploy your teams

Now that you created your CSV files and set up your environment, you're ready to deploy your teams.

You use the New-CsBatchTeamsDeployment cmdlet to submit a batch of teams to create. An orchestration ID is generated for each batch. You can then use the Get-CsBatchTeamsDeploymentStatus cmdlet to track the progress and status of each batch.

  1. Run the following to deploy a batch of teams. In this command, you specify the path to your CSV files and the email addresses of up to five recipients to notify about this deployment.

    New-CsBatchTeamsDeployment -TeamsFilePath "Your CSV file path" -UsersFilePath "Your CSV file path" -UsersToNotify "Email addresses" 

    The recipients will receive email notifications about deployment status. The email contains the orchestration ID for the batch you submitted and any errors that might have occurred.

    For example:

    New-CsBatchTeamsDeployment -TeamsFilePath "C:\dscale\Teams.csv" -UsersFilePath "C:\dscale\Users.csv" -UsersToNotify ","
  2. Run the following to check the status of the batch you submitted.

    Get-CsBatchTeamsDeploymentStatus -OrchestrationId "OrchestrationId"

Get analytics on frontline teams usage

The Teams usage report in Teams admin center gives you an overview of usage activity in Teams. You can use the report to view usage details for your frontline teams, including active users, active channels, total organized meetings, last activity date, and other information.

  1. In the left navigation of the Teams admin center, choose Analytics & reports > Usage reports.

  2. On the View reports tab, under Report, select Teams usage.

  3. Under Date range, select a date range of 7 days, 30 days, 90 days, or 180 days. Then, choose Run report.

  4. In the upper-right corner, select Export to Excel > Export table as CSV.

  5. Filter the spreadsheet based on your frontline team IDs.


    Your frontline team IDs are listed in the PowerShell output when you deploy your teams.