When it comes to importing the data from Microsoft Excel to Google Sheets and vice versa, most of us do it by uploading the Excel file to Google Drive and downloading the Google Sheets in Microsoft Excel format, or simply by copying and pasting the data. It is a time-consuming process, as you have to do it every time you make any changes to either Excel file or Google Sheets. In this article, we will see how you can import data from Excel to Google Sheets and vice versa automatically. This is a two-way integration between Google Sheets and Microsoft Excel.
How to Export or Import Data from Excel to Google Sheets
You can link Google Sheets with Microsoft Excel by creating a web query in Excel. But this is only one-way integration which means that the changes made to Google Sheets will automatically be updated in Excel but the changes made in Excel will not be updated in Google Sheets automatically.
If you want to establish a two-way integration between Google Sheets and Microsoft Excel, go through the following instructions.
- Download Google Drive for Windows.
- Install Google Drive for Windows on your computer.
- Create a new Excel file inside Google Drive on your File Explorer.
- Open the Excel file that you have just created and enter your data.
- Save the Excel file and close it.
- Open Google Sheets in your web browser. There you will see the spreadsheet that you have created on your computer.
- Open that spreadsheet in Google Sheets and you will see all the data that you have entered in the Excel file.
Now, let’s see all these steps in detail.
1] Download Google Drive for Windows.
2] Double-click on the installer file to install Google Drive on your Windows computer. After successful installation of Google Drive, open it and sign in by entering your Google Account credentials. After signing into Google Drive for Windows, wait till it completes synchronization. After that, you will see that a hard drive named Google Drive has automatically been created in File Explorer.
If Google Drive is not added to your File Explorer, you have to add it manually.
3] Now, double-click on Google Drive in File Explorer to open it. There, you will see a folder named My Drive. Double-click on it to open it.
4] Now, right-click in the empty space and go to “New > Microsoft Excel Worksheet.” If this option is not available, open Microsoft Excel on your computer, create a new worksheet, and save it in Google Drive on your computer.
5] Open the newly created Excel Worksheet, enter your data, and save it. After that, open Google Sheets. You will see that the Excel file you have created on your computer has automatically been added to the Google Sheets.
The two-way integration between Google Sheets and Microsoft Excel has been established. From now, all the changes you make in Google Sheets will automatically be updated in Microsoft Excel and the changes that you make in Excel will automatically be updated in Google Sheets.
Can Google Sheets retrieve data from Excel?
Google Sheets can retrieve data from Excel. For this, you have to download and install Google Drive on your computer and then create an Excel file in Google Drive on your computer. After that, Google Sheets will start retrieving data from that Excel file.
How do I auto-pull data in Excel?
You can auto-pull data in Excel from Google Sheets either by creating a web query in Excel or by installing Google Drive on your computer. The former method is the one-way integration between Excel and Google Sheets, whereas the latter method is the two-way integration between Excel and Google Sheets.
Hope this helps.