+Qaz Posted January 28, 2014 Share Posted January 28, 2014 (edited) 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 Quote Link to comment
+NanCycle Posted January 28, 2014 Share Posted January 28, 2014 (edited) 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 Quote Link to comment
Blue Square Thing Posted January 28, 2014 Share Posted January 28, 2014 (edited) 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 Quote Link to comment
+Qaz Posted January 28, 2014 Author Share Posted January 28, 2014 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 ? Quote Link to comment
+ngrrfan Posted January 29, 2014 Share Posted January 29, 2014 Project-GC ? Where do you go to get into that ? Project-gc.com Quote Link to comment
Blue Square Thing Posted January 29, 2014 Share Posted January 29, 2014 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. Quote Link to comment
+Qaz Posted January 29, 2014 Author Share Posted January 29, 2014 Great! Thanks everyone! Quote Link to comment
+JBnW Posted January 29, 2014 Share Posted January 29, 2014 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. Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.