What a Good Travel Itinerary Template Must Contain Before You Trust It With Your Trip

Choose a travel itinerary template based on the type of fields it requires you to complete, not based on how attractive the page is. The template determines what information gets written and what information you never consider again. The majority of the most used free templates are set up with where you’re going to, when, what you’re doing and the confirmation number; therefore, the information that will ultimately determine your trip’s success has no place to sit.

This isn’t an argument for the largest spreadsheet you can find. If you have a template with a column for everything, sooner or later, you will quit updating it altogether, and if you never enter anything into a column, it will become meaningless and create noise on your page. The trade-off is significant, and that’s why you should spend at least ten minutes on this decision instead of just thirty seconds. There are a limited number of columns available on a template that will hold up over time versus those templates that simply appear to be well organised.

The Column You Don’t Have Is the Detail You’ll Forget

A Template Is Not A Layout! A Template Is A List Of Questions With Answers.

The Columns Provide Direction: Booking Reference Emails Us Back To Confirmation Emails, Check-In Times Directly To Hotel Pages, and Flight Numbers Directly To Airline Schedules.

If The Column Were Removed, No Direction Would Be Provided. Nobody Just Sits Down And Says “I Want To Skip The Moment Check-In Closes”, The Reason Being Is There Is Nothing In The File To Refer To, Therefore No Questions Can Be Asked. An Empty Cell Keeps Reminding Us, A Missing Cell Does Not.

Operators’ Timeframes, Cut-Offs, Passengers’ Rights Listed Below Were Checked On 20 September 2026, And Are Set By Airlines, Railway Companies And Regulators Who Can Change These Rules At Any Time. Be Sure To Research The Rules For Your Route From Your Operators Webpage Before You Book Everything [yourself].

When You Read The Current Guides That Rank Travel Itineraries, They Intersect At The Same Points; Dates, Destinations, Daily Assigned Grids Of Travel, Flight Train Schedules, Assignment Of Hotels With Confirmation Number, Budget, Emergency Contact Numbers, and All Other Related Information. It’s A Reasonable List. It’s Also An Exact Match On Every Site, And The Same Information As When Planning A Trip Begins To Get Complicated (Case: When Should My Next Leg Be Booked After The Previously Booked One Runs Late; When Would My Arrival Land After Midnight, And Finally, What Time Is My Flight Door Actually Closing?).

The gap will be filled in by hand. A former thread from the Rick Steves travel forum on January 2026 shows someone asking for a simple template for a trip to Italy got a public column list back in another person’s post. The list showed “Cancel Date (if non-refundable, highlight cell in red)” and “Week Day” — the second column, according to that poster, is important for those that do not want to schedule trains/buses on Sundays in a few countries. Neither of these columns are included in the generated downloadable file. An experienced traveller added these columns after experiencing this first-hand.

The best way to read a free template is to review the five questions that you can either ask for or not: what mode of transportation do you actually use for which parts of your trip? When are the actual bookings made in the local time zone of the respective country? What evidence do you have of bookings made and what is the cancellation policy? At what time does each door close? When do you expect to use the downloaded file? The balance of the guide gives you the answers for these five questions. So, let’s start by taking a look at what is being used in the layout of the most downloaded files.

Four Popular Free Layouts, Audited: What Canva, Vertex42, Smartsheet and Template.net Leave Blank

Four different types of templates are available – all on 20 September 2026 – and all available for free to start. The table below contains information about what types of questions each file will generate but does not provide information on which type of template is best to use. It is imperative to understand that Smartsheet’s template is considered the “exception” and therefore important to specify why it should not be grouped with the other files as an exception.

The template from Smartsheet does provide an itinerary but it does not include layover times as the other three templates do. However, having an itinerary that contains two times does not indicate what happens if the first time falls through; specifically whether both legs of the trip are on the same ticket and what alternate transportation will be provided. Furthermore, the flight schedule is distinct from the day-by-day timeline; thus, a consumer who purchases the vacation template will never see it.

All four templates should include a date in addition to the qualifier “Free”. Vertex42’s page is clearly marked with the date of the most recent revision as 2011 and Smartsheet has been reviewed with no updates since 2018. This is especially true for a standard blank template but it does indicate that no one has made changes to the column titles for a lengthy time. Canva has a gallery full of templates that are free to open and according to its own help pages, premium elements will not be available until they are paid for or upgraded to become available. Inclusions of premium templates can be found on the Template.net website as well as a button to upgrade and additional tier options for premium templates and exclusivity of watermark-free files.

The decision-making principle is as follows: When choosing a free itinerary template, look at the column headers, rather than at the cover; download the template from the website that has created it, rather than from someone who has downloaded and re-uploaded it; view one of the four templates as a base that you would modify to fit your needs, since none of them have a “route” row.

One Row per Transit Leg, With Connection Time and “Same Ticket?” Written Down

A day grid tracks your location, but does not provide information on how you arrived at that location. This is the point in time where the day diverges.

To track your travels, create one row per leg of your journey. Each row should include all relevant information for that leg of travel (i.e., mode, operator, departure point and time, arrival point and time), together with three additional pieces of information not included in a travel download: connection time as published and as you expected; ticket status (i.e. same booking or a new purchase for this leg) and next service in case you miss this leg.

The middle column of the grid will be the most impactful in terms of outcome, because it is where responsibility changes. When two legs are part of the same booking (or itinerary), the company that sold you the entire itinerary is responsible for mitigating issues caused by delays on either leg. However, if you have two separate bookings for the same trip to get to your final destination, the first operator has no obligation to cover the cost of delays incurred on the second leg.

Ticket Status issues should be monitored with a Status rather than a Promise to provide you with your Rights. For example, in Europe, Rail Passenger Rights are now governed by Regulation (EU) 2021/782, which supersedes the 2007 Regulation and has been in effect since 7 June 2023; in addition, the European Commission has published a Common Claim Form for Rail Passengers, which can be used to file claims for delays, missed connections and cancellations. However, as indicated on the same page, there may be exceptions or exclusions for certain types of services from specific parts of the Regulation at the discretion of Member States. This means that even if your trip qualifies within the definition of an “EU Train”, you still must verify what Rules apply to your journey on the day of travel by checking the Rail Passenger Rights Guidance for the Country you are travelling through by the Date of 20 September 2026.

If you want to quickly see if a connecting flight exists, you do not have to read through Legal Documents. Using the Manage My Bookings Page provided by the airline, all you need to do is input the booking reference number, and then you will be able to view your flight and the flights connecting to it, no matter what airline operates them. Using British Airways as an example, the Manage My Bookings page will indicate which flights connect to your flight, including those operated by other Airlines, which means that if the flight connecting to yours does not appear to be booked under the same Reservation, your row in the Template should indicate this.

On any given day, two minutes of lost time in a fallback column can equal one minute’s worth of accumulated savings. You will also need to write down the next departure for that same route with associated departure time—if the next train joins the same route—you will want to list it at the bottom under your fallback column so that at the Transfer Desk you can simply check when you will next receive a train (or bus) from that route rather than having a conversation (or argument). The next departure from that same route will allow you to determine quickly if you should go with this connection or not as it will likely be very close to each other. In short, there is nothing in the section with a travel connection that explicitly states if there is enough time available. You will have to make that decision separately. If you are not certain of the exact time of the travel connection, double-checking the travel connection may take additional time and expense, but you should confirm that you has a sufficient time to plan your day around.

Local Time, the “+1” Day and the Day of the Week: Three Date Fields Missing From Most Grids

Departure and arrival times that have already been published correspond to time measured by a clock somewhere; i.e.; each and every published departure time has been published according to the clock that exists at the point of departure from the starting city; whereas every published arrival time has been published according to the clock in its destination city (arrival); a travel journey that travels far enough east, or over a long enough period of time, will also find its arrival date (arrival) does not correspond with the date(Thursday) of when it departed (departure).

We should therefore include three fields instead of just one. To label the corresponding date for the respective departure time, we should have a separate date field for arrival time along with an area for markers (i.e. markings) used by the operator at the landings on subsequent dates, i.e. the markers for the arrival time. It would also be helpful to include the respective days of the week corresponding with the respective arrival and departure dates; since as mentioned earlier, they are normally added in by hand by planners who experience a travel journey.

There are also practical reasons for doing this. The process of operating airline schedules is most frequently associated with the calendar date rather than the time (hours elapsed) of travel. For example, British Airways has a schedule that allows for passengers to drop off luggage for flights that depart before 10:00 the next day; this means passengers are able to drop off their luggage (overnight drop-off) between the hours of 16:00-22:00 on the previous day’s journey (19 September 2026); the operator will then include that information on the passengers itinerary. A traveler can interpret this to be convenient when looking solely at one time column on their itinerary. When looking at the date column, we realize that the “drop-off” time of the previous day corresponds to a completely different page of the passengers itinerary compared to the flight.

Most of the time, the accommodation component is the sole component that lists the date field, because a hotel night represents a specific date. If you fly out of your city on the 4th and arrive in another city after a long overnight flight on the 6th, your booked hotel night will be on the 6th in the new city; therefore, to determine if you need a hotel, the arrival row must have a date field.

Under the accommodation section of the booking, you will also see another field, “Last Verified.” Airlines will notify you of any changes in their schedule by email, and according to British Airways on the manage booking page, any changes to a booking are also communicated through email to the email address you provide. An email that you never opened is just as valid as any other email that was not sent, so the only way you will know how long ago you checked this information is from the last verified field in the file.

Booking Reference, Paid Status and Cancel-By Date: The Columns That Work at the Front Desk

These three columns are the only columns you see when you stand up; when you are sitting down, the three columns will be empty.

The reference is the one that people think that they have. According to British Airways Manage My Booking guidance checked on 20 September 2026, a booking reference is a set of six characters made up of letters and numbers and appears on your ticket as a line entitled “PNR code” or “Locator,” although it doesn’t actually include either of those terms. Six characters are conveniently short enough to be typed into a single cell and long enough to mistakenly type incorrectly, thus, it should be shown in the template and not in the screenshot.

There is a third column that most grids completely miss, it is the owner of the booking. The reason this is important is that British Airways states that if you booked through a travel agent and make any changes to your itinerary in British Airways’ systems, “Typically all changes made won’t be passed on to your Travel Agent booking,” and depending on the circumstances some itineraries may not appear in your Travel Agent’s systems. When there are two systems with two different versions of your travel, this information is very helpful for you to identify which number to call for assistance.

The last two columns of the grid are paid and cancel by. Paid acts as a flag indicating that you have fully paid for your ticket and cancel by is the deadline for cancelling this ticket. Deadlines are the only type of item in a travel itinerary that can expire without any written warning; if you have a non-refundable ticket and there is no cancel by column in the grid, this fact won’t be disclosed to you until the very last day you would normally have had to cancel it, which is why paid and cancel by merit a place in even a minimal grid layout.

An additional column should be included for anything with a time element. Many attractions, rail fare and event tickets, are offered for sale on a specific date and are not necessarily available for an indefinite period of time. Therefore, having a cell that shows when you can purchase a ticket is a way to differentiate between a planned purchase and just an aspiration. You’ll need to record this along with the reservation it pertains to, and not create a separate action item on your “to-do list”, which you may forget to revisit.

Buffers You Can Write Down: Check-In Closes, Gate Closes, Doors Open

A large number of templates rely upon slack by means of a rule of thumb. When planning, add 20% to your time budget (leave 20-30 minutes extra over and above what you were given for the half-day). These are best practices published by the various companies and organisations who publish travel guides; however, it is the opinion of one organisation or publisher and there is not a set standard that everyone will follow. There also is one major flaw with the rule of thumb method; if you are at the airport, they do not add the slack.

A better approach would be to document what the airline is telling you about their deadlines, as those deadlines are when you are able to close your check-in. For example, British Airways (as of the date I checked 20-sept-2026) has stated on the Heathrow Terminal 5 airport page that check-in for long-haul flights will close 60 minutes prior to take-off time. Check-in for short-haul flights will close 45 minutes prior to take-off time. If you don’t make it through security at least 35 minutes prior to your scheduled departure, you will not be at the departure gate at least 20 minutes before the scheduled departure time. The three cut-off times from above will need to go in three different cells.

Two of the airline’s own published numbers, side by side, is the only part of this where it becomes clear that a percentage buffer can’t be used. The published time for when gates will close for the gate-check-in period is 20 minutes before the scheduled flight departure, while the time required to travel to boarding gates “B” and “C” is also stated as approximately 20 minutes from the terminal. Therefore, when taken together, they tell us that the final safe time to leave a terminal shop or lounge is not 20 minutes before your flight, but approximately double that time (i.e., around 40 minutes). This is why the published guidance in Terminal 5C informs passengers that they need to leave for the gates a minimum of 40 minutes in advance of the scheduled departure.

You can defend this buffer because it holds for all cases without simply regurgitating the same numbers verbatim. Record the published cut-off time, the time travelling to the departure point, and whatever permanent local item is between them for all legs of your journey. In a train journey, this could be the time a platform closes; in ferry journeys, a vehicle loading period; museum visits may involve bag searching prior to entering the museum. A template that shows you can visually see together all the steps taken by the airline that influenced the decision of whether to travel based upon your published cut-off is not a template that will allow you to calculate whether or not your day will work.

