EXEL Data tab " From web tab" in exel

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