Help with data scraping to excel for multiple search results from within a webpage

Help Studio
1

Hi All,

Very new UiPath user here. I am looking to set up a one time automation task as follows:

  1. Open web browser and go to webpage.

  2. Login using credentials (do I add these to the project or have it pull from a data source such as excel?)

  3. On the webpage search a company by its name (the names are currently in a long excel list)

  4. Select the company from the search dropdown

  5. On the next webpage, pull the company number and registered office details and insert into excel - these details are in a table format on the webpage already so hopefully should be easy for the system to identify?

  6. Insert that company number and address into designated columns on the same row as the name in the original excel sheet.

  7. Repeat steps 3 to 7, going down the list on excel.

Two issues I am already expecting - the list also contains individuals who will not be on the website - can the system skip them/indicate they were skipped somehow?

If a name is not exact such as using the abbreviation Ltd instead of Limited is there a way to have an and/or situation for that?

Thank you in advance for any advice/help - we have a large data gathering project for over 900 companies/individuals we work with, with 25 points of information to be compiled on each so I am hoping some work can be automated.

2

can you provide us a excel and web link

3

I cannot share the excel file as it contains company client list. It is a simple excel list with column headers “Name” / “Company Number” / “Company Address”. Currently only the name column is filled in.

The website I will pull from is https://www.vision-net.ie/

I may be able to reduce a step - if you search (example, not my client) 123 Money Limited it will prompt the company with its number in (brackets) and also will have its registered address. This would stop the need to move to another webpage - but maybe would add a step to clear the search box to repeat.

Thanks.