Free template

Travel Itinerary Template for Excel

Shobhit Shrivastava · Founder

Download the blank template (.xlsx)Free · no email · Excel 2010 or newer, live budget formulasDownload a filled exampleA 7-day Japan trip our AI planner wrote, in its export layout

Rather not fill it in yourself? Tap through 8 quick cards and get the whole trip planned for your destination. Free, for now. No sign-up.

  • Made for your trip: Built around who is going, your interests, pace and budget
  • Real places: Every stop checked against real venue data, and closed places swapped out
  • Booking checklist: What to book and how far ahead, from flights to stays
  • Day by day: Times, travel between stops and a budget
  • Local guides: What to eat, what to buy and where, and the festivals on your dates
Build an itineraryTakes about 2 minutesSee a finished example →

What’s inside

Trip sheet
Dates, travelers and budget, with a countdown and your first flight and hotel
Day Planner sheet
One row per stop, with map link, travel time, hours and a buffer row
Shortlist sheet
Sights, restaurants and shops you have not decided on, each with a priority
Bookings sheet
PNRs, seats, hotel confirmations and free-cancel dates on one screen
Budget sheet
An expense log that converts currency, totals by category and splits who paid
Packing sheet
53 items grouped by category, with checkbox dropdowns and no macros
Pre-Trip sheet
Document expiry dates and a 12-item checklist; every sheet prints to width

A look inside the Excel template

Trip tab: a days-to-go countdown, planned against spent, and a link to every tab.
Day Planner tab: one row per stop, with map link, travel time, hours and a buffer row.
Shortlist tab: the places you are still deciding on, each with a priority.
Bookings tab: flights, hotels, car rental and emergency contacts, each with a free-cancel date.
Budget tab: planned against spent per category, and a log that splits costs by who paid.
Packing tab: 53 items grouped by category, with a link to a list made for your trip.
Pre-Trip tab: a 12-item checklist and the expiry date of every document.
Narrated, with captions: a week in Lisbon kept in one workbook. Filling in the trip once, shortlisting places, recording bookings with their free-cancel dates, the trip page picking up the first flight and hotel, sharing, the day plan and spending in euros converted to dollars, and ticking off the checklists, in Excel for the web. Then a quick look at a trip our planner wrote.

Most travel itinerary templates for Excel are a grid with the word "itinerary" at the top. The useful ones treat the spreadsheet as what it is, a calculator, and let it carry the boring work: adding up costs, tracking who paid, remembering confirmation numbers.

This travel itinerary template does all three. It is a seven-sheet workbook: a trip overview that doubles as a glance page, a day planner laid out one row per stop with a map link and travel time between them, a shortlist for places you are still deciding on, a bookings sheet with space for PNRs, seat numbers and free-cancel dates, a budget that converts spending through one exchange rate and splits costs across travelers, and packing and pre-trip checklists (with a documents-and-expiry block) you can tick off. Each sheet is described below, followed by how to build the same travel itinerary in Excel from a blank workbook if you would rather make your own.

How to make a travel itinerary in Excel

  1. 1Start a sheet named Trip and give it four labelled cells: destination, dates, travelers, total budget. Every other sheet in a travel itinerary template refers back to these, so they live in one place.
  2. 2Add a Day Planner sheet with one row per stop: plan, map link, travel time from the previous stop, hours, cost and priority. Group each day's rows into a block and end it with a labelled buffer row, then freeze the header row (View → Freeze Panes) so it stays put while you scroll.
  3. 3Add a Shortlist sheet for the sights, restaurants and shops you are still deciding on (type, name, area, priority, hours, cost), the list the Day Planner draws from.
  4. 4Add a Bookings sheet with a row per reservation: airline confirmation code, PNR, seat, hotel confirmation, a link, the date it is free to cancel, car rental, emergency contacts. This is the sheet you open at the airport, so keep it to one screen.
  5. 5Add a Budget sheet as an expense log: date, item, category, local amount, currency, home amount, paid by. Reference one exchange-rate cell on the Trip sheet to convert every row, put =SUM(F:F) under the Home amount column for the running total, and =SUMIF(G:G,"Name",F:F) once per traveler for the who-paid split. Compare the total against the budget cell on the Trip sheet.
  6. 6Add Packing and Pre-Trip sheets with a Data Validation dropdown (☐ / ☑) in the first column for tickable cells without macros, plus a documents block on Pre-Trip (passport, visa, insurance, licence) with an expiry column.
  7. 7Set print areas on each sheet (Page Layout → Print Area) and fit the Day Planner to one page wide in landscape, so the itinerary prints as a booklet. Or skip all seven steps: the travel itinerary template above is this workbook, already built.

