If you download the cache data files from the Snaptek site (as always,
thanks Brian and Jason!) and import them into Excel 2000 or Excel 2002
(XP), here's a formula that will generate a hyperlink to the web page
for any cache in the listing.
 
In the first blank column (Column "I" in the "az_caches_team" file,
Column "G" in the "az_caches" file) of Row 2, enter the following
formula:   
 
=Hyperlink("http://www.geocaching.com/seek/cache_details.asp?ID="&Hex2De
c(Right(C2,4)))
 
It will evaluate to the Web link of the cache that has its waypoint
listed in cell C2. You should then be able to click on it and, assuming
you are connected to the Internet, automatically open a browser window
containing that cache's web page. Once you've checked that the formula
is working, you can drag that formula down all the rows of the list, and
generate a hyperlink for each line.
 
If you enter this formula and get an Excel #NAME? error, you probably
need to install and/or enable the "Analysis ToolPak" Excel add-in. Go to
"Tools, Add-ins" on the Excel menu bar.
 
You can actually use this formula to convert a waypoint in any
spreadsheet into a link. Just replace "C2" in the above formula with the
cell address that contains the waypoint. As the formula is written, the
waypoint must be six characters in the format GCxxxx. To illustrate, the
waypoint must be in the cell as GC0057 not GC57.
 
Hope you find this useful.
 
Steve
Team Tierra Buena