Travel Itinerary Template for Excel (Made for Microsoft 365)
Travel itinerary template Excel setup: add dates, format trip costs, then print a readable day plan in Microsoft 365 without shrinking every column.
By Ultimate Travel Planner by Cosmo Suite · Editorial policy
Published · 8 min read

Excel can show a tidy itinerary on your monitor, then split the same columns across pages when you print. It often shows up after the dates, bookings, and costs are already in the sheet. A travel itinerary template for Excel needs to work in both views.
Work in this order: enter the dates, add fixed bookings, build the day plan around them, format the costs, then print the pages you need. This guide walks through that order in Microsoft 365 and shows what to check before you pack. If you want a connected workbook instead of building the layout from scratch, the trip itinerary spreadsheet from Ultimate Travel Planner (ultimatetravelplanner.site) comes in Google Sheets and Excel.
Key Takeaways
- Enter real date values before choosing how they look.
- Put fixed bookings on the right day before adding flexible plans.
- Label every amount with its currency. A currency symbol does not convert a value.
- Use print preview, a selected print area, and readable scaling for a one-day handout.
What should an Excel travel itinerary template include?
An Excel travel itinerary template is a workbook layout for keeping trip dates, bookings, daily plans, and useful notes together. Add cost fields only if you intend to track them. A single sheet can work for a short break; a longer, multi-stop trip may need separate sections or tabs so the daily plan does not become a wall of columns.
| Field | Store it as | Display or check |
|---|---|---|
| Trip date | Excel date value | Use a clear month name, such as 7 Jun 2027 |
| Booking time | Time value | Keep the local time beside the place or service |
| Trip cost | Number plus currency label | Show the unit, such as EUR 240 or USD 65 |
Pick the layout that makes the next useful detail easy to find. When you are heading to a station, you need the departure time and the next stay quickly. At home, you may want the full route and trip cost. A layout that supports both jobs is easier to maintain than one oversized table.
For the wider itinerary structure, see this travel itinerary template with a filled sample trip. If you prefer to work in Sheets, the Google Sheets itinerary setup covers that version.
Start with the trip dates and a consistent format
A date value is the calendar date Excel stores for calculations; the format controls how a reader sees it. Enter the trip’s first date as a date value, then fill later dates in order. If your sheet uses one row per day, the next date can be the previous date plus one. Check the first and last dates against your bookings before you format the column. A date that looks tidy can still be wrong if the underlying value is off by a day.
Excel lets you change how dates display. Select the date cells, open the number format controls, and choose a short or long date format. Microsoft explains that the display format can depend on regional settings, so a date such as 6/7 may be read differently by people using different date conventions. A format such as 7 Jun 2027 is easier to scan across regions. Microsoft’s date-format guide shows the available date formats and how to select one.

If dates appear as a row of hash marks, widen the column. If a date changes unexpectedly after entry, check the cell value and regional settings rather than adding spaces or punctuation to make it look right. Keep the date column narrow enough to scan, but wide enough to show the whole date.
For a trip with several travellers or stops, start from the 12-tab travel planner spreadsheet layout. Its structure separates the overview from the day-level plan. Use only the sections you need; extra columns make a printed itinerary harder to read.
Excel itinerary template layouts: which fits your trip?
Choose a layout by asking what you need to find while travelling. These options suit different levels of detail. Use the smallest structure that keeps fixed commitments and the next step easy to find.
| Template shape | Good fit | Trade-off |
|---|---|---|
| Single table | Weekend trip, one stay, few reservations | Easy to print, but long notes can make it wide |
| Separate booking and day views | Multiple stays or transport changes | Less repetition, but you must link each booking to its date |
| Overview plus daily plan | Longer trip with a route and changing details | Easier to scan by purpose, with more setup at the start |
For a wider format choice between a spreadsheet, a Notion page, and a printable, compare these travel planner template options.
An itinerary spreadsheet is not a substitute for the booking confirmation. Keep the confirmation number, supplier contact, and exact time in the workbook if those details help you, then check the original email or app before departure. This is especially useful when a plan changes. Update the itinerary after you verify the new booking, not from an old screenshot.
Add bookings before filling the day plan
Put the fixed items in first: flights, trains, accommodation check-in, timed tickets, and reservations. Use one row for each booking and include its date, local time, location, confirmation reference, and status. Keep notes brief. A street address or pickup point is more useful in the itinerary than a long description copied from a confirmation email.
Then connect each fixed item to the day it affects. A hotel check-in may determine where you can go in the afternoon. A train departure may make a morning activity unrealistic. Leave the flexible ideas for later so the plan does not hide a transfer or reservation.

