How to extract data from a website and save it to excel using UiPath?

+3 votes
I want to extract data from a website and save the extracted data into an excel file. How can I do that using UiPath, please suggest?
Mar 7 in RPA by Piyush
5,813 views

1 answer to this question.

+1 vote
Best answer

Hi Piyush, if you want to extract data from a website and save it into an excel file using UiPath, you can simply use Data Scraping from Design Tab of UiPath. To do so, go through the following steps one by one to get an idea:

1. Create a Sequence. Now open a browser and go to http://www.amazon.in.

2. Now search for Football Balls and exclude the Out Of Stock items.

3. Now come back to UiPath Studio and click on Data Scraping from Design Ribbon Tab.

4. Now follow the Data Scraping Wizard:

  • Click Next to select First Item Name. Then click Next to select Second item name to form a pattern.
  • Now click on Extract URL Checkbox and give names to columns like Football Name & URL.
  • Then Click on Extract Corelated Data to extract other details like Price etc. 
  • Finally click on Finish, to finish the wizard. You will be asked to indicate a Next button in case items are present on multiple pages. 
5. Then come back to UiPath again, and drag an Excel Application Scope activity below Data Scraping activity. Mention the file path of existing excel file into which you would like to extract data.
6. Add a Write Range activity. Here mention the extracted Data table (generated automatically in Data Scrapping activity).
7. Now simply run this activity and you have your data extracted.
answered Mar 8 by Anvi
• 13,960 points

selected Jul 31 by Abha
If I want to search a five random products details and extract data from a website and save it to excel
Hi Tejaswi, by random products you mean searching for 5 products one by one and saving all the products details? Please clarify your question.
hai.. yeah, like iphone, samsung,redmi,one plus, vivo.. if i search iphone i want  those  extract data from a website and save the extracted data into an excel file..and   again dynamically i search about samsung those  extract data from a website and save the extracted data into an excel file in my  excel sheet separately..like redmi,one plus.. i hope you understand my question..
Hi Teja, so what you can do to search 5 random products, follow the steps mentioned by @Anvi in her answer and after Step1, Use a For loop for 5 times and inside that loop, add Data Scraping activity and Excel Application Scope activity.

I hope this would resolve your problem.
thanq..Abha i will try..
You're welcome Teja. Feel free to ask if you face any issue.

Related Questions In RPA

+2 votes
1 answer

How to extract data from website and save it to excel using Blue Prism?

Hey, you can use following steps to ...READ MORE

answered Aug 19 in RPA by Abha
• 27,180 points
427 views
0 votes
0 answers

HOW to extract a column data and save it in the new sheet using UIPATH

Sep 12 in RPA by anonymous
• 120 points
118 views
0 votes
1 answer

Robot Manager in UiPath

the robot.exe file is located in: C:\Users\USER_ACCOUNT\AppData\Local\UiPath\app-17.1.6523\Ui-Robot.exe Hope it ...READ MORE

answered Apr 17, 2018 in RPA by wrecker
• 3,110 points
458 views
0 votes
1 answer

Automation in Uipath

you can use the Database package for connecting  ...READ MORE

answered Apr 17, 2018 in RPA by wrecker
• 3,110 points
365 views
0 votes
1 answer

UiPath vs Workfusion

in WorkFusion, you can create a script ...READ MORE

answered Apr 17, 2018 in RPA by wrecker
• 3,110 points
1,110 views
0 votes
3 answers

Any open source tools for RPA ?

Yes, here is the Free RPA tool ...READ MORE

answered Oct 24, 2018 in RPA by Karthiksiddhu
• 240 points
271 views
0 votes
1 answer

How to extract specific type of files from a directory using UiPath?

Hey @Avani, if you want to extract ...READ MORE

answered Mar 13 in RPA by Anvi
• 13,960 points
2,585 views
0 votes
1 answer

How to read Month and Select Start & End Date from a Calender in Uipath?

Hello Apeksha, If you need start date of ...READ MORE

answered Oct 23 in RPA by Anvi
• 13,960 points
90 views