In this tutorial, you will learn how to import Google Sheets to Excel
How To Import Google Sheets To Excel
You may find yourself in a situation where you have data in a Google Sheet that you need to add to an existing Microsoft Excel project. Perhaps you are collaborating with a team on both Excel and Google Sheets and you need to integrate your data.
Whatever the reason, you can use Excel’s From Web feature to import data from a Google Sheet into Excel. This method has a great benefit over simply copy-pasting the data manually: the ability to refresh data automatically.
In this guide, we will show you how to import your Google Sheets data to Excel in just a few simple steps.
How To Add Data from Google Sheets To Excel
Here’s how to add data from Google Sheets to Excel.
First, open the Google Sheets document that you want to import into Excel.
Click on the Share button on the top-right of the current window.
In the Share dialog box, we must ensure that our Google Sheets document is accessible by a third-party user. Set the access to “Anyone on the internet with the link can view” if it is not already. Click on the Copy link button to save the shareable URL to your device’s clipboard.
Click Done to proceed.
Use any text editor to convert the URL into a format that works with Excel. This process simply requires replacing “edit?usp=sharing” with “export?format=xlsx”.
Next, open the Excel spreadsheet file that you want to import your data into. Click on the Data tab.
In the Data tab, click on the From Web option.
Paste the modified URL from earlier into the provided textbox. Click on OK to proceed.
Select the sheet you want to import into Excel. The dialog box will return a preview of the data you’ll be importing.
If the data looks right, click on the Load button.
Excel should now create a new sheet in the current spreadsheet that contains the imported data.
You can refresh the data by clicking on the Refresh icon in the Queries & Connections panel on the right.
This guide should be everything you need to import Google Sheets data to Excel.
You may make a copy of this example spreadsheet to test it out on your own.