Forum Discussion

Jodhvir's avatar
Jodhvir
Brass Contributor
Sep 13, 2020

Import Data from Webpage in Excel

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.

excel
power bi

4 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Sep 13, 2020

    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.

    • Jodhvir's avatar
      Jodhvir
      Brass Contributor
      Sep 13, 2020
      Thank you.
      Is there still any other method via which I can import this data in Excel?

Resources