Create a location list

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 you're not, you can skip this step and continue to Add or edit a SharePoint connection.

Step 1: Set up a CSV file

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 find your site collections below.)
  • If you're migrating from OneDrive, include the URLs of 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:

SharePoint location list

Find your URLs

In SharePoint Online
  1. If you don't already have it, install the SharePoint Online Management Shell.
  2. Open the Sharepoint Online Management Shell.
  3. Enter Connect-SPOService -Url https://<SharePoint-site>. Replace <SharePoint-site> with your SharePoint admin site (for example, https://yourdomain-admin.sharepoint.com).
  4. Enter your SharePoint administrator credentials.
  5. Enter Get-SPOSite | Select Url.
In SharePoint Server
  1. On your SharePoint server, open Microsoft PowerShell.
  2. Enter Add-PSSnapin "Microsoft.SharePoint.PowerShell".
  3. Enter Get-SPWebApplication https://<SharePoint-site> | Get-SPSite. Replace <SharePoint-site> with your SharePoint admin site. 
In OneDrive
  1. If you don't already have it, install the SharePoint Online Management Shell.
  2. Open the Sharepoint Online Management Shell.
  3. Enter Connect-SPOService -Url https://<SharePoint-site>. Replace <SharePoint-site> with your SharePoint admin site (for example, https://yourdomain-admin.sharepoint.com).
  4. Enter your SharePoint administrator credentials.
  5. (Optional) To include OneDrive site collections, enter Get-SPOSite -IncludePersonalSite $true | Select Url.

Step 2: Create a location list

  1. In the Google Workspace Migrate platform, click New ""and thenList
  2. Enter a name for the list. 
  3. Under Type, click the Down arrow ""and thenLocations.
  4. Click Upload CSV file to upload a CSV file or drag a file to the box.
  5. Click Create.

Update a location list

Open all   |   Close all

Update a list using a CSV file
  1. In the Google Workspace Migrate platform, click Lists.
  2. Point to the list name and click Entries "".
  3. Click Add "".
  4. Click Upload CSV file or drag a file to the box.
  5. (Optional) To have the new CSV file replace the existing entries, check the Clear existing entries box.
  6. Click Import.
Update individual list entries
  1. Point to the list name and click Entries "".
  2. Click Add ""and thenAdd entries manually
  3. Enter a new source value.
  4. If you want to add another value, click Add "" and enter the new value. 
  5. After you enter all the new values, click Add.
Edit an entry in a list
  1. Point to the list name and click Entries "".
  2. Point to the entry and click Edit "".
  3. Enter the new value and click Save.
Rename a list
  1. Point to the list name and click Rename "".
  2. 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:

  1. Point to the list name and click More ""and thenUsed by bridges or Used by connections.
  2. 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.

Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false