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

Pick a travel itinerary template by the fields it forces you to fill in, not by how the page looks. The layout decides what gets written down — and what you never think about again. Most popular free grids are built around dates, activities and confirmation numbers, so the details that actually break a trip have nowhere to sit.

That isn’t an argument for the biggest spreadsheet you can find. A template with a column for everything is one you stop updating, and a column you never fill is just noise on the page. The trade-off is real, and it’s why this choice deserves ten minutes rather than thirty seconds. A short list of columns separates the templates that hold up from the ones that only look organised.

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

A template isn’t really a layout. It’s a list of questions, and you answer the ones it asks.

Each column is an instruction to go and find something. A booking reference sends you back to a confirmation email, a check-in time sends you to the hotel’s page, a flight number sends you to the airline’s schedule.

Take the column away and the instruction is never issued. Nobody sits down and decides to skip the moment check-in closes — there is simply nothing in the file waiting for it, so the question never gets asked. An empty cell nags at you. A missing one doesn’t.

The operator times, cut-offs and passenger rights described in the sections below were checked on 20 September 2026, and they are set by airlines, railway companies and regulators who can change them, so check the rule on your own operator’s page for your own route before you book anything.

Read the guides that rank today for what a travel itinerary should include and they converge, almost field for field: dates, destinations, a day grid, flight and train times, accommodation with a confirmation number, a budget line, emergency contacts. It’s a sensible list. It’s also the same list everywhere, and it stops exactly where the hard part starts — which leg is protected when the one before it runs late, which arrival lands on tomorrow’s date, and what time the door actually closes.

You can watch that gap get patched by hand. In a January 2026 thread on the Rick Steves travel forum, someone asking for a simple template for Italy got back a column list from another traveller that included “Cancel Date (if non-refundable, highlight cell in red)” and “Week Day” — the second one, that poster explained, because in some countries you don’t want to plan on trains or buses on a Sunday. Neither column comes in the file people download. Someone added them after a trip taught them to.

So the useful way to read a free template is as five questions it either asks or doesn’t: what each leg of transport actually is, what date and local time things happen on, what proves a booking and how long you can still cancel it, when each door closes, and where the file will be when you need to open it. The rest of this guide works through those five. The place to start is what the most-downloaded layouts have in the boxes right now.

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

Four layouts, all captured on 20 September 2026, all free to start. The table below is not about which one looks best — it’s about which questions each file already puts in front of you, and which it leaves you to think of yourself.

Smartsheet looks like the exception, and it is worth being precise about why it isn’t. Its Flight Itinerary template does cover departure and arrival times for each leg of a journey including layovers, which is more than the other three offer. But a leg with two times on it still doesn’t tell you the two things that decide what happens when the first one slips — whether both legs sit on one ticket, and what you would get on instead. And that flight file is a separate download from the day-by-day grid, so the reader who takes the vacation template never sees it.

“Free” needs a date and a qualifier on all four. Vertex42’s page carries its own 2021 update stamp and Smartsheet’s carries a 2018 byline, which matters less for a blank grid than it would for a rule, but it does tell you nobody has revisited the column list in years. Canva’s gallery is free to open, while Canva’s own help pages explain that premium elements sit behind a watermark until you buy them or upgrade. Template.net heads its itinerary index “free templates” and runs an Upgrade button on the same page, with a paid tier that advertises premium templates and watermark-free export.

So the decision rule that comes out of this is unglamorous. Judge a free itinerary template by its column headings rather than its cover, download it from the provider’s own page rather than a re-upload, and treat any of the four as a starting grid you will add to — because the first thing all four are missing is the row that describes how you actually get from one place to the next.

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

A day grid records where you are. It does not record how you got there, and that is where the day breaks.

Give every movement its own row: mode, operator, departure place and time, arrival place and time, and then three columns the downloads don’t have. Connection time, as published rather than as you hope it is. Ticket status — is this leg on the same booking as the one before it, or a separate purchase? And the next service if this one is missed.

The middle column is the one that changes outcomes, because it changes who is responsible. When two legs sit on one booking, the company that sold you the journey is dealing with the whole journey. When they sit on two bookings, you have bought two separate journeys that happen to meet in your spreadsheet, and the first operator has no contract covering the second.

That is also why the ticket-status column should record a status rather than promise a right. In the European Union, rail passenger rights now run on Regulation (EU) 2021/782, which replaced the 2007 regulation and has applied since 7 June 2023, and the Commission has since published a common claim form covering delays, missed connections and cancellations. But the same page notes that Member States may exempt certain types of service from parts of the regulation — so “it’s an EU train” is not by itself an answer, and what applies to your route on your date is something to read on the rail passenger rights guidance for the country you are travelling in, checked on 20 September 2026.

There is a quick way to test the status of an air connection without reading anything legal. Open the airline’s own manage-booking page and put in your reference. British Airways, for instance, publishes that its tool shows you its own flights plus the connecting flights immediately before and after, whatever airline operates them — so if the second leg of your trip simply isn’t there, you are looking at a different booking, and the row in your template should say so.

The fallback column costs you two minutes and pays for itself once. Write down the next departure on the same route, with its time — the later train, the evening flight — so that the decision at the transfer desk is a lookup rather than a negotiation. What this row deliberately does not do is tell you whether the connection is long enough; that is a separate judgement, and if the gap looks tight you want to check the connection itself before you build the rest of the day around it.

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

Every published departure and arrival time belongs to a clock somewhere. Departure belongs to the clock where you leave; arrival belongs to the clock where you land. A grid with one unlabelled time column quietly throws that away, and on any journey long enough or eastward enough, the arrival stops being on the same day as the departure.

So three fields, not one. Label each time with the place it belongs to. Give arrival its own date cell, with room for the marker operators use when a service lands on the following day. And put the day of the week next to the date, which is the field experienced planners add by hand, as the forum thread earlier in this guide shows.

The consequence is not abstract, because operator rules routinely attach to calendar days rather than to elapsed hours. British Airways publishes an overnight bag drop at Heathrow Terminal 5 for flights departing before 10:00, with bags accepted between 16:00 and 22:00 the day before, as stated on its own airport page checked on 20 September 2026. Read that with a single time column and it sounds like a convenience. Read it with a dated row and it is an instruction that lands on a different page of your itinerary from the flight it belongs to.

Accommodation is where the date field earns its place most often, because a hotel night is a date, not a duration. If you leave on the 4th, fly overnight, and land on the 6th, the night you need booked is the 6th in the city where you land — and the grid can only tell you that if the arrival row has its own date.

Add one more cell while you are in this part of the sheet: last verified. Airlines notify schedule changes by email, and British Airways states on the same manage-booking page that you will be notified of changes to your booking by email where you have given one. An email you didn’t open is indistinguishable from an email that was never sent, and a date in a cell is the only thing in the file that will tell you how long ago you last looked.

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

These three columns exist for moments when you are standing up, not sitting down.

The reference is the one people think they have. British Airways publishes that a booking reference is a series of six characters containing letters and numbers, and that it may be printed on your ticket under a heading like “PNR code” or “Locator” rather than the words you were expecting, according to its Manage My Booking guidance checked on 20 September 2026. Six characters is short enough to write in a cell and short enough to mistype, which is exactly why it belongs in the template rather than in a screenshot.

Then a column most grids miss entirely: who owns the booking. It matters because the same airline states that when you have booked through a travel agent, changes you make in its own tool “will normally not be passed back to your travel agent booking,” and that some flights on an agent’s booking may not be visible to it at all. Two systems holding two versions of your trip is a problem you can only manage if the row tells you which one to phone.

Paid and cancel-by are a pair. Paid is a flag; cancel-by is a deadline, and deadlines are the only entries in an itinerary that expire silently. A non-refundable booking with no cancel-by cell doesn’t announce itself on the last useful day — it just quietly becomes non-refundable, which is why that column earns a place even in a minimal grid.

One extra field belongs here for anything timed. Attractions, rail fares and events often open for sale on a fixed date rather than being available indefinitely, so a “can buy from” cell is the difference between a plan and a hope. Note it with the booking it belongs to, not on a separate to-do list you’ll forget to reopen.

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

