Stumbled across another free Excel spreadsheet that uses the Yahoo geocoder to convert addresses to geographic coordinates. Simple, basic, but does the job.
A link to a compressed version of ExcelGeocoder is available at the top of this page. Run the program to uncompress the spreadsheet, then open it up in Excel. It requires Visual Basic for Applications, so it won’t currently run in OpenOffice, but apparently VBA compatibility is coming soon to OpenOffice’s Calc spreadsheet and other components.The program uses Yahoo’s Geocoder, and requires you to enter a Yahoo ID in the Settings And Instructions tab, a remainder from when you had to register to use the service. Since registration is apparently no longer necessary, you can enter anything you want for a Yahoo ID, but you have to enter something. Paste your address data into the appropriate columns in the spreadsheet, click on the Geocode button in the upper left, and you’ll get back latitude/longitude for those addresses (up to 5,000 per day is allowed by Yahoo).
If you want to use this geocoded data in Google Earth, you can use excel2kml, or if you save the resulting data in CSV format, you can use csv2kml to convert it into a Google Earth file. You can also convert it into a point shapefile using software that I’ll be covering soon.