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

google-maps google-maps-api-3 latitude-longitude google-sheets geotagging
Redwall picture Redwall · Jul 20, 2012 · Viewed 15.9k times · Source

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

enter image description here

Answer

geocodezip picture geocodezip · Jul 20, 2012

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.

Related questions

Using Address Instead Of Longitude And Latitude With Google Maps API

I've heard that it is possible to submit an Address instead of Longitude and Latitude and this would be much more feasible for my system. The user has to input their address when creating their profile and their profile afterwards …

Read More
Maximum Lat and Long bounds for the world - Google Maps API LatLngBounds()

The Google Maps terrain view by default has unlimited panning of the map tile. You can use LatLngBounds() to limit this, but what are the maximum and minimum coordinates I should use to set the viewport as just the earth …

Read More
Latitude, Longitude Grabber

What I would like to do is create app where when anyone clicks on the map object and two fields get filled with latitude and longitude at every click. Is there sample code of Google Maps V3 JavaScript API (Geocoding …

Read More