How to get specific data from web and save it in a excel file

datatable
excel
csv
datascraping

#1

Hi guys
For the image mentioned below i want to collect data from web,only the info of the companies which i have highlighted in red boxes(3 companies) with the headers. Then i want this data to be loaded and saved in a excel file . Which is the easiest way to do??

please help me out. Thank you!


#2

@Dolvin_John is there any condition based on which you are extracting data? I yes, Please specify that. :slight_smile:


#3

Hi!! i want to extract just the three data which i have boxed in red and load into a excel sheet. no other condition!


#4

@Dolvin_John please provide the website link


#5

@Niket_Ghai http://www.bangalorecircle.com/pages/IT-2.html


#6

@Dolvin_John what i’ve done is that for the first two items i have used data extraction and have limit the number of results to 3(Because we also are including the headers) and for the third data I’ve used get text and then stored it in same excel file using write cell…


#7

Main.xaml (12.7 KB)
this is my workflow…


#8

Hello @Dolvin_John,

I’d extract the complete table using data scraping and then filter it according to my need :slight_smile:
Check out this workflow

Extract_Selective_Data.xaml (15.9 KB)

PS - You could also use Filter Data Table


#9

thank you will check, as first two data are at top one below the other it was easy to extract, the thing i wanted to know is how we can extract the data in between other alternate companies specifically wanted into the excel is there any filter option that can extract the whole data and then select the specific company i want to show in excel


#10

That is exactly what i’ve done @Dolvin_John
You could just add on to the filterString with desired expressions to filter it according to your need.

Cheers :slight_smile:


#11

thank you @Rishabh_Lakhera will check it out