Trip planner template
A trip planner with dates, flights, lodging, daily activities and budget.
- ๐บ๐ธ US format ยท Letter size
- Free
Pick your options and the preview updates. The file opens in Excel, Google Sheets or Numbers.
The file is built in your browser. Nothing is uploaded or saved.
Sheets
- How to use
- Day plan: day, date and weekday pre-filled; time, place, plan, getting there, estimated cost, notes; cost total, bookings total, trip total, travelers and cost per person (formulas)
- Bookings: flights, lodging, rental car, tours and restaurants with confirmation numbers, phone and cost total
Color key
- Yellow cells: fill these in
- Blue cells: formulas, leave them as they are
- Gray rows: examples you can delete
1 / 3
Trip planner
| Day | Date | Weekday | Time | Place | Plan | Getting there | Est. cost | Notes |
|---|---|---|---|---|---|---|---|---|
| Day 1 | 2026-10-22 | Thu | 9:00 AM | Austin-Bergstrom Airport | Flight to San Francisco | Flight | 289 | Seat 14C |
| Day 1 | 2026-10-22 | Thu | 12:30 PM | Ferry Building | Lunch at the market | Walk | 24.5 | |
| Day 1 | 2026-10-22 | Thu | ||||||
| Day 1 | 2026-10-22 | Thu | ||||||
| Day 1 | 2026-10-22 | Thu | ||||||
| Day 2 | 2026-10-23 | Fri | ||||||
| Total | =SUM(โฆ) |
Cost summary (under the day plan)
| Item | Value |
|---|---|
| Day plan total | =SUM(...) |
| Bookings total | =Bookings!... |
| Estimated trip total | =day plan + bookings |
| Travelers | 2 |
| Cost per person | =total / travelers |
Bookings
| Type | Name (airline, hotel, company) | Date and time | Confirmation # | Phone | Cost | Notes (address, check-in time) |
|---|---|---|---|---|---|---|
| Flight | United UA 1234 | 10/22 9:00 AM departs | ABC123 | 289 | Carry-on only | |
| Hotel | Hotel Northwind, 2 nights | 10/22 3:00 PM check-in | H-7781920 | (555) 010-0000 | 418 | Breakfast included |
| Total | =SUM(โฆ) |
This shows the first part of each sheet as it prints on Letter paper. The file also has a how-to sheet and formulas, and every column fits one page width when you print from Excel.
How to use it
Type the destination, departure date, number of days and travelers. The Day plan sheet comes with the dates filled in; you add the time, place, plan, how you are getting there and an estimated cost. The Bookings sheet keeps flights, hotels and rental cars with their confirmation numbers.
The bottom of the day plan adds the day-by-day costs and the bookings into an estimated trip total and a cost per person. Start with the places you are sure about and leave gaps; the plan is easier to keep when it is not packed.
Things to watch
These are planning numbers. To split what you really spent with friends, use the trip expense splitter, which works out who owes whom.
Calculators that go with this
Frequently asked questions
Can I add more rows for a day?
Copy a row for that date and insert it below. As long as it sits above the Total row, the cost total includes it.
Does it work in Google Sheets?
Yes. Upload it to Google Drive and the SUM and ROUND formulas work the same, so the group can edit the plan together.
Where do flights and hotel confirmations go?
On the Bookings sheet: type, name, date and time, confirmation number, phone and cost. The cost total feeds the trip total on the Day plan sheet.
Is what I type saved anywhere?
No. Everything stays in your browser and nothing is sent to our server. If you refresh the page it is gone, so print, save a PDF or download the DOCX when you are done.