Scoped view & mapping headers for SharePoint

If you're migrating from OneDrive for Business, follow the instructions for SharePoint unless specified.

Use the following headers when you're creating a CSV file for a scoped view or mapping for a Microsoft SharePoint migration. Your choice of headers depends on the data that you want to migrate.

CSV file format

  • All headers and entries are case-sensitive unless indicated.
  • When using a mapping CSV file, prefix the column headers belonging to the source connection with Source. Prefix the target connection column headers with Target.
  • Make sure the character encoding of the CSV file is set to UTF-8. 

CSV file headers

Expand all  |  Collapse all

CSV file headers for SharePoint (source)
Header Use and examples
SPFolder To map data from a SharePoint folder, use the SPFolder header with the URL of the folder.

Example
SPFolder
https://example.sharepoint.com/SitePages/Home.aspx?RootFolder=%2FShared%20Documents%2F4444&FolderCTID1

Note: You must include RootFolder or ID keys in the folder path.

SPLibrary To map data from a SharePoint library, use the SPLibrary header with the URL of the library.

Example
SPLibrary
https://example.sharepoint.com/Shared%20Documents/Forms

SPList To map data from a SharePoint list, use the SPList header and the URL of the list.

Example
SPList
https://example.sharepoint.com/ReusableContent

SPSite To map data from a SharePoint site collection, use the SPSite header and the URL of the site collection.

Example
SPSite
https://example.sharepoint.com/sites/dev

SPWeb To map data from a SharePoint website, use the SPWeb header and the URL of the SharePoint website.

Example
SPWeb
https://example.sharepoint.com/demonstration

Other source CSV file headers
Header Use and examples
MapChildrenOnly

Must be preceded by a column with a folder value

To map the contents of the folder, but not the folder itself, use the MapChildrenOnly header with the (case-insensitive) string true. To map the folder and its content, omit the column or use the (case-insensitive) string false.

Example
MapChildrenOnly
true

CSV file headers for Google Workspace (target)
Header Use & examples
GDrive

Must be preceded by a GUser column and value

To map data to a user’s My Drive or to a shared drive, use the GDrive header with one of the following strings:
  • GMyDrive
  • GSharedDrives

Example
GDrive
GMyDrive

GFolder

Must be preceded by a GUser column and value

To map data to a folder inside a user’s My Drive or shared drive, use the GFolder header with the folder’s ID. Find the ID value by navigating to the folder and inspecting the URL. For example, the URL https://drive.google.com/drive/u/0/folders/BDEz25J3DzFb has an ID value of BDEz25J3DzFb.

Example
GFolder
BDEz25J3DzFb

GGroup To map data to a group in Google Groups, use the GGroup header with the group’s email address.

Example
GGroup
group1@solarmora.com

GOrgUnit To map data to a specific organizational unit, use the GOrgUnit header and the path to the organizational unit.

Example
GOrgUnit
/Org_Unit/Sub_Org_Unit

GService

Must be preceded by a GUser column and value

To map data to a user’s Google Workspace service, use the GService header with one of the following strings:

  • GCalendarService
  • GContactService
  • GDrive
  • GMailService
  • GSitesService

Example
GService
GMailService

GSharedDrive

Must be preceded by a GUser column and value

To map data to a shared drive, use the GSharedDrive header with the shared drive’s ID. Find the ID value by navigating to the shared drive root folder and inspecting the URL. For example, the URL https://drive.google.com/drive/u/0/folders/BDEz25J3DzFb has an ID value of BDEz25J3DzFb.

Example
GSharedDrive
BDEz25J3DzFb

GUser To map data to a Google Workspace user, use the GUser header with the email address of the Google Workspace user.

Example
GUser
user1@solarmora.com

Sub Path To map data to a folder that doesn't currently exist on your Google Workspace domain, use the Sub Path header. Add the path and name of the new folder below. During a migration, Google Workspace Migrate creates the path and folder and migrates the data to the new folder. 

Example
Sub Path
Folder1#Folder2

Scoped view CSV file example

Scoped view CSV file for SharePoint:

SPSite
https:example.com/sites/team
https:example.com/sites/project
https:example.com/sites/newproject

To see example mappings for SharePoint and OneDrive, visit Common examples of mappings.

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.

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