How Do You Create a Google Sheets Itinerary Template?

How Do You Create a Google Sheets Itinerary Template?

Every travel itinerary eventually becomes a spreadsheet. Flight numbers, hotel confirmations, and three time zones that refuse to line up. Google Sheets is the obvious place for all of it, and a reusable template takes about twenty minutes.

What almost no guide tells you is where that template breaks. Google Sheets has no function for converting a time between two time zones, and Google has never published which time zone NOW() resolves against. Both of those matter enormously the moment your trip crosses a border.

This guide builds the template, names the formulas that do the real work, and is honest about the two places where you will have to work around Sheets rather than with it.

How Do You Create a Google Sheets Itinerary Template?

Open a new spreadsheet, create one row per travel event, and give it columns for date, start time, end time, event type, location, confirmation number and notes. Add a dropdown on the event type column, sort by date and time, and save the file as your master copy to duplicate for each trip.

That is the whole answer. Structure matters more than formatting: one event per row, and every date and time stored as a real date or time value rather than as text.

Google does ship a template gallery: go to Google Sheets and, at the top right, click Template Gallery. Worth knowing first — Google does not publish a list of what is in that gallery anywhere in its own documentation. Its one official templates page names no templates at all, offering only generic category examples like budgets and project roadmaps.

A spreadsheet titled "Travel planner" is hosted on Google Docs with an Agenda tab and rows for flights, hotels and layovers, but no Google page names it as a template. Check the gallery in front of you rather than any article calling it official.

Free SEO + AI Search Audit. Whether your site shows up in Google and in AI search engines like ChatGPT, Claude and Perplexity is a different kind of visibility problem. Run your free audit to see where you stand in 60 seconds.

What Belongs in a Travel Itinerary Sheet?

An itinerary is a sorted list of events. The columns that earn their place are the ones you will read on your phone in an airport.

The columns that do the work

Date, start time and end time belong in separate columns, each formatted as a date or time rather than typed as text. Event type is best as a dropdown: Flight, Hotel, Train, Meal, Activity, Transfer. Location, confirmation number and notes round it out.

One tab per trip, not one tab per day

The instinct is to give each day its own tab. Do not. A single tab sorted by date and time lets you see the whole trip at once, filter it, and calculate across it. Days are a view, not a structure.

If you do want separate tabs, reference them with plain 'Tab name'!A1 syntax. Do not reach for IMPORTRANGE, which pulls data across separate spreadsheet files rather than between tabs of one file. Plenty of itinerary tutorials get this wrong.

How Do You Build It, Step by Step?

1. Set the spreadsheet's locale and time zone first

Do this before entering a single date. Open your spreadsheet, click File and then Settings. Under "General," click the "Locale" and "Time zone" menus to change your settings, then click Save settings.

Note the route: it is File > Settings, with the fields under a General tab. Articles still telling you to open "File > Spreadsheet settings" are describing a dialog that no longer carries that name.

Setting locale first matters because it decides how Sheets interprets a date you type. Enter 03/04 in a US locale and you get March 4th; in a UK locale you get April 3rd.

2. Add the event type dropdown

Select the whole event type column, click Data, then Data validation, then Add rule. Choose Dropdown as the criteria, add your event types with Add another item, and click Done.

Google's current name for this is a dropdown list, and it writes "dropdown" as one word with no hyphen. The Data validation label is still live as the menu path, and there is also an Insert > Dropdown route to the same panel. Under Advanced options you can set Display Style to Chip, Arrow or Plain text.

3. Format the date and time columns explicitly

Select the date column and apply a date format; do the same for your two time columns. This is not cosmetic. A time typed into a text-formatted cell is a string, and strings do not sort, subtract or total.

4. Add the duration formula

Subtract start time from end time, then format the result as a duration rather than a time. That is what stops a nine-hour flight from displaying as 09:00 and behaving like nine in the morning.

5. Sort the itinerary

Use SORT to produce a date-and-time-ordered view. Its syntax is SORT(range, sort_column, is_ascending, [sort_column2, is_ascending2, ...]), where sort_column is "The index of the column in range or a range outside of range containing the values by which to sort."

Google notes that "range is sorted only by the specified columns, other columns are returned in the order they originally appear" — so sort by date and then by start time, or two events on the same day will come back in whatever order you typed them.

Is your content actually being found? A spreadsheet tells you where you are going. A free SEO and AI search audit tells you whether anyone can find you when they search. Check your site now.

Which Formulas Do the Real Work?

SORT and SORTN

SORT handles ordering. SORTN is its underrated sibling, with syntax SORTN(range, [n], [display_ties_mode], [sort_column1, is_ascending1], ...), where n is "The number of items to return. Must be greater than 0."

TEXT for readable dates

TEXT(number, format) converts a date into something a human reads. Google's own documentation uses TEXT(DATE(1969,7,20),"yyyy-MM"), which is exactly the shape an itinerary header wants.

Two documented constraints to respect: "The format argument to TEXT cannot contain an asterisk (*)," and "Note that the date/time patterns and # or 0 cannot be mixed."

DATEDIF for trip length

