In some cases, we need to add some information from a website to an Excel sheet that changes frequently. To save time and energy, it’s better to connect a website to an Excel sheet directly instead of extracting information again and again. In this article, you will learn 2 methods to link a website to an Excel sheet with ease.
Download Practice Workbook
You can download the Excel file from the following link and practice along with it.
2 Methods to Link a Website to an Excel Sheet
1. Use Power Query to Link a Website to an Excel Sheet
You can use the Get & Transform Data which is also known as Power Query to create a dynamic link between a website and an Excel sheet.
Now follow the steps below to create a connection between a website with an Excel sheet.
❶ First of all, go to the Data tab.
❷ Then click on From Web in the Get & Transform Data group.
A dialog box named From Web will appear.
❸ Insert a website link in the URL box that you want to connect to.
❹ Then click OK.
Then the Navigator window will appear.
If the webpage link that you have inserted contains tables, they will all appear in a list.
❺ Select any table that you want to insert into your Excel sheet.
❻ After that, click on Load To from the Load drop-down.
Then a dialog box named Insert Data will appear.
❼ Choose New Worksheet and click OK.
After that, you will see the table has been loaded to your Excel sheet. And a link has been built between the webpage and your Excel sheet.
To make your Excel sheet updated with the website data,
Go to the Data tab and click on Refresh All command from the Refresh All drop-down.
2. Use Link Command to Link a Website to an Excel Sheet
If you want to insert a hyperlink to an Excel sheet with a website link, follow the steps below:
❶ At first, select the cell where you want to insert the hyperlink.
❷ Then go to the Insert tab.
❸ From the Links group, click on Link.
A dialog box called Insert Hyperlink will appear.
By default, you will be in the Existing File or Web Page tab.
❹ insert a website link in the Address section under the Current Folder.
❺ Then you can insert a title for the hyperlink in the Text to display box.
❻ After that, click Ok.
Finally, you will see that your specified website link has been inserted into the particular cell that you’ve selected before.
You will get an Excel sheet like the following screenshot, at the end of the provided Excel file. Where you can practice all the methods discussed in this article.
To sum up, we have discussed 2 methods to link a website to an Excel sheet. You are recommended to download the practice workbook attached along with this article and practice all the methods with that. And don’t hesitate to ask any questions in the comment section below. We will try to respond to all the relevant queries asap. And please visit our website Exceldemy to explore more.