Import Data from Webpage in Excel



I am trying to import a table from into Excel. When i use the Import Data from Web option, no table is detected by Excel. If I try to transform the data, it takes me down a rabbit hole and still I am not able to retrieve the data.

However,  when I tried the same with Power BI Desktop, the same worked perfectly.

Can anyone tell me how to import such data in excel? (Screenshots Attached)

Thank you.

4 Replies


Power Query for Excel is bit behind the one for Power BI Desktop. That's only wait when Web.BrowserContents will be added to Excel version.

Thank you.
Is there still any other method via which I can import this data in Excel?


Sorry, I don't know the way

thank you once again Sergei.