Geocoding and reverse geocoding with Google Maps APIs

Geocoding is to convert an address into a pair of coordinates.
Reverse geocoding is to convert coordinates into an address.
If you want to geocode or reverse geocode locations, dashdash can help you!

It takes only 3 simple steps:

  1. Grab a key
  2. Send the request for geocoding with GET
  3. Parse the request with PARSE
    (4. Then reverse geocode)

Here’s how the app looks like:

Grab a key

Follow our documentation here to get your Google API key.

Send the request

A2: “Empire State Building, NYC” (an address)
B2: =GEOCODE_GOOGLE(A2)

A2 is the address you’re looking for. B2 is the request itself, clean as a whistle.

Parse the request

C2: =PARSE(B2,"lat")
D2: =PARSE(B2,"lng")

C2 is that latitude and D2 is the longitude.

Lets reverse geocode now!

E2: =REVERSE_GEOCODE_GOOGLE(C2,D2)

E2 now contains the nicely formatted address that google has on its database.

Know more

About Google Maps Web Service API

  • Rate limiting: 50 requests per second.
  • Free quota per account (key): 2500 free requests per day.

You can do the same without our integration, i.e. by directly calling the Google Geocoding API with our GET function. In this case, you need to store your API key, e.g. in H1:

B2: =GET("https://maps.googleapis.com/maps/api/geocode/json?key="&H1&"&address="&A2)
C2: =PARSE(B2,"results[0].geometry.location.lat")
D2: =PARSE(B2,"results[0].geometry.location.lng")
E2: =PARSE(GET("https://maps.googleapis.com/maps/api/geocode/json?key="&H1&"&latlng="&C2&","&D2),"results[0].formatted_address")