How to do FREE Web Scraping to Excel in Windows 10

This video tutorial shows how to do free web scraping to Excel in Microsoft Windows 10 with Power Automate Desktop. You'll get Power Automate Desktop for free as a Windows user.
LINKS FROM THE VIDEO:
🔹 Install Power Automate Desktop: • Get Started with Power...
🔹 Power Automate Desktop Full Course: • Microsoft Power Automa...
🔹 Web Scraping in Power Automate for Desktop (Full Tutorial): • Web Scraping in Power ...
🔹 Follow me on Twitter and get quick RPA tips: / andersjensenorg
🔹 Behind the scenes from my office on Instagram: / andersjensenorg
👨‍👩‍👧‍👦 Discord: / discord
- Join my network with 3000+ RPA Developers, where we solve RPA problems, network, and help each other upgrade our careers. It's free!
0:00 Intro
It's free to do web scraping in Windows 10. We use Microsoft Power Automate for Desktop, as it's low-code. We don't need to be programmers. For example, today, we want to scrape used cars from a website to Excel. First, we scrape the basic information from the structured data. Then we move on to more advanced cases, where we scrape the URL of each item, go to the page, and save the information there to Excel.
2:13 Simple Web Scraping to Excel
In Power Automate for Desktop, we use simple drag and drop actions to open a website, do a search, and click a button. Now we're ready to data scrape. First, we use the Extract data from web page action to easily scrape our table data. Very easy, no magic involved. Then, we add headers to our Excel results with a simple action. Finally, we use the current date and time to create a dynamic name for our Excel and convert it to text.
33:05 Advanced Web Scraping in Windows with Power Automate for Desktop
Karsten, a viewer of the channel, posted this question, and I decided to create the part of the video for him (and you). First, you'll learn how to use the scraped URLs to open the websites.
#scraping #powerautomate #office365

[@andersjensenorg]

More advanced Web Scraping in PAD: kzbin.info/www/bejne/hoDJfGV3bc6Kd9U Thanks for all your help and support 🙌😍

[@sergiopeixoto6651]

Please do a few more case studies on Power Automate Desktop. This topic is amazing. I never heard of RDA and now I hooked and looking to ways to automate scraping, excel data collection, set up social media profiles and managing those profiles, etc. The potential is unlimited. Fantastic Content.

[@andersjensenorg]

Hey Sergio. Thanks a lot - have you seen my Discord? kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@craigbeuthin4299]

Hi Anders, ALL of your videos that I have watched at truly fantastic. Your videos are so very carefully structured, very well explained and your delivery in so easy to listen to, including your accent. Thank you for all your hard work.

[@andersjensenorg]

Hey Craig. Thanks x 1000 ❤️💪 It's funny when I got back to my older videoes (just 6 months), I see 1000 things I've improved - so a constant journey in perfecting the videos. I still have many things I can do better (mostly in editing), and comments like yours boost my motivation. Have a great day. Kind regards, Anders

[@camera0n_worries0ff]

Learned some new actions today.. thanks Anders

[@andersjensenorg]

Hey Akshay - Much appreciated 😍👋 Have a great day, kind regards, Anders

[@harjitsamra]

Great tutorial on web scraping. Thanks for making this!

[@andersjensenorg]

Hey Harjit Samra. Thanks a lot 😊 Have a great day. Kind regards, Anders

[@sudipto902]

Simply great tutorial and great presentation for easy understanding 👍👍👍

[@andersjensenorg]

Thanks a lot, Sudipto Samanta 🤗 Your feedback helps me immensely. Kind regards, Anders

[@FTSociety]

Thanks, great tutorial!

[@andersjensenorg]

Thanks a lot, KelsC 🙌 Kind regards, Anders

[@realkiddshady]

Thank you for this video!

[@andersjensenorg]

Thanks a ton, D B 🤩 Have a great day. You're more than welcome at my Discord, where we're 5800+ RPA developers networking and solving problems: kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@mikerobertson83]

