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

In this article we’ll demonstrate two quick steps to import data into Excel from the web.

Suppose we have a large Excel worksheet that contains information about several sales representatives. Let’s import data from the web into this dataset using the From Web command.

import data into excel from web


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

First we need the Uniform Resource Locator (URL) from where we will copy our data. For this example, we will use the data on a page on Exceldemy.com.

  • Open a browser.
  • Go to the site from which we will copy our data.
  • Select the URL in the address bar and press Ctrl + C on your keyboard.

Copy the URL to Import Data into Excel from Web


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

  • Select cell B15.

Use From Web Command to Import Data into Excel from Web

  • Go to Data → Get & Transform Data → From Web

A dialog box named From Web will appear.

  • Paste the URL into the URL box:

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

  • Click OK.

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

A window named Navigator will appear.

  • From the Navigator window, select Web view then Load.

Power Query transforms the data and loads it as an Excel table.

After completing the above process, data will be imported from the web as in the image below.

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


Things to Remember

➜ If a value cannot be found in the referenced cell, a #N/A error will occur.

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


Download Practice Workbook


Related Articles


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

Get FREE Advanced Excel Exercises with Solutions!
Md. Abdur Rahim Rasel
Md. Abdur Rahim Rasel

MD. ABDUR RAHIM is a marine engineer proficient in Excel and passionate about programming with VBA. He views programming as an efficient means to save time while managing data, handling files, and engaging with the internet. His interests extend to Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning, reflecting his versatile skill set. He earned a B.Sc in Naval Architecture & Marine Engineering from BUET, and now he has become a content developer, creating technical content... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo