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

+2 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
2,742 views

1 answer to this question.

0 votes
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
• 11,930 points

selected Jul 31 by Abha

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 6 days ago in RPA by Abha
• 20,110 points
110 views
0 votes
4 answers

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

These are the steps to add two ...READ MORE

answered Aug 2 in RPA by Shivi Singhal
2,640 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
349 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
289 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
961 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
200 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
• 11,930 points
1,455 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
• 11,930 points
888 views