Data scraping from website with multiple searches items from different states and countries

Hello Everyone,
i trying to data scrap an information from a website by selecting cities from CSV file and automating the process till the last data is copied from CSV

can any one suggest me how to perform such task

1 Like

hope these steps would help you resolve this
–use READ CSV activity and pass the file path of csv file as input and get the output with a variable of type datatable named outdt
–then use a for each row loop and pass theabove variable asinput
–inside the loop use a open broswer activity and pass the url of the web page from where we want to get the datatable
–inside the do container of open browser, use a DATA SCRAPPING method from design tab in studio and scrape the datatable and get the output with a variable of type datatable named dt
–if we want to store the datatable in a excel use a excel application scope and write range activity within it where we can pass the dt variable as input
while in excel file path mention as
this will create new file for each data scrapping inside the project folder

Hope this would help you
Cheers @vijayalakshmi8

Hi @vijayalakshmi8

You mean to say that you have a csv file with column as City based on data scrapping you need to scrap and then write the data in csv is that right?

Ashwin S

States and Cities of USA.xlsx (16.3 KB)

this is my csv file from which i have to copy that data into an web site where i can data scrap from the results i have got and it need to repeat for each and every row of my entire file

thanks for the reply @AshwinS2


this is how i used and below are the properties which i have used

kindly try with this steps as you told we need to get the datatable for each and every row in sequence
Cheers @vijayalakshmi8

Hi @vijayalakshmi8

is the file in csv or xlsx
if xlsx means do the scrapping and then do the write range based on iteration
Ashwin S

xlsx but i saved in csv format

Hi @vijayalakshmi8

Have a try i think @Palaniyappan steps should work :slight_smile:

Ashwin S

1 Like

is this correct which im trying??

Kali.xaml (10.4 KB)
didn’t include data scraping

this is what i want can you verify @Palaniyappan @AshwinS2

try.xaml (24.8 KB)

this is my activity can you guys verify it once @Palaniyappan @AshwinS2
thanks in advance