Transfer Google Drive to SharePoint Online for IT Administrators

ⓘ Fact-checked and reviewed in accordance with our Editorial Policy

User Query: “Although the tool continues to fail, we still need to move 800 GB of Google Drive data over to SharePoint Online. A second team has 330 GB spread over many folders, and its current permissions should stay unchanged. SharePoint upload throttling reportedly sits near 0.75 GB per hour, implying roughly 440 hours or 18 days. Therefore, which migration approach ensures reliable transfer and preserved permissions quickly?”

  • r/sysadmin

Introduction: 

Google Drive is Google’s cloud storage solution for Google Workspace, whereas Microsoft’s SharePoint Online offers cloud storage capabilities for Microsoft 365. Due to the platforms’ dissimilarity in relation to storage solutions, the process of migration can be complicated, resulting in suspended transfers, improper hierarchy organization, loss of vital files, and restricted access permissions. These issues delay tenant consolidation and leave users without the required files. This guide explains how to transfer Google Drive to SharePoint Online manually, with Microsoft Migration Manager, or using the SysInfo Google Workspace Backup Tool.

Why Organizations Migrate Google Drive to SharePoint?

Most organizations migrate due to the several tenant features and flexibility in Microsoft 365. These features provide options to easily scale, manage, and improve:

  • Centralized management: Sites and libraries.
  • Microsoft 365 integration: With Teams, Outlook, and Office.
  • Tenant-level governance: Retention, labels, DLP, and audit logs.
  • Control permissions: Access control down to the file level.
  • Pooled storage: 1 TB + 10 GB per user.
  • Site limit: Each site is read-only at 25 TB.
  • Large libraries: 30 million files and folders each.
  • Large files: Upload up to 250 GB/file.
  • Version history: 500 (default) up to 50,000.
  • DLP protection: Detects sensitive data.
  • Preservation Lock: Retention policies cannot be shortened or disabled.
  • Audit logs: 180 days, up to 10 years (Premium).

You can read more precise and detailed plans and limits for specific parameters in SharePoint on Microsoft Learn.

Google Drive vs. SharePoint Online: Key Differences

Google Drive is the cloud storage service of Google Workspace. It organizes files through My Drive and Shared Drives and focuses on simple folder-based sharing.

SharePoint Online manages documents within Microsoft 365. It structures content using sites and libraries while providing governance, metadata, and detailed permissions.

Aspect

Google Drive

SharePoint Online

Organizing unit

Drives and folders

Sites and libraries

Max file size

5 TB

250 GB

Library capacity

500,000 items per Shared Drive

30 million files and folders

Storage cap

Pooled organizational storage

25 TB per site

Version history

Non-native: 30 days/100 versions

500 default, up to 50,000

Permissions

File and folder sharing

Inherited, unique when needed

Therefore, duplicating the Drive structure exactly rarely works well in SharePoint. Google-native files must also be converted to Office formats when you transfer Google Drive to SharePoint Online.

Pre-Migration Checklist

  1. Inventory data: Record size, file count, distribution.
  2. Clean source: Remove duplicate files.
  3. Check names and paths: Fix unsupported characters, long paths.
  4. Plan destination: Create sites, libraries, groups.
  5. Verify admin access: Admin rights on both tenants.
  6. Check storage: Confirm enough free tenant space.
  7. Back up source: Keep a restorable copy.
  8. Run pilot: Test with a few accounts.

Methods to Transfer Google Drive to SharePoint Online

In the current section of this blog, we will discuss three different methods for the migration. Each method reflects its approach, steps, and limitations. Each method has its scenario where it is more appropriate; let’s get to know each and choose the most suitable one according to our needs.

Method 1: Manual Download and Upload

This is the simplest method, in which we just have to download the files from Google Drive to a local system and then upload them to the SharePoint document library. This method is best for small migrations.

Steps to Transfer Google Drive to SharePoint Online:

  1. Open Google Drive
  2. Select the files or folders, and choose Download (ZIP files).
  3. Extract the ZIP.
  4. Open the SharePoint site and go to the document library.
  5. Select Upload, choose the files/folders, and wait for completion.
  6. Verify and review access.

However, it does not preserve sharing permissions, produces no migration report, cannot process multiple accounts together, and gives no way to pick up changes made after the download.

Limitations during transfer Google Drive files to SharePoint Online :
  • Files over 250 GB cannot be uploaded.
  • Large browser uploads may time out.
  • Original author and timestamps are not preserved.
  • Google sharing permissions do not carry over.
  • Inheritance cannot be broken in libraries or folders above 100,000 items, which limits permission fixes afterward.
  • No incremental sync for changes made after download.
  • No migration reports to track failed files.

Method 2: Microsoft Migration Manager

The Microsoft 365 admin center comes with Migration Manager, an integrated solution for importing Google Workspace content into SharePoint and OneDrive. Despite Migration Manager being fit for enterprise-level transfers, it possesses a series of significant limitations, one of which is an unchangeable migration endpoint.

