DOWNLOADING DATA FROM THE WEB

Published: 01 January 1970
on channel: Akerele Oluwasogo (Mr Excel)

Excel Video: How To Download Table Of Data From The Web

Emmanuel wants to analyze some data from a website, so he typed the URL on the google and copy the data manually from the website

If you merely copy and paste data from a web page to Excel, you sometimes find the entire row of data is in one cell. (Using the Paste Special command will often also achieve this, but not always.)

You can easily import a table of data from a web page into Excel, and regularly update the table with live data.

Open a worksheet in Excel.

From the Data menu depending on version of Excel select Get & Transform Data . From Web (eg in Excel 2016) or Get External Data (eg in 2000) or Import External Data (eg in XP).

Fill in the URL of the web page with your desired data table. Excel will connect.

Choose a table and select Load.

In Excel 2000:Select New Web Query.

Fill in this dialogue with the URL of the web page, the table of data you want and the formatting you want to keep.

In Excel XP:

Select New Web Query.

Enter the URL of the web page from which you want to import the data and click Go.

Choose the table of data you wish to import, then click the Import button.

Choose how often you want to refresh the data.

In Excel 2016, From the Data menu select Queries & Connections. Right-click your table and select Properties then choose how often to refresh.

In Excel 2000, from the Data menu select Import External Data again, then choose Data Range Properties.

This method is also useful for capturing static data from a web site.

The data will be reliably imported into correct columns and rows in Excel.

Is the video helpful?

Kindly follow and subscribe to my YouTube channel Akerele Oluwasogo, GLMP (MR EXCEL)

Watch video DOWNLOADING DATA FROM THE WEB online without registration, duration hours minute second in high quality. This video was added by user Akerele Oluwasogo (Mr Excel) 01 January 1970, don't forget to share it with your friends and acquaintances, it has been viewed on our site 89 once and liked it 1 people.