Extract Data from a website

[Sriram Iyengar]

Hi All,

I have a list of Product IDs & a list of URLs. The process I need to follow is

1) copy the URL from my list and paste it into a browser
2) Copy the product id from the same file and do a search for it on the website
3) Copy the URL that i get as an outcome of the search result and paste it back in the same file
4) Copy the second URL & Repeat Steps 2 & 3
5) Repeat this process for 21 Urls

 

[Marc L]

Hi !

As here it's the Excel general use and Excel formulas forum :
• Introduction to Power Query
• How to import web data to Excel using Power Query …

For a programmatic way, see samples in threads of the appropriate
VBA Macros forum as well the Web Scraping tutorial …
​

 

[Adam Brown]

Hi Sriram, I take it you're trying to scrape an ecommerce website for their products? If you figure out how to do this please share!

 

[Marc L]

All is yet in the tutorial as samples in threads …
​