As we have tried to geocode addresses in Google Spreadsheets automatically we have found a solution. It turned out, that this solution is not usefull if you want to produce Lat/Lon automatically. I’ve played a little bit and would like to show you an easier and simpler way.
For our job site here on digital-geography I was searching for a way to auto geocode spreadsheet location cells. So I’ve found this very short announcement from Max. See it here in depth:
I think there are pleanty of companies which store customer informations in some sort of a database or even in a plain excel-sheet to stay a little organized in their daily work. This could be convenient for them but I would love to see some maps, where are my customers from and where are dense areas of origin. This could increase my impressions using advertisement or I can adress customers with special offers that rely on their adress. In the next days I will create a little tool that will automatically scan your customer database, transform the the results in…
One thing I have never kept in mind is the divergence on how shops and agencies store their adresses (more or less like John Doe, 123, Main Street, Anytown, U.S.A ) and the way we store our point-informations (103°E, 45°N). So one problem is,to bring these both things together. YOu cannot do this straightforward because you need some kind of reference like a georeferenced and digitized or u use such thing like the googlemaps-API. ArcGIS is also capable of translating this information into points. Just watch the following tutorial and I’ll show you how: