If you're migrating from OneDrive for Business, follow the instructions for SharePoint unless specified.
You use a location list to define the data available to a Google Workspace Migrate connection. It's required if you want to migrate data from:
- More than one Microsoft SharePoint site collection, as is the case with SharePoint Online (Office 365).
- OneDrive user accounts.
If not, you can skip this step and continue to Add or edit a SharePoint connection.
Format of the location list
Create the list in a spreadsheet program with one entry per line:
- Include the URLs of all SharePoint site collections, including those on OneDrive, that you want Google Workspace Migrate to access. (See tips on how to generate your location list below.)
- If you're migrating from OneDrive, include the URLs of the OneDrive users.
- Do not use headers.
- Save the spreadsheet as a CSV file.
- Make sure the character encoding of the CSV file is set to UTF-8.
For example, if you configured a SharePoint Online connection with the URL, https://example.sharepoint.com, you might have the following location list:
Step 1: Generate a location list
Before you begin, if you don't already have it, install and open Microsoft's SharePoint Online Management Shell.
Expand section | Collapse all & go to top
SharePoint Online- To connect to SharePoint Online, enter the following command:
Connect-SPOService -Url https://SharePoint-site
Replace SharePoint-site with your SharePoint admin site (for example, https://example-admin.sharepoint.com).
- Enter your SharePoint administrator credentials.
- To generate the location list, enter the following command:
Get-SPOSite | Select Url > sharepoint-locations.csv
- To load the SharePoint snap-in, enter the following command:
Add-PSSnapin "Microsoft.SharePoint.PowerShell"
- To generate the location list, enter the following command:
Get-SPWebApplication https://SharePoint-site | Get-SPSite > sharepoint-locations.csv
Replace SharePoint-site with your SharePoint admin site (for example, https://example-admin.sharepoint.com).
- To connect to SharePoint Online, enter the following command:
Connect-SPOService -Url https://SharePoint-site
Replace SharePoint-site with your SharePoint admin site (for example, https://example-admin.sharepoint.com).
- Enter your SharePoint administrator credentials.
- Choose an option:
- To generate a list of OneDrive site collections, enter the following command:
Get-SPOSite -IncludePersonalSite $true | Where-Object {$_.Template -like "SPSPERS*"} | Select-Object Url | Export-Csv -Path "sharepoint-locations.csv" -NoTypeInformation
- To generate the location list and include OneDrive site collections, enter the following command:
Get-SPOSite -IncludePersonalSite $true | Select Url > sharepoint-locations.csv
- To generate a list of OneDrive site collections, enter the following command:
Step 2: Add the location list
- In the Google Workspace Migrate platform, click New
List.
- Enter a name for the list.
- For Type, click the Down arrow
- Click Upload CSV file to upload the sharepoint-locations.csv file you created in step 1 or drag the file to the box.
- Click Create.
Update a location list
Expand section | Collapse all & go to top
Update a list using a CSV file- In the Google Workspace Migrate platform, click Lists.
- Point to the list name and click Entries
.
- Click Add
.
- Click Upload CSV file or drag a file to the box.
- (Optional) To have the new CSV file replace the existing entries, check the Clear existing entries box.
- Click Import.
- Point to the list name and click Entries
- Click Add
- Enter a new source value.
- If you want to add another value, click Add
and enter the new value.
- After you enter all the new values, click Add.
- Point to the list name and click Entries
- Point to the entry and click Edit
.
- Enter the new value and click Save.
- Point to the list name and click Rename
- Enter the new name and click Save.
Check if a list is being used
To check whether a list is being used by a bridge or connection:
- Point to the list name and click More
- Click OK.
Next step
Add or edit a SharePoint connection
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.