If you are wondering how to save Google Sheets file to SharePoint, there’s no direct integration, but it can be done quickly with an appropriate method. Here, you will learn how to transfer Google Sheets to SharePoint with intact formatting simultaneously.
Let’s get started:
Why You Might Need This
Here are a few common reasons I’ve come across for saving Google Sheets files to SharePoint:
- Switching from Google Workspace to Microsoft 365.
- The organisation uses SharePoint for central document storage and access control.
- Want to keep all files, including Sheets, in a unified platform.
- Need to collaborate with users who don’t have access to Google Drive.
Whatever the reason, the thing is how to backup Google Sheets to SharePoint in one go. In the sections below, I’ll explain to you how to do so.
How to Save Google Sheets File to SharePoint Without Losing Data
When I needed to migrate Google data to SharePoint, I was surprised that there was no native solution provided by Microsoft or Google to proceed. Luckily, I researched and found several solutions, and among them, the most reliable ones are listed below:
Method 1. Download as Excel & Upload to SharePoint
This is an indirect method, but the most reliable method I use when I need to preserve formulas and formatting. In this, our first step is to download Google Sheets locally and then upload them to SharePoint. If you haven’t done this before, Google’s support article on how to download a Sheets file as Excel explains it clearly:
- Open the Google Sheets file.
- Now, click the File option. Then, Download and choose Microsoft Excel (.xlsx) as the output format.
- The file will download to your computer.
- Now, open the SharePoint site to import Excel to SharePoint List or Document Library.
- Open the Document Library.
- Lastly, click Upload > Files, and select the downloaded .xlsx file.
Let’s move to the next solution to solve how to save Google Sheets file to SharePoint, which is easier and quicker than this.
Method 2. Use Google Drive for Desktop + OneDrive Sync
Syncing Google and Microsoft services is better to avoid regular downloads and uploads. Here are the steps to do so:
- Install Google Drive for Desktop and sign in.
- Google Drive will appear as a virtual drive on the PC.
- Open the Google Sheets file via browser and download it as an Excel file.
- Move that file into your OneDrive sync folder that points to a SharePoint document library.
- If you haven’t set this up, use the OneDrive sync button in SharePoint to sync the library to your computer.
That’s all, now previous and newly arrived files which come to the folder will automatically sync to SharePoint.
Method 3. How to Save Google Sheets File to SharePoint Via Microsoft’s Migration Manager
Microsoft 365 Migration Manager is an enterprise-grade tool offered by Microsoft to migrate content from Google Workspace into SharePoint or OneDrive. I read Microsoft’s official guide on migrating Google files to Microsoft 365 with Migration Manager, and followed these steps:
- Install & authorise the Migration Manager agent in Google Workspace Admin.
- Connect the Microsoft 365 admin portal to Google Workspace.
- The tool scans Google Drive content, including Sheets, and shows detailed reports of the issues (if any).
- After reviewing scan results, configure the destination, SharePoint document libraries.
- Once the migration is launched, the tool copies all selected Google Sheets to the target SharePoint locations simultaneously.
Remember, this also converts Google Sheets to Excel and then uploads them to SharePoint automatically.
If you’re considering bulk or tenant-level transfers, you can also explore the SharePoint Migrator Solution as an alternative to Migration Manager for some advanced scenarios.
Method 4. Use Microsoft Power Automate
I tried creating a workflow in Power Automate to transfer files from Google Drive to SharePoint. But, honestly, I failed 2 times, so opt for this only if you are familiar with technicalities:
To answer how to save Google Sheets file to SharePoint automatically, follow this setup:
- Update SharePoint Online Management Shell
- Use the Google Drive connector as the trigger.
- Add an action to convert the file.
- Then use the SharePoint connector to upload the file to a document library.
- Requires an active license
Method 5. Manually Share a View-Only Link (Alternative)
In some cases where I didn’t want to convert or download the file, I added the link to the document in SharePoint as a workaround by following these steps:
- Open the Google Sheets file.
- Click the Share option.
- Then hit the Get link option, and then select Anyone with the link can view.
- Copy the link.
- In SharePoint, create a Link item in your document library or add the link to a page.
This solution can be used by any skill level of users, as it doesn’t require any technical expertise. However, sometimes, I experienced Excel links broken after migration to SharePoint.
How to Save Google Sheets File to SharePoint Smoothly – Best Practices
While we have the best options with easy instructions, it is still necessary to follow some best practices to make the task hassle-free and smooth:
- Always check formatting after conversion. Sometimes merged cells or formulas don’t convert cleanly.
- Use version control in SharePoint. This helps in case someone edits the Excel file later.
- Communicate with your team about changes.
Author’s Verdict
Today, we’ve learned how to save Google Sheets file to SharePoint, and now you can easily access your files in SharePoint. Additionally, I prefer downloading as Excel, and uploading it directly is the best, as it confirms zero data loss.
People Also Ask
- Can I upload Google Sheets directly to SharePoint?
No, SharePoint doesn’t natively support .gsheet files. You need to download them as Excel files first.
- Will all formatting and formulas be preserved when converting to Excel?
Most formulas and formatting are preserved, but it’s best to double-check charts, conditional formatting, and custom functions.
- Can I edit the file after uploading to SharePoint?
Yes, once it’s converted to Excel and uploaded, you can edit it directly using Excel Online or the desktop app.
- Do I need a Google Workspace account to download the file?
Yes, you need access to the Google Sheet to download it. Make sure the owner has shared the file with you.