If you have no information from an operator, you need to indicate this in the cell so as not to create a fictional figure. “Not Published” is an acceptable entry, but a larger estimate of time written down as a deadline is not acceptable.

Word, Excel, Google Sheets or Paper: Pick the Format for the Moment You’ll Actually Open It

When discussing whether you should create an itinerary template using Word, Excel or Google Sheets, the conversations often break down because the features of the different programs are compared to each other. Instead, the question should be more specific; i.e. at the time you need this file the most, what will you be using to access it?

There are four moments, and they pull in different directions. Editing at home rewards a wide grid and a real keyboard. Reading on a phone in a queue rewards something narrow. Working with no signal rewards a file that lives on the device. Handing a copy to someone rewards paper or a PDF.

When you have no Internet access, one area of significant divergence differences exists between the “popular” option and the honest option regarding Google Sheets. In many template round-up articles, Google Sheets is listed as an online-based solution only because of the fact that the default setting of Google Sheets makes it an online-only option. Google’s official help documentation for Google Docs Editors states that you can create, read, and edit Google Docs, Sheets, and Slides when you are offline (no connection). To take advantage of this feature, you must enable offline access in advance — there are two ways to enable the feature: either by enabling “Make recent files available offline” in the Google Sheets app settings or by marking the specific file to be marked with the “Make available offline” option. Each of these options are true regarding the same feature, but each of them pertain to different states of Google Sheets — you have to do this before losing signal.

Tony Phillips explains in a May 2026 article for How-To Geek how to use Excel’s built-in trip-planner workbook (which has different tabs to plan your travel using Excel). Phillips saves the workbook on OneDrive and then after arriving at an airport, sets the option to make the workbook available offline using the Excel mobile application. Phillips then uses the Excel mobile application’s Cards View to transform a multi-row trip planner to a single card that can be read conveniently without zooming out or resizing the rows. This was an example of Tony Phillips’s excel writing workflow; it was not a statement regarding whether or not Excel was the best program for travel planning, but a great example of how this specific workflow makes clear the step people forget.

The opposite of nostalgia in this specific context is a different failure mode. In a thread on the Rick Steves travel forum dated June 2022, one of the contributors to the forum indicated that they have a master copy of their itinerary that they keep on a tablet instead of a phone. The contributor wrote: “The phone screen is too small to see all the details.” There is also a second copy of the itinerary saved on a thumb drive that is carried separately from the tablet. A second contributor listed the itinerary for their entire trip and printed up for each device. This contributor printed two copies of a booklet of the entire itinerary and also kept a PDF of their itinerary on both devices. The third contributor printed one sheet of paper from the entire trip to keep on their person in the event of losing their device due to connectivity issues. While these individuals have different systems for traveling with a plan, they all have a common assumption: that the plan has to survive the device.

Two guidelines apply. Format by the time of use — typically this ends up meaning one broad working file will be used at home, one narrow/printout of the same file on days to be travelled. And include a “copies held by” space (a person at home, offline version of document, printout) because Smartsheet’s recommendations reiterate that backup printouts should be travelling with someone in their carry-on baggage and that if no one can locate a copy, there isn’t one.

Required Fields by Trip Type: City Break, Multi-Stop Rail, Road Trip, Business Trip

Each of the five types of fields will not weigh the same way during each of the five different trips. A weekend in Lisbon will have a different weight than a two-week train trip through three countries, so the template is filled out to different degrees.

When comparing the two columns, the pattern of the five types of fields is more important than the individual fields themselves. Fields become required fields when any other type of fields are dependent on them and become optional when they do not have dependent fields. During a city break, very few items depend on the ticket-status field because there is usually only one round-trip flight each way. During a multi-destination train trip, the ticket status field will dictate what other fields will happen throughout the next week.

There are two types of fields that cut across all four field types. Travelling as a family allows fields to be filled out that very few people are going to enjoy filling out (medical notes, emergency contacts, etc.). These fields will be included in the template of Smartsheet’s Family trip template. Travelling as a group adds another field: Who can change this spreadsheet? Where is the current version of this spreadsheet? A grid of three people editing the grid without any one person being in charge of it will result in two different plans.

The Fill Test: Typing a Published London–Dubai Schedule Into the Template Before Trusting It

By adhering to the following guidelines, you will be able to properly adapt this template to match your trips. A “blank” template will look acceptable until you begin using it for a new trip. To determine if it works, all you need to do is take approximately 15 minutes to create one itinerary and check it against what you have until you begin to receive confirmation as to how well it works. A roundtrip ticket from London to Dubai is a good example because you will cross multiple time zones, and most flights will arrive after midnight in Dubai.

