How to extract Web Data to Excel with UiPath - Full Tutorial

[@shashankbankar7612]

Great Tutorial . Haven't found any other tutorial taking a single value at a time and then putting it in excel . They directly put into table. This tutorial is still relatable after 3 years

[@andersjensenorg]

Haha thanks a lot 😍 Kind regards, Anders

[@DanielFeitosaSQ]

God bless you Man...This is the video that I was looking for...Sorry about my english..I'm from Brasil..thank's a Lot

[@andersjensenorg]

Hey Feitosa. Thanks a lot! And your English is great. Let me know, if you have any questions and have a great weekend. Kind regards, Anders

[@kagisoclass2111]

Great video, Anders. Thank you

[@andersjensenorg]

Thanks a lot, Kagiso Class 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 6000+ RPA developers networking and solving problems: kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@XaVii1996]

Thank you so much, saved lot of work hours

[@andersjensenorg]

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

[@mariusnicolae6636]

Great tutorial, helped me A LOT with my work, after I adapted it to my needs.

[@andersjensenorg]

Hey Nicolae. Thanks a ton! Have you seen my new channel, where I teach UiPath in 1 minute videos: kzbin.info/door/aoEfYNHl6UGRKu-x5K_oAg Let me know, what you think? Kind regards, Anders

[@dhaneeswars1878]

Hi Anders, the video was really useful and I need to know, how to pass the Get Text activity in work flow when there is no required data present in a webpage for that particular item but has the data for upcoming items in a row ?

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

[@excelratheesh4025]

Hi Anders Jansen, I am newly learning the UiPath and this video is cool. I also done the same. but i have stuck in two place, if you could help on this it will be great. 1. While a product search, if there is no match found, currently it will not skip automatically, how to skip automatically and check next product. 2. Any possibility of getting related product picture in the excel cell. Thanks. Ratheesh

[@andersjensenorg]

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

[@vikichhaya7824]

Simple and crisp explanation. thanks :)

[@andersjensenorg]

Thanks a lot, Vikrant :) Kind regards, Anders

[@maxpena007]

Thanks for the video. Helped me make my first automation.

[@andersjensenorg]

Thanks a lot, Anthony :) Have a great day. Kind regards, Anders

[@nithyakavitharant2013]

Hi Anders, can we copy a image from a website search for a particular product from excel and copying it into excel into a specific row and resizing it too. ( how to search the web (browser) with data from Excel, extract the search result and save it to Excel row by row. same senario but need to copy images )

[@andersjensenorg]

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

[@nithyakavitharant2013]

@@andersjensenorg Thank you for your prompt reply.

[@tarunraghav1045]

Hello Anders you are doing very nicely. I have one query for you like first we go to any shopping site and search any product(vestige) so we get the 100 products in multiple pages then I want to copy the URL and product's seller name for all the products(100) and paste the bank Excel using UiPath.

[@andersjensenorg]

Hey Tarun. Thanks a lot! What you want to do is to use the Data Scrape Wizard. Pick the first Seller Name. Then the Second. Extract correlated data and choose URL. Now tell UiPath about your next page selector (it pops up) and your done. Kind regards, Anders

[@andersjensenorg]

And thanks a lot for the kind words :) Feel free to join the Discord - there is a link on the channell page.

[@KarlaGarcia-hl7eq]

Hi, I need to extract data 12 quarters of data (13f) from the Security Exchange Commission into Excel, with the instructions in the video I was able to extract one quarter but I dont know how to do the other 11.

[@andersjensenorg]

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

[@TailerTeilor]

Muito obrigado!!! Thanks from Brazil!

[@andersjensenorg]

Hey Diego. Thank you for taking your time to write such a nice comment 😊 Kind regards, Anders

[@jam05eun]

Hi Anders, I hope you're doing well, I'm doing almost the same project with your tutorial, however it is in StudioX. I have challenge on saving data in excel because it keeps on saving on the same row, so basically, whatever is collected from site is just overwritten by the next item. Would you know the solution for this?

[@andersjensenorg]

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

[@feliciamakamu7845]

Hi can you please help how to extract information from browser to excel using the flow chart functionality in uipath

[@andersjensenorg]

Hey Felicia Makamu 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 UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders

[@gavp1336]

Hi Anders, can we use Uipath to extract data from any program or does it have to be ones specified within Uipath (e.g. Excel)? My company uses an ERP system called Microtech and I'm wondering if I could make use of Uipath

[@andersjensenorg]

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

[@Manjureddykanugula]

HI, How can we extract data into the spreadsheets( two or more sheets) by using data scraping. can you make a video on it.