Anders - thanks for the information and opening up this fantastic resource. To be sure - I will be implementing for future projects. I would like to request a few items for inclusion in some future uploads. 1. Please include examples of passing parameters into the robot, say for example instead of a Tesla model X you might want to run the robot for a Ford model car. 2. Writing the information out to a report and what I'm thinking of here is a monthly MS Word report to the project manager for example and 3. Date manipulations not only for parsing data in table (so you only look at some date range) but determination of durations - for example days elapsed between October 1st to December 16th. I'm finding your instruction and narration/demonstration and reiterating of functions very helpful and a useful aid to remembering the syntax of the function / action. Thanks Mike

[@andersjensenorg]

Hey Mike Robertson Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@MicahJohns]

Thanks Anders!

[@andersjensenorg]

You're very welcome, Micah - your support helps me a lot 😍 You're more than welcome at my Discord, where we're 5000+ RPA developers networking and solving problems: kzbin.info/www/bejne/roipq2CJbpuLfdE

[@ASO-xh5vu]

Great stuff. Always great stuff. Thank you!

[@andersjensenorg]

Thanks a ton, ASO - these comments are gold 😎😍

[@vikramparte2910]

You are amazing 🫶 I am looking for this type of web scraping.. Thanks a lot 🙏

[@andersjensenorg]

Hey Vikram - I'm so happy to hear 😀 Thanks a lot for commenting. Have a great day! Kind regards, Anders

[@KT-zh9xg]

Hi, wants to really thank for this tutorial clip, you save my days. Very well done I'm subscribing

[@andersjensenorg]

Thanks a ton, KT 🤩 Have a great day. You're more than welcome at my Discord, where we're 5300+ RPA developers networking and solving problems: kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@sidneygarcia2415]

There is a lot of great content in this video!

[@andersjensenorg]

Thank you so much, happy to hear 😍 Kind regards, Anders

[@yvindEilevstjnn-zh9xc]

Hi Anders. Thank you so much for this helpful video.

[@andersjensenorg]

Thanks a lot for the nice comment, Øyvind. Have you seen my new PAD course - here the case gets more advanced (but you can easily do it) 😊 It's here: kzbin.info/www/bejne/p5fTeaScpZeFabs Kind regards, Anders

[@duesenberger]

Thx for this lesson. Helped me get into web scraping with Power Automate Desktop. Really love that step at 43:00 - that is so powerful! Lot's of things to automate ahead. 😄

[@andersjensenorg]

Haha, thanks my friend - is the step to ask you fine folks to comment? 😄

[@andersjensenorg]

More Power Automate for Desktop? Check my 4.5-hour FREE course: kzbin.info/www/bejne/fobUZ42HnbSjmM0 Thanks for all your help and support 🙌🔥 Twitter: @andersjensenorg

[@AsifurRahman]

Hi Anders Jensen!!! you have just made my sunday awesome, now I will be able to generate my report just by clicking a button. Appreciated, Keep making great content. Best wishes.

[@andersjensenorg]

Thanks a lot, Asifur Rahman 🤗 Your feedback helps me immensely. Kind regards, Anders

[@ahmedhosny2412]

U r very helpful. Great work. Thank you

[@andersjensenorg]

Hey Ahmed Hosny. Thanks a lot 😊 Have a great day. Kind regards, Anders

[@dragon3602010]

Aaaawesome thanks 🔥🔥👍🏼

[@andersjensenorg]

Hey S. Thanks a lot 😊 Have a great day. Kind regards, Anders

[@xasancle]

☺️ Thank you so much.

[@andersjensenorg]

Hey @xasancle. Thanks a lot 😊 Have a great day. You're more than welcome at my Discord, where we're 8000+ RPA developers networking and solving problems: kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@businessclaud]

Thanks, it really helped

[@andersjensenorg]

Thanks a lot, Business Claud 🤗 Your feedback helps me immensely. Kind regards, Anders

[@quintonballenden1436]

