About Me

Hello and welcome to my blog, Love and Trails! My name is Morgan and I am the author, educator, map creator, chef and inventor around here! Love and Trails was born out of my passion for the outdoors. It is an avenue for me to share my knowledge and skills with others. Through it I hope to inspire others to embark on adventures of their own.


Weighing out Gear for the Google Sheet Gear Spreadsheet.

Ultimate Gear Spreadsheet: Google Sheets

I have long been a spreadsheet girl. In fact, my fiance Gerald recently proclaimed at a dinner party that “we are spreadsheet people”. He is right. We live and die by our trip planning checklists. We have a checklist for practically everything. Probably because we are procrastinators; it will be 5 pm on a Friday and we won’t have packed. We simply pull out the list open the bag and slide things in.

I decided that I wanted to up my Google Sheet game; I have long since used Excel but love how easy it is to use and share Google Sheets. As such, I made it my mission to translate my checklists to Google Sheets. Keen to dive in? Access the Google Sheet here! 

The Gear Closet

The main goal with this checklist is to contain an inventory of all the gear I own, allow me to easily add selected items to a list, and calculate the weight. With that in mind, the first sheet you need to know about is the Gear Closet. Within the Gear Closet worksheet, you can log, categorize, and list the weight of each piece of gear you own.

Gear Closet - Google Sheets Checklist

Trip Lists

Once you have logged the contents of your gear room the next step is simply to build lists for the various types of trips you take. For example, in the spreadsheet, you can see examples of different lists that I use.

Within each of these lists, you simply select the category of the item you wish to add, then in the next column, the item itself. The weight is automatically added as you go.

Trip Planning - Google Sheets Gear Checklist

Get Going Yourself

Here you can access a publicly editable version of the list I have created. If you would like to keep and modify it for your own use simply click File > Make a Copy. This will save a copy of the publically available file to your own Google Drive. From there you can edit it and make it your own!

Save a copy of the sheet to your own google drive

Have Suggestions?

Have a suggestion to improve the spreadsheet for everyone? Let me know in the comments!

Leave a Reply

3 Comment threads
0 Thread replies
Most reacted comment
Hottest comment thread
2 Comment authors
David BoyerClint Williams Recent comment authors

This site uses Akismet to reduce spam. Learn how your comment data is processed.

newest oldest most voted
Notify of
Clint Williams

This is awesome. Exactly what I was looking for so I wouldn’t have to resort to using a Filemaker Pro database. I love the dependent drop down lists that you guys created through the scripting. That makes managing the “list as a whole” a much less complicated task.

David Boyer
David Boyer

Thank you! This is exactly what I was looking for. The only change that I made was to add a “location” tab because my gear is in 3 different locations. GREAT JOB!


Clint and Jody from Emet.us have come up with another great checklist and shared it with us here: https://www.emet.us/gear-checklist/