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.
This geocoding excel tool is actually the Juice Analytics: Excel Geocoding Tool.
I actually just blogged about this myself.
Forgot to mention that this is a fantastic blog. Among my favorites lately. Keep up the good work!
I’ve blogged about the Juice Analytics Geocoder in a previous post, and I did notice a resemblance. Didn’t make the connection, because the Juice Geocoder includes the option of using the Batch Geocode website in addition to Yahoo and the option to convert the file to KML automatically, whereas this spreadsheet only uses Yahoo and doesn’t do KML. Oddly enough, I think there’s a place for both versions – this simpler one is cleaner and neater than the later one, and that might make it a better choice for non-Google-Earth uses.
Thanks for the compliment – mapz: a gis librarian has been on my bloglist from the start.
I have used this geocoder from Juice & it works perfectly. It also works with geocoder.us.
Thank you !