Hi Anders, an excellent video, thank you. If I may a question: How do you take a variable from a list, and use it as a List item in the "Click link on web page" action?

[@andersjensenorg]

Hey Quinton Ballenden Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@HamedBenhaddou]

Hi Anders, What a great tutorial🤪. Learned a lot. Thank you for your effort in explaining this. I followed it step by step with my own example and everything went perfectly. although it is my first time using Power Automate. Here's my question: At the end of the video you add another detail to the list based on a URL from the list. "The date of registration of the car". So far so good, but how can one select multiple items from the same page and add them to the same Excel table? I mean that for each URL in the list you add 1 item to the list, while I want to be able to add multiple items from that URL page lo that same list.

[@andersjensenorg]

Thanks a lot Barcon - you just need to have the columns for it and then "just" copy the action. You're more than welcome to add the question on my discord, then we'll solve it for you 🙂 Kind regards, Anders

[@happy9955]

come and learn again and again Great Video

[@andersjensenorg]

Thank you so much for your nice comments 😊

[@ceran305305]

Thank you for these amazing tutorials. Is there anyway we can save the scraping result to CSV File instead of Excel file?

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 4900+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@alexlijesen6197]

Dear Anders, Clear video thanks, get a lot of info from this, In the option after the url extra info (field) "year of construction" of the website. You indicate that 1 field is written to excel, but if you want to save several, how can you do this in your example?

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@nielsotten1548]

Tak Anders Det gør du godt og grundig du er bestemt i en seriøse ende. God vind

[@andersjensenorg]

Haha mange tak, Niels - værdsat 😍

[@jordanwright4083]

Hey Anders these videos are fantastic! I'm using this tutorial here for a task now actually. Could you clarify (either in a reply or in a video) about how to go about extracting data from multiple tabs in an internet browser? For example, let's say I open multiple Chrome tabs of wikipedia entries for US Presidents, and I wanted to place inside of an excel sheet the Presidents' names, date of birth, date of death, time in office. All of the individual page tabs are for each single president. How could i tell Power Automate to scrape from one browser tab to the next? thanks!

[@andersjensenorg]

Hey Jordan Wright Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@user-ep1te9hu9s]

Hey Anders, thanks for the fantastic video. I've been working on the same and I found this video. I need a help, while we are browsing through the individual URLs what if we don't find the similar structure. Say here in this video, you are finding the registration year, for the first one you selected and the loop will go on, in the third or fourth page there is an error saying the element is missing, how can we resolve this. That could be a lot of help for me if you can show some solution to me. Thank you

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 8000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@sudhajgvir4560]

Will you make video on how to extract data from list and another list and write into excel

[@andersjensenorg]

Hey Sudha, how is that - can you specify what you want? 😊

[@happy9955]

i see again and again thank you for teaching

[@andersjensenorg]

I'm so happy for all your support, happy99 - thanks a lot 🙌💪

[@adulasaluma]

Hi Anders, and thanks for this great video. I just have one question. You are using Power Automate for Desktop, but Can we do the same with Power Automate for Cloud ?

[@andersjensenorg]

Hey Adulasaluma, Many thanks for the nice words. Unfortunately, we can't use Power Automate cloud for UI automation. Kind regards, Anders

[@sudipto902]

Can we scrap websites based on certain text elements present on the website? I mean when all the web pages have different text content and we need to scrap only certain text elements (title, paragraph). If you wish I can share the website URL.

[@andersjensenorg]

Hey Sudipto Samanta Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@ianpayling956]

Hi Anders Great vids as usual but the project I am working on is giving me an error when I go to a second web page to scrape the price in your example (I am collecting a date of birth) My error is Failed to Navigate because URL " is invalid When I run it the pages get iterated but the error comes up at the end of the last item Any ideas about what's wrong? I'm using a table in the sheet and not just a plain worksheet? Thanks Ian

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 9000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@amineredone1304]

Hi Andres, Is there away to avoid captcha when we scrape amazon ?

[@andersjensenorg]

