How to… Import Pocket Queries into Excel

This a bit of a geeky one but who knows why you need this. We don’t judge.

  1. Download PQ from geocaching.com (you will need a premium membership for this)
  2. Open in Notepad (or other text-editor)
  3. Change the tag “<gpx bla bla bla bla bla bla bla bla bla bla >” to “<gpx>”
  4. Save as .xml
  5. Open Excel
  6. Open file
  7. Choose “Use the XML Source task pane”

    xls7

  8. OK

    xls8

  9. Drag’n drop, click refresh and enjoy!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s