What's imported from SharePoint Online?

Supported editions for this feature: Business Starter, Business Standard, and Business Plus; Enterprise Standard and Enterprise Plus; Education Fundamentals, Education Standard, and Education Plus; Essentials Starter, Essentials, Enterprise Essentials, and Enterprise Essentials Plus; Nonprofits; G Suite Basic and G Suite Business. Compare your edition

Use the data import tool to copy files from Microsoft SharePoint Online to your organization's Google Workspace account. The service doesn't delete or modify existing files or folders but copies them to the user's account in Workspace. Not all SharePoint Online features are supported.

Imported features & data

Feature in SharePoint Online Feature in Google Workspace
Site collections

Shared drives

The entire site collection and the associated file and folder hierarchy gets imported.

Nested sites Shared drives or folders in shared drives
Document libraries Folders
Folders Folders
Files

Files

Files are imported in their existing format. For example, a PDF imports as a PDF.

OneNote notebooks Folders

Specific user & group permissions on SharePoint Online files, folders, and document libraries:

  • Writer
  • Viewer
  • Reviewer
  • Can't download

Specific user & group permissions on files in Google Drive:

  • Writer imports to Editor.
  • Viewer, Reviewer, and Can't download import to Viewer.

Specific group permission levels on sites files:

  • Visitors
  • Members
  • Owners
  • Custom permissions

Specific group permissions on folders within the shared drives in Workspace:

  • Visitors imports to Viewers.
  • Members imports to Contributor.
  • Owners imports to Content Manager.
  • Custom permissions import to Viewer, Contributor, or Content Manager depending on the level of access in SharePoint Online.

Multiple shareable links

  • Anyone
  • People in your organization
  • People you choose

Anyone links import as Anyone with the link links.

People in your organization links import as domain-based link permissions.

People you choose links import as user permissions.

An item in Workspace can only have one shareable link. When multiple links to the same item import, the service uses the most restrictive sharing setting. For example, if a SharePoint Online link is shared with Writer and Reviewer permissions, the link imports to Workspace with Viewer permission.

Files shared with external users

Shared with the same users in Workspace. External users also receive email notifications when new files or folders are shared with them.

You don't need to include external users in the identity map.

Document links inside documents

Unchanged

What's not imported?

  • SharePoint Online permissions on site folders.
  • SharePoint Online lists and webpages.
  • Files and folders with Restricted permissions.
  • Files and folders with Blocked Download policies in SharePoint Online.
  • Files and folders that are created (owned) by external users.
  • Any file or folder that was last modified by an external user.
  • Previous versions of files—only the latest version of a file imports.
  • Permissions for internal users and groups that aren't in your identity map.
  • SharePoint Online Personal Vault files.
  • SharePoint Online Favorites.
  • SharePoint Online folder shortcuts and colors.
  • SharePoint Online document expiration dates.
  • SharePoint Online file imports to a Workspace user's My Drive.
  • A single SharePoint Online file mapped to multiple users or groups in Workspace. You need to provide a one-to-one or many-to-one mapping.


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.