Marketplace logo
MarketplaceListingsSolutionData Extraction from Web Portal into Excel
Data Extraction from Web Portal into Excel

Data Extraction from Web Portal into Excel

by Thirdware Solutions Limited




back button
back button
next button
next button





Extracting dealer information from various portals like Generac, Cummins, etc is done quarterly to fetch the dealer data like Company name, Street address, City, state, Zip-code, Website, Phone number & the services offered. The search needs to be performed by zip-codes in U.S. and Canada countries such that each and every zip-code is searched for dealers for a range of xx KMs. Web data scraping needs to be performed from web portals which is a highly voluminous and repetitive task that consumes multiple FTE’s time and is a monotonous task to be done manually.


UiPath automation tool performs web data scraping to navigate to each portal one by one and based on the pin code of a particular city or name of the particular city in a country, it extracts the full address of that specific dealer along with its contact information and services provided from the web portal and saves the information in an Excel sheet for further analysis.
This bot deals with extraction of data from web portals based on input data from an Excel (.CSV) file, and then saves the extracted results into an Excel file.

Validate Information

· UiPath reads the list of zip codes/cities and inputs a range of xx KMs to locate the dealer within that area.
· Once the extraction is completed, it updates the address and other data for each dealer from those locations in the Excel file.

Products Used:
  • This bot is developed using UiPath Studio Activities, which reads the text from the webpage.
  • UiPath Studio activities are used to integrated with Excel for data manipulation.



  • Web data scraping saves a lot of manual hours as it performs repetitive task of searching more than 40000 Zip codes in the US and each City in the Canada with a defined range.
  • Automatic storing the information in an Excel file makes the process highly accurate and error-free.
  • Saving FTE’s cost reliving them from data extraction duties to having them perform some meaningful analysis on the extracted data.
  • High ROI achieved by deploying the bots to run every Month/Quarter as per required schedules

Additional Information

Additional Information



Thirdware Solutions Limited

Visit publisher's page

Trusted Source

License & Privacy

License Agreement

Privacy Terms



Dec 9, 2021

Works with

Studio: 19.10 - 22.10


web data extraction
website data extract
data scrapping web


Microsoft Excel


UiPath Community Support

Similar Listings