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.
Other posts in the Coordinate Converters series
- Coordinate Converters I – NAD Conversions
- Coordinate Converters II – Worldwide Coordinate Conversion
- Coordinate Converters III – Two Freeware Converters
- Fast Lookup Of The State Plane Coordinate System ID For Any US County
- Handy Online Lookup Of EPSG Coordinate System Codes
- Natural Area Coding Tool For Google Earth
- MGRS/UTM/Latitude-Longitude Converter
- Degree-Minute-Second To Decimal Degree Converter
- More Degree-Minute-Second Converter Options
- Reprojecting Raster Imagery I
- Reprojecting Raster Imagery II – ERDAS Viewfinder
- Additional ERDAS Viewfinder Utilities
- Options For MGRS Coordinate Conversion And Viewing
- Projection Parameters / Point-Of-Origin For State Plane Coordinate Systems (SPCS)
- Spreadsheet Tools For Lat/Long, MGRS and UTM Coordinate Conversions
“Cartisan Total Map Coordinate Converter” does anybody have the Marco for this spreadsheet
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.
I suspect they’ve had a major website meltdown, and should be back up again shortly; try again later this week.