Hey Amine. I've used 2Captcha (paid subscription), which worked perfectly (API). But check this: docs.microsoft.com/en-us/previous-versions/troubleshoot/winautomation/process-development-tips/web-automation/how-to-handle-a-captcha It's the WinAutomation doc. Kind regards, Anders

[@shivaprrasadsk3060]

Excellent video. If href is javascript how to extract data from that page

[@andersjensenorg]

Thanks a lot. Can you please give me an example? Kind regards, Anders

[@shivaprrasadsk3060]

@@andersjensenorg ngodarpan.gov.in/index.php/home/statewise_ngo/174/35/1

[@nareshkumar-qo9qy]

what if PAD takes title column and url column as a single column. what can we do???? just asking because i had the same problem with my local server.

[@andersjensenorg]

Hey naresh, then we need to seperate them with some data gymnastics (either split or RegEx). Kind regards, Anders

[@rocknets]

Is it possible to scrape pages with incremental page numbers? The site I want to scrape doesn't display information like in your example. .

[@andersjensenorg]

Please check this: kzbin.info/www/bejne/r6fShnWteNaXpJI 🙂

[@rocknets]

@@andersjensenorg I'll check it out. Thank You.

[@nareshkumar-qo9qy]

in this video for clicking each url first you copied the urls to excel, but if i do the same in my local server it shows some message with a pic ""OOPS"". So how can i click each link without knowing the end value please explain.

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 4900+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@user-jo8np5mk6d]

I want in a link and extract some data from that link page then close the link and open another link and extract same data from that page also. this goes on in pages

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 9000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@user-ph7vd4us2z]

Hi, How to select from drop down in a web page

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 7000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@malves82]

This is really good. Does this method still work?

[@andersjensenorg]

Hey Mario - yeah and today I'm releasing my How to Get Started video (2 Hours): kzbin.info/www/bejne/lWi8nKSbpc13rsk Kind regards, Anders

[@malves82]

@@andersjensenorg awesome, will definitely check it out as soon as I get a chance. Keep well. Your channel is really good, I appreciate the attention to detail.

[@dragon3602010]

Can we interact with the chrome extension?

[@andersjensenorg]

Yes for sure. Same approach as the Edge. Just change the Lanch new Edge action to a Launch new Chrome action. Everything else is the same 😊

[@Kaigozen]

why am i not able to select Href link from amazon product titles? please help

[@andersjensenorg]

We need to do a little selector work. I have a video for you on this exact topic next week 🙂

[@Kaigozen]

@@andersjensenorg thank you I'll subscribe

[@Kaigozen]

@@andersjensenorg btw I figured what changes to make in order to extract href link. But now even after selecting the pager element, it is not switching to next page in Amazon 🥲

[@M.Akilesh]

13:44

[@sandeepmalpani4137]

Anything similar on Mac ?

[@andersjensenorg]

Unfortunately not as good 😔

[@LearnValue]

Can we have PDF copy?

[@andersjensenorg]

Hey Motivational - Love - Passion Skill Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@Kaigozen]

how to do this for several pages?

[@andersjensenorg]

Hey Kaigozen, I have a new video ready in next week for you on this topic 🙂

[@Kaigozen]

@@andersjensenorg 💀💀💀 you always say this

[@andersjensenorg]

@@Kaigozen Haha, I promise my friend!

[@EcomMaker]

Hey There! Looking to get something done like this. Would you be willing to help me out. Trying to scrape products and descriptions into csv file to match Woocommerce import CSV. Reach out to me ! maybe some work there. Great Video by the way also! Let me know the best way to reach out to you or to communicate about this project

[@andersjensenorg]

Hey Econ. You're more than welcome on my Discord - there will be plenty, that can help you 😊 Here's how to join: kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@EcomMaker]

@@andersjensenorg Hey Anders. I joined the Discord... Either doesn't seem to be too active.. or people don't seem interested in the task.. Been a couple hours an no responses - I messaged in the #power-automate-desktop-help