Open Site link from excel, scrape and repeat

Help
1

image
image1920×1080 227 KB

Hi All, I have an excel table which in column c, has a website address. It visits the website address (cell c2) and then scrapes/extracts data from the website page and saves it into the excel document in d2 and e2.

How do I get this to repeat this process for each row?

1 Like
2

Hi Steven,

Try reading the excel file into a data table. Filter out the unwanted columns from the data table and keep the website URLs. Loop over the list of URLs in column C and write the results to the columns D and E using write range activity.