How to do FREE Web Scraping to Excel in Windows 10

Поділитися
Вставка
  • Опубліковано 18 жов 2024

КОМЕНТАРІ • 110

  • @andersjensenorg
    @andersjensenorg  Рік тому +2

    More advanced Web Scraping in PAD: ua-cam.com/video/POfK2A8iWAs/v-deo.html
    Thanks for all your help and support 🙌😍

  • @andersjensenorg
    @andersjensenorg  2 роки тому +4

    More Power Automate for Desktop? Check my 4.5-hour FREE course: ua-cam.com/video/HUq6ZQhOpbk/v-deo.html
    Thanks for all your help and support 🙌🔥
    Twitter: @andersjensenorg

  • @craigbeuthin4299
    @craigbeuthin4299 Рік тому +2

    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
      @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

  • @MyTravelFlashBack
    @MyTravelFlashBack Рік тому +1

    Learned some new actions today.. thanks Anders

    • @andersjensenorg
      @andersjensenorg  Рік тому

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

  • @MicahJohns
    @MicahJohns Рік тому +1

    Thanks Anders!

    • @andersjensenorg
      @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: ua-cam.com/video/xWFz-S96XGo/v-deo.html

  • @harjitsamra
    @harjitsamra 2 роки тому +2

    Great tutorial on web scraping. Thanks for making this!

    • @andersjensenorg
      @andersjensenorg  2 роки тому

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

  • @sudipto902
    @sudipto902 2 роки тому +2

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

    • @andersjensenorg
      @andersjensenorg  2 роки тому

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

  • @yvindEilevstjnn-zh9xc
    @yvindEilevstjnn-zh9xc Рік тому +1

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

    • @andersjensenorg
      @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: ua-cam.com/video/qfpHqfp2R3Y/v-deo.html Kind regards, Anders

  • @KT-zh9xg
    @KT-zh9xg Рік тому +1

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

    • @andersjensenorg
      @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: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders

  • @duesenberger
    @duesenberger Рік тому +1

    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
      @andersjensenorg  Рік тому

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

  • @sidneygarcia2415
    @sidneygarcia2415 11 місяців тому +1

    There is a lot of great content in this video!

    • @andersjensenorg
      @andersjensenorg  11 місяців тому

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

  • @MacroVisionInsight
    @MacroVisionInsight Рік тому +1

    Thanks, great tutorial!

  • @realkiddshady
    @realkiddshady Рік тому +1

    Thank you for this video!

    • @andersjensenorg
      @andersjensenorg  Рік тому +1

      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: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders

  • @mikerobertson83
    @mikerobertson83 Рік тому +1

    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
      @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: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html Have a great day. Kind regards, Anders

  • @AsifurRahman
    @AsifurRahman 2 роки тому +1

    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
      @andersjensenorg  2 роки тому +1

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

  • @ahmedhosny2412
    @ahmedhosny2412 2 роки тому +1

    U r very helpful. Great work. Thank you

    • @andersjensenorg
      @andersjensenorg  2 роки тому

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

  • @vikramparte2910
    @vikramparte2910 Рік тому +1

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

    • @andersjensenorg
      @andersjensenorg  Рік тому

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

  • @adulasaluma
    @adulasaluma 6 місяців тому +1

    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
      @andersjensenorg  6 місяців тому

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

  • @ASO-xh5vu
    @ASO-xh5vu 2 роки тому +1

    Great stuff. Always great stuff. Thank you!

    • @andersjensenorg
      @andersjensenorg  2 роки тому

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

  • @FamilyBiz-b7e
    @FamilyBiz-b7e Рік тому +1

    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
      @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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders

  • @alexlijesen6197
    @alexlijesen6197 Рік тому +1

    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
      @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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders

  • @HamedBenhaddou
    @HamedBenhaddou Рік тому +1

    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
      @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

  • @quintonballenden1436
    @quintonballenden1436 2 роки тому +2

    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
      @andersjensenorg  2 роки тому

      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: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html Have a great day. Kind regards, Anders

  • @xasancle
    @xasancle Рік тому +1

    ☺️ Thank you so much.

    • @andersjensenorg
      @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: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders

  • @happy9955
    @happy9955 8 місяців тому +1

    come and learn again and again Great Video

    • @andersjensenorg
      @andersjensenorg  8 місяців тому

      Thank you so much for your nice comments 😊

  • @dragon3602010
    @dragon3602010 2 роки тому +2

    Aaaawesome thanks 🔥🔥👍🏼

    • @andersjensenorg
      @andersjensenorg  2 роки тому +1

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

  • @ceran305305
    @ceran305305 2 роки тому +1

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

    • @andersjensenorg
      @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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders

  • @businessclaud
    @businessclaud 2 роки тому +1

    Thanks, it really helped

    • @andersjensenorg
      @andersjensenorg  2 роки тому

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

  • @rocknets
    @rocknets Рік тому +1

    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
      @andersjensenorg  Рік тому

      Please check this: ua-cam.com/video/yvoUBwCqdn0/v-deo.html 🙂

    • @rocknets
      @rocknets Рік тому

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

  • @sudhajgvir4560
    @sudhajgvir4560 Рік тому

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

    • @andersjensenorg
      @andersjensenorg  Рік тому

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

  • @leocawaling8837
    @leocawaling8837 2 місяці тому +1

    Hi Anders thank you for this, I'm following your samples and currently build an automation, I have here a list of emails then I'm trying to validate if its pawned on the website name Have I been pawned. There are 2 result 1st one is Good and the 2nd result is your pawned or no Good. How can I have the extracted data, if I have "your pawned" is there an if else statement something like that?

    • @andersjensenorg
      @andersjensenorg  2 місяці тому

      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 13,000+ 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders

  • @jordanwright4083
    @jordanwright4083 Рік тому +2

    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
      @andersjensenorg  Рік тому +1

      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: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html Have a great day. Kind regards, Anders

  • @shivaprrasadsk3060
    @shivaprrasadsk3060 2 роки тому +1

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

    • @andersjensenorg
      @andersjensenorg  2 роки тому

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

    • @shivaprrasadsk3060
      @shivaprrasadsk3060 2 роки тому

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

  • @ianpayling956
    @ianpayling956 Рік тому +1

    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
      @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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders

  • @malves82
    @malves82 Рік тому +1

    This is really good. Does this method still work?

    • @andersjensenorg
      @andersjensenorg  Рік тому +1

      Hey Mario - yeah and today I'm releasing my How to Get Started video (2 Hours): ua-cam.com/video/_7YkqephDxg/v-deo.html Kind regards, Anders

    • @malves82
      @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.

  • @sudipto902
    @sudipto902 2 роки тому +1

    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
      @andersjensenorg  2 роки тому

      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: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html Have a great day. Kind regards, Anders

  • @KuldeepSingh-nq1vi
    @KuldeepSingh-nq1vi 2 місяці тому

    How to create Base CSS seletor and custom selector to extract data from web page, please make a video... Thanks.

    • @andersjensenorg
      @andersjensenorg  2 місяці тому

      Kindly check this: ua-cam.com/video/7jqD9YucPSA/v-deo.html 😊

    • @KuldeepSingh-nq1vi
      @KuldeepSingh-nq1vi 2 місяці тому

      I already watched it, but I didn't understand how to create a separate video especially on Base Selector and custom seletors..

  • @happy9955
    @happy9955 Рік тому

    i see again and again thank you for teaching

    • @andersjensenorg
      @andersjensenorg  Рік тому

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

  • @amineredone1304
    @amineredone1304 2 роки тому +1

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

    • @andersjensenorg
      @andersjensenorg  2 роки тому +1

      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

  • @nareshkumar-qo9qy
    @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
      @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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders

  • @Kaigozen
    @Kaigozen Рік тому +1

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

    • @andersjensenorg
      @andersjensenorg  Рік тому

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

    • @Kaigozen
      @Kaigozen Рік тому

      @@andersjensenorg thank you I'll subscribe

    • @Kaigozen
      @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 🥲

  • @nareshkumar-qo9qy
    @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
      @andersjensenorg  Рік тому

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

  • @nielsotten1548
    @nielsotten1548 2 роки тому

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

  • @dragon3602010
    @dragon3602010 2 роки тому +1

    Can we interact with the chrome extension?

    • @andersjensenorg
      @andersjensenorg  2 роки тому

      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 😊

  • @MyXL-n5x
    @MyXL-n5x Рік тому

    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
      @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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders

  • @MuhammadAtif-x3g
    @MuhammadAtif-x3g Рік тому

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

    • @andersjensenorg
      @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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders

  • @LearnValue
    @LearnValue 2 роки тому +1

    Can we have PDF copy?

    • @andersjensenorg
      @andersjensenorg  2 роки тому

      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: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html Have a great day. Kind regards, Anders

  • @sandeepmalpani4137
    @sandeepmalpani4137 Рік тому

    Anything similar on Mac ?

  • @Kaigozen
    @Kaigozen Рік тому +1

    how to do this for several pages?

    • @andersjensenorg
      @andersjensenorg  Рік тому

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

    • @Kaigozen
      @Kaigozen Рік тому +1

      @@andersjensenorg 💀💀💀 you always say this

    • @andersjensenorg
      @andersjensenorg  Рік тому

      @@Kaigozen Haha, I promise my friend!

  • @M.Akilesh
    @M.Akilesh Рік тому +1

    13:44

  • @EcomMaker
    @EcomMaker Рік тому +1

    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
      @andersjensenorg  Рік тому +1

      Hey Econ. You're more than welcome on my Discord - there will be plenty, that can help you 😊 Here's how to join: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders

    • @EcomMaker
      @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