EXEL Data tab " From web tab" in exel

[Zeta Blignault]

Hello, I am trying to link a web page to a workbook and when I go to a website instead of going to the tab where I can insert the url: I get a website page. It is hard to explain here are some pics of what I want to do.  The pathway is "data tab" then I select " from web tab"

The first two is what I want to do the second one is were I end up on.

[#2]

Hi Zeta

Try this:

1. Go to Data tab.
2. Drop down New Query menu > From Other Sources > From Web.
3. Enter your desired URL https://en.wikipedia.org/wiki/UEFA_European_Football_Championship
4. Click OK. Let Excel connect to the site.
5. Click onto the table you want to save (e.g. like in your image, Results).
6. Click onto the drop own for Load button (bottom right).
7. Choose Load To...
   

1. In the Load To box, choose where you want to save the Table (e.g. to the current sheet or a new worksheet).
2. Click onto the Load button.
3. Your desired data should appear in a formatted table.

I hope that is what you are after. I've also attached the end result for your viewing.

Please let us know if you still need assistance?

Cheers

Damien