How to Link a Website to an Excel Sheet (2 Methods)

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.

Use Power Query to Link a Website to an Excel Sheet

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.

Navigator window: Use Power Query to Link a Website to an Excel Sheet

Then a dialog box named Insert Data will appear.

❼ Choose New Worksheet and click OK.

Import Data dialog box: Use Power Query to Link a Website to an Excel Sheet

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.

Use Link Command to Link a Website to an Excel Sheet

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.

Insert Hyperlink dialog box: Use Link Command to Link a Website to an Excel Sheet

Finally, you will see that your specified website link has been inserted into the particular cell that you’ve selected before.


Practice Section

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.


Conclusion

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.

Mrinmoy

Mrinmoy

Hi! I'm Mrinmoy Roy. I'm an Excel and VBA content developer. I write blogs relating to Microsoft Excel on Exceldemy.com. I've completed my graduation in Electronics and Communication Engineering from Khulna University of Engineering & Technology. I've expertise in Excel functions, formulas, Pivot Table, Power Query, Visual Basic, etc. I write blogs to lessen people's hassles while working on Microsoft Excel.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo