Last spring I landed in Tokyo with a screenshot of a booking confirmation and a vague memory that I had a hotel somewhere in Shinjuku. I didn’t. I had booked it in Shibuya. I spent 45 minutes at the airport on sketchy Wi-Fi trying to piece together a trip I’d planned across three different apps and a notes file. That was the last time I traveled without a single source of truth.
You don’t need a fancy app. You need a spreadsheet that does the heavy lifting. Here’s the exact structure I use now, and why it works better than any $10/month trip planner.
The Core Problem: Why Your Current Itinerary Fails
Most people plan trips in fragments. A flight confirmation email here. A restaurant reservation text there. A Google Doc with a list of “things to do” that has no times attached. When you’re standing on a street corner in a foreign country with no data, that fragmentation costs you time and money.
The fix is a single workbook with three tabs. Not one massive list. Three separate sheets that talk to each other.
Tab 1: The Master Timeline. This is the day-by-day view. Rows are days. Columns are time blocks (Morning, Afternoon, Evening). Each cell holds a location, an address, and a confirmation number.
Tab 2: The Booking Ledger. Every paid reservation goes here. Flight numbers, hotel addresses, tour operators, prices, cancellation policies. This is the tab you check when something goes wrong.
Tab 3: The Budget Tracker. This is where you log actual spending against planned spending. Most people skip this. Then they come home and wonder why their credit card bill is $800 higher than expected.
The mistake people make is trying to put everything on one sheet. It becomes a wall of text. You stop looking at it. Then you’re back to checking three apps at once.
Building the Master Timeline: The Only Layout That Works
I’ve tried horizontal layouts, vertical layouts, and color-coded calendars. The one that actually survives contact with a real trip is a simple grid.
Here’s the structure I use for every trip, from a weekend in Lisbon to a three-week haul through Southeast Asia.
| Day | Date | Morning (8am–12pm) | Afternoon (12pm–6pm) | Evening (6pm–late) | Sleeping At |
|---|---|---|---|---|---|
| 1 | 2026-03-14 | Land HND 6:40am (JL 001), Suica card, train to Shinjuku | Drop bags at Hotel Gracery, walk to Meiji Jingu | Omoide Yokocho for yakitori, Golden Gai bars | Hotel Gracery Shinjuku, Conf #HG-88213 |
| 2 | 2026-03-15 | Tsukiji Outer Market (arrive by 8am to beat crowds) | TeamLab Planets (ticket 1:30pm, Conf #TL-5542) | Shibuya Sky sunset (book 5:20pm slot), dinner in Ebisu | Hotel Gracery Shinjuku |
| 3 | 2026-03-16 | Day trip to Kamakura (Odakyu pass), Kotoku-in by 9am | Hokokuji bamboo grove, lunch at Kamakura Matsubara-an | Return to Tokyo, free night in Shimokitazawa | Hotel Gracery Shinjuku |
Every cell has a location and a time. No vague “explore the city” entries. Those are useless when you’re actually on the ground. If you don’t know where you’re going, you’ll stand around looking at your phone for 20 minutes.
I keep the Master Timeline to a maximum of three items per day. Any more and you’re planning a forced march, not a vacation. Leave gaps. The gaps are where the trip actually happens.
The Booking Ledger: Your Insurance Against Chaos
If your flight gets cancelled or your hotel loses your reservation, you need to pull up a confirmation number in under 10 seconds. Not scroll through 400 emails.
This tab is boring. It’s also the one that saves you when things break.
What goes in the Ledger
- Flights: Airline, flight number, departure/arrival times, booking reference, ticket number, baggage allowance, seat assignment.
- Hotels: Property name, full address in local language, check-in/out times, booking platform (Booking.com, Agoda, direct), confirmation number, cancellation deadline.
- Transport: Train tickets (JR Pass, Eurail), rental car company, pick-up location, booking reference.
- Tours & Activities: Operator name, meeting point, start time, confirmation code, refund policy.
I organize this tab by date, not by category. When I land, I look at today’s date and see everything booked for that day. That’s it.
One specific thing that has saved me twice: I copy the hotel’s address in the local language (Japanese, Thai, whatever) into the ledger. When I hand my phone to a taxi driver, they don’t have to guess what “Hotel Gracery” means.
The Budget Tab: Stop Lying to Yourself About Spending
Most people don’t track spending on vacation because it feels like work. Then they get home and the credit card statement is a mystery. The fix is to make the budget tab so simple you update it in 30 seconds while waiting for a coffee.
Here’s the layout I use:
- Column A: Date
- Column B: Category (Food, Transport, Lodging, Activities, Shopping, Other)
- Column C: Item (e.g., “Ramen at Ichiran”, “Shinkansen ticket”)
- Column D: Planned Cost (from your pre-trip estimate)
- Column E: Actual Cost (what you actually paid)
- Column F: Difference (E minus D, automatically calculated)
At the bottom, a simple SUM formula shows you total planned vs. total actual. That’s the whole thing. No pivot tables. No charts. Just a running tally.
I use Microsoft Excel for this because the mobile app is fast and I can use it offline. Google Sheets works too if you prefer cloud sync. The point is that it takes 30 seconds to log a meal. If it takes longer than that, you won’t do it.
Excel vs. TripIt vs. Wanderlog: What Actually Works
I’ve tried the dedicated apps. TripIt parses your confirmation emails automatically, which is genuinely useful. Wanderlog has a nice map view and collaborative features. Notion templates look beautiful.
But here’s what happens with all of them: you still end up checking multiple places. TripIt doesn’t do budgets well. Wanderlog’s free tier limits offline access. Notion requires you to build the whole system yourself, and then you spend an hour tweaking it instead of planning your trip.
Excel wins because it’s boring and it works. It’s already on your computer. It works offline. You can customize it in five minutes. You’re not learning a new interface while you’re jet-lagged.
That said, if you’re traveling with a group and everyone needs to edit the itinerary from their own phone, Google Sheets is the better call. The sharing is frictionless. For solo travel or couples, Excel’s offline reliability wins.
Common Mistakes That Ruin a Good Spreadsheet
I’ve watched friends abandon their carefully built itineraries by day three. Here’s what kills them.
Overstuffing the timeline. If every hour is scheduled, the spreadsheet becomes a tyrant. You’ll rebel by ignoring it entirely. Leave at least one completely empty afternoon every three days.
Putting restaurants in the timeline without addresses. “Lunch at that pasta place” is useless. You need the name, the address, and ideally a note about when it opens. Otherwise you’ll wander around hungry and end up at a tourist trap.
Not updating the budget in real time. If you log three days of spending at once, you’ll forget half of it. The whole point of the budget tab is to catch overspending while you can still do something about it.
Using a template you don’t understand. I’ve seen people download a 12-tab Excel monster with macros and pivot tables. They spend two hours trying to figure out how it works, then give up. Start with three tabs. That’s it.
The spreadsheet is a tool, not a project. If you’re spending more than 15 minutes setting it up, you’re doing it wrong.
The Verdict
For most travelers, a three-tab Excel workbook is the best itinerary system. It’s free, it works offline, and it forces you to actually think through your trip instead of just collecting screenshots.
If you’re traveling with a group that needs live collaboration, use Google Sheets with the same structure. If you want automatic email parsing and don’t care about budget tracking, TripIt is fine. But for a single source of truth that covers timeline, bookings, and budget, a spreadsheet still beats the apps.
Build it once. Use it every trip. Stop landing in foreign cities with no idea where you’re sleeping.
