Free Geography Tools

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.