[@andersjensenorg]

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

[@MyMamatha]

Thank you so much for this video!

[@andersjensenorg]

Hey Amsha. Thanks a lot :) Kind regards, Anders

[@MrLangam]

How to copy from excel spreadsheet row field value and paste to browser search, copy text and paste back to an excel field? Do this for multiple rows?

[@andersjensenorg]

Hey Sino. Thanks a lot for writing. You can use this: kzbin.info/www/bejne/b3nbpayrds6Dis0 and combine it with the one you just saw. Let me know, if you encounter any problems. It will be a very good UiPath exercise :) Kind regards, Anders

[@tejasriremma9833]

Hello, I really appreciate your way teaching Uipath. Can you please answer this.. 1) We have so many cities names. From each cities we have to extract stores names. 2) After extracting Stores from each city . We need They all contact details. Can we do that using Uipath. Hope I will get Response. Thanks & Regards.

[@andersjensenorg]

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

[@rogerkiran]

Hi I need to copy data from SAP and paste in Excel. Can you please show how to paste the copied data from SAP in a particular cell in excel.

[@andersjensenorg]

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

[@nathanmora9734]

I have a similar automation and i followed your video, when i write range and add my datatable into the write range I get the error "string cannot be converted to system.data.datatable" . Any suggestions?

[@andersjensenorg]

Hey NATHAN. Definately. I solved the question in the UiPath forum for you 😊 Please let me know, if you managed to move on. Kind regards, Anders

[@irfanmansoori3060]

Thanks, i have a query, how can i post it..

[@andersjensenorg]

Hey Irfan. By post it, do you mean type something into web? Then a Type Into. Kind regards, Anders

[@hiennguyenminh8083]

i don't to look fuction " for each row" please tell me why ? thanks a lot

[@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 10,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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@chinmoykumarpatra5143]

Can u make a video on sentiment analyser using Excel and uipath

[@andersjensenorg]

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

[@richardlazaro6969]

Hey Anders! Good day to you, This is Richard, i am continuously watching your session, just need you expertise for some project that we need to provide with Event Viewer. Step1 Type in the Event Viewer on the search tab, press enter Step 2: Double click Windows logs and click Application. Step 3 is the critical part that i cannot figure out. Client wants me to only get the "Error" without using the Filter logs. they want me to get the data for all Error for "Date and time", "Source" , "Event ID" and the message in "General" automatically save it to Excel file. what function in UI path do i need to use? filtering the log for error will have more or less 2899 datas that need to be extracted. Appreciate your help.

[@andersjensenorg]

Hey Richard. Thank you. I have answered you on the other video 😊 Kind regards, Anders

[@manuelcaballero5827]

Thank you Anders, very useful!! You mentíon some web in 11:13 like for léarning vb i think, is it vb.net?? Thank you again!!

[@andersjensenorg]

Hey Manuel. Thank you 🙂 I would read the first book in this selection (Learning vb.net), andersjensen.org/the-best-uipath-book-selections-to-take-your-rpa-developing-skill-set-to-the-next-level/ It is hands down the best book with easy to implement examples you can follow all along. Kind regards, Anders

[@manuelcaballero5827]

Anders Jensen Great!! Thank you!!

[@plasaferstone3374]

Hey Anders! Good Day to you, This is Sriram, I'm continuously watching your sessions, can you provide a tutorial in Gmail and Google Sheet Automation?

[@andersjensenorg]

Hey Plasafer, thank you 😎 Indeed I can. Take this, which will set up the integration with Google, kzbin.info/www/bejne/pZzVfISborR-hJI Let me know, if you can solve your problem now? Kind regards, Anders

[@plasaferstone3374]

@@andersjensenorg thanks for your information 😇. I want to read the range from Google Sheet and send a Email to that email id mentioned in the Google sheet row

[@plasaferstone3374]

Google Sheets contains Email ID & Course Details Want to Read to read both Then send a email to the Mail ID's and mail contents related to the course details Kind Regards, Sriram

[@promate1698]

What if I want to capture info of all products

[@andersjensenorg]

Hey ProMate 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 UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders

[@chhoemsothy2185]

if some search are not data how to fix it?

[@andersjensenorg]

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

[@susanabiglieri1544]

some numbers from my first column are typed with mistakes (for example a missing number) and I dont get all the results. Why can this be happening? maybe its going too fast Edit: Yes, it was going too damm fast. I fixed it with 1 second delay at the beginning and 2 seconds delay at the end of the sequence.

[@andersjensenorg]

Hey Susana. Haha great. Yeah, sometimes we can use these delays to fix our processes :) Kind regards, Anders