Coords in Word file to map?

For all your general chit chat, caching or not.
Bunya
Posts: 418
Joined: 10 May 05 5:51 pm
Location: South Australia

Coords in Word file to map?

Post by Bunya » 24 September 12 9:52 am

I have a set of coords in a Word file.
Is there an easy way to plot these onto a map? (For example like the map you get when you click on the geocaching.com map.)

User avatar
g_ordo
500 or more caches logged
500 or more caches logged
Posts: 57
Joined: 23 January 10 5:32 pm
Location: Myrrhee

Re: Coords in Word file to map?

Post by g_ordo » 24 September 12 10:33 am

Hi Bunya, go to http://www.gpsvisualizer.com/tutorials/waypoints.html here you will find how to create an excel file, take note of the top line of the sheet, with name/lat/long formatting, then you upload the file on the site and it will plot to co-ords for you...

Cheers Gordo

Bunya
Posts: 418
Joined: 10 May 05 5:51 pm
Location: South Australia

Re: Coords in Word file to map?

Post by Bunya » 24 September 12 10:52 am

Thanks for that - I'll give it a go.

User avatar
Agent Basil
2500 or more caches found
2500 or more caches found
Posts: 674
Joined: 31 July 08 8:26 pm
Location: Deakin, ACT

Re: Coords in Word file to map?

Post by Agent Basil » 24 September 12 11:19 am

Can't you just copy and paste into Google Maps ?

Bunya
Posts: 418
Joined: 10 May 05 5:51 pm
Location: South Australia

Re: Coords in Word file to map?

Post by Bunya » 24 September 12 11:51 am

Agent Basil wrote:Can't you just copy and paste into Google Maps ?
I tried that and Google Maps hung at the "loading" stage - perhaps I had the wrong input format.

I've got GPS Visualizer working and it's got a good number of options I've yet to fully explore - thanks g_ordo!

User avatar
gmj3191
7500 or more caches found
7500 or more caches found
Posts: 1316
Joined: 22 April 03 12:37 am
Location: Sandringham, Vic Garmin Oregon 650

Re: Coords in Word file to map?

Post by gmj3191 » 24 September 12 2:07 pm

If you have GSAK, import them into a database and use the Google Maps macro, it does a great job and very simple to use.
If you haven't got GSAK .....get it!

Image

User avatar
lemmykc
2500 or more caches found
2500 or more caches found
Posts: 328
Joined: 29 August 10 1:36 pm
Location: Hampton, Victoria, Australia

Re: Coords in Word file to map?

Post by lemmykc » 24 September 12 6:05 pm

gmj3191 wrote:If you have GSAK, import them into a database and use the Google Maps macro, it does a great job and very simple to use.
If you haven't got GSAK .....get it!
But what if he is a MacMan? You know, those sensible people unlike those Windows folk..... :P

User avatar
akkatracker
600 or more caches found
600 or more caches found
Posts: 221
Joined: 23 December 10 3:35 pm
Location: Sydney

Re: Coords in Word file to map?

Post by akkatracker » 24 September 12 6:10 pm

lemmykc wrote:
gmj3191 wrote:If you have GSAK, import them into a database and use the Google Maps macro, it does a great job and very simple to use.
If you haven't got GSAK .....get it!
But what if he is a MacMan? You know, those sensible people unlike those Windows folk..... :P
What wizardry? Crapintosh :P

User avatar
lemmykc
2500 or more caches found
2500 or more caches found
Posts: 328
Joined: 29 August 10 1:36 pm
Location: Hampton, Victoria, Australia

Re: Coords in Word file to map?

Post by lemmykc » 24 September 12 6:24 pm

akkatracker wrote:
lemmykc wrote:
gmj3191 wrote:If you have GSAK, import them into a database and use the Google Maps macro, it does a great job and very simple to use.
If you haven't got GSAK .....get it!
But what if he is a MacMan? You know, those sensible people unlike those Windows folk..... :P
What wizardry? Crapintosh :P
Windows is just a Window look into the past. Something like 1960's technology? :P

User avatar
gmj3191
7500 or more caches found
7500 or more caches found
Posts: 1316
Joined: 22 April 03 12:37 am
Location: Sandringham, Vic Garmin Oregon 650

Re: Coords in Word file to map?

Post by gmj3191 » 24 September 12 6:30 pm

lemmykc wrote:
akkatracker wrote:
lemmykc wrote:
gmj3191 wrote:If you have GSAK, import them into a database and use the Google Maps macro, it does a great job and very simple to use.
If you haven't got GSAK .....get it!
But what if he is a MacMan? You know, those sensible people unlike those Windows folk..... :P
What wizardry? Crapintosh :P
Windows is just a Window look into the past. Something like 1960's technology? :P
He could what you do Liam and run Windows under Basecamp most of the time.
The jig is up.

Bunya
Posts: 418
Joined: 10 May 05 5:51 pm
Location: South Australia

Re: Coords in Word file to map?

Post by Bunya » 24 September 12 6:32 pm

I'm not sure what you folks are going on about.
Would these things work on my TRS-80?

More seriously - yes, I do have GSAK, but I'm still having fun playing with GPS Visualizer and one new thing per day is enough for me!

User avatar
lemmykc
2500 or more caches found
2500 or more caches found
Posts: 328
Joined: 29 August 10 1:36 pm
Location: Hampton, Victoria, Australia

Re: Coords in Word file to map?

Post by lemmykc » 24 September 12 6:39 pm

gmj3191 wrote:
lemmykc wrote:
akkatracker wrote:
lemmykc wrote:
gmj3191 wrote:If you have GSAK, import them into a database and use the Google Maps macro, it does a great job and very simple to use.
If you haven't got GSAK .....get it!
But what if he is a MacMan? You know, those sensible people unlike those Windows folk..... :P
What wizardry? Crapintosh :P
Windows is just a Window look into the past. Something like 1960's technology? :P
He could what you do Liam and run Windows under Basecamp most of the time.
The jig is up.
I never said GSAK was as bad as Windows! GSAK is the only reason!

I swear I swear!!

User avatar
lemmykc
2500 or more caches found
2500 or more caches found
Posts: 328
Joined: 29 August 10 1:36 pm
Location: Hampton, Victoria, Australia

Re: Coords in Word file to map?

Post by lemmykc » 24 September 12 6:44 pm

Bunya wrote:I'm not sure what you folks are going on about.
Would these things work on my TRS-80?
Please! I've had enough of learning about the the technology of the Industrial Revolution in my Australian History classes at school!

User avatar
g_ordo
500 or more caches logged
500 or more caches logged
Posts: 57
Joined: 23 January 10 5:32 pm
Location: Myrrhee

Re: Coords in Word file to map?

Post by g_ordo » 25 September 12 11:19 am

I got gsac to do the export to macro last night, excellent, is there a way to get it show proximity from one point to the next closest?

I also worked out how to get it to strip the gc from the cache codes, so I can load a heap of caches onto my êtrex h. Very happy now!!!

User avatar
lemmykc
2500 or more caches found
2500 or more caches found
Posts: 328
Joined: 29 August 10 1:36 pm
Location: Hampton, Victoria, Australia

Re: Coords in Word file to map?

Post by lemmykc » 25 September 12 12:00 pm

g_ordo wrote:I got gsac to do the export to macro last night, excellent, is there a way to get it show proximity from one point to the next closest?

I also worked out how to get it to strip the gc from the cache codes, so I can load a heap of caches onto my êtrex h. Very happy now!!!
There is a macro for that too! Search 'KML' or 'proximity' or '.10'

Post Reply