Convert XYZ to Lat Long

[nando88]

I want to convert XYZ to Lat Long and viceversa, but I don't know how.
I have found many spreadsheets on the internet, but none of the ones I've tried seem to work correctly.
Can someone please share with with me a spreadsheet that can do this the right way?
Thanks in advance.

 

[DRSteele]

Just what is XYZ? Could you please clarify what you're after?

I gather you wish to convert a decimal numeral to Hours/Minutes/Seconds and vv. If that is so, this ought to suffice:

	A	B	C	D	E	F	G	H	I
1	locale	hours	minutes	seconds	Latitude	h	m	s	Longitude
2	Calgary	51	2	46	51.04611	114	3	24	114.05667
3	Calgary	51.00000	2.00000	46	51.04611	114.0000	3.0000	24.0000	114.05667

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet25​

Worksheet Formulas Cell Formula E2 =B2+C2/60+D2/3600 I2 =F2+G2/60+H2/3600 B3 =INT(E3) C3 =INT((E3-INT(E3))*60) D3 =((E3-INT(E3))*60-INT((E3-INT(E3))*60))*60 F3 =INT(I3) G3 =INT((I3-INT(I3))*60) H3 =((I3-INT(I3))*60-INT((I3-INT(I3))*60))*60 <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[nando88]

Sorry for not explaining myself correctly.
I wish to convert UTM coordinates to Latitude and longitude in excel.
Can you please give me the formulas as you did above, so I can do this?
Thanks in advance.

 

[nando88]

If you could also show me a way of how to convert latitude and longitude to UTM, I would really appreciate it.

 

[mikerickson]

The formulas for converting between UTM and latitude and longitude can be found in Wikipedia.
https://en.wikipedia.org/wiki/Universal_Transverse_Mercator_coordinate_system#Simplified_formulas

How you would implement them in Excel depends on how your spreadsheet is set up.

 

[DRSteele]

Read through this and we'll see if it helps us along.
https://www.uwgb.edu/dutchs/UsefulData/UTMFormulas.HTM

 

[nando88]

Can someone please share with me a spreadsheet that I can use to make these conversions the right way?
I tried making my own, but had no luck.
Thanks.