How to upload Excel to Google Sheets automatically
Microsoft Excel has dominated the spreadsheet world for decades, but many users are now moving to Google Sheets. Sheets is great for collaboration. As it’s an online application, anyone can access a spreadsheet via their browser, multiple users can work in the same sheet and you see what’s happening with your data in real-time.
If your team is transitioning to G Suite, you might have a large number of spreadsheets to move from XLS to Google Sheets format. If you prefer G Sheets but work with colleagues, clients or customers who still use Excel, it can be time-consuming to repeatedly convert files manually.
Some companies restrict their employees to using Excel and insist that staff only share files as attachments. At other times it comes down to personal preference: some people prefer to use Excel for heavy data processing before transferring that data to Google Sheets for collaboration. Sometimes you need Google Sheets as an input source for other software, such as Google Data Studio.
Whatever your reason for needing to upload Excel files to Google Sheets, here’s how to create a seamless, automated system to sync the two.
- Upload and convert Excel files to Google Sheets automatically
- Any changes in your Excel files are saved in your Google Sheets files
- Schedule automatic updates as frequently as you need
How to upload Excel to Google Sheets
Step 1: Install Sheetgo
Install Sheetgo here. Note that you can sign in with either your Google account or your Dropbox account.
This means that, if you have your Excel files stored in Dropbox, you can directly upload and connect them to Google Sheets with Sheetgo.
Step 2: Upload Excel to Google Drive automatically
If you do not store your Excel files on Dropbox, go through the following steps to upload them automatically to your Google Drive:
Rather than moving the Excel files to Google Drive manually, one by one, you can automate this process by using Google’s Backup and Sync software.
Just store the Excel files you want to upload in the same folder on your computer, then select this folder to automatically upload to your Drive using Backup and Sync.
Go to Google Drive > Computers > Select folder.
Select the folder containing your Excel files and right-click to add it to your Drive.
Your Excel files are now easily accessible from either inside your Google Drive or straight from Dropbox. The next step is to create a connection between your Excel file and Google Sheets.
To do so, click on Connect from inside Sheetgo.
Firstly, select the Excel file and its specific tab you want to upload to Google Sheets as your data source.
Step 4: Select your data destination
After selecting your data source, move to the next step and select the Google Sheets you want to upload your Excel file to.
Let Sheetgo automatically create a new Google Sheets for you, and choose in which destination storage it should enter, or select one of your existing Google Sheets files as data destination.
Click on Finish and save to create the Excel to Google Sheets connection in Sheetgo. In doing so, Sheetgo transfers the selected Excel tab to your Google Sheets file.
Step 5: Automate your workflow
Finally, automate your Excel to Google Sheets workflow.
Click on Automate on the floating bar and choose to set the automatic updates frequency to hourly, daily, weekly, or monthly.
Your automated Excel to Google Sheets system is up and running.
You have now set up automatic uploads between Excel and Google Sheets — using Sheetgo and its connection builder from Google Drive to Google Drive or Dropbox to Google Drive.
If you want to do this the other way around (automatically convert Google Sheets to Excel) — just take a look at this blog post.