Home > SharePoint Online Migration > Migration to Google Drive > Data Mappings for SharePoint Online to Google Drive Migration
Export to PDFRefer to the table below to view the mappings of source SharePoint Online data types and the corresponding Google Drive data types.
| SharePoint Online Data Type | Google Drive Data Type |
|---|---|
| Site/subsite | Folder |
| Library | Folder |
| Folder | Folder |
| List | Folder |
| File | File |
| Attachment | File |
| File Version | File Version |
| OneNote | Folder |
| Column | Google Sheet Column |
Refer to the table below to view the mappings of source SharePoint Online metadata types and the corresponding Google Drive metadata types.
| SharePoint Online Metadata Type | Google Drive Metadata | Comment |
|---|---|---|
| Created By | N/A | Fly will create the Created By metadata in the destination. In a destination user's drive, the Created By metadata will display the drive owner. In a shared drive, it will show as one of the Manager users. |
| Modified By | N/A | Fly will create the Modified By metadata in the destination. In a destination user's drive, the Modified By will display the drive owner. In a shared drive, it will show as one of the Manager users. |
| Created | Created Time | |
| Modified | Modified Time |
Refer to the tables below to view the mappings of source SharePoint Online permission levels and the corresponding Google Drive permission levels.
*Note: By default, Fly will automatically map permissions from SharePoint Online to Google Drive based on the mappings. You can also configure custom permission mappings in Fly to map permissions.
Permission mapping for user drive
| SharePoint Online Permission Level | User Drive Permission Level |
|---|---|
| Full Control | Editor |
| Contribute | Editor |
| Design | Editor |
| Edit | Editor |
| Read | Viewer |
| View Only | Viewer |
| Restricted view/Can’t download | Viewer |
| Review | Commenter |
Permission mapping for shared drive
| SharePoint Online Permission Level | Shared DrivePermission Level |
|---|---|
| Full Control | Editor/Content Manager |
| Contribute | Editor/Contributor |
| Design | Editor/Contributor |
| Edit | Editor/Contributor |
| Read | Viewer |
| View Only | Viewer |
| Restricted view/Can’t download | Viewer |
| Review | Commenter |