da8d3d20-f58c-40ba-899a-1e95d5d8ea65.gif

5a36dc73-dcf3-4048-a323-539286b748b7.PNG

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.

  

This bot is developed using UiPath Studio Activities, which reads the text from the webpage.

  

It is useful for processes which require repetitive tasks of data scrapping from websites.

  

The main advantage is that it can be used to extract the data precisely without any errors.

  

This bot saves lot of manual work and also time as it extracts the data in a swift manner, which in turn saves time.

This BOT reads the Excel file, fetches the pin code of the cities, searches the data in web portal and fetches the location address. The data is saved into an Excel sheet.

e3593683-bbd3-46c5-aa1d-3e48d63479ee.jpg

a3ef73cd-ebcf-4880-bf86-ada3fe8e504f.jpg

b838f03d-beeb-4cae-9686-dfefefbfd807.jpg

74f974cc-117e-4b5f-87db-2c3ba218f48f.jpg

9e523799-1eca-4417-b1a5-e1344901e0be.jpg

Visual Basic

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.

  

This bot is developed using UiPath Studio Activities, which reads the text from the webpage.

  

It is useful for processes which require repetitive tasks of data scrapping from websites.

  

The main advantage is that it can be used to extract the data precisely without any errors.

  

This bot saves lot of manual work and also time as it extracts the data in a swift manner, which in turn saves time.

This bot reads the Excel file, fetches the pin code of the cities, searches the data in web portal and retrieves the location address. The data is saved into an Excel sheet.

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.

  

**Solution**

  

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.

This UiPath bot reads the Excel file, fetches the pin code of the cities, searches the data in web portal and retrieves the location address. The data is saved into an Excel sheet.

Data Extraction from Web Portal into Excel