Jump to content
Sign in to follow this  
Followers 0
smithfamily33

Export "Found" logs to MS Excel???

Recommended Posts

I'm trying to track progress of my finds towards certain challenge caches, i.e. "Find 25 caches with an outdoor activity word", "15 caches with various food names", etc. I'm only at 200+ finds, so I'm getting close on some, have a ways to go on others. Is there a way I can periodically download my finds to an excel spreadsheet and track my progress? This would be tremendously helpful...Thanks.

Share this post


Link to post

A very old post several years ago suggests that you can do this sort of thing with the help of GSAK:

 

https://forums.geocaching.com/GC/index.php?/topic/153416-any-easy-way-to-convert-gpx-files-to-word-or-excel/&do=findComment&comment=2661216

 

Share this post


Link to post

Go to the advanced search: https://www.geocaching.com/play/search#Content
Hit the "Filter" button.
Jot down your outdoor keyword and set radio button "I've found"

 

ea4de6e9c8ea0c499ebdd239f1195c2a.png

 

My result (for keyword "wandern"):

 

0de9cb0c8981b30e341ba2761871375a.png

 

Save the URL of your resulting pages for future reference.

Hans

 

Share this post


Link to post
11 minutes ago, HHL said:

Go to the advanced search: https://www.geocaching.com/play/search#Content
Hit the "Filter" button.
Jot down your outdoor keyword and set radio button "I've found"

 

My result (for keyword "wandern"):

Save the URL of your resulting pages for future reference.

Hans

 

 

 

This works for a specific word, but not for a group of (not predetermined) related words.  

Does ProjectGC handle this?

Share this post


Link to post

I think the easiest way to do this is to use the bookmark feature for each of the challenges you are working on. When you log a find add it to the appropriate list or lists. I think one of the reasons new challenges of this type are not publishable under the new guidelines is that there is no easy way to create an auto checker. At least you don’t have thousand of finds to search through.

  • Helpful 1

Share this post


Link to post

What kind of information do you need to export to Excel? If the cache code and name will suffice GPSBable can convert the GPX into a tab delimited csv that can be sorted in Excel. If you need all the information in the GPX I think GSAK is your only choice. If you try the GPSBabel method set the input file format to GPX XML and the output to Garmin Mapsource - txt (tab delimited). There are several formats that I've not tried but I know what I listed is a quick way to come up with sorted cache codes and names.

Share this post


Link to post

If you have a PQ with your finds, you can easily open the GPx file with excel. (excel can open XML files and a GPX file is a kind of XML)

Then your can sort it as you want or apply any kind of post-processing.

  • Upvote 2

Share this post


Link to post

I have used a free program called GAPP to do exactly what you mentioned in the OP.  Get my finds into an Excel spreadsheet, so I can sort and filter my found caches in different ways.

 

However, I will say that I tried using the live api in GAPP the other day and it wasn't working for me.  But, that could just be an issue on my end.  I haven't gotten around to digging into the Forums for that program yet, since they are in the Dutch language, not English.  BUT, the program allows for loading gpx files, so a MyFinds PQ could be loaded without dealing with the Live API menu.

Share this post


Link to post
On 10/29/2018 at 4:00 PM, NanCycle said:

Does ProjectGC handle this?

It can show you some of what you look for, go to ProjectPc. find My Stats, then select badges.

 

The computer messed up what I wrote somehow!

 

 

Edited by Jayeffel
spelling

Share this post


Link to post
9 minutes ago, Jayeffel said:

iy ca n show your some ion wjsatt you look for, go to ProjectPc. find my stats the select badges.

Is this English? I doubt that. ;-(

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  
Followers 0

×