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 8, 2019 in RPA by Piyush
21,588 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, 2019 by Anvi
• 14,150 points

selected Jul 31, 2019 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.
Hi....How to read different product names from Excel and type the product names into search bar of flipkart app and grab all products information using data scrapping and write these values into Excel sheet
Hey @Hary, Could you please post this as a separate query?

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, 2019 in RPA by Abha
• 28,140 points
6,275 views
0 votes
0 answers

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

Sep 12, 2019 in RPA by anonymous
• 120 points
2,080 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,110 points
1,562 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
1,301 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
2,370 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
1,497 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 14, 2019 in RPA by Anvi
• 14,150 points
9,479 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, 2019 in RPA by Anvi
• 14,150 points
5,676 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP