Using the Yahoo Geocoder with Excel

If you're an Excel power user with a stack of addresses you'd like to geocode, look no farther than Jon Udell's Excel geocoding adventures to learn how.

I’ve been working with a spreadsheet containing addresses that want to be geocoded. I’ve had lots of experience running batches of addresses through geocoding services, but in the case of the police department I’ve been working with, it would be nice to be able to do the geocoding interactively.

In his signature style, Jon lays out the problem, walks through his thinking, illustrates the solution, and even provides example code.

All in all, it was an educational exercise. The patterns here can serve as a model for any scenario that involves interactively querying a web service based on some cell in Excel, and then incorporating the results into companion cells. Of course since I’m a complete novice when it comes to this stuff, I’m hoping that by posting my code I’ll also find out about other and better approaches.

Good to see our geocoder being put to good use.

Have you come up with a cool way of using it? If so, let us know...

Jeremy Zawodny
Yahoo! Developer Network