Forum Discussion

ElliottET's avatar
ElliottET
Copper Contributor
Sep 13, 2021

Importing data from webpage

Hi there,

 

Recently, I have been experimenting with importing web data into excel. In particular, from this website: https://eu.store.ui.com/

 

I am trying to import the current product prices of some of their products:

https://eu.store.ui.com/collections/operator-airmax-and-ltu

 

I do not have much knowledge about web deveopent; however, it seems that this particular website loads most of their product information after the HTML (presumably via javascript), which includes the product price. Therefore I cannot select any prices to import directly from the HTML into excel.

 

To give you a better idea of what I mean:

When loading the webpage via Excel:

 

When loading the webpage Via a Browser:

 

Is there a way of importing those prices into excel?

If so, how would i do so?

 

Thanks in advance,

Elliott

 

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    ElliottET 

    Afraid not with Excel. In Power BI Desktop there is more advanced Power Query connector to Web (using Web.BrowserContents() ) which gives something like

    It's not available for Power Query in Excel.

Resources