I need a program that will search for information on the web, and export it to a CSV, or database file.
The search will begin with a real estate parcel number. This number will link to the treasurer's site to pull the the back taxes owed, to the assessor's site to pull information about the property, and to the recorder's site to pull information about liens, and defaults.
It would have to input about 1-5k parce numbers which would be copied and pasted, and then search the websites for all the information with it all ending up in a csv file that i can place into excel.
All of this is for Clark County, Nevada.
I may want to add an additional web search in the future.
I would start with a list of Parcel Numbers. I would have to input them all at once. This list could be up to 5-10k individual numbers. They will be in a csv file.
The parcel number would be entered into 3 different websites....
That is the first. It would place most of the information from the results page into the spreadsheet.
It would only need to place one item from the results page into the spreadsheet
It would need to place the results from that page into the spreadsheet
I will have a spreadsheet with about 10 columns already filled out including the parcel number that is needed to search all the other sites. I would want this program to complete the data. I will attach a before and after spreadsheet so you can understand. Neither of these will have the info from the third site I listed.
I have added a general before and after of what the spreadsheet should look like. Hopefully this can be done.