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

enter image description here

I am facing same issue ? how to add the gadget thi sgadget is depricated.any other alternative for that. — Narasimha, Mar 03 '14 at 09:04
@Narasimha: check my answer http://stackoverflow.com/a/22581585/114029 — Leniel Maccaferri, Mar 22 '14 at 18:15

score 3 · Accepted Answer · answered Jul 20 '12 at 13:48

3

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.

answered Jul 20 '12 at 13:48

geocodezip

158,664
13
220
245

Funny, I just found that before you posted...I was just coming back here to post that exact answer...thanks! – Redwall Jul 20 '12 at 14:12
As ScottYoumans' answer suggested, this suggestion no longer works :( – Adrian van Vliet Feb 18 '14 at 08:10

Leniel Maccaferri · Answer 2 · 2014-03-22T18:51:09.427

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.

score 2 · Answer 3 · answered Aug 21 '14 at 15:14

2

The answers relating to Google spreadsheets are obsolete now.

I used this site which works well: http://www.findlatitudeandlongitude.com/batch-geocode/#.U_YD8x_8aYN

answered Aug 21 '14 at 15:14

GenericJam

2,915
5
31
33

score 1 · Answer 4 · edited May 23 '17 at 12:30

1

Google Spreadsheet gadgets, like the one pointed to by geocodezip's answer, will soon be disabled.

Stephen Morse's Batch Conversions of Address to Latitude/Longitude page allows for copy-and-paste conversion via Yahoo.

edited May 23 '17 at 12:30

Community

1
1

answered May 18 '13 at 15:32

ScottYoumans

48
4

Damn, apparently MapQuest doesn't allow you to confine your addresses to a certain country. Or at least not the way that this solution processes the supplied data... – Adrian van Vliet Feb 18 '14 at 08:25

score 0 · Answer 5 · answered Sep 22 '16 at 23:57

You can geocode addresses directly in Google Spreadsheets using the free GeoSheets add-on. It allows for you to do all sorts of lightweight GIS tasks and create maps without writing a bunch of code.

After you install the add-on, try this:

=GEO_GEOCODE(A1:A10)

That should return the list of lat/lng's that you're looking for.

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

5 Answers5