export the caches from the virtual gps in a csv file it changes the latitude & longitude numbers to a different format

Question

Exporting to csv changes the Lat & Long to a different format ( from N33 52.305 to 33.87175 ) is there a way to prevent this from happening?

Answer 1

If you load the CVS in a spreadsheat you and convert the coordinate from d.d to d m.m with the formula below. 

It is for libre office and can probliy be modified for other software

The A9 has to be changet to the correct cell and S N changed to W for longitude

 

=IF(A9<0;"S";"N")&FLOOR(A9;1)&" "&FLOOR(MOD(A9*60;60)*1000;1)/1000

Comments

Tried it in Microsoft Excel but no luck

---

I dont have excel. Found on the web that , instead of ; shall be used in functions
I think the line below will work
=IF(A9<0,"S","N")&FLOOR(A9,1)&" "&FLOOR(MOD(A9*60,60)*1000,1)/1000

---

That worked like a charm, thanks

Answer 2

Decimal degree format is the format that groundspeak and gpx files use. They use this format because it is just a simple number, which is easier to store and process than the degree/decimal minutes format. Groundspeak then converts this to degree/decimal minute format for display on Geocaching.com, as does your GPS.

So the short answer is no, it cannot be changed.

The slightly longer answer is that this would actually be a nice option to add to CSV exports. How about it Ganja?

Answer 3

We have now released a new version of CSV export. It includes more (all?) fields, and also displayes the coordinates in the expected format instead of decimal.