convert lat long coordinates in a table to MGRS

Question

I have an Excel table with lat and long coordinates in separate fields. Now I'd like to convert these fields into a third field with its MGRS coordinate. Any suggestions of how?

Answer 1

If you have ArcGIS 10+, you can use the convert Coordinate notation tool, as mentioned by Neil Ayres.

If you don't have ArcGIS, you can use EarthPoint batch converter, which works directly from a spreadsheet.