Most templates handle slack with a rule of thumb. Add twenty per cent; leave twenty to thirty minutes per half-day. Those are real practices published by real planning guides, but they are one publisher’s heuristic, not a standard anyone enforces, and they have a specific weakness: the airport does not round up with you.

The alternative is to write down the deadlines the operator publishes, because those are the ones that actually close. British Airways states for Heathrow Terminal 5, on its own airport page checked on 20 September 2026, that check-in closes 60 minutes before long-haul departures and 45 minutes before short-haul, that you must pass through security at least 35 minutes before departure, and that you must be at the gate no later than 20 minutes before departure. Three separate cut-offs, three separate cells.

Now put two of that airline’s own numbers next to each other, because this is the part a percentage buffer cannot produce. The same page gives the gate deadline as 20 minutes before departure — and also says it takes roughly 20 minutes to reach the B and C gates from the main terminal. Both are the airline’s published figures for the same terminal, and read together they mean the last safe moment to leave a shop or a lounge is not 20 minutes before your flight. It is about double that, which is why the airline’s own lounge guidance for that terminal tells passengers using Terminal 5C to leave at least 40 minutes before departure.

That is a buffer you can defend, and it generalises without being copied. For any leg, record the operator’s published cut-off, the published time to reach the boarding point, and whatever fixed local step sits between them. For a train it might be a platform that closes; for a ferry it might be vehicle loading; for a museum slot it might be a bag search. The template’s job is not to compute whether the day works — it is to make sure the numbers that decide it are written where you can see them together.

Where an operator publishes nothing, say so in the cell rather than inventing a figure. “Not published” is a usable entry. A padded guess dressed up as a deadline is not.

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

Arguments about whether to use an itinerary template in Word, Excel or Google Sheets usually go wrong because they compare features. The better question is narrower: at the moment you most need this file, what will you be holding, and will it work?

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.

Offline is where the honest answer diverges from the popular one. Several template round-ups list Google Sheets as an online-only option, which is true of the default state. Google’s own Docs Editors Help says the opposite about the enabled state: you can create, view and edit Docs, Sheets and Slides without a connection, provided you switch it on in advance — either by turning on “Make recent files available offline” in the app’s settings, or by marking that specific file “Make available offline” beforehand. Both statements are accurate about different states of the same product, and the precondition is the whole point: it has to be done while you still have signal.

Microsoft’s side has the same shape. Writing in How-To Geek in May 2026, Tony Phillips describes using Excel’s built-in trip-planner workbook with tabs for travel, lodging, activities and budget, saving it to OneDrive, and toggling “Make Available Offline” in the Excel mobile app before heading to the airport — then using the app’s Cards View to collapse a wide row into a stacked card that can be read without pinching. That is a named account of a specific workflow, not a claim about which product is better, and it is useful precisely because it names the step people skip.

Paper is not nostalgia here; it is a different failure mode. In a June 2022 thread on the Rick Steves travel forum, one poster explained why they keep the master file on a tablet rather than a phone — “Phone screens are too tiny to see all the details” — and keeps a second copy on a thumb drive carried separately. In the same thread another traveller prints a booklet of the whole trip, two copies, with a PDF on each device as well, while a third keeps a single sheet of paper specifically because of connectivity. Different systems, one shared assumption: the plan has to survive the device.

Two rules follow. Set the format by the moment of use rather than by preference, which often means one wide working file at home and a narrow or printed version for the days you are moving. And add a “copies held by” cell — a person at home, an offline file, a printed page — because Smartsheet’s own guidance makes the same point about carrying a printed backup in hand luggage, and a copy nobody can find is not a copy.

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

The five field families don’t weigh the same on every trip. A weekend in Lisbon and a fortnight of trains across three countries fail in different places, so the same blank template should be filled to different depths.

The pattern underneath the table is worth more than the rows. Fields become mandatory when something else depends on them and optional when nothing does. On a city break almost nothing depends on the ticket-status column, because there is usually one flight each way; on a multi-stop rail trip it is the column that decides what happens to the rest of the week.

