Forum Discussion

Zeta Blignault's avatar
Zeta Blignault
Copper Contributor
Feb 16, 2018

EXEL Data tab " From web tab" in exel

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.

excel

1 Reply

  • Damien_Rosario's avatar
    Damien_Rosario
    Silver Contributor
    Feb 19, 2018

    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

     

Resources