Ever needed to find the height above sea level? Here’s a method to pull altitude data into Excel either from latitude and longitude, or a city name, address, postcode, or anything else that resolves to a location on Google Maps.

Seeing as the various Google Maps API posts on here seem to be so popular, when I saw Google’s elevation API I thought it should probably join distance, journey time and latitude & longitude in having an Excel function written for it.

It’s not that difficult. The form is pretty much the same as the others so I’ll just put it here.

To call it just enter =G_ELEVATION(LatLng) in a cell. LatLng there should be a reference to a cell which contains a latitude and longitude in the form “0.0000000,0.0000000”. If your latitude and longitude are in separate cells can use =G_ELEVATION(Lat&","&Lng).

You could even daisy-chain it with the latitude and longitude function like =G_ELEVATION(G_LATLNG("London, England")) to return London’s height above see level. It’s 20.23 meters, apparently.

Jamie Bull | jamiebull1@gmail.com

Related Posts

WiGLE is a popular platform which can be used for finding the location of a device using the names of WiFi networks in its vicinity. I’ve written about this before, and wrote some Python code to interact with their API. This API has since been retired and replaced with a new one, as of December […]

Just a quick post to point out a couple of really useful tools. The first is a web-based tool for finding weather files for a location of interest. It’s similar to the Excel EPW finder tool we created a few years back, but much more modern looking. It is however missing a few of the […]

Eppy is a really useful library which I’ve written about several times, since before I really had anything to offer in terms of contributing code. Over the past year or so though, I’ve started to contribute back some of the changes and additions I’ve made while using eppy on academic and commercial projects. This post […]

Leave a Reply

Your email address will not be published. Required fields are marked *