Forum Discussion
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
- SergeiBaklanDiamond Contributor
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.