Home > SharePoint Online Migration > Migration to Google Drive > Data Mappings for SharePoint Online to Google Drive Migration

    Export to PDF

    Data Mappings for SharePoint Online to Google Drive Migration

    Refer to the table below to view the mappings of source SharePoint Online data types and the corresponding Google Drive data types.

    SharePoint Online Data TypeGoogle Drive Data Type
    Site/subsiteFolder
    LibraryFolder
    FolderFolder
    ListFolder
    FileFile
    AttachmentFile
    File VersionFile Version
    OneNoteFolder
    ColumnGoogle 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 TypeGoogle Drive MetadataComment
    Created ByN/AFly 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 ByN/AFly 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.
    CreatedCreated Time
    ModifiedModified 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 LevelUser Drive Permission Level
    Full ControlEditor
    ContributeEditor
    DesignEditor
    EditEditor
    ReadViewer
    View OnlyViewer
    Restricted view/Can’t downloadViewer
    ReviewCommenter

    Permission mapping for shared drive

    SharePoint Online Permission LevelShared DrivePermission Level
    Full ControlEditor/Content Manager
    ContributeEditor/Contributor 
    DesignEditor/Contributor
    EditEditor/Contributor
    ReadViewer
    View OnlyViewer
    Restricted view/Can’t downloadViewer
    ReviewCommenter