Is there a way to retrieve Google Map Longitude & Latitude from Addresses in Spreadsheet?

Question

I am currently working with a data listing and one of my columns of data is an address of the listing. I plan on plotting each of my addresses on a Google Map, but I would like to avoid having to manually paste the address into Google to obtain the parameters I need which are.

• Longitude
• Latitude

My excel sheet (Or I have it in Google Docs spreadsheet) contains about 3000 addresses. So I was hoping that there is someway to try and automatically get these extra column data so I can import into my backend.

I am going to be importing a CSV file into my database (As I have set up the long and lat's as custom fields that will be imported) so I need the final values as columns in my excel sheet. I have attached an example.

Any help would be appreciated

Answer 1

Try this blog post by Pamela Fox. It is fairly old, but worked the last time I tried it. It is limited to 100 entries of a spreadsheet at at time, but isn't too hard to run multiple times.

Answer 2

I was using the good ol' Google Spreadsheet Gadget but they were deprecated.

Recently I saw that one of my old blog posts stopped showing a Google Map that was integrated with it.

A new search revealed this awesome project at GitHub called geo-googledocs:

Tools to integrate MapBox with Google Docs http://mapbox.com/blog/mapping-google-doc-spreadsheet/

It does the job beautifully! You can see it working on this spreadsheet I updated right now for that old blog post I mentioned.