How to Convert Lat Long in DMS to Decimal Degrees in Excel

This short video shows you how to convert Latitude Longitude values from Degree, Minutes, Seconds into Decimal Degrees. There is two parts to this. The first being separating the DMS to separate columns for each value using text to column function, then the second using the math functions to convert the minutes and second to degrees to add to get decimal degrees.

[@adriandowning5532]

Brilliant! I've been working with Excel for years and I never knew the text-to-columns function! Great solution.

[@leikeli2]

Thank you for this! I knew how to do the math formulas, but the first portion was very helpful to get my data out of the degree/minute format!

[@kevinaltheim5881]

Thanks for this; your example was excellent; and now I know how to do this. I was quite easy; thanks again for putting this resource up for others. Well done; excellent work!

[@benjaminbanet7340]

Thanks a ton for this! Been trying for hours to figure this out and your video helped immensely.

[@Fairley_Bule]

This is still the easiest and most precise explanation on this. Thank you for sharing.

[@jmmifsud1]

Thank you - just created a conversion of angles for my shadow calculations using your video with relative ease !!

[@Tamarindgyal]

You helped me out of a jam but you didn't have your wallet turned on for me to send a payment. You seriously were a godsend, Thank you. Next time I hope I can pay you!

[@courtneymiller4624]

THANK YOU!!! this just saved me so much time/work!

[@wesgush]

Thanks a lot for this educational video. One thing I discovered after banging my head against the wall for a while is that depending on which "quarter" of the world you are in the +/- may be different for your decimal degrees. For example I am in South Africa, therefore south of the equator and east of the Greenwich Meridian so my latitude DDs need to be negative and my longitude DDs positive, which is the opposite to Moulay's example, as he must be based somewhere like the US (i.e. north of the equator, west of the GM. Otherwise very helpful, thanks!

[@debasishgogoi8955]

thanks a lot, Sir! that's what i love about tech.

[@KnotJinx]

You just saved me a lot of time. Thanks a lot. Cheers!

[@angelagonzalez4601]

Wow! You just saved me so much time! Thank you!

[@billisenberger7112]

Excellent video! thanks for posting.

[@zaynabshaik5340]

Thank you! Easy and helpful tutorial :-)

[@kirank_j]

Thank you, keep it up. It helped me lot.

[@debg939]

Thank you, very well explained

[@Jwargo10]

Thank you. This was a very quick easy and extremely helpful tutorial and a cinch compared to trying to manually convert multiples individually!

[@danielb1787]

I know it would be adding an extra step, but, for negative values aka Western Hemisphere, instead of subtracting, you can use the same formula used for lat vales, but when finished, simply multiply your DD by -1 and convert that way.

[@lilbykings]

Thanks. This is cool

[@me_meyou_youus_us]

Thank you man that is amazing help!

[@aeetcsdmalapparamba1425]

Thanx a lot bro It worked perfectly. U saved me a lot of time

[@elizabethatchoi4155]

Thank you for this! quick solution to a two day headacke! I did the first step a little different tough, because my coordinates didnt align very well on account of different number of characters - so i couldnt use the fixed with very well - i first selected the two original columns and substituted º ' " and N/W with instead of deleting them after the separation. :)

[@aravindgodi]

Thank you teacher, you saved 3 days time for me.

[@dresoto2694]

This was extremely helpful. keep up the good work teach

[@Liveforthisshit]

Thanks man, this was eZ thanks to you

[@shannamurphy5072]

So helpful--thanks!

[@prodanmn]

thx for tutorial, very useful example

[@gautamspeax]

I'm amazed! Thanks man :)

[@SmashMukesh]

Its very helpful thank you,sir...

[@madeindz3954]

thankyou very much شكرا كثيرا

[@dilmahdotryit]

great work, thanks a lot

[@TheJoseph0012]

Thanks dude! Now I can sleep...

[@linardskrumsteds3928]

Thank you for the help!

[@MegaDOMINOFREAK]

Very helpful. Thank you kind stranger.

[@orinamicedric5733]

Simple but yet didactical thanks a lot

[@brunof.m3170]

Huge thank you bro.

[@CrossetteEnterprises]

Good stuff. Is there a way to take a coordinate and reduce the digits, but keep the N or S at the end. For instance Let's say I have a 8 grid coordinate 3400N 2100W and I wanted to remove the 00 and at the end of the first and only 1 0 from the second and end up with 34N 210W is there a simple formula (conditional formatting or something I can do that could be applied to the cell?

[@Magnus247]

Really useful! Thanks

[@trieagustiyo4924]

Thank you so much, Only 1 question: for Southern Hemisphere is simply just put negative on the formula?

[@adolfohc78]

You saved me, THANKS!

[@sounny]

glad to help.

