MapsDownloadsGoogle earth / maps

Convert degrees / minutes / seconds to decimals

Some time ago I have been asking for this, and since the friend looks like a Little hurried And today is a day to celebrate many things, here I leave a tool that allows you to convert geographic coordinates, degrees to decimals.

Why the conversion table

It is common to find coordinates that are in degrees, minutes, seconds, for example:

75°25'23.72”N 45°59'12”W

The N means that it is a latitude 75 degrees above the equator, if it had an S it would mean that it is in the southern hemisphere. In the case of longitudes, they will have E or W, depending on whether they are east or west of the Greenwich meridian

Programs such as Google Earth and ArcGIS require that they go in decimal format, such as:

75.42325556 -45.98666667

Latitude, if it were below the equator, would be negative, and the same will happen with longitudes, which would be negative for the western hemisphere. I recommend to understand it, play a bit with Google Earth, changing the UTM display options, geographic, with and without decimal places.

Convert geographic coordinates, degrees to decimals

How the table works to convert geographic coordinates, degrees to decimals

Always using the Gabriel Ortiz table, which had been arranged for the conversion of geographic coordinates to UTM, displaying a column where they are seen in decimal format.

Convert degrees to decimal coordinates

  • You can choose the spheroid, in the upper flange.
  • The columns in yellow, are to enter the data, in the first column accepts a point identifier number.
  • To the right of each one is the latitude and longitude in decimal form, without rounding, with its respective negative symbol when it corresponds.
  • The orange column contains the concatenated data, with the point number, latitude and longitude.
  • In the header of this column, you can enter the number of decimal places we expect the concatenation to round. Be careful, that rounding decimals of geographic coordinates can lead to large errors.

Send the coordinates to txt

Convert degrees to decimal coordinates


To send them to a txt file, just open a new file, copy the data from the orange column and paste it there.

Then this file can be loaded from Google Earth, indicating the order, such as I explained it in that post.

Of course, the Datum must be in WGS84 so that they do not fall elsewhere. The columns have always been to convert to UTM and concatenate for AutoCAD, as it was The original version Of this table.


Convert geographic coordinates, degrees to decimals

Downloading it requires a symbolic contribution for the download, which you can do with Paypal or credit card.

It is symbolic if one considers the utility it provides and the ease with which it can be acquired.





Learn how to make this and other templates in the Excel-CAD-GIS cheat course.


Golgi Alvarez

Writer, researcher, specialist in Land Management Models. He has participated in the conceptualization and implementation of models such as: National Property Administration System SINAP in Honduras, Management Model of Joint Municipalities in Honduras, Integrated Cadastre-Registry Management Model in Nicaragua, Territory Administration System SAT in Colombia . Editor of the Geofumadas knowledge blog since 2007 and creator of the AulaGEO Academy that includes more than 100 courses on GIS - CAD - BIM - Digital Twins topics.

Related Articles


  1. Hello Raul
    Each grade has 60 minutes and every minute 60 seconds. What happens is that when you mark them on the map or the sphere, they are only made at a certain distance so as not to overload the grid.

  2. Hi, how are you? I'm a bit confused with this of the degrees, minutes and seconds because in geography it is assumed that each meridian measures 15 degrees and each degree therefore measures 4 minutes, how is it possible then that 1 degree measures 60 minutes? Or measure 4 or measure 60, how's that? I hope someone can respond
    Thanks a lot and greetings

  3. Let's see.
    One degree has 60 minutes, but in this case you do not have minutes.
    But each grade also has 3,600 seconds (60 minutes for 60 seconds). So your 15 seconds are equivalent to:
    15 / 3600 = 0.004166
    Then 75.004166 would be degrees in decimal format.

    Let's take another example that includes degrees, minutes, and seconds:
    Grades: 75
    Minutes: 14, which are equivalent to 14 / 60 = 0.23333 degrees
    The seconds: 57 / 3600, equivalent to 0.0158333 degrees.

    Summed would be 75.249166 degrees.

  4. well, nothing I need to know how to pass 75 ° 15 ″ to value ,, that is to say, to decimal ,, please help

  5. Thanks for the info, surely someone can take advantage of it.

  6. I decided to send the code:

    Function GMS (DegreesDecimal)
    Az = Degrees Decimal
    g = Int (az): m = Int ((az - g) * 60): s = Round (3600 * (az - g - m / 60), 0): If s> = 60 Then s = 0: m = m + 1
    If m> = 60 Then m = 0: g = g + 1
    If g> = 360 Then g = 0
    MSG = g & “° ” & m & “' ” & s & “””
    End Function

  7. I made a complement for Excel whose function is to transform an angle Decimal degrees into a Grade 2 Minute text
    3.15218 = 3 ° 09'7.85 ″, but I don't know how to upload it to the forum. Someone help me please.

  8. I want a table to convert UTM PSAD56 to Degrees, decimal minutes
    Thank you

  9. Nu ma thank you very much for the auda nu knew nothing but graxiias

  10. many thanks!! You do not know how much was lost, hahaha, a saludooo !!!!!!!!!

  11. The first, first
    1 grade has 60 minutes, one minute 60 seconds.

    Divides 4,750 between 60 to know how many degrees there are, that gives 79.16

    Then, you would have 1 degree (for 60 minutes) but 19 minutes both add 79 grades.

    When totaling how many seconds there are in the closed 79 minutes, we would have 79 × 60 = 4,740. Which means you still have 10 seconds left to hit 4,750

    In conclusion:

    1 degree, 19 minutes, 10 seconds

  12. I need you to tell me the precedence to follow to express in degrees, minutes and seconds: 4750 seconds. I have not the slightest idea

  13. Pork do not put things to serve pure porkeria

  14. You can use "Convert a GPS file to plain text or GPX" from the webpage And transforms the points into a GPX file and loads it into GE or the Global Mapper and from there to the format you need.
    Greetings from Argentina and every day I check the blog is very interesting.

Leave a comment

Your email address will not be published. Required fields are marked with *

Back to top button