I have many URLs on a column L in excel. Can power automate go in and web extract each page?

[lionelh]

Hi, I am still new to Power Automate. I have many URLs on a column L (100 and more urls in Column L) in excel. Can power automate go into web extract some information from these individual pages (from Column L) and paste the information in (column N)?

[julia5306]

Should be able to! You can have your desktop flow read the URLs from the worksheet, and then for each URL, go to the website, extract the relevant data from it and finally paste it into the next column. The "extract data from webpage" action does however take a little while to run, so I would recommend creating a test Excel sheet with only a few URLs to use while building your flow to make sure it works as intended