The number of Exhibitors at GDC 2015 is over 400. There is a list of all of them on this page:
. When you click on any one of them, you can determine at what location they have their offices.
It will take too much time, however, to click on each, one-at-a-time, but I want to determine which companies that are exhibitors at GDC 2015 are from California, the Bay Area, or other states in the USA, rather than other countries.
Any ideas how to determine which companies are from California or the Bay Area?
Can you help me to write a script in PHP or Excel VB that will take each link from a list in Excel (or other file format), automatically open each link, scan the page and return company name, country, and state information into a file?