How do I create a spreadsheet for Geocache finds.

[+tdfthom1975]

Hopefully someone has the answer I'm looking for. I want to create a spreadsheet with all the Geocaches I have found, I know how to do this for each individual cache, but this will take a very long time. Is there a option to download all finds as a CSV file?

 

Many thanks

 

Tristan Thom

[+bflentje]

Hopefully someone has the answer I'm looking for. I want to create a spreadsheet with all the Geocaches I have found, I know how to do this for each individual cache, but this will take a very long time. Is there a option to download all finds as a CSV file?

 

Many thanks

 

Tristan Thom

 

Become a Premium Member and then downloads your My Finds pocket query.

[Pup Patrol]

Since you already are a Premium Member, the My Finds pocket query will also help you find those duplicate "found it" logs, if that is of concern to you.

 

http://support.Groundspeak.com/index.php?pg=kb.chapter&id=28

 

A special query is available, My Finds. This query is found at the bottom of the Pocket Query page, in the grey background pane. It will return all the geocaches you have found, with no limit on that number, and it will return archived geocaches. It will return all of your log entries on those geocaches.

 

 

B.

[+Harry Dolphin]

I go into: My Profile, click on Geocaches, click on Found. Lists all the caches I have found. Copy and paste into Excel. Warning: the cache type icon will be on top of the cache name. And it does not list the GC code for the cache.

[+Cardinal Red]

Hopefully someone has the answer I'm looking for. I want to create a spreadsheet with all the Geocaches I have found, I know how to do this for each individual cache, but this will take a very long time. Is there a option to download all finds as a CSV file?

 

Many thanks

 

Tristan Thom

 

Are you only open to free solutions? And I don't mean GSAK. I routinely convert PQ data to Excel (via CSV), and from Excel back to GPX. But it wasn't free.

Edited August 21, 2013 by Cardinal Red

[+Walts Hunting]

Sounds like a job for gsak. It will take your file and export a csv file although why you would is beyond me. GSAK is probably to whatever you want and more.

[+Burton Kidz]

The Pocket Query suggestion is good, but it won't show the date you found it if there have been several finds after yours. Any other suggestions for finding out our own data?

[+Walts Hunting]

The Pocket Query suggestion is good, but it won't show the date you found it if there have been several finds after yours. Any other suggestions for finding out our own data?

 

It will if he runs the My Finds query. Only shows his logs.