Microsoft Streets And Trips

[+t-hunt, Inc]

Anyone use Streets and Trips to map out cache coordinates? I'd like to download a pocket query and import it in. The map printing features are superior to my Garmin software.

[+buck09]

This assumes you have Microsoft Excel - version XP or 2003

 

The .loc files you download from the geocaching site are in a format called XML. Download your .loc file and save it to your hard drive. (DON'T OPEN IT IN EASYGPS - it will change the format right away).

 

Go into Microsoft Excel and open a new worksheet. Click Data -> XML -> Import. Under "files of type" select "All Files (*.*)".

 

From there, find your .loc file and it will import into a new worksheet.

 

Save your workbook as a regular excel spreadsheet.

 

Next, open S&T and click Data -> Import Data Wizard.

 

Find your excel worksheet and open it.

 

Then, you have to tell S&T which colums are which - Lat, Long and a minimum. I also [ut the geocache number and name in the Name and Name1 fields.

 

click ok and all the caches will display on the map.

[+PDOP's]

You can use GPSBabel or GSAK (which uses Babel internally) to do this and even automate the whole process.

 

Importing waypoints to Microsoft Streets & Trips

 

Xangxa's Automating Custom MSST Pushpins

 

Edit to update link.

Edited January 16, 2006 by PDOP's

[+t-hunt, Inc]

Awesome! Thanks loads for the info! Works like a charm.