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

This video tutorial shows, how to search the web (browser) with data from Excel, extract the search result and save it to Excel row by row.

🔔Subscribe if you enjoyed

🤖UiPath Tutorial

#uipath #rpa #automation

[shashankbankar]

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

[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

[excelratheesh]

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

[tarunraghav]

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.

[XaVii]

Thank you so much, saved lot of work hours

[dhaneeswars]

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 ?

[mariusnicolae]

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

[maxpena]

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

[tejasriremma]

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.

[jameun]

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?

[nithyakavitharant]

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 )

[gavp]

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

[vikichhaya]

Simple and crisp explanation. thanks :)

[KarlaGarcia-hleq]

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.

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

[TailerTeilor]

Muito obrigado!!!
Thanks from Brazil!

[feliciamakamu]

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

[chinmoykumarpatra]

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

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

[richardlazaro]

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.