Two variants cut across all four. Travelling with family adds fields nobody enjoys filling in — medical notes and emergency contacts, which Smartsheet’s family template already has boxes for. Travelling as a group adds a different one: who is allowed to change this file, and where the current version lives, because a shared grid with three editors and no owner produces two plans.

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

A blank template looks adequate right up to the moment you put a real trip in it. The way to find out whether it is takes about fifteen minutes and one real routing — and a long-haul London to Dubai flight is a good test case precisely because it crosses time zones and usually lands after midnight local time.

Do it as a desk exercise before you book anything. Open the operator’s own schedule page for the route and date you are actually considering, and copy what it publishes rather than what you remember: flight number, departure airport and terminal, departure time, arrival airport, arrival time, and the arrival date. Then open the airline’s airport page for the terminal you are leaving from and copy the cut-offs, as published on the day you look.

Now watch where the template resists. 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’ published Terminal 5 figures as the example set, a filled row for a long-haul departure carries a check-in close 60 minutes before departure, security at least 35 minutes before, and a gate deadline 20 minutes before, with the terminal’s own note that B and C gates take about 20 minutes to reach. Type those into your candidate template. If all four fit without you inventing a “notes” cell to hold them, the layout is doing its job.

The last step is the one that makes this a test rather than an exercise. Put today’s date in the last-verified cell, and repeat the schedule lookup once before you travel — published times and cut-offs change, and a figure you copied months ago is a figure nobody has checked since.

Download the Printable Template Set and the Required-Fields Guide

The template set below is built by Happy Day Turismo, which is a travel agency and sells trips, so treat it as one option rather than the only one: the free layouts audited earlier in this guide are genuinely usable, and if you already have a grid you like, adding the five field families to it by hand takes about ten minutes and costs nothing. The honest reason to take ours instead is narrow — the fields are already in it — and the honest reason not to is equally narrow: it is a fixed column set, and if your trip needs something it doesn’t have, you will be editing it anyway.

The set comes in four formats, matched to the moments in the format section: a Word document for editing, an Excel workbook for anyone who wants the grid and formulas, a Google Sheets copy for sharing, and a print-ready PDF in both A4 and Letter — one day per page, no images, kept narrow enough to print without spilling.

The required-fields guide is the part worth reading even if you download nothing at all. It is a field dictionary rather than a packing list: every field, the failure it prevents, where the value comes from, and which formats it belongs in.

Fourteen fields is more than any of the four audited layouts carries, and fewer than a full project plan. That is deliberate: every one of them either records something an operator publishes or records who holds a copy, and none of them asks you to estimate anything.

O Detalhe Que Decide a Viagem

The template you download decides which facts you will ever go and look up, which is why the column list matters more than the cover. Before you fill in a single day, run the fill test on one real routing you are actually considering, and see whether the layout has somewhere to put the arrival date, the ticket status and the operator’s published cut-offs. If it does, the trip is being planned with the awkward details visible; if it doesn’t, they will surface at a desk, on a day when the only thing you can change is your plans.

Frequently asked questions

Is Canva free for making a travel itinerary?

Canva’s itinerary gallery is free to open and the designs are editable without paying. Canva’s own help pages state that premium elements carry a watermark until you buy them or upgrade, so a finished design can still cost something, as checked on 20 September 2026.

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

Both do, and neither does by default. Google’s Docs Editors Help says Sheets can be viewed and edited offline once you enable offline access or mark the file available offline in advance, and Excel needs the same kind of step in its mobile app. The deciding factor is doing it before you lose signal.

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

Not a different template — two extra fields. Family trips need medical notes and emergency contacts, which Smartsheet’s family layout already includes. Group trips need a named owner for the file and a stated current version, because a shared grid with several editors and no owner ends up as two plans.

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

Re-copy the whole row from the operator’s page, including the date and not only the hour, because a schedule change can move both. Then reset the last-verified cell to today. British Airways states it notifies booking changes by email where you have given one, so a quiet inbox is not confirmation.