Lat/Long from google?

[Rattus]

I just experimented further. I am generally signed out of Google, except when I have a specific need to sign in.

When signed out, it shows D/M/S in the blue part and decimal degrees in the white search box. When signed in, it is showing me D/M/S in both. When signed out again, it reverts to previous behaviour.

Not entirely sure what this tells us or how it can help you, other than pointing towards experimentation at your end to see if you can come up with the right combination of variables.

[KGarrad]

Just searching in Google.
Found this site: http://www.earthpoint.us/Convert.aspx

Copy-and-paste latitude and longitude separately, and hit "Calc".

[KGarrad]

I have been playing around!
So, I wrote an Excel spreadsheet to do the conversion

Send me your email address via PM if you want a copy.

With the Latitude-Longitude character string in cell A2, enter the following formulae:

B2 =LEFT(A2,(FIND("N",A2)-1))    Split out the Latitude coordinates
C2 =LEFT(B2,(FIND("°",B2)-1))     Split out the Degrees
D2 =MID(B2,(FIND("°",B2)+1),2)  Split out the Minutes
E2 =MID(B2,(FIND("'",B2)+1),4)   Split out the Seconds
F2 =C2+D2/60+E2/3600              Calculate the Decimal Latitude

Repeat for Longitude
G2 =RIGHT(A2,(FIND("N",A2)-1))   Split out the Longitude coordinates
H2 =LEFT(G2,(FIND("°",G2)-1))      Split out the Degrees
I2 =MID(G2,(FIND("°",G2)+1),2)    Split out the Minutes
J2 =MID(G2,(FIND("'",G2)+1),4)     Split out the Seconds
K2 =H2+I2/60+J2/3600                 Calculate the Decimal Longitude

Obviously, don't copy the red comments!

[bugbear]

I have been playing around!
So, I wrote an Excel spreadsheet to do the conversion

Thank for that!

I already use a perl/CGI script to tidy FreeBMD data, so I added some perl "inspired" by your Excel work to my script.

I'd still prefer google to give the format I want in the first place though.

 BugBear

[KGarrad]

I know what you would prefer!

Just offering an alternative - and I use Excel every day.
Thought I'd write something that would work on any spreadsheet?

A change is as good as a rest - and it was certainly a change from Ice Hockey Statistics, and Beer/Cider Festival stuff   (My usual activities)

[Marwite]

Have you tried clicking on "directions" under the degrees/minutes/seconds result?  For me, also Firefox, that produces the required format in a selectable field. 

(Another Gramps user, first used Streetmap to get lat & long but its search is so very clunky.  Google maps has never given me decimal format in that first panel.  Very odd.)

[bugbear]

Have you tried clicking on "directions" under the degrees/minutes/seconds result?  For me, also Firefox, that produces the required format in a selectable field.

No. No I hadn't.

But I have now, and it gives me sacred, blessed decimals. 

  BugBear