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,025 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,520 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
• 25,240 points
322 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
87 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
433 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
346 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,073 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
250 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,520 points
2,223 views
+1 vote
2 answers

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
• 13,520 points
1,947 views