How to Import Data into Excel from Web (with Quick Steps)

While working with large Microsoft Excel, sometimes we need to import data into Excel from the web. Importing data from the web is an easy task. This is a time-saving task also. Today, in this article, we’ll learn two quick and suitable steps to import data into Excel from the web effectively with appropriate illustrations.

Import Data into Excel from Web: 2 Easy Steps

Let’s assume we have a Excel large worksheet that contains information about several sales representatives of Armani Group. The name of the sales representatives, their Identification Number and the Revenue Earned by the sales representatives are given in Columns B, C, and D respectively. We can easily import data from the web by using the From Web command. Here’s an overview of the dataset for today’s task.

Step 1: Copy the URL to Import Data into Excel from Web

First of all, copy the Uniform Resource Locators (URL) from where we will copy our data. To do that, follow the instructions below to copy the URL from the web!

Firstly, open the browser.
Then, go to your desired site to copy the URL for importing data.
For the convenience of our work, we will go to the Exceldemy.com site to copy URL for importing data. To copy the URL, press Ctrl + C on your keyboard simultaneously which has been given in the screenshot below.

Step 2: Use From Web Command to Import Data into Excel from Web

Undoubtedly, importing data into Excel from the web is an easy task. To do that, follow the instructions below to insert data into Excel from the web!

First of all, select a cell. From our dataset, we will select cell B15 for the convenience of our work.

After selecting cell B15, from your Data tab, go to,

Data → Get & Transform Data → From Web

As a result, a dialog box named From Web will appear in front of you.

Hence, From Web dialog box, paste the URL under the URL inserting box. The URL is,

https://www.exceldemy.com/due-date-formula-in-excel/

At last, press OK option.

After pressing OK, a window named Navigator will appear in front of you. From the Navigator window, firstly, select Web view. Secondly, press Load option.

After pressing the Load option, Power Query transforms the data and loads it as an Excel table.
After completing the above process, you will be able to import data from the web which has been given in the below screenshot.

Things to Remember

➜ While a value cannot be found in the referenced cell, the #N/A error happens in Excel.

➜ If you want to copy data in Excel, simply press Ctrl + C on your keyboard, and to paste the copied data, press Ctrl + V.

Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.

Import Data.xlsx

Conclusion

I hope all of the suitable methods mentioned above to import data into Excel from the web will now provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.

<< Go Back to Web Scraping in Excel | Importing Data in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!