[@JohnBlackwell_FRAS]

Nice, but how does one work with a -00d20m35s latitude...? Similar to negative declinations in astronomy. This technique does bot handle this particular case.

[@gringoranchero1]

Thank you so much!

[@humbleafrikan6325]

thank you! Thank you! thank you!

[@firescrap3502]

Great work!! Can you send the calculation to convert DDM (Degree* Decimal. Minutes') to DD (Decimal Degrees)? Thank you so much!

[@kevinkev500]

Nice work on this. My only recommendation would be is to use a HD capture program. It's a little tough to read and follow along. Please keep up the good work, well done.

[@sounny]

+Kevin Kev will do in the future, this was one of my first captures with quicktime.

[@dimitricrtz3352]

Great video Hare krishna buddy

[@CrockGaming99]

It worked, thanks.

[@nataliyarybnikova892]

it helped very much)

[@rodrigozimmerle3140]

very helpful, thx

[@FarsatNajat]

Thank you very much

[@lilbykings]

Thank you very much. Excellent step by step description 👏🏾❤️🫶🏾

[@bouzianeibrahim164]

thank you brother

[@srinivms]

very good...it is very useful

[@VIJESHKRISHNA]

Thank you!

[@darrenjoseph1557]

Thank you. Solution to a week of rescoped GPS cords.

[@nehajaiswal5340]

if I am having a range of latitude for example 22º15' - 22º58' N the which value I should consider. Kindly reply soon

[@comedyworld4730]

THIS VIDEO MADE MY DAY. THANK YOU SO MUCH

[@fadlinauval5096]

Thank You :)

[@brownmunde8142]

Thanks you sir😊😊😊

[@ThePaganrage]

nice. thanks.

[@monadm5697]

Thanks,,but how you split the no. in the data option.. text... it was very fast didn't get it ... Thanks again

[@ahmedissa672]

Okay then, if it’s not a fixed what we can do ??

[@batoi8508]

very helpful thanky;u

[@shofpos4303]

hey #moulay_anwar.....i want to enter in the format cell the latitude and longitude and how to enter them correctly to covert them into decimal Please i want Fast reply for My own own work i want to finish it fast Furthermore, i want to add sybol to the lat/long like N Or W

[@shabangu288]

Hi Thanks for Video. Whats the reason for the No value pop up?

[@sounny]

It means there is something wrong with formula. You are pointing to a blank cell?

[@swvaroot]

Wouldn't it be simpler to just post the Excel sheet somewhere for download ?? :-)

[@futurewiseaerial7619]

go on then

[@sounny]

You can give people a fish and they eat for one day, you can teach them to fish and they eat their whole life.

[@daneger09]

@@sounny never hurts to provide the actual file in the video description below. haha.
But thanks, really! For teaching me this. It's a little frustrating that Excel doesn't have a built-in formula for conversions like that. I can't imagine it to be too complicated.

[@chellalhichemaymenkatib4645]

birilliant thank you

[@getinettafesetucho7999]

May you please tell me why you put -ve sign in front?

[@sounny]

In my case I am in north America so it is west of the prime meridian and negative. Depends what hemisphere you are in. The west and south are negative. The north and east positive.

[@dennisthacker5627]

i am trying to do something similar but my decimals are not lining up to separate. i tried to separate everything but it is over 15k rows. Any idea on how to do this? Thanks

[@sounny]

email me a few lines of it in an excel sheet, I have to see it in order to advice. [e-mail]

[@sounny]

Dennis Thacker You should check out my other video where I make DD to DMS, it does the function of separating out the degrees from the decimal portion you need. czcams.com/video/uOW88OfGhDs/video.html

[@aatifraza-en7ed]

THANKS

[@JouharaliKhan]

nice

[@raracinta]

it works on my computer but it doesnt on my friend's! anybody knows why? =(

[@John7Bennington]

How to do reverse of that

[@ecomedy4843]

😘😘😘 thanks

[@SharifulIslam-ow8wz]

You can easily convert degree minute second values into decimal degrees value in Microsoft Excel instantly. The length and amount of data is not a problem at all. You can even convert degree-minute-second readings with garbage into decimal degrees within just a matter of click. See the video- czcams.com/video/2uVkE_mReBM/video.html

[@pskumthekar]

Not able to see what is happening..

[@marceloverganio4682]

the video is blurry, can't see

[@manojitmalik4405]

Lat long to utm please sir

[@billwells8054]

EX-EL-Ent!!!! Thank you!

[@AneesMerzi]

your formula doesn't account for South and East

[@sounny]

I subtracted for the west, but for east just add instead. Use the formula for the north on the east and the formula from the west on the south and it will work for you.

[@dmcg2511]

Thank you so much!

[@dadishelwin2181]

Thank you very much