[login to view URL]
[login to view URL]
[login to view URL]
I need an excel document with a separate sheet for each of these three companies. I need a list of all the agencies that these companies serve.
I then need the following data about each agency: name, address, city, state, zip code, telephone number, type of insurance offered, and email address (only for Progressive). These fields would be the heading of the columns in the Excel Spreadsheet.
On the websites of each of these companies, you can find the list of agents near you by entering your zip code. We would require all the agents in every zip code for these three companies. Some agents show up in more than one zip code, we would want you to eliminate the duplicates.