Return to Project-GC

Welcome to Project-GC Q&A. Ask questions and get answers from other Project-GC users.

If you get a good answer, click the checkbox on the left to select it as the best answer.

Upvote answers or questions that have helped you.

If you don't get clear answers, edit your question to make it clearer.

0 votes
345 views
I am working a lot with google sheets to track my geocaching.  I know you can download .csv files from the Virtual GPS, but is it possible to get a .csv file of my geocache finds? I think the Virtual GPS has a limit to the number of lines in can export.
in Support and help by mikeri (350 points)

1 Answer

0 votes
This isn't a service that's available at PGC. I'd suggest googling "gpx to csv converter" or similar.
by Pleu (Moderator) (65.7k points)
Yes, but it could be. Couldn't it?
I doubt it would be used enough that it would make sense to spend time and resource on such a feature.
I do use GSAK to export a .csv file, and it's not too bad of a process. I was hoping to skip a few manual steps. Let me explain what I do after I get my .csv file. I import the .csv file into Google Sheets where I can manipulate it to create calendars that help me organize those geocache types and sizes into days when I need a find to complete the 366 Addons and I use it to organize those missing D/T combinations I need for the D/T Add-ons in BadgeGen.   I also use it to help find candidate geocaches to complete the Fizzy and Jasmer grids for different cache types and sizes both locally and along a route. Even if I was the only one to use such a feature, trust me, it would be used a lot. And if other geocachers embrace my love of spreadsheets, there would be many more users.
Okay, great for you. You already have a system there and I see no reason why Project-GC should add a feature to support that system as Project-GC already has tools for creating such calendars. The reasonable thing for Project-GC would be to want people to use the tools provided, not aid in workarounds for those that don't want to use those tools.
I have used the Needed Found Dates tool where I can create calendars for each type, size, difficulty, terrain, etc., or a combination of these things that I haven't found. The first version of my spreadsheet used these outputs from the Needed found dates tool to populate the Google Sheet.

I've also used the Download ICS calendar file option from the Needed Found Dates tool to create a variety of different calendars in Google calendar for the Type and Sizes, but when I added the Difficulties and Terrains, it became cumbersome and unreadable. So, I switched to a Google Sheet version.

In the current version of the spreadsheet, I found it more useful to get all the data from the Project-GC My Finds GPXs and began converting it into a CSV file using GSAK to populate the Google Sheet. It's made the process much easier, but being able to download my finds as a CSV file would make it even easier.

In my use of  Project-GC, it does create calendars of individual type, size, difficulty, terrain, etc., or a combination of these things, but I haven't been able to find the tool in Project-GC that will create a calendar that shows every type, size, difficulty, terrain, etc., I need to find for a certain day. This is what the Google Sheet show me.

In summary, I have used Project-GC’s tools (like Needed Found Dates), but because I am targeting multiple 366-day BadgeGen add-ons at once (Type, Size, etc.), viewing them requires checking multiple separate calendars every day.

My spreadsheet isn't a workaround to avoid Project-GC tools; it was born out of necessity to consolidate all that data into a single, daily checklist and calendar.

If a tool, or even a non-challenge challenge checker, exists that will show me every type, size, and anything else you can earn a 366-Day addon in BadgeGen in one calendar, can you direct me to it?

Thank you for your time.
...