Go to: [login to view URL]
Create a spreadsheet that will capture all the data for every state and county combination available on that website.
See attached spreadsheet. The attached spreadsheet shows the data for Alabama, All Counties, the very first entry, exactly the way I want it entered into the spreadsheet.
Make sure to strip out the words "Telephone:" from the Phone field, and just put in the number, same with Fax, same with the word Email:, and URL:, just put in the actual data for easier sorting.
Add a column State at the beginning of the spreadsheet
Move the data called Counties Served to the second column, as indicated in the attached spreadsheet.
Thanks, Dean
I'm experienced web scraper. I can do this, I can write script in Excel , so you could do some updates next time by yourself.
Only with me you can be sure of 100% accurate results.