Oct 202010
 

Addin for Microsoft Excel which allows you to perform forward and reverse geocoding, both by address and latitude / longitude, calculate Great Circle Distances using Vincenty’s algorithm, calculate travel distances and durations and verify the results with a Google Maps Task Pane, all inside your comfortable Excel interface.

This is useful for creating GoogleMap applications to find places from a list, like this.

Implements three Excel formulas:

=Geocode(request, location)

Request is the field to return:

  • status The status of the geocode request (Fetching, OK, N matches, etc.)
  • latitude The latitude of ‘location’
  • longitude The longitude of ‘location’
  • and so on: formatted_address, country political,administrative_area_level_1 political, administrative_area_level_2 political, administrative_area_level_3 political, locality political, sublocality political, route, street_number, postal_code, types, location_type, partial_match, point_of_interest, establishment, viewpointne, viewpointsw, airport establishment transit_station, bus_station transit_station, establishment, natural_feature, neighborhood political, postal_town, premise, street_address, subpremise

Location is the name or address of a place or point of interest

=GreatCircleDistance(latitude1, longitude1, latitude2, longitude2)

Calculates the Great Circle Distance using Vincenty’s Formula, with fallback to the Haversine formula when Vincenty’s method doesn’t converge.

=Travel(request, origin, destination, mode)

Calculates the distance or duration to get from origin to destination, according to Google Directions.

Request is the field to return:

  • distance The distance in metres from origin to destination
  • duration The estimated duration from origin to destination

Origin and destination are the names or addresses of the start and finish.

Mode is the mode of transport to use: Driving, Bicycling or Walking

Free download here

Enjoy!

Screenshot, click to enlarge:

  6 Responses to “GeodesiX – Geocoder, Great Circle Distance and Google Maps in Excel”

  1. I’m supposing you’re using Windows 7.
    In Windows explorer, double-click the zip file. You should see 2 files in there. Double-click the setup.exe.

  2. I am a low watt bulb. I have downloaded the zip file, but do not understand how to install it. I also do not see any documentation on its usage, other than what you have listed above. Can you help me get it installed? I am using Excel 2007.

    thanks

  3. AMAZING plugin – hunted for a LONG time trying to figure out how to do this, couldn’t even figure it out with the $300 latest version of Microsoft Mappoint, google earth, google maps by itself, etc. THANK YOU!

  4. Hi,

    This is a great add-in, but I can only see and use the Show Map button on the GeodesiX ribbon bar.

    How do I enable the Geodcode, GreatCircleDistance, and Travel UDF’s?

    Thank you,

    Robert

  5. Greetings from Ohio, USA.

    This is a really cool and (I expect) useful tool.

    Thanks for posting!

  6. The tool looks very interesting for my purpose. Only difference, I have the exact coordinates and need the country for output.
    Is this possible with this tool?

    Thanks Pierre

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)

*