The Naked Kayaker
  • Blog
    • Search the site
  • Resources
    • Complete List of Posts
    • Trip Planning 101
    • Intro to Kayaking - Course Outline
    • Where can I rent a kayak in Belgium/the Netherlands?
    • How do I get certified in NL?
    • Map of Paddling Clubs
    • Dutch-English Watersports Dictionary
  • Destinations
    • West Coast
    • Great Lakes Region
    • New York State
    • New England
    • Europe
    • Oceania
  • Water Nerd
  • About & Contact

Blog

"Believe me, my young friend. There is nothing, absolutely nothing,
half so worth doing as simply messing around in boats." 

The Wind in the Willows

Trip Planning 101: The Best Trip Planning Spreadsheet Ever, Seriously.

6/6/2016

7 Comments

 
Picture
Celebrating another well-planned trip! (Grand Sable Dunes, MI, 2014)
​This is the first in a 6-part series about the awesomeness of spreadsheets for planning your dream trip. An overview of the series can be found on the Trip Planning 101 page. Once a week for the next 5 weeks, I'll describe another part (e.g. budget, packing list, itinerary) of an awesome trip planning tool that I've developed and tested over the course many trips. This is a slight deviation from the standard Naked Kayaker posts, but I'm quite excited to share it because I think it's useful to more than just kayakers. 

Goal #1: make trip planning less daunting and a lot more fun.
Goal #2: save money and make the most of your time off.

What exactly is this trip planner?

​When it comes down to it - it's a spreadsheet with a bunch of different tabs to organize all your trip-related information.

​Boring, right? It doesn't have to be!

What I've come to realize is that not everyone loves spreadsheets. Many people actually dislike them, because they associate them with work or school. If you're one of these people, then I'd like to invite you to change your mind. Okay, let's be realistic for a moment - if you ended up on this blog post by searching google then you're probably also a spreadsheet lover... but let's be optimistic and carry on...

​The Trip Planning 101 Series

The series will include more or less 5 posts:

1. Brain Dump - Where should we go? What should we do? This is when/where the dreaming happens.

2. Itinerary - How do you piece together an itinerary now that you've got all these great ideas?

3. Budget - Probably the most valuable part of the whole tool. Here you can do pre-trip budget planning, during trip cost tracking, and post-trip settling up. Simple even if you have 8 people in your trip! 

4. Packing List - A handy way to let everyone pack light (save on baggage fees), but still have all the necessary items.

​5. The Complete Trip Planning Spreadsheet - Everything combined in a handy template that you can copy for your future trips, including flights, rental cars, and lodging! 
Picture
On a backpacking trip, not thinking about trip planning...

What makes it so great?

I've been doing some market research, and it's becoming clear that the free trip planning tools available online are limited in so many ways. Some are completely inflexible in terms of how lodging is organized/managed. Budgets are overly simple and don't help when you're tryin to settle up with your friends. Tools assume you're traveling to one location and back (terrible for any kind of roadtrip/wandering itinerary).

So here are a few reasons why this tools works better:

  • Not unnecessarily complicated - There are many trip planning spreadsheets out there with tons of formatting and complex formulas. This spreadsheet has everything you need and nothing more, making it easy to tailor to your needs. I've only added formatting if it adds to the functionality (like identifying whether or not hotels/campsites have been booked).
  • ... Yet capable of handling complex trips - Some of the top hits on google for planning spreadsheets are really limited in the kind of trips you can plan (e.g. only letting you stay in one hotel - who does that?).
  • Share it with your friends and family - Google Spreadsheets lets you share the spreadsheet so everyone can edit (or just look - for the worried parents out there). Everyone can work on it, separately or at the same time while you're in a trip planning conference call. It even has a handy little chat function, so you can chat with other people who happen to be planning at the same time.
  • Accessible from any phone/computer AND available offline - Since the spreadsheet is online, you can access/edit it from any location/computer. If you install Google Spreadsheets on your phone, you can tell it to store an offline copy, which is handy if you'll be traveling somewhere without cell service (think: any international/backcountry trips). Everytime you open it on WiFi, it will automatically update to the most recent version. Of course, I always have a hardcopy handy in case my phone dies/falls in water/gets stolen/falls off the roof of my car as I drive away (it has all happened...). 
  • Flexible - Unlike a lot of the paid/free trip planning software/apps out there, this spreadsheet knows no bounds. This will come up more in each of the posts in the series. But basically, each trip is different, and with this spreadsheet you can add info and delete pages as needed to get the most streamlined tool for the trip you're planning.
  • Free - I'm not trying to make money off this - I just get really excited about organizing trips. :) 
  • Planning can be fun - I realize that I say this as the friend-who-plans-things, but planning really can be fun, or at least a lot less painful than it has been. In the past few years I've had the chance to plan and go on several month-long roaming trips, and I honestly believe the planning phase can be nearly as exciting as the trip itself. It's an excuse to catch up with your friends, dream about the infinite permutations of things you could do, and make your trip go as smoothly (or unsmoothly) as you'd like.
Picture
Plan your trips well, and you just might find yourself wandering along a deserted beach with your friends...

​Who is the trip planner for?

​The trip planner is ideal for people who love wandering/road-trip style trips! If you're just going on a short weekend trip with a friend to one location, this spreadsheet is probably not necessary. But if you are traveling with multiple people and/or your trip involves multiple stops (think: roadtrip, city hopping, or backpacking around Europe), then this spreadsheet will be a lifesaver. It has a budget tool that can handle any combination of people and a clean way to organize lodging info for a 2-month trip where you stay somewhere different each night. And more!

