How to Make a Travel Itinerary in Google Sheets
For a spreadsheet itinerary, start with one row per activity and a small number of clearly named columns. Add a separate booking sheet rather than turning the schedule into a list of confirmation emails.
The structure below is an original example you can enter in Google Sheets or adapt to another spreadsheet. It does not require an add-on or a downloadable template.
Create three sheets
Name them Days, Bookings and Budget. In Days, use these columns in order:
| Column | Header | Example |
|---|---|---|
| A | Date | Your actual travel date |
| B | Start | 09:30 |
| C | End | 11:00 |
| D | Activity | Museum visit |
| E | Area | Historic center |
| F | Address or map link | Provider's location |
| G | Status | Planned |
| H | Estimated cost | 20 |
| I | Notes | Check entry slot |
Keep cost cells numeric and put the currency in a clear header note. If you type “about twenty euros” into a cost cell, a sum will not treat it as a normal number.
Add only the formulas you need
If estimated costs are in H2 through H100, this formula totals those rows:
=SUM(H2:H100)
Use one row for each party-wide expense or one row for each person's expense, but do not mix both representations of the same purchase. A €60 group taxi recorded once and then again as three €20 shares would double the trip total.
For a different number of rows, change the range. Some regional spreadsheet settings use different function names or separators; use the formula syntax shown by your own spreadsheet if it differs.
Keep the booking tracker private
In Bookings, record the provider, date, amount paid, outstanding amount and cancellation deadline. Store confirmation references only where the intended travelers can access them. A sheet shared publicly as inspiration should not contain private booking details.
In Budget, summarize categories such as accommodation, transport, activities and food. Our travel budget template explains how to separate estimates from money already committed.
Make the schedule readable on a phone
Use short activity names and a consistent date format. Put detailed research notes outside the main day view. Sort a copy by date and start time when reviewing the sequence, and check that all columns move together.
Color can help, but status words are still useful when printing or sharing with someone who cannot easily distinguish the colors. Keep a visible distinction between “planned,” “booked” and “optional.”
Test it before the trip
Ask another traveler to find the next meeting point and the accommodation address. If that takes several searches, simplify the layout. Test the version you intend to use without relying on your usual desktop screen.
For a non-spreadsheet option, use the document-style itinerary template. For a group, borrow the owner and meeting-point fields from our shared itinerary guide. The goal is a plan you can use, not a workbook you spend the holiday maintaining.