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

0 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
1,502 views

1 answer to this question.

0 votes

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
• 10,310 points

Related Questions In RPA

0 votes
3 answers

How to find the sum of 2 columns of an excel and display it in a 3rd column using UIPATH?

1.  Excel Application Scope (Activity) : In ...READ MORE

answered Jun 9 in RPA by anonymous
• 140 points
2,056 views
0 votes
1 answer
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,090 points
302 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,090 points
254 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,090 points
897 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
160 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
• 10,310 points
954 views
0 votes
1 answer

Looping through PDF files to extract specific data using Uipath

Hi Rashi, you can access all the ...READ MORE

answered Mar 5 in RPA by Anvi
• 10,310 points
509 views