The John Muir Trail and Thru-Hike Planning – An Excel Workbook to Plan Your Hike!

December 3, 2018

Planning a thru-hike on the John Muir Trail (or any other trail)? Use this Excel workbook as a tool to organize and keep track of everything!

Planning a thru-hike on the John Muir Trail (or any other long-distance trail) can be overwhelming, it can take months of planning, and keeping track of details can be frustrating. There are so many different books, articles, and apps to reference that finding one comprehensive tool to plan your trek seems elusive, but from my own experience, I believe it all comes down to personal preference and how you choose to keep information organized.

I’ve written a couple of other blog posts related to what is involved in planning for a backpacking adventure of this magnitude, including ‘The JMT – I have to carry how much food?‘ In this particular post, I included some screenshots to a workbook I was using for selecting my on-trail menu. Since then, I’ve received multiple requests asking if I would provide a copy of my workbook to help others with their planning.

So without further ado, here it is, my comprehensive JMT Hike Planning Workbook (click to download)!

A couple of notes regarding the workbook:

  • It is a COMPREHENSIVE planning tool that includes worksheets for itineraries, logistics, resupplies, costs, food selection lists, food ordering lists, food schedules, and gear lists. Remember I spoke about planning being overwhelming? Well, this workbook is the epitome of that word, I apologize if looking at it gives you a migraine. People asked, and I provided.
  • It is an Excel workbook that contains formulas, vLookups, and pivot tables. If you are unfamiliar with any of these, using this workbook can be cumbersome and perhaps impossible to understand. Again, I apologize. People asked, and I provided.
  • In addition to the first row in every sheet, I’ve added comments in various cells on many of the worksheets. Be sure that you have comment viewing turned on in Excel.

Here are some other posts you might find helpful:

More about Go. Own It


    1. Hi, could you please email the workbook directly to me as well?


    1. Hi, I can’t seem to download the link for the planning excel sheet. Would you please email?

      1. Hello. I apologize for the difficulty. I just emailed it to you. If you need anything else, please let me know!

    1. Hello. Thank you so much for all the effort you put into this great resource. I had the same issue trying to download. Could you also email the excel sheet to me please. Many thanks. AH

      1. Hello, Aran! I apologize for the issues you’ve had downloading the file. I’m sending you the workbook via email now.

Leave a comment

Your email address will not be published. Required fields are marked *

%d bloggers like this: