How To Extract Data From a Web Page to Excel Using Power Automate Desktop

One of my clients requested to extract data from a web part to an Excel file using Power Automate Desktop. In this tutorial, I will explain how to extract data from any web page using Power Automate Desktop with two different examples.

Extract Data from a Web Page using Power Automate Desktop

I wanted to extract data from a web page [Amazon – Power Automate books].

Here are the steps to extract data from a web page using Power Automate Desktop:

1. Open the Power Automate desktop app-> Click on the + New button -> Select Flow -> Provide a name for the flow in the Create a flow dialogue box. Then, click on the Create button.

2. Then, it will open a separate window where you can drag and drop the actions to the workspace designer.

3. Now, open your Chrome browser and search for ‘Amazon’ to access the Amazon website. Search for Power Automate Books.

4. On to the Power Automate workspace, search for Launch new Chrome action. It will be presented under Browser automation. Drag and drop it to the workspace.

5. Next, configure the properties of Launch new Chrome as given below.
   • Launch mode: Select the “Attach to running instance” option.
   • Attach to Chrome tab: Choose the By title option from the drop-down.
   • Tab title: Click on drop-down -> Select the “Amazon.in:Power Automate Books”.

Then, click on Save to save the details.

6. Next, under the Actions pane, search for and add the “Extract data from web page” action to the workspace.

6. This will open a Live web helper – extract data from a web page.

From the Amazon web page, I want to extract the Book Title and Author names into Excel. The Live web helper will produce a red border.

7. Go to your Chrome tab, where you opened it, and focus on the book title. Right-click the mouse, select “Extract element value,” and then select the text. You can follow the GIF below for your reference.

8. Then, in the “Extract data from web page” action, the extracted values will be added. Set the properties as below:
   • Web bowser instance: It will be automatically selected. You can also select from the drop-down.
   • Store data mode: Select “Excel spreadsheet”.

9. Now, let’s close the Chrome browser by adding the “Close web browser” action. The Web browser instance will be taken by default. Click on Save.

10. The flow is ready now. Click on the Save icon and run the flow.

11. When the flow runs successfully, you can see the Excel sheet with the data extracted from web page. Take a look at the reference image.

This is how you can extract data from a web page to an Excel file using Power Automate Desktop.

I hope this tutorial is helpful. You can give suggestions in the comments section.

You may also like the following tutorials:

• Extract Tables from a PDF using Power Automate Desktop
• Variables in Power Automate Desktop
• Convert JSON to Custom Object in Power Automate Desktop
• Insert Row into Data Table in Power Automate Desktop
• Update Data Table Items using Power Automate Desktop
• Add Excel Table into HTML Email Body using Power Automate Desktop

Bijay Kumar

After working for more than 18 years in Microsoft technologies like SharePoint, Microsoft 365, and Power Platform (Power Apps, Power Automate, and Power BI), I thought will share my SharePoint expertise knowledge with the world. Our audiences are from the United States, Canada, the United Kingdom, Australia, New Zealand, etc. For my expertise knowledge and SharePoint tutorials, Microsoft has been awarded a Microsoft SharePoint MVP (12 times). I have also worked in companies like HP, TCS, KPIT, etc.