​Disclaimer - If you already love spreadsheets and automating things and over-planning, then this might not be that enlightening for you (though I still think the Budget spreadsheet is quite handy, though...). 
Picture
Coordinating flights and travel for lots of travelers can seem daunting, but it doesn't have to be!

What makes me the expert?

To provide a bit of context, I have always been a lover of spreadsheets. Since high school I've documented my finances, job application statuses, exercise, headaches, weight, favorite recipes, to-do lists, and much more using these handy tables. Travel planning is no exception, and I don't think my friends will disagree if I say that I tend to be the most enthusiastic planner of the group. To build a little credibility, I'd like to mention that my friends and I have used this spreadsheet tool to seamlessly organize a number of complex trips:
​
  • 2011: 30-day cross-country roadtrip with 3 friends.
  • 2014: 24-day cross-country roadtrip involving 2 friends flying in to meet up for portions of the trip. 
  • 2015: 3-month trip across Europe (Norway, Portugal, Spain, Ireland, France, Switzerland, Italy) with 8 friends flying in from other countries to meet up for shorter segments.
  • 2011 - 2016: A pile of shorter (weekend/week-long) trips to other places

So here it goes! Stay tuned for the upcoming posts (aiming for once/week).
​How do you plan your trips? Let me know in the comments below :)
Continue to Step 2. The Dreaming/Brain Dump Phase!
Just take me to the trip planning spreadsheet!
7 Comments
Richard
1/27/2018 16:42:15

Hi, where is the travel sheet??

Reply
Nena link
2/13/2018 11:16:34

Hi Richard,
Thanks for your question! It reminded me that I never got around to finishing this series, and that it's still highly relevant. I just posted the 3rd in the series and will try to have the last few up in the next month or so. If you contact me directly (see About & Contact), then I'd be happy to share the complete template early.
Nena

Reply
Nena link
2/25/2018 01:04:40

Hi Richard,
The trip planning spreadsheet/template is now available here:
http://www.nakedkayaker.com/trip-planning-101.html

See page for access link and instructions for making a copy.
Feedback is always welcome!
Nena

Reply
Mutie link
7/10/2019 22:45:53

Its informative blog, thanks.

Reply
Norah link
12/24/2020 11:31:46

I enjoyyed reading your post

Reply
Tim Anderson link
12/23/2023 11:17:53

But planning really can be fun, or at least a lot less painful than it has been. In the past few years I've had the chance to plan and go on several month-long roaming trips, and I honestly believe the planning phase can be nearly as exciting as the trip itself. Thank you for the beautiful post!

Reply
Ashlee M link
6/24/2024 15:28:57

Thhanks great post

Reply



Leave a Reply.

    Welcome!

    This is a blog about exploring the outdoors (mostly by kayak), traveling, trip planning, and coastal engineering. It currently focuses on kayaking in the Netherlands and Belgium, but previous posts cover Upstate New York, California, and much more. See the Complete List of Blog Posts for a history of the site. Looking for something specific? Search the site here.

    In addition to the blog, check out the Water Nerd section, where I write about coastal engineering and hydrology. 

    ​Happy Paddling!
    ​Nena

    Subscribe Here!

    Email updates on new blog posts, about once per month.

    Reader Tips

    Click the "Read More" link at the bottom of each summary for more photos, to see an interactive map of the route, and to read about the adventure.

    Maps in each blog post: Click the icons to learn more about the launch site (amenities) and destinations. Click the square in the bottom-left corner to see an aerial photo behind the route.
    Suggestions much appreciated!


    Archives

    December 2020
    April 2019
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    August 2017
    July 2017
    May 2017
    April 2017
    March 2017
    September 2016
    August 2016
    July 2016
    June 2016
    May 2016
    March 2016
    December 2015
    November 2015
    June 2015
    May 2015
    April 2015
    March 2015
    February 2015
    January 2015
    November 2014
    October 2014
    September 2014
    August 2014
    July 2014
    June 2014
    May 2014
    April 2014
    March 2014
    February 2014
    December 2013
    June 2013
    May 2013
    December 2012
    November 2012
    June 2012
    May 2012
    May 2011
    November 2010
    October 2010
    September 2010
    August 2010
    July 2010
    June 2010
    May 2010


    Categories

    All
    Biking
    Camping
    Canoeing
    City Trip
    Distance: 00 - 05 Miles
    Distance: 05 - 10 Miles
    Distance: 10 - 15 Miles
    Distance: 15 - 20 Miles
    Distance: > 20 Miles
    Guest Post
    Hiking
    Kayak Polo
    Reflections
    Region: Belgium
    Region: California
    Region: Canary Islands
    Region: Croatia
    Region: France
    Region: Great Lakes
    Region: Greece
    Region: Italy
    Region: Netherlands
    Region: New York
    Region: New Zealand
    Region: Norway
    Region: Oregon
    Region: Portugal
    Region: Spain
    Region: Switzerland
    Region: UK
    Region: US East Coast
    Region: Vancouver
    Region: Washington
    Roadtrip
    Tide: Non-Tidal
    Tides: Non-Tidal
    Tides: Tidal
    Time Capsules
    Trip Planning 101
    Type: Bay
    Type: Canal
    Type: Channel
    Type: Fjord
    Type: Lake
    Type: Lake/Reservoir
    Type: Open Coast
    Type: River
    Water Nerd

    RSS Feed

    Click the RSS Feed link, copy the URL, and paste it into your favorite feed reader.
    Blog Expat: living abroad

    Expats Blog
© 2021 The Naked Kayaker. All rights Reserved.