Skip to content

Instantly share code, notes, and snippets.

@Computer-Tsu
Last active September 30, 2026 20:30
Show Gist options
  • Select an option

  • Save Computer-Tsu/bb0d58321769871269574f2b6d83ee62 to your computer and use it in GitHub Desktop.

Select an option

Save Computer-Tsu/bb0d58321769871269574f2b6d83ee62 to your computer and use it in GitHub Desktop.

GPS and Maidenhead gridsquare conversions for Excel into Latitude and Longitude (decimal)

=(CODE(MID(A2,2,1))-65)*10 + VALUE(MID(A2,4,1)) + (CODE(MID(A2,6,1))-97)/24 + 1/48 - 90
=(CODE(MID(A2,1,1))-65)*20 + VALUE(MID(A2,3,1))*2 + (CODE(MID(A2,5,1))-97)/12 + 1/24 - 180

presumes 6-character gridsquare address stored in column A. Case-sensitive, 2 UPPERCASE letters, 2 numbers 2 lowercase.
first formula provides latitude. second line provides the longitude.
(+/- decimal)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment