Travel planner in Google Sheets: how to build one that works

A travel planner in Google Sheets works if you keep it to a few tabs: one for the day-by-day plan, one for bookings, one for costs and one for packing. Share it with the group, give every tab a clear owner, and keep each row to one thing. A spreadsheet is flexible and free, and for a short trip with a few people it is plenty. It gets heavy when the trip grows, when people are on their phones, or when you need it offline.
Here is the structure that holds up, and the point where it makes sense to move on.
Tab 1: the itinerary
One row per item, in time order, with these columns:
- Date
- Time (a start time, or "morning", "evening" if it is loose)
- What (the activity, the travel leg or the meal)
- Where (the place name, and a map link in the next column)
- Link (a pasted map or website link)
- Booked? (yes, no, not needed)
- Notes (door code, meeting point, what to bring)
Use a drop-down for "Booked?" and conditional formatting to colour "no" in a warm tone. At a glance you can see what still needs doing. Freeze the top row so the headings stay put on a phone.
Sort by date and time with a filter, and add a column for who is in charge of each item if the group is splitting the work.
Tab 2: bookings
Keep a separate tab so you can find a confirmation without scrolling the plan. Columns that earn their place:
- Type (stay, train, tour, restaurant)
- Name or provider
- Dates and times
- Confirmation number
- Who booked it and who it is under
- Cancellation or change deadline
- Cost and whether it is paid
The deadline column is the one that saves money: sort by it and you see what to decide first.
Tab 3: costs
For a group, a costs tab needs more than a total. Use one row per payment:
| Date | What | Paid by | Amount | Currency | Shared between | |---|---|---|---|---|---|
Then a small summary block that sums by person. The formulas for "who owes whom" are the part that gets complicated: with different currencies, uneven shares and some people missing from some costs, a sheet needs careful setup and checking. Track travel expenses covers the habits that make this easier whatever you use, and settle up after a group trip shows the end of it.
Tab 4: packing
A column for the item, a column for who is bringing it, and a tick box. Make a section for things the group shares, so you do not end up with four hair dryers and no first-aid kit.
Sharing it with a group
Share the sheet by link with edit access only for people who need it, and view access for everyone else. Agree two rules before you start:
- One person owns the structure. Anyone can add rows, but changes to columns or tabs go through one person.
- Update, do not duplicate. Never make "Copy of Trip plan". If there are two versions, nobody knows which is true.
Use the comment feature for questions on a row, not the chat, so the answer stays with the item.
Offline and on the phone
This is where sheets struggle. A spreadsheet is built for a keyboard. On a phone, a wide table means a lot of scrolling, and editing a cell is fiddly. If you rely on it in the street, make the itinerary tab narrow: date, time, what, where, notes, nothing else. As of November 2026, Google's help explains how to make a file available offline in the Sheets app, so install it and set that on the trip file before you leave, and test it in airplane mode at home.
When a spreadsheet stops being enough
A sheet starts to creak when:
- The trip has many cities or many people, and rows multiply.
- People mostly use phones.
- You want a map of the day, not just addresses.
- Costs need real currency conversion and a fair settle-up.
- You want to see gaps, such as a night with nowhere to stay.
None of this is a reason to avoid sheets. Plenty of good trips have been run from one. But if you find yourself building formulas, you are building an app, and that is the point to use one that exists.
If you want the comparison in detail, Travel Life vs a spreadsheet sets out what each does well, and how to make a travel itinerary works for either.
Small touches that make a sheet easier to live with
- Colour the tabs, so the itinerary and bookings are easy to tell apart on a small screen.
- Add a "Today" view: a filter by date that shows only one day. Save it, and open it each morning.
- Keep one cell at the top of the itinerary with the trip dates and the address of where you are staying.
- Write times in one format, and put the time zone in the notes when you cross one.
- Protect the cells with formulas, so nobody overwrites a total by accident.
Whatever you choose, test the sheet on a phone before the trip, with the connection off, so you know what you will see in the street.
What to do next
Make a sheet with the four tabs above and fill in only what you already know. Share it with the group and ask each person to add one thing within a day. If after a week it feels like work to keep up to date, that is the signal to move the plan somewhere easier.



