blankblank blank




Spreadsheet Tools For Lat/Long, MGRS and UTM Coordinate Conversions



Cartisan Maps has several free spreadsheet tools for basic coordinate conversions; each one can handle up to 5000 sets of coordinates. Files are in Microsoft Excel format, but seem to work fine in OpenOffice 2.4.

Cartisan Map Coordinate Converter: Enter latitude and longitude in separate columns for degrees, minutes and seconds, and have them converted to a DD MM SS string, DD MM.d string, or numeric decimal degrees. The first column, labeled Hemisphere, is multiplied times the longitude, and if you leave it blank, the calculated degree value for longitude will always be zero. Enter “1″ for East longitudes, “-1″ for West longitudes, and make sure your longitude degree value is always positive; or, enter a “1″, and then enter positive and negative values for the longitude degree value. Cartisan also has a link to simple VBA code to do these transformations, which you can download.

Cartisan Total Map Coordinate Converter: Converts from decimal and DDMMSS latitude/longitude to UTM and MGRS, and back again; includes support for 14 datums, including NAD27 and WGS84. Also has another version of a converter from degrees/minutes/seconds to decimal degrees and back, similar in output to the one above.Requires that you have macros enabled in your spreadsheet program. Notes: 1. File is in the .RAR compression format; if your unzipping program can’t handle that, try 7-Zip. 2. Enter your coordinate data in the areas highlighted in green in the spreadsheet.


Looking for something else? Enter some keywords below, then click "Search".
"This site" searches Free Geography Tools; "Web" searches the Internet using Google.
 



3 Responses to “Spreadsheet Tools For Lat/Long, MGRS and UTM Coordinate Conversions”


  1. 1 Ryan

    “Cartisan Total Map Coordinate Converter” does anybody have the Marco for this spreadsheet

  2. 2 Yannick

    Hi, looks like the Cartisan Total Map Coordinate Converter is no longer available from the website (actually, the whole site’s down)
    Would anybody have a copy ?
    Thanks in advance.

  3. 3 Leszek Pawlowicz

    I suspect they’ve had a major website meltdown, and should be back up again shortly; try again later this week.

Leave a Reply


I welcome all legitimate comments. But spammers should know that my spam filters are currently blocking almost 100% of comment spam, and any that gets through the filters is immediately deleted. Don't believe me? Try posting a spam comment, and see what happens.

Powered by WP Hashcash