Trip planning spreadsheet template
Created:
Use template
The spreadsheet contains placeholder text. This is not my real information.
This is a great way to plan your annual leave to make sure you use all of your paid time off, as that’s a part of your compensation. Take the days off that you have in the year and fill those into the spreadsheet, then move them around as you plan your travel.
| Column | Description | Examples |
|---|---|---|
| Month | Abbreviated month of when the travel will occur | Apr |
| Day | Abbreviated day of when the travel will occur | Thu |
| Date | Full date of when the travel will occur | 2025-04-10 |
| City | Destination city | St. Louis, Lima, Antananarivo |
| Country | Destination country | United States, Peru, Madagascar |
| Comments | Important notes, or days to avoid travel | Don't travel: Doctor's appointment |
| Conveyance | Flight number(s), train numbers, etc. | SQ 23, 5821, BA1565 |
| Hotel Name | Linked name to booking site or website of hotel | Sutton Place Toronto |
| Rental car | Rental car company name | Hertz, Sixt, AVIS |
| To airport | Mode of transportation to departure airport | Ride share service, Driver, Train |
| From airport | Mode of transportation from arrival airport | Ride share service, Driver, Train |
Tips
- Filter the Date column by condition “Greater than or equal to”
=TODAY()-1to hide days that have already passed.
jlmc.space@gmail.com or consider buying me a coffee.