Import chat data from Teams

Use the data import tool to copy chat data from Microsoft Teams to your users' Google Workspace accounts. Except where indicated, you complete these steps in the Google Admin console for the Workspace account you're importing to.

Workspace requirements

Teams requirements

Before you begin: Avoid duplicate spaces

If you roll out spaces for a data import and then start a new import for the same data set, the second import might create duplicate spaces in Workspace. To prevent duplication, avoid creating 2 separate imports for the same data set.

Run a data import

Step 1: Connect to a Microsoft account

  1. In the Google Admin console, go to Menu and then Data and then Data import & export and then Data import.

    You must be signed in as a super administrator for this task.

  2. For Microsoft Teams, click Import.
  3. Click Connect to Microsoft account and sign in as a Global Administrator with your Microsoft account. If you're successful, you get a Connected message. If you can't connect, make sure you're using a Global Administrator account to sign in to Microsoft.

Step 2: Create a file of teams to import

The data import tool copies chat data from Teams to Workspace users. Create a comma-separated values (CSV) file that lists the teams that you want to import. You can create a new CSV file. Or, download a sample file and add information. The completed CSV file must be smaller than 10 MB.

To create the CSV file:

  1. Using your Workspace administrator account, open a spreadsheet program. Or, in the Admin console, click Download a sample CSV file.
  2. Add the column header Source MicrosoftTeamsID and enter a Teams ID for each team that you want to import. Use a separate row for each email team.

    Example:

    Source MicrosoftTeamsID
    8f445146-9d80-b020-d50d5589ab
    bd4685f0-61f2-4789-4c1cda85d93
    d0bef58c-9a55-4d8d-976c89n006
  3. Save the spreadsheet as a CSV file.
  4. Upload the file to the Google Admin console:
    1. In your Admin console, click Upload CSV.
    2. Select your CSV mapping fileand thenclick Open.
    3. Click Tasksto confirm that the mapping file is successfully uploaded.
  5. If the CSV file doesn't successfully upload:
    1. Select the file and click Delete and then Yes to confirm.
    2. Create a new file and try to upload it again.

    If you encounter this issue more than once, contact Google Workspace support.

Step 3: Create & upload an identity map

Create a second CSV file (separate from the file of Teams IDs) to map Teams users to Workspace users. You can create a new CSV file. Or, download a sample file and add rows. You don't need to add external users. Their permissions import by default. The completed CSV file must be smaller than 10 MB.

An identity map is not always required. You don't need an identity map if:

  1. The user's email address in Microsoft is the same as their address in Workspace. For example, the user's email address is raha@example.com for their Microsoft account and their Workspace account.
  2. All users keep the same username in Workspace and are mapped to another domain name. For example, all users have the domain name @example.com and are moving to the domain name @altostrat.com. The users keep their username and only the domain name changes.

If you have some users that don't need to be mapped and some that do, you can create an identity map for only the users that require mapping.

To create the identity map:

  1. Using your Workspace administrator account, open a spreadsheet program. Or, in the Admin console, click Download a sample CSV file.
  2. In the first column, add the header Source Email and enter an email address for each user. Use a separate row for each user.
  3. In the second column, add the header Destination Email and enter a Workspace email address for each user. Use a separate row for each user.

    Example:

    Source Email Destination Email
    charliecruz@example.com ccruz@other-company.com
    kailee@example.com klee@other-company.com
  4. Save the spreadsheet as a CSV file.
  5. Upload the file to the Google Admin console:
    1. In your Admin console, click Upload CSV.
    2. Select your CSV mapping fileand thenclick Open.
    3. Click Tasksto confirm that the mapping file is successfully uploaded.
  6. If the CSV file doesn't successfully upload:
    1. Select the file and click Deleteand thenYes to confirm.
    2. Create a new file and try to upload it again.

    If you encounter this issue more than once, contact Google Workspace support.

Step 4: Select data import settings

Use any of the following settings to specify which data to copy from Teams:

  1. For Date Range, select a date. The data import tool will copy all Teams events or messages that were sent or received after this date.
  2. To import all Teams users, including those not found in the identity map, ensure that the Copy accounts that aren't included in the map that are discovered during the data import box is checked and choose an option:
    • If the user's email address in Teams is the same as their address in Workspace, select Keep their original email address.
    • If the domain name for all imported users is changing, select Use a different email address domain for these accounts and then select a domain.
  3. Click Save changes.

Step 5: Start a data import

Starting a data import grants domain-wide delegation and creates a client ID for Data import in Workspace. For more information, go to Control API access with domain-wide delegation.

  1. Click Start import.
  2. You can see updates on the following information in real time while the data import is in process:
    • Discovered tasks—Number of tasks that were successfully completed
    • Warning—Number of tasks that were completed but failed to complete as expected
    • Failed—Number of tasks that failed to import due to an error
    • Skipped—Number of tasks that were skipped because of certain data import settings, or because they were completed in a previous import
    • Successful—Number of tasks that were successfully completed
    • Channels discovered—Number of channels that were imported, skipped, or failed
    • Spaces created—Number of channels that were imported to spaces
    • Spaces skipped—Number of spaces that weren't created
    • Discovery issues—Number of items that were unable to be read from Microsoft
  3. Click View data import logs. You can export the report at any time once the data import starts.
  4. If the Tasks list doesn't automatically open with the exported report, click Tasksand thenthe report link.
  5. (Optional) Click Open in Google Sheets to open the report in Google Sheets.

When the data import is complete, you get an email with import statistics. Any reports are attached.

(Optional) Step 6: Stop a running data import

If you need to stop a data import while it's in progress, click Stop import.

Stopping a data import might take a few minutes, and it doesn't roll back the import process. Any files that imported before the stop aren't deleted from Drive.

Step 7: Make spaces & messages available to users

After you complete the data import, make the imported spaces and messages available to Workspace users. You must complete this process within 90 days of the start of the import, or the imported spaces are deleted.

Important: Don't complete these steps if you still need to run a delta import. You can't run a delta import after you click Roll out spaces.

  1. In your Google Admin console, click Roll out spaces.

    In real time, you can review the number of spaces and messages that successfully imported.

  2. When the process is complete, click Download logs to view information about which spaces and members were successfully added to users' Google Workspace accounts.

    Note: If any spaces fail to import, click Roll out spaces again to retry the process on all the spaces that failed to import.

Step 8: Exit a completed data import

You can run delta imports and review information about a completed data import in the Admin console until you exit the import. If you need to start a new data import from Teams, you must exit the existing import.

  1. If you want to import any new or updated files before you exit, follow the steps in Run a delta import for chat data.
  2. (Optional) To save logs and reports from a data import, click View data import logs and Export user report.
  3. Click Exit importand thenExit and delete import.

Avoid duplicate files

Data import is intended as a productivity feature and is not designed to assist with legal compliance matters. You and your organization are responsible for assessing and meeting your organization's legal compliance needs. If you require files and folders for legal compliance purposes, consider backing up the files in Teams prior to importing data to Google Workspace.


Google, Google Workspace, and related marks and logos are trademarks of Google LLC. All other company and product names are trademarks of the companies with which they are associated.