Use the following headers when you're creating a CSV file for a scoped view or mapping for a Google Workspace to Google Workspace 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
| Header | Use & examples |
|---|---|
| GCalendar
Must be preceded by a GUser column and value |
To map a user’s calendar, use the GCalendar header with the email address of the Google Workspace user and the calendar’s ID. To find the calendar’s ID, go to Create & share a group calendar.
Example |
| GCalendarResource | To map a calendar resource, use the GCalendarResource header with the calendar resource ID. Find the calendar resource ID by opening your calendar. Point to the calendar resource and click More Example |
| GDrive
Must be preceded by a GUser column and value |
To map a user's My Drive or a shared drive, use the GDrive header with one of the following strings:
Example |
| GFolder
Must be preceded by a GUser column and value |
To map 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 |
| GGroup | To map a group in Google Groups, use the GGroup header with the group’s email address.
Example |
| GOrgUnit | To map a specific organizational unit, use the GOrgUnit header and the path to the organizational unit.
Example |
| GService
Must be preceded by a GUser column and value |
To map a user’s Google Workspace service, use the GService header with one of the following strings:
Example |
| GSharedDrive
Must be preceded by a GUser column and value |
To map 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 |
| GUser | To map a Google Workspace user, use the GUser header with the email address of the Google Workspace user.
Example |
|
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 |
| Sub Path |
To map a Drive folder that doesn't currently exist in your target Google Workspace account, 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. You can map only data to a folder in Drive using the Sub Path header. You can’t map email messages to a label. Example |
Scoped view CSV file example
Scoped view CSV file for migrations to Google Workspace:
| GUser |
| [email protected] |
| [email protected] |
| [email protected] |
To see example mappings for migrations to Google Workspace, 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.