Forum Discussion

TJReis's avatar
TJReis
Copper Contributor
Aug 03, 2021

Excel get data from web help

Hi I'm trying to figure out why the data from web isn't working. So i click data tab on excel then click "from web". When i enter the URL it shows an empty table. Some websites were working before and would show the data, but no websites work now.. is there something I'm doing wrong? The image attached shows what appears when trying to use data from web option.

Excel for web

1 Reply

  • ExcelExciting's avatar
    ExcelExciting
    MVP
    Aug 03, 2021

    Hi TJReis,

     

    The data currently you are trying extract from the web do not have any table, you need to drill down children table to extract right information, but if you are using PowerBI it already have smart feature to extract such information just by giving examples.

     

    Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

    If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.

Resources