2026-11-18 · 12 min read
A trip planner sheet needs four tabs: overview, bookings, itinerary and a planned-versus-actual budget. Here is how to build each in Google Sheets, plus printing and group splits.
By the Fortrip editors. The budget formulas use standard Google Sheets syntax, and the print and conversion steps follow Google's own help articles, linked in those sections.
A good trip planner sheet is one file that holds your confirmation numbers, your day plan and your running cost, so nobody is searching email threads at a boarding gate. Four tabs do that job:
This guide builds the sheet tab by tab in Google Sheets. After that it covers printing, splitting costs on a group trip, opening an Excel template in Sheets, and when an app is the better tool.
Share

A decision guide to UK tours: coach, mini-coach and independent travel compared, four buying questions, a 14-day Britain route and a pre-booking checklist.
An all-inclusive honeymoon bundles room, meals and drinks into one price. Here is what packages cover, how each region handles transfers and storms, and how to test a quote.
For a minimal reference layout to compare against, see SpreadsheetDaddy's trip planner template.
Start with the four that carry the trip, then add extras only when you will open them more than once during the trip. A tab earns its place by being used, not by looking thorough.
A packing checklist is useful if you travel with the same gaps every time, such as chargers or medication. A research tab for restaurants and activities makes sense only while you are comparing options before booking. Once you have chosen, move the winners into the itinerary and delete the tab.
Skip a separate travel expense spreadsheet when the budget tab already has an actual column. Skip a dashboard when the trip is a long weekend; a summary row at the bottom of the budget tells you the same thing.
The overview is the page you open when someone asks where you are staying. Give it these fields, one per row, with labels in column A and answers in column B:
Below those, add an emergency block: the accommodation address, the travel insurance policy number, and the phone number for each booking. Keeping these together means you copy one block into a message instead of hunting.
Keep the whole tab to a single screen. If it scrolls sideways on a phone, it will not get read.
The bookings tab is a ledger of everything you have paid for or reserved. Use one row per booking and these columns:
Sort by date, not by category. Sorted that way, the sheet reads as a timeline: the train out, the hotel, the rental car pickup, the train back.
Give the cancellation deadline its own column rather than a line in a notes cell. It is the field that saves money when plans shift, and it is the one that gets lost when it sits in free text.
Do not paste attachments into cells. Keep the confirmation PDFs in a Google Drive folder and put the folder link on the overview tab.
The itinerary is where most travel itinerary spreadsheets fall apart, because people list places without listing the gaps between them. Build the gaps in from the start. If you want a second opinion on whether a day is physically workable, the itinerary validator checks a plan for that kind of strain.
Use one row per time block. If you are starting from a blank trip itinerary template, these are the columns to put in it:
The "booked or open" column matters more than it looks. It tells you at a glance which parts of the day are fixed and which can move if it rains.
The table below is a sample travel itinerary template for Lisbon, written as an illustration of the layout rather than a recommendation. The travel-time column is filled from a maps app or timetable on the day you plan, because those figures change with the route and the service.
| Date | Start time | Place | What you are doing | How you get there | Travel time | Booked or open | Cost |
|---|---|---|---|---|---|---|---|
| Day 1 | Morning | Alfama | An unhurried walk through the old quarter | On foot from lodging | Read from maps app | Open | Free |
| Day 1 | Midday | Baixa | Lunch | Walk downhill from Alfama | Read from maps app | Open | Your estimate |
| Day 1 | Afternoon | Castelo de São Jorge | The one fixed visit of the day | Walk or tram uphill from lunch | Read from maps app | Booked | From confirmation |
| Day 1 | Evening | Unscheduled | Rest or an early dinner | Back to lodging | Read from maps app | Open | Your estimate |
| Day 2 | Morning | Sintra | Palace visit on a timed ticket | Train from Rossio station | Read from rail timetable | Booked | From confirmation |
| Day 2 | Afternoon | Sintra | A second, lighter stop, then the return | Return train, with a buffer | Read from rail timetable | Open | Your estimate |
| Day 2 | Evening | Bairro Alto | Dinner | On foot uphill from Rossio, or a taxi | Read from maps app | Open | Your estimate |
The lesson in the layout is that a day trip fills a morning and part of an afternoon. It is not a single line item.
Add a column for the one fixed event, such as a dinner reservation or a tasting, and plan slack on both sides of it so a late train does not wreck the evening. If part of the trip is a surprise, keep those items in a private column or a separate tab that the guest of honor does not have access to.
Cap each half-day at one anchor activity. Then leave one unscheduled block per day. The blank block is not wasted time; it is where the delay, the long lunch and the unplanned find land.
The budget tab answers two questions: what did we expect to spend, and what did we spend. Everything in the layout below serves those two.
Use these columns: category, planned amount, actual amount, difference, and a note. The difference is actual minus planned. A positive number means you went over; a negative one means you came in under. In Sheets, if planned is in column B and actual in column C, put =C2-B2 in D2 and fill down. Add a total row at the bottom with =SUM(B2:B8) style formulas for each numeric column, adjusting the range to your rows.
This table shows the layout for a city trip. It is illustrative advice, not data, and the cells are deliberately blank: fill them from your own quotes and bookings, not from anyone's average.
| Category | Planned | Actual | Difference | Note |
|---|---|---|---|---|
| Transport | your quote | from receipts | =C2-B2 | Flights and airport transfer |
| Lodging | your quote | from receipts | =C3-B3 | Nightly rate times nights |
| Food | your estimate | from receipts | =C4-B4 | Set a daily figure |
| Activities | your quote | from receipts | =C5-B5 | Only booked items |
| Local transit | your estimate | from receipts | =C6-B6 | Passes or single fares |
| Gifts and incidentals | your estimate | from receipts | =C7-B7 | Souvenirs, tips, small purchases |
| Buffer | your estimate | from receipts | =C8-B8 | Draw from this first |
| Total | =SUM(B2:B8) | =SUM(C2:C8) | =C9-B9 | Check this against your bank statement |
Add three things: a column for the local-currency amount, one cell holding the exchange rate you chose, and a converted column that multiplies the first by the second. Keep the rate in a single labeled cell so changing it updates every row.
Then decide how the rate gets updated. By hand is predictable: you pick a rate on the day you book and stick with it. Sheets also has a built-in finance function that can pull a rate, in the form =GOOGLEFINANCE("CURRENCY:EURUSD"). Read Google's GOOGLEFINANCE help page before relying on it, since supported pairs and refresh behavior are documented there.
To split costs evenly, total the shared costs, divide by headcount, and subtract what each person already paid from that share. A positive result means that person owes the group; a negative one means they are owed. Test the sheet on a small made-up sample before you trust it with real money.
Set it up with two extra columns on the actual budget: paid by, and shared with. Then build a small summary block with one row per person that shows what they paid and what they owe.
The unequal case needs more care. If someone skips a dinner or shares a room, a single division no longer works. List the participants for each line in the shared-with column, and split each line only among the people named on it. The summary then adds up each person's share across lines, rather than dividing one grand total.
Print the overview and the itinerary. The bookings tab is better read on a phone, where you can tap a confirmation code.
Menu names shift over time, so confirm the exact wording in Google's help article, Print, save, or customize spreadsheets. The path runs like this:
Save the PDF to your phone so it opens without a signal. Paper is a fine backup, but the file in your pocket is the one you will actually consult.
Upload the Excel file to Google Drive, open it with Google Sheets, and check that nothing broke in the conversion. Google documents the steps in its article on editing Microsoft Office files in Docs, Sheets and Slides, and it is the page to trust if menus differ from what you see.
Three things commonly break and deserve a look:
Spot-check the formulas in the budget total and the difference column, and test any dropdowns before you enter real data.
Use a sheet while you are planning with others and want to see everything at once, then add an app for the days of travel itself, when alerts and maps matter more than columns. The traits below describe categories, not specific products.
A sheet wins on control. You choose every column, share the file with a co-planner in a click, and pay nothing. Keep a saved PDF on your phone for the moments you have no signal. An app tends to win where automation matters: importing booking emails, sending live flight alerts, and showing places on a map.
If you would rather start from a generated draft than a blank grid, the AI trip planner builds an itinerary you can copy into your own sheet, and the pricing page lists what is free. For more on building a plan that holds up, read the other trip-planning guides from our editors.