Steps to Transfer Google Drive to SharePoint Online:

  1. Open Migration Manager and select the Google Workspace option.
  2. Install the Microsoft 365 migration app from the Google Workspace Marketplace through a domain install.
  3. Sign in to Google Workspace and add the drives to scan.
  4. Scan the drives and review the scan report.
  5. Set the SharePoint destination for each task.
  6. Review the identity mapping between Google and Microsoft 365 accounts.
  7. Start the migration and download the report afterward.

This approach handles larger volumes than manual transfer. It is required to perform setup, and destinations cannot be changed once a task is running, 

Limitations during Google Drive to SharePoint Online Migration:
  • Tasks: Keep each task under 100,000 items or 1 TB.
  • Concurrency: Only 50 drive tasks run at once.
  • Scan list: 50,000 tasks.
  • File size: Files above 250 GB are not migrated.
  • Path length: Destination URLs over 400 characters are not migrated.
  • Destination: The destination locks once migration starts.
  • Permissions: File-level permissions are off by default.
  • Excluded content: Google Sites and Maps are not migrated.
  • Sharing: External sharing links and collaborators are not recreated.

Method 3: Professional Approach using SysInfo Google Workspace Backup Tool

Organization needs: not for an individual but for multiple accounts, filtering, etc. The Google Workspace Backup Tool offers a professional approach to migrate files from Google Drive. It runs on the local machine through Google and Microsoft APIs, so your credentials will not be stored. Moreover, it supports domain-level authentication, bulk processing, mapping, advanced filters, size filters, etc. Additionally, it also provides a demo version to evaluate it yourself.

Steps to Move Files from Google Drive to SharePoint Online:

  1. Launch the tool and choose Google Drive Migration from the dashboard.
  2. Connect the Google source. Then, select the users and click Continue.
  3. Choose SharePoint Online as the destination under the Email Client tab.
  4. Connect the Microsoft 365 admin account, and map the source and destination.
  5. Configure the migration filters and start the migration. 

You can go through the software guide to get detailed steps and multiple feature options provided within the tool.

Conclusion

A structured migration plan to transfer Google Drive to SharePoint Online is required for seamless migrations. Manual transfer suits small datasets or some large datasets. A dedicated tool like Google Workspace Backup Tool handles larger, multi-account projects more reliably. Moreover, it is specially designed to perform bulk migrations with its advanced features, providing high flexibility and allowing you to modify migration processing according to your requirements.

Frequently Asked Questions

Q1. How do I transfer Google Drive to SharePoint Online without losing files?

Ans: A dedicated tool is recommended to use for the migration. But it is better to follow the pre-migration checklist first. Then migrate using it without losing files.

Q2. Will transferring Google Drive files to SharePoint Online preserve the original folder hierarchy?

Ans: In the SysInfo G Suite Backup Tool, enable the Preserve Folder Hierarchy option, which will preserve your folder hierarchy.

Q3. How do I migrate Google Drive files shared with specific users or groups?

Ans: Include the Shared With Me section and map each source account to its Microsoft 365 account. Afterward, review access on the migrated content, since Google roles and SharePoint permission levels do not match exactly.

Q4. How long does a Google Drive to SharePoint Online migration take?

Ans: It depends on several factors such as data volume, file count, bandwidth, and throttling on both platforms. Many small files generally take longer than fewer large files, so a pilot gives the most reliable estimate.

Q5. Can I preserve file metadata, timestamps, and ownership during migration?

Ans: The Google Workspace backup tool preserves all of it. At the same time, when using the migration method, SharePoint establishes ownership of objects based on sites and libraries.

Q6. How can IT administrators migrate multiple Google Drive accounts to SharePoint Online in bulk?

Ans: Connect through Workspace Admin (DWD) of dedicated software with a JSON or P12 key, then map accounts using Quick Actions or a CSV file. This avoids individual logins for every user.

Q7. What security checks should businesses perform before migrating Google Drive data to SharePoint Online?

Ans: Audit files and remove access held by former employees. In addition, confirm admin roles and use OAuth 2.0 or DWD authentication, which keeps credentials secure.

Q8. What is the best way to migrate Google Drive to SharePoint Online?

Ans: The best way to migrate is to use a specialized tool for the migration. Reason behind is that these tool are built for these specific tasks which can handle them in bulk and becomes reliable method.

Q9. Can I migrate Google Drive files modified within a specific date range?

Ans: Yes. The Date Range filter of professional software provides two fields: start and end dates. You need to set them, and the tool will filter for the range and migrate them.

Q10. Can duplicate Google Drive files be removed during SharePoint Online migration?

Ans: Yes. You can remove the duplicates easily on the basis of different parameters. This tool also provides migration in a secure and seamless manner.

Rate this post

About The Author:

Simran Bhatia is a technical content writer engaged in writing clear, concise, and SEO-optimized content. With a background in computer science and a passion for writing, I thrive to deliver complex technical content in simple layman terms.

Related Post