DATEDIF(start_date, end_date, unit) gives you trip length. It accepts six units and no others: Y, M, D, MD, YM and YD. For D it returns "the number of days between start_date and end_date."

Google documents a gotcha that catches almost everyone: a DATEDIF result can render as a date rather than a number, so a count of eight days appears as 1/4/1900. It happens when the cell carries a date format, and the fix is a number format.

Conditional formatting, and its one real constraint

Use Format > Conditional formatting to colour flights one shade and hotels another. The condition dropdown is labelled Format cells if, the custom option is Custom formula is, the entry field is Value or formula, and you confirm with Done. Custom formulas are supported and Google documents them properly.

The constraint matters for anyone building a multi-tab itinerary: a conditional formatting formula can only reference the same sheet. To point one at another tab you have to wrap the reference in INDIRECT. This is first-party documented and almost universally omitted.

The Time Zone Problem Google Never Solved

This is where a travel itinerary differs from every other spreadsheet, and where honest advice is scarce.

Google Sheets has no built-in function for converting a time between two time zones. The Date category of Google's function list contains 26 functions and not one of them converts between zones or even takes a time zone argument. The only one that names a zone at all is EPOCHTODATE, which "Converts a Unix epoch timestamp in seconds, milliseconds, or microseconds to a datetime in UTC" — hard-wired to UTC, and no help for a flight between Tokyo and London.

The asymmetry is telling. Google Apps Script ships formatDate(date, timeZone, format), which takes an explicit time zone argument. The worksheet formula language never got one. That makes this a deliberate gap rather than an oversight in the documentation.

So a flight leaving at 18:00 Tokyo time and landing at 11:00 London time cannot be reconciled by any Sheets formula. The practical workaround is to store a UTC offset yourself in a helper column and add it as a fraction of a day, because that is how Sheets represents time: TIMEVALUE "Returns the fraction of a 24-hour day the time represents."

There is a second, quieter absence. No Google page states which time zone NOW() and TODAY() actually resolve against — the spreadsheet's configured zone, or the viewer's. The settings page attributes the locale and time zone setting only to default currency, date and number formatting, and says nothing about function behaviour. Competing articles assert an answer confidently. Google never has. If your itinerary depends on the distinction, test it rather than trusting anyone.

Crossing midnight

An overnight flight breaks naive time subtraction, because the end time is numerically smaller than the start time. Google documents the wrap-around in its TIME reference: "TIME will silently recalculate numeric time values which fall outside of valid ranges," with the example that "TIME(25,0,0), which specifies the illegal hour 25, will create a time of 1:00 AM."

What Google does not document anywhere is the fix. Neither the bracketed-hours duration format that lets travel time exceed 24 hours, nor the technique for summing times across midnight, appears on any Google page. Store a full date-and-time value in one cell rather than a date and a bare time in two.

See your real search visibility. Google does not document everything, and your analytics may not either. A free SEO + AI search audit shows where your site actually stands across search and AI answers. Start your free audit.

What Are the Real Limits?

A Google Sheets spreadsheet holds "Up to 20 million cells or 100MB for spreadsheets that are created in or converted to Google Sheets." Note that figure. Google doubled the cell limit from 10 million to 20 million in September 2026, for new, existing and imported files, across Workspace and personal accounts alike. Almost every article published before then still quotes the old number.

Google publishes no limit on the number of tabs a spreadsheet can have. Any tab-count figure you find online is third-party, so do not plan around one.

The genuine limits are different in kind. There are no reminders, no live flight status, and collaborative editing has no conflict resolution worth the name, so two people reorganising the same itinerary will overwrite each other.

And then there is the time zone gap above, which is the one that actually ruins trips.

How Does This Compare to a Dedicated Trip Planner?

A purpose-built app wins on the things a spreadsheet structurally cannot do. It parses confirmation emails automatically, pushes notifications, tracks flight delays live, and handles time zones without being asked.

A spreadsheet wins on everything else. It is free, imposes no structure you did not choose, exports anywhere, and calculates whatever you want. You can total costs by traveller or add a packing tab — neither of which a trip planner will let you do.

The honest split: use a dedicated planner for a complex multi-leg trip across several time zones where live flight data matters. Use a spreadsheet for everything else, and especially for group trips where cost-splitting and shared editing do more work than notifications would.

Free SEO + AI Search Audit. Before your next content project, find out how your site performs in traditional search and in AI assistants. Get your free audit in under a minute.

Final Thoughts

A Google Sheets itinerary template is a twenty-minute build that pays back on every trip afterwards. One tab, one row per event, real date and time values, a dropdown for event types, and SORT keeping it in order. Set the locale and time zone before you type anything.

Go in knowing the two gaps. Sheets will not convert between time zones, and Google will not tell you which zone NOW() uses. Store UTC offsets yourself and use full date-and-time values for anything that crosses midnight, and neither will catch you out.

If you are building other reusable spreadsheets, the same structural principles carry over — our guide to creating a Google Sheets inventory template covers the tab layout and formula choices for a very different data shape.

The best itinerary template is the plain one you actually keep updated.