Travel Planner Spreadsheet: Budget, Bookings, Itinerary

Picture a group of four friends planning a ten-day trip across two countries. Flight options are in a chat, the hotel confirmation is in someone’s inbox, the budget is a guess, and nobody is sure who paid for the train tickets. By the time they land, the shared costs are a puzzle that takes an evening to untangle. A travel planner spreadsheet keeps the budget, bookings, itinerary, expenses and packing list together, with the group split worked out as you go.

Below is a practical guide to planning a trip in a spreadsheet, followed by a walk-through of the Travel Planner Spreadsheet for Excel and Google Sheets from Create Digital Tools.

Get the Travel Planner Spreadsheet →

Why trip planning gets scattered

Travel planning pulls information from many places at once. Without a central plan, a few problems come up again and again:

• Booking details are hard to find. Confirmation numbers and check-in times sit in different emails and apps.
• Cancellation deadlines pass quietly. Free-cancellation windows and balance-due dates are easy to forget.
• Budgets drift. Booked costs and on-trip spending are rarely compared with the original budget.
• Shared costs get messy. In a group, working out who owes who after the trip is slow and awkward.
• Multiple currencies. Prices in different currencies are hard to add up.

Travel apps solve parts of this. A spreadsheet lets you see and change all of it yourself.

How to plan a trip in a spreadsheet

1. Set up the trip basics

Enter the trip dates, who is travelling, your home currency and the total budget. Add exchange rates for any other currencies you expect to use.

2. Split the budget into categories

Typical categories include flights, accommodation, local transport, food, activities and insurance. Give each a target amount.

3. Log every booking

For each booking record the confirmation number, dates, times, cost, payment status and any free-cancellation deadline. Sort by date so the next booking is always at the top.

4. Build a day-by-day itinerary

One row per day, split into morning, afternoon and evening, is enough detail for most trips. Leave some gaps; not every hour needs a plan.

5. Track spending as you go

Record each expense with the currency, who paid and whether it is shared. Converting to your home currency at your chosen rate keeps the totals meaningful.

6. Count back from departure

List pre-trip tasks such as checking passports, buying insurance and arranging transport to the airport, each with a due date counted back from the day you leave.

7. Pack from a list

A packing list grouped by category, with a packed checkbox, saves last-minute stress.

Inside the Travel Planner Spreadsheet

The Travel Planner Spreadsheet is an .xlsx file that works in Excel and Google Sheets. It includes multi-currency support with your own exchange rates, a group cost splitter, cancellation-deadline and balance-due alerts on bookings, and a sample 10-day trip dated from today. A Setup Guide PDF is included.

START HERE

Six setup steps and a colour key.

DASHBOARD

Days to go, nights, budget, booked and spent, amount left, still to pay, packed percentage, open to-dos, next bookings, a budget chart and the checklist items due next.

SETUP

Trip dates, travellers, home currency, budget, up to 10 exchange rates and a quick converter.

BUDGET

Nine categories comparing budget, booked and spent, with a per-person view and a chart.

BOOKINGS

Up to 100 bookings with confirmation numbers, times, payment status, amount still to pay and free-cancellation alerts.

ITINERARY

Up to 30 days. Dates fill in automatically, with morning, afternoon and evening plans.

EXPENSES

Record spending in any currency, who paid and whether it is shared. A group split shows who owes who.

FLIGHT COMPARE

Compare six options including bag fees and the group total, and see which is cheapest and which is fastest.

CHECKLIST and PACKING LIST

Twenty pre-trip tasks with due dates counted back from departure, and a packing list of 90+ items in 8 categories with packed progress.

Watch the setup guide and full tour

This video shows how to set up your trip and use each tab:

Trip planning tips that save stress

• Book the fixed things first. Flights and accommodation shape the rest of the plan. Fill in the itinerary once they are confirmed.
• Prefer free cancellation early on. While plans are still moving, flexible bookings give you room to change. Watch the deadlines.
• Agree on the split before you go. In a group, decide which costs are shared and which are personal. Recording “shared or not” for each expense makes this easy.
• Compare full flight costs. Include bag fees and the group total, not just the headline fare.
• Use your own exchange rate. Choose a realistic rate, including any card fees, so totals reflect what you will actually pay.
• Leave free time. A plan for every hour leaves no room for rest or surprises.
• Pack from a checklist. Start the packing list a week before you leave and tick items off as they go in the bag.

Getting started in your first session

Download the .xlsx file and the Setup Guide PDF. Open the file in Excel, or create a blank Google Sheet and use File > Import > Upload > Replace spreadsheet. Look through the sample 10-day trip to see how the tabs connect, then follow the six steps on START HERE. Enter your trip dates, travellers, home currency, budget and today’s exchange rates on SETUP. Set your category budgets, then add any bookings you already have, including free-cancellation dates. The DASHBOARD then shows days to go, what is booked, what is still to pay and what is due next on your checklist.

Who it is for (and who it is not for)

A good fit if you:

• Plan group trips and want shared costs split clearly.
• Travel across currencies and want totals in your home currency.
• Like a spreadsheet you control rather than another travel app.

Probably not the right fit if you:

• Want bookings imported automatically from your email. Details are entered by you.
• Need live exchange rates. You enter the rates you want to use; the sample rates are examples.
• Are planning a trip longer than 30 days in the itinerary.

Saving for the trip? Our Annual Budget Spreadsheet helps you plan the year’s money. Browse more in our Excel and Google Sheets spreadsheets.

FAQ

Excel or Google Sheets?

Both. Open the .xlsx in Excel. For Google Sheets, create a blank sheet and use File > Import > Upload > Replace spreadsheet.

Can I update it on my phone while travelling?

A computer is recommended for setup. The Google Sheets app works for quick updates on the go.

Are exchange rates updated automatically?

No. The sample rates are examples, so enter today’s rates yourself in the Setup tab.

Is it an instant download?

Yes. You receive the .xlsx file and the Setup Guide PDF; nothing is shipped.

Can I reuse it for my next trip?

Yes. Keep a clean copy of the file and make a new copy for each trip.

Get the Travel Planner Spreadsheet →

Microsoft Excel is a trademark of Microsoft Corporation, and Google Sheets is a trademark of Google LLC. This is an independent spreadsheet, not affiliated with or endorsed by Microsoft or Google.