For the last 10 years, the interest in spreadsheet software has pivoted. Microsoft Excel, which had been the undisputed trendsetter since the early 1990s, yielded the palm to Google Sheets, a lightweight and web-based alternative.
However, this doesn’t mean that Excel remains a spreadsheet software just for offline work. Users can store their XLSX files on OneDrive, Dropbox, Google Drive, and other cloud document storage services. And, one day, they may need to convert their Excel data to Google Sheets. Why? Reasons differ, but the data transfer flow is mostly the same:
- Download an Excel file to a device.
- Upload an Excel file to Google Sheets.
In this blog post, we’ll show you an alternative way free of any download/upload activities. You’ll be able to schedule data import from Excel to Google Sheets. Interested? Here we go then!
Excel stored on Google Drive to Google Sheets
Google Sheets provides a number of native functions to import different data, such as IMPORTDATA for CSV, IMPORTHTML for HTML and others. But there is no function to import Excel data. So, you’ll need to use a third-party solution – Coupler.io. It’s an importing tool to retrieve data to Google Sheets from CSV and Excel files, as well as apps, such as Airtable, Xero, QuickBooks, and many more. Check out all available Google Sheets integrations.
Let’s use it to synchronize your Excel Workbook on Google Drive to Google Sheets. You need to sign in to Coupler.io (you can do this with your Google account), click Add New Importer and select the source and destination applications, in our case:
- Google Drive is a source
- Google Sheets is a destination
Click Proceed to complete the setup:
- Name your importer
- Click Connect to connect a Google account.
- Select an Excel file on your Google Drive and a tab to export data from.
Click Jump to Destination Settings.
Note: Optionally, you can select a range to export from the chosen Excel file. To do this, click Continue after you selected a spreadsheet and a sheet.
- Click Connect to connect your Google account to connect.
- Select a spreadsheet and a sheet to synchronize your Excel Workbook with. You may enter the name of a non-existing sheet, and Coupler.io will create it for you.
- Click Continue to configure the optional parameters, Cell address and Import mode.
By the way, you can easily change the destination and get your data, for example, from Google Drive to Excel.
Here you can configure the schedule for automatic data imports. For example, the data from your Excel file will be refreshed every hour or every week. To do this, toggle on the Automatic data refresh and customize the schedule:
- Days of week
- Time preferences
- Time zone
When ready, click Save and Run. After that, you can jump right to your Google Sheets doc if you click View Results.
If you need to import CSV from Google Drive to Google Sheets, the flow will be mostly the same.
Excel stored on OneDrive to Google Sheets
Let’s import data from an Excel Workbook on OneDrive to Google Sheets.
Coupler.io provides a ready-to-use Excel integration to load data from OneDrive. The setup flow is similar:
- Set up source
- Set up destination
- Set up schedule (if automation is needed)
However, you’ll need to choose Microsoft Excel as the source, connect to your Microsoft account and select a file and sheet(s) to load data from.
Optionally you can also select a range in the workbook you want to export data from.
The destination setup won’t change. When you’re ready, click Save And Run and then View Results. Welcome your data from a OneDrive Excel file in Google Sheets.
How to transfer Excel files with multiple sheets to Google Sheets
In the example above, the Excel Workbook only has one tab. If you deal with an XLSX file that has two or more tabs, you’ll need to create a separate importer to load each Excel tab to a separate sheet in Google Sheets.
At the same time, Coupler.io allows you to merge sheets or tabs into one master view. To do this, you need to select them when setting up the source.
Read our guide on how to merge sheets into one for more.
Excel stored on Dropbox to Google Sheets
Dropbox is another popular cloud storage where you can store your XLSX files. With Coupler.io, you can import data from Excel and CSV files stored on Dropbox to Google Sheets.
The flow is similar to the ones above, but you’ll need to choose Dropbox as a source:
Then connect your Dropbox account, select an Excel file and a sheet to load data from. The rest of the flow you already know :).
The import of CSV from Dropbox to Google Sheets looks absolutely similar.
Do I need to sync Excel with Google Sheets?
If you manipulate refreshable datasets in Excel, you should definitely connect your Workbook to Google Sheets. With Coupler.io, you can customize the data refresh schedule, as well as specify the range of data to import. This is quite useful for reporting and sharing your data.
On the other hand, Coupler.io also provides Microsoft Excel as a destination, so you may want to connect different Excel workbooks or Dropbox to Excel.
What you can do is test the flow with Coupler.io and decide whether it is what you need. This won’t take much time and has no cost from your side. Your feedback is highly welcome, so feel free to fill out this form. Good luck with your data!Back to Blog