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 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.


Download Practice Workbook

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


2 Easy Steps to Import Data into Excel from Web

Let’s assume we have an Excel large worksheet that contains the 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.

import data into excel from web


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 e browser.
  • Then go to your desired site to copy the URL for importing data.
  • For our convenience of our work, we will go to 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 below screenshot.

Copy the URL to Import Data into Excel from Web


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

Undoubtedly, import 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.

Use From Web Command to Import Data into Excel from Web

  • 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.

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

  • 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.

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

Read More: How to Import Data into Excel from Another Excel File (2 Ways)


Things to Remember

➜ While a value can not 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.


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.


Related Articles

Md. Abdur Rahim Rasel

Md. Abdur Rahim Rasel

Hi! I'm Md. Abdur Rahim Rasel. Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed my graduation in Naval Architecture and Marine Engineering(NAME) from Bangladesh University of Engineering and Technology(BUET). I have a passion for learning new things with my knowledge through perseverance and hard work.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo