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

Enjoy!

Screenshot, click to enlarge:

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

1. After you hae installed Geodesix you should see a map on the right and a ‘Geodesix’ tab in the ribbon.
If you don’t, run the troubleshooter
and send me the results

2. from where do i activate this add-in?

3. 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.

4. 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

5. 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!

6. 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

7. Greetings from Ohio, USA.

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

Thanks for posting!

8. 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