Editing tips

Why a travel itinerary template beats a blank workbook

A blank sheet makes you decide the structure before you have anything to put in it. The template fixes the structure (one row per stop, one row per booking, one log for spending) so the only decisions left are about the trip.

The checkboxes are dropdowns, not decorations

Click any checkbox cell in the Packing or Pre-Trip sheet and a small dropdown appears. Pick the checked box to mark it done; no macros, so no security warning when the workbook opens.

Print is already set up

Every sheet has print areas, margins, and fit-to-width configured. The day planner prints landscape; everything else portrait. Ctrl+P should look right the first time.

Group trips: use the "Paid by" column

Put a name next to each expense and enter the same names in the Split by Traveler table. It sums what each person has fronted, which makes settling up at the end painless.

Formulas that survive a Sheets import

Every formula in this workbook (budget totals, the currency conversion, the countdown) uses only functions Excel and Google Sheets both support, so uploading it to Drive breaks nothing.

Frequently asked questions

Does this travel itinerary template work in older versions of Excel?

Yes. It is a standard .xlsx with plain SUM and SUMIF formulas, so anything from Excel 2010 onward opens it, as do LibreOffice and Numbers.

Is there a travel itinerary template for Excel with a budget built in?

This is one. The Budget sheet is a working expense log with a running total and a per-traveler split, and the total sits next to the budget you set on the Trip sheet so you can see the gap at a glance.

How do I make a travel itinerary in Excel from scratch?

Seven steps, listed above: a Trip sheet for the basics, a Day Planner with one row per stop and a buffer row per day, a Shortlist sheet, a Bookings sheet with free-cancel dates, a Budget sheet that converts currency with SUM and SUMIF, tickable Packing and Pre-Trip lists with a documents block, then print areas. The template on this page is that workbook already built.

Is there a version with the itinerary already written?

Two, in fact: the filled Japan example above is a finished 7-day trip as our AI planner exports it, and monkeyeatingmango.com writes a complete custom itinerary like it for any destination, exportable to Excel. Planning a trip is free, for now, and needs no account. Every day is free to read and edit. A one-time $0.99 Trip Pass gets the downloads of that trip to keep offline. The blank templates stay free.

Can I add more days or categories?

Yes. Copy a day's block of rows in the Day Planner for more days, and add rows to the budget categories. The formulas reference whole ranges, so totals keep working.

Does the Excel itinerary template work for a vacation or a business trip?

Both. The Bookings sheet (flight PNR, seat, hotel, car rental) is the spine of a business trip; the Day Planner and packing list carry a vacation. Delete the parts your trip does not need.

Is the Excel travel itinerary template a free download?

Yes. The blank template and the filled Japan example both download free, no email required, no watermark.

Can I use it as a travel expense tracker?

Yes. The Budget sheet is a working expense log: date, item, category dropdown, amount and who paid, with a running SPENT total. For a work trip, filter or sort the log by date and you have the receipt list an expense report wants.

Get the Excel template

Download the blank template (.xlsx)Free · no email · Excel 2010 or newer, live budget formulas

Other formats

Google Sheets template · Word itinerary template · Printable PDF template · Google Docs itinerary template · Notion template

Planning a specific kind of trip?

Bachelorette itinerary template · Disney itinerary template · Girls trip itinerary template · Road trip itinerary template · Business travel itinerary template · Birthday trip itinerary template · Family vacation itinerary template · Honeymoon itinerary template

Just one part of the plan

Travel budget template · Packing list template

Keep planning

Best AI travel planners, compared · What Wanderlog Pro costs (and free routes) · Sicily travel guide

Or start from a ready plan

7-day Japan itinerary · 5-day Paris itinerary · 7-day Italy itinerary

Or browse all 136 ready-made itineraries. Every one exports to PDF, Excel, Word, Google Sheets, or Google Docs.