Pick one booking and follow it into the daily view. Can you see the time, place, and next step without switching between several unrelated notes? If not, add a short reference or a link to the booking source. Do not copy sensitive payment details into a shared itinerary.
For a route with several driving legs, a road trip itinerary template gives the driving segments their own space.
Format trip costs without implying currency conversion
Keep the amount and the currency together. A column labelled “Amount” can be ambiguous when one booking is priced in euros and another in dollars. Use a currency label in the heading or a separate currency column, then apply the matching number format to the values.
Select the relevant cells and choose Currency or Accounting from Excel’s number-format options. Microsoft notes that these formats change how the number is displayed. They do not calculate an exchange rate. If you compare a trip total across currencies, record the rate you chose and the date or source you used, then keep the original amount visible.
A simple example: a hotel charge of 240 EUR and a rail ticket of 65 USD should remain clearly labelled as separate currencies unless you have converted them using a rate you selected. Do not add those values as if they were the same unit. The Microsoft currency-format guide explains how to choose a symbol and decimal display.
A currency symbol can also follow your computer’s regional defaults. Review the symbol and decimal places in the cell preview before you format the whole column. If Excel shows hash marks, widen the column. If you need a second currency, keep it in its own field and label it.
Print a day plan that stays readable
Print the selected day or a small block of days, not every planning column in the workbook. A print area is the range of cells Excel sends to print. Select the cells you need, open File > Print, and inspect the preview. Choose a page orientation that fits the table, set the paper size, and check whether the sheet breaks between a time and its place or separates a booking from its date.

If the page is too wide, remove columns that do not help during the trip or set a print area around the day’s essential details. Microsoft’s print-area instructions explain how to save a selected range for printing. If a worksheet spans several pages, use page-break preview to see where Excel divides it.
Excel can scale a worksheet to fit a specified number of pages, but forcing a dense workbook onto one page can make the text too small. Microsoft’s fit-to-page guide describes the scaling controls. Use them after choosing the rows and columns you actually need. A readable two-page plan is more useful than a one-page sheet that requires zooming with your eyes.
Print preview also catches paper-size mismatches. A page designed for Letter may break differently on A4 paper. Check the preview on the device and printer you plan to use, and keep a digital copy available in case the paper version is lost.
How Ultimate Travel Planner fits an Excel trip
Ultimate Travel Planner (ultimatetravelplanner.site) is a trip-planning spreadsheet sold as a one-time purchase, with files for Google Sheets and Excel. Its contents include 12 connected tabs, a sample copy and a clean copy, plus two printable PDF pages: a one-day plan and a packing checklist. The workbook is designed for trips up to 60 days and up to 8 travellers. You type in the exchange rate yourself; the planner does not pull live rates.
The itinerary, bookings, budget, and day plan sit alongside packing and pre-trip details in the same file. If that layout matches your trip, see the trip itinerary spreadsheet for Excel and Google Sheets. If you want to compare app features before choosing a format, the travel planning app comparison sets out where a spreadsheet has limits, including booking imports and live updates.
Why trust this article?
This guide uses Microsoft Support’s current instructions for Excel date formatting, currency display, and print setup, checked on 9 November 2026. Product details for Ultimate Travel Planner come from its published contents list. The date and currency examples are illustrative, not a claim that a workbook was tested with a particular itinerary. Check your own print preview because paper size, printer settings, and Excel version can change page breaks.
Frequently asked questions
Can I use an Excel template for a travel itinerary?
Yes. An Excel travel itinerary can hold dates, bookings, daily plans, and costs in one workbook. Choose a layout that keeps each day readable and check the print view before you leave.
How do I format dates in an Excel travel itinerary?
Enter each date as a date value, select the date cells, then choose a display format such as 9 Jun or 09-Jun-2027. The format changes how the date appears, not the date value Excel uses.
How do I print a travel itinerary from Excel?
Select the cells you need, open File > Print, and review the preview. Set the page orientation and print area, then adjust scaling only if the text remains readable.
Can I show travel costs in more than one currency?
Yes. Label each amount with its currency and format the cells for the currency shown. A number format changes the display, not the exchange rate or the underlying value.
Is an Excel itinerary better than a travel planning app?
It depends on the task. A spreadsheet gives you an editable file and flexible columns. An app may suit you better when you want booking imports, live updates, or offline features.
Sources
Keep reading

Itinerary Templates
Travel Itinerary Template: What a Day-by-Day Plan Needs (and a Sample Trip, Filled In)
Travel itinerary template: what a day-by-day plan needs, how to fill one in, and a sample 10-day trip to Lisbon and Porto worked from morning to evening.
· 12 min read

Itinerary Templates
Travel Itinerary Template for Google Sheets: Set Up a Trip, Step by Step
Travel itinerary template Google Sheets setup: six steps from your own copy to the Day Plan on your phone, worked on a 10-day Lisbon and Porto trip.
· 7 min read

Itinerary Templates
Travel Planner Spreadsheet: The 12 Tabs a Trip Uses (and the 4 You Can Skip)
Travel planner spreadsheet tabs explained: which of the 12 a weekend trip needs, which a 3-week trip needs, and the 4 you can skip, on a sample trip.
· 7 min read
