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 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

1. 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).

2. Enter your SharePoint administrator credentials.
3. To generate the location list, enter the following command:

   Get-SPOSite | Select Url > sharepoint-locations.csv

SharePoint Server

1. To load the SharePoint snap-in, enter the following command:

   Add-PSSnapin "Microsoft.SharePoint.PowerShell"

2. 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).

OneDrive

1. 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).

2. Enter your SharePoint administrator credentials.
3. Choose an option:
   • To generate a list of OneDrive site collections, enter the following command:

     Get-SPOSite -IncludePersonalSite $true -Filter { Template -like "SPSPERS" } | Select Url > sharepoint-locations.csv

   • To generate the location list and include OneDrive site collections, enter the following command:

     Get-SPOSite -IncludePersonalSite $true | Select Url > sharepoint-locations.csv

Step 2: Add the location list

1. In the Google Workspace Migrate platform, click New List. 
2. Enter a name for the list.
3. For Type, click the Down arrow Locations.
4. Click Upload CSV file to upload the sharepoint-locations.csv file you created in step 1 or drag the file to the box.
5. Click Create.

Update a location list

Expand section  |  Collapse all & go to top

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 Add 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 Used 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.}