Power automate (Extracting from web to multiple excel sheets)

[Theee]

Good day, I would like to extract data from multiple websites and then save it in what excel sheet. I understand in the beginning when you extract data from the web you can save it in an excel sheet that has its instance, but how do you reference that sheet to add another data from another website? I tried to reference but the data from the second website overridden the data in the excel sheet from the first website. Your help will be appreciated.

I have made an example from the picture of how I want my extracted data to appear in the end. I want to be able to reference the same sheet and then save multiple tables extracted from various websites.

[Pavel_NaNoi · Accepted solution]

I'm assuming here that each website is unique and so I'd recommend to instead do something like the following:

- Start a new Excel Instance

- Use the Extract data from Webpage action and store the different data into a different variable for each website, not into an Excel spreadsheet

- Use multiple write data to excel actions to write each data into whatever column you wish it to be written to (you can perform a loop that writes each data in with just one write data to excel action if you really want to, this method is just easier)