How to get data from web into Excel

So instead of having to manually enter data, which is time-consuming and unprofessional, with this available tool, the data content from the web will appear immediately in Excel. The following article will guide you to get data from the web into Excel.

Instructions for getting data from the web into Excel

Step 1:

At the Excel interface, click on the Data tab and then click on the From Web tool as shown below.

How to get data from web into Excel Picture 1

Step 2:

Now the interface is displayed for you to enter the website URL that we want to get data from. You will have 2 options: Basic with entering the website link.

How to get data from web into Excel Picture 2

And the Advanced option has more settings.

How to get data from web into Excel Picture 3

Here we will click on the Basic option to paste the website URL we want to get data into Excel. Click OK to continue.

How to get data from web into Excel Picture 4

Step 3:

Immediately after that, the Navigator interface appears, click on Table to display the data table on the website or click Document to view the data.

How to get data from web into Excel Picture 5

Then we will see the data displayed as shown below. Click Load to dump the data on the website to Excel.

How to get data from web into Excel Picture 6

Step 4:

We wait a moment for the data to display in Excel as shown below.

You proceed to change the data table interface, edit the font and color of the data table as usual and you're done.

How to get data from web into Excel Picture 7

How to update data in Excel from website

After inserting data from a website into Excel, in some cases, you also need to update the data from the original source. You can do it in 2 different ways.

Method 1: Update Excel data from the web

At the interface in Excel, click on the Data tab and then click on the Refresh All command or press the shortcut key combination Ctrl + Shift + F5.

The data will then be updated according to the data from the website.

How to get data from web into Excel Picture 8

Method 2: Update Excel data from the web automatically

Step 1:

First, click on the current data table and then click on the Query tab .

How to get data from web into Excel Picture 9

Step 2:

Then look down at the Edit group and click Properties to set up automatic data table update mode.

How to get data from web into Excel Picture 10

Step 3:

Display the interface, here you will check Refresh Every and then enter the number of minutes you want to automatically update the data . In addition, you can also check Refresh data when opening the file to update the data every time you open this table.

How to get data from web into Excel Picture 11

Marvin Fry

Update 29 October 2024