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 lengths, 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

The latitude, if it were below the equator would be negative, and the same will happen with the 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, geographical, with and without decimals.

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 decimals that we hope will round the concatenation. With care, that rounding off 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 they do not fall elsewhere. The columns have always been left 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.

20 Replies to "Convert degrees / minutes / seconds to decimals"

  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:
    75 ° 14'57 »
    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 ,, bone to decimal ,, help please

  5. I decided to send the code:

    Function GMS (DegreesDecimal)
    Az = Degrees Decimal
    60): If s> = 3600 Then s = 60: m = 0: s = 60: s = 0 = M + 1
    If m> = 60 Then m = 0: g = g + 1
    If g> = 360 Then g = 0
    GMS = g & «°» & m & «'» & s & «» »
    End Function

  6. 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 do not know how to upload it to the forum. Someone help me please.

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

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

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

  10. 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 closed 79 minutes, we would have 79 × 60 = 4,740. Which means that you still have 10 seconds to reach the 4,750

    In conclusion:

    1 degree, 19 minutes, 10 seconds

  11. 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

  12. You can use «Convert to GPS file to plain text or GPX» from the web page 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.

This site uses Akismet to reduce spam. Learn how your comment data is processed.