Download caches found in excell format

[+Qaz]

Is there a way to download the listing of caches I have found that I can use in excel?

 

I looked at the pocket queries and that does not look like it would work.

Edited January 28, 2014 by qaz

[+NanCycle]

Go to Your Profile

Quick View

Under Your Logs (Last 30 Days)

Show all logs for Geocaches

Show Found it

 

This list will download to Excel. (Copy & Paste)

Edited January 28, 2014 by NanCycle

[Blue Square Thing]

There may be other ways to do this (and much more effective ways at that...) but...

 

If you go to Project-GC and create a Map Compare with just your username in the search fields you'll get a map (obviously) with all the caches you've found on it - and underneath will be the caches listed with various information about them. Highlight the cache information (click and drag) and paste into Excel seems to work - it did for me anyway. You'll just need to hack the headers around a little.

 

You'd probably want to add the Disabled/Archived filter as well.

 

You will have to do this for each country in turn unfortunately.

Edited January 28, 2014 by Blue Square Thing

[+Qaz]

Problem with copying it from the found it's in the geocaches is that it does not include the GC#'s

 

That's what I was trying at first.

 

Project-GC ? Where do you go to get into that ?

[+ngrrfan]

Project-GC ? Where do you go to get into that ?

Project-gc.com

[Blue Square Thing]

Project-GC ? Where do you go to get into that ?

You need to authenticate your account - i.e. link it to your account here - before you can do anything on there, but once you've done that this link:

 

http://project-gc.com/Maps/mapcompare/?profile_name=qaz&country=United+States&onefound=on&showdisabled=on&showarchived=on&submit=Filter

 

should produce your US map (if you click on the link it'll take you to an authentication request first I think).

 

Once you have that:

 

- you can change the country (and lots of other interesting things) by clicking on where it says Filters with an arrow above the map

 

- below the map there should be a tab that says Only qaz found. Click that and you'll get your list of caches. The GC number is included. The date isn't unfortunately.

 

- you may also find the Profile > Profile Stats link at the top quite useful possibly.

[+Qaz]

Great! Thanks everyone!

[+JBnW]

Another option would be to open your My Finds PQ in MapSource and/or Basecamp, and then either Save As or Export a CSV or Tab delimited file that goes straight into a spreadsheet.