Import Data from Webpage in Excel

Highlighted
Occasional Contributor

Hello...

I am trying to import a table from https://coinpaprika.com/tag/gaming/home-overview 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
Highlighted

@Jodhvir 

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.

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

@Jodhvir 

Sorry, I don't know the way

Highlighted
thank you once again Sergei.