How to Add Google Sheets to SharePoint
SharePoint is Microsoft’s popular content-managing app. For that reason, a lot of people use it to tidy up their documents and other files online.
All of which is convenient until you stumble upon a common problem. How to organize your G-Suite documents such as Google Sheets in SharePoint? The two platforms are incompatible, right?
Luckily, that’s only a minor issue. Google allows you to convert these files and add them to your SharePoint library in an instant. This article will explain how to do it.
Step 1: Download (Convert Sheet to Excel Automatically)
Although you can’t add a Google spreadsheet to SharePoint directly, you can still convert it before uploading.
Believe it or not, you can download any file from your Google Drive to your computer. If it’s a Google Sheet, it will automatically convert to a Microsoft Excel file.
Since Excel is a part of Office 365, you can simply upload it to SharePoint afterward.
But first, let’s find out how to download it.
- Go to your Google Drive (make sure that you’re logged to your account).
- Click on the arrow next to the “My Drive” to the left. A dropdown menu with your folders will appear.
- Search for your desired spreadsheet.
Note: You can use the search bar above the Quick Access bar to locate a single spreadsheet.
- Right-click on the desired file.
- Click “Download”.
Google Chrome will download the to your designated “Downloads” folder. It will keep the same name as the original file, but it’ll automatically convert to XLSX (Microsoft Excel’s File Format).
Downloading Multiple Files
It’s possible to download multiple files from your Google Drive at the same time.
This is especially convenient if you want to move a large number of documents from Drive to SharePoint.
For instance, if you’re migrating your entire Team Drive to Office 365, this is the easiest way to transfer everything with a few clicks.
All G-Suite files will convert to their Microsoft Office counterparts in the process. Follow these steps:
- Open Google Drive.
- Open a folder with the desired files.
- Press and hold CTRL.
- Click each file that you want to download (while holding the CTRL key).
- Right-click the last file that you want to download (while all previously selected files are highlighted).
- Press “Download”.
If you want to download the entire folder, just right-click on the folder and select “Download”.
You’ll notice that Google Drive downloaded all the files into one single ZIP file. So you’ll have to unzip them into a separate folder before you can upload them to the SharePoint.
Upload Files to SharePoint
If all your documents are SharePoint-compatible, you’ll be able to move them to the app easily.
- Open the SharePoint on your browser.
- Click the “Documents” button at the left side of the screen.
- Press the “Upload” button above the Documents list.
- Locate your spreadsheet (now Excel document).
- Upload to SharePoint.
Note: You can also use the CTRL + left click method to select multiple files and upload them at the same time.
On the other hand, you can also simply use the-drag-and-drop method to add the files to SharePoint.
Just open the folder with the files, select them with the mouse, and move them to the SharePoint in your browser.
Either way, your spreadsheet will remain in the app, only this time as an Excel file.
As you see, you can use Microsoft SharePoint with Google’s G-Suite with no issues. That’s because your Chrome will convert any G-Suite file into it’s Microsoft counterpart.
Therefore, if you ever want to add any other Google file to SharePoint, don’t hesitate to use the same methods outlined above.
Download a Google Doc, Sheet, Slide, or anything else, and you’ll convert it to a Word, Excel, PowerPoint, or another document. That way, you’ll easily transfer it to SharePoint for further use.
Do you like this convenient feature? Are you a G-Suite or an Office Suite user? Why? Share your opinions below.