Complete the desk exercise by examining the airline’s own schedule; take note of the flight number, departure airport and terminal, departure date and time, arrival airport, arrival date and time. In addition, review the airline’s airline/airport page for the departure terminal to see what time your airline has established as the cut-off for a long-haul flight.

Once you have completed the first two steps, begin to see where the template fails. Four things go wrong in almost every downloaded grid, and each one is a missing box rather than a mistake:

1. There is one time column, so the London departure time and the Dubai arrival time end up in the same unlabelled format and you lose which clock each belongs to.
2. There is no arrival-date cell, so an arrival after midnight silently inherits the departure date — and the hotel night gets booked for the wrong day.
3. There is nowhere to put the three cut-offs, so the check-in close, security time and gate time live in the airline’s page rather than in your plan.
4. There is no ticket-status cell, so a second flight bought separately looks identical to a connection sold as one journey.

Using British Airways’ terminal 5 long-haul numbers as an example, the check-in deadline for a long-haul flight is 60 minutes before departure, security must be completed at least 35 minutes before departure, and the boarding gate closes about 20 minutes before departure. Additionally, British Airways states that gates B and C take about 20 minutes to reach from the terminal. Enter this information into your candidate template; if all four pieces of data fit into the appropriate cells without having to add another “notes” cell, you have created a viable layout.

As this document mentions, the last step will confirm that you have performed a test rather than an exercise. Enter today’s date into the last-verified field and perform a second lookup of your schedule before traveling. The reason for this is that the published times and cut-off dates may have changed; therefore, it is possible that the numbers/findings that were copied from the published documents, may not be cross-checked with present-day numbers/findings since these numbers could have completely changed.

Required Fields to Add to Your Own Travel Itinerary

Happy Day Turismo is an informational travel blog. We do not sell trips or handle reservations. Use the field checklist below to adapt a spreadsheet or document you already use, or a template obtained directly from one of the providers discussed above.

You can add these columns in Word, Excel or Google Sheets, then export or print a copy if that suits your trip. This article provides the checklist on this page; it does not offer a separate downloadable Happy Day template set.

The table below explains which problem each field helps prevent and where to obtain the information. Copy the fields you need into your own itinerary, then fill them with the details of your actual bookings.

The fourteen fields contain more information than any of the four types of layouts reviewed for audit purposes, but it is still considerably less than what a complete project plan would require. The reason for this is intentional; each field is intended to document either something that an operator publishes or document who has a copy of that published item, and therefore does not require any estimation from you.

O Detalhe Que Decide a Viagem

The column list is much more important than the cover page because whatever template you download will dictate what information you will ever search for. Before filling in any days using your template or downloading your template, do the fill test on an actual routing you are considering. Check to see if there is a place for the arrival date, ticket status and published cut-off information for each route in your layout. If there is a spot for all of these elements, you will have been planning your trip in advance with all the necessary details; if there is no place for them in your layout, they will come up at some point on a day (possibly at the desk) when all you can do is change your plans.

Frequently asked questions

Is Canva free for making a travel itinerary?

The designs found in Canva’s itinerary gallery can be created free of charge and modified through a free account (announced last year, September 20, 2026), however, any design that incorporates premium elements will have a watermark unless you upgrade to a paid account or purchase the premium elements.

Google Sheets or Excel — which one actually works without a signal?

While both Google Sheets and Excel allow offline viewing and editing, Google Docs Editors Help makes it clear that Google Sheets must have offline access enabled for you to be able to view or edit the files that you create. Excel on the other hand requires you to set offline access to the respective file prior to losing your data connection.

Do I need a different template for a group or family trip?

Smartsheet has added two additional fields to create an itinerary folder with a family layout. Each family member should have an authorized contact who can provide medical information regarding each trip. Suh identifies an owner and version for a group trip folder, whereas without this information, two different plans may exist for that trip due to multiple editors.

What should I do with my itinerary when the airline changes my flight?

To verify your flight schedule, it is imperative that you copy and paste the entire row (including the date) from the operator’s website, as schedule changes can include multiple hours in the case of a flight delay or cancellation. You should also re-verify your last-verified cell on the same day you make changes to your itinerary. Many airlines like British Airways use email notifications to inform customers of changes to their flight schedules when they have email addresses registered, so a quiet inbox can’t be interpreted as the fact that a schedule change did or didn’t occur.