Supported editions for this feature: Business Starter, Business Standard, and Business Plus; Enterprise Standard and Enterprise Plus; Education Fundamentals, Education Standard, Teaching and Learning Upgrade, and Education Plus; Essentials Starter, Essentials, Enterprise Essentials, and Enterprise Essentials Plus; Nonprofits; G Suite Basic and G Suite Business. Compare your edition
Migrating files from SharePoint Online using the new data migration service is currently in beta and subject to the Pre-General Availability Offerings Terms in the Google Workspace Service Specific Terms.
Use the new data migration service to migrate files from Microsoft SharePoint Online to your organization's Google Workspace account. Except where indicated, perform the following steps in the Google Admin console of your Workspace account (the account you're migrating to).
Run a migration
Resellers can't migrate data for their customer accounts.
Expand section | Collapse all & go to top
You must be signed in as a super administrator for this task.
-
Sign in with a super administrator account to the Google Admin console.
If you aren’t using a super administrator account, you can’t complete these steps.
- For Microsoft SharePoint Online, click Migrate.
- Click Connect to Microsoft SharePoint Online and sign in as a Global Administrator with your Microsoft account. If you can’t connect, make sure you're using a Global Administrator account to sign in to Microsoft.
The new data migration service copies files, folders, and permissions from a list of SharePoint Online sites to shared drives in Workspace. You can create a comma-separated values (CSV) file for the list. Or, update an existing file to match the required formatting. The file must be smaller than 10 MB.
Tip: Click Download sample CSV file to get an example file you can use.
If you're creating your own file:
- Open a spreadsheet program.
- In the first column, add the following headers in order:
- Source SharePoint URL—URL for the SharePoint Online site collection or sites, such as https://example.sharepoint.com/sites/site-name/. You can find all the URLs at Manage sites in the SharePoint admin center.
- Target Drive FolderID—Unique ID of the shared drive where you want to migrate. You can find existing shared drive IDs on the Manage shared drives page in the Google Admin console.
- Target GUser—Email address for a Workspace user who has the Manager permission in the target shared drive. After migration, Target GUser owns all shared drives connected to a mapped site, including any subsites nested within parent sites. Target GUser will also be the owner in cases where:
- Information on the creator or last modified user is unavailable.
- The source folder contains only group permissions and no user permissions.
- The creator or last modifier of a document library, folder, or file lacks sufficient permissions on the target.
- The item was created or last modified by a source-specific application.
- Folders corresponding to sites are created or modified.
Recommended: Use multiple Target GUsers in the file to avoid migration failures and Google Drive performance issues. The maximum number of Drive items that can be migrated using a single Target GUser is 300,000.
- Add one row for each site or site collection that you want to migrate and populate the values for Source SharePoint URL, Target Drive FolderID, and Target GUser.
You can migrate up to 100 sites at a time. Subsites are automatically included. Additional sites will require a separate migration. To avoid duplication errors, only include parent sites or subsites in your file.
Source SharePoint URL Target DriveFolderID Target GUser https://company.
SharePoint.com/SiteMain/1dyUEebJaFnWa3Z4n
0BFMVAXQ7mfUH11g[email protected] https://company.
SharePoint.com/
SiteComms/Events3xyUVNbJaFn9Ym2PL
0BFMoQXm7PK09vFl[email protected] - Save the spreadsheet as a CSV file.
- Upload the file to the Google Admin console:
- In your Admin console, click Upload CSV.
- Select the file
click Open.
- Click Tasks
to confirm that the file is successfully uploaded.
Use an identity map to connect users and groups in SharePoint Online to users and groups in Google Workspace. Your identity map is a CSV file that you create and then upload to the Google Admin console. The CSV file must be smaller than 10 MB. You can map users, Microsoft 365 groups, and SharePoint Online site groups to users and groups in Workspace.
Before you begin:
- You don't need to add external users to the identity map. Their permissions are migrated by default.
- If you're mapping SharePoint Online Site Groups to Google Groups, you need to:
- Create groups in Google Groups in your Google Workspace account.
- Replicate the same user memberships in Google Groups as those in SharePoint Online Site Groups.
Tip: Click Download sample CSV to get an example CSV file that you can use.
To create an identity map:
- Open a spreadsheet program.
- In the first column, add the header Source Entity.
- In the second column, add the header Destination Email.
- In the Source Entity column, enter the users and groups that you want to map.
- In the Destination Email column, enter valid email address and site group names for your organization’s SharePoint Online users and their target accounts.
Source Entity Destination Email [email protected] [email protected] [email protected] [email protected] SiteComms Visitors [email protected] - Save the spreadsheet as a CSV file.
- Upload the file to the Google Admin console:
- In your Admin console, click Upload CSV.
- Select your mapping file
- Click Tasks
Use migration settings to define how to handle unmapped identities in Step 3.
Unmapped identities are source users and Microsoft 365 group email addresses that were detected during migration but not included in the uploaded identity map. When the map all accounts setting is turned on, the new data migration service automatically maps source users and Microsoft 365 group email addresses from SharePoint Online to detected users and Google Groups in Workspace.
The unmapped identities setting is turned on by default, along with the Keep the source domain option. But, as an administrator, you can disable these settings if needed:
- To map users and Microsoft 365 groups that were not added to the identity map, ensure that the Copy accounts that aren't included in the map that are discovered during the migration box is checked.
- Choose an option:
- If the email address for the Microsoft account is the same as the address in Google Workspace, ensure that Keep the source domain is selected.
- If the domain name for all migrated users and Microsoft 365 groups is changing, select Select a different domain for the migration and then select a domain.
This setting applies only to users within your organization. If you include external users in the identity map, they are mapped to their listed addresses unless you specify a different mapping.
Note: The unmapped identities setting does not apply to Site Groups. Use the identity map to map Site Groups to Google Groups.
- Click Start migration.
Note: This action grants domain-wide delegation and creates a client ID for Data migration (New) in the target account. For more information, go to Control API access with domain-wide delegation. - You can review updates on the following information in real time while the migration is in process:
- Discovered tasks—Total number of tasks, such as crawling, creating, and updating files, folders and permissions
- Warning—Tasks that were completed but failed to complete as expected
- Failed—Tasks that failed to migrate due to an error
- Skipped—Tasks that were skipped because of certain migration settings or because they were completed in previous migration
- Successful—Tasks that were successfully completed
- Sites processed—Number of sites whose migration completed
- Files discovered—Number of files migrating
- Files migrated—Number of files successfully migrated
- Files skipped—Number of previously migrated files that were skipped
- Files failed—Files that failed to migrate in Google Drive
- Discovery issues—Folders from the source account that could not be crawled
- Time elapsed—Time elapsed since migration started
- You can export the following reports at any time once the migration starts:
- To troubleshoot errors, click Export migration report.
- To monitor migration progress and statistics per site, click Export site report.
- If the Tasks list doesn't automatically open with the exported report, click Tasks
- Click Open in Google Sheets to open the report in Google Sheets.
If you need to stop a migration while it’s in progress, click Stop migration.
Stopping a migration might take a few minutes, and it does not roll back the migration process. Any files migrated before the stop won’t be deleted from Google Drive.
You can run delta migrations and review information about a completed migration in the Admin console until you exit the migration. If you need to start a new file migration from SharePoint Online, you must exit the existing migration.
To exit a completed migration:
- If you want to migrate any new or updated files before you exit, follow the steps in Run a delta migration for SharePoint Online.
- If you want to save reports from a migration, click Export migration report
- Click Exit migration
Related topics
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.
