{"id":2344,"date":"2026-02-26T19:16:25","date_gmt":"2026-02-26T19:16:25","guid":{"rendered":"https:\/\/templates.yopki.com\/travel-itinerary-google-sheets\/"},"modified":"2026-04-07T21:46:27","modified_gmt":"2026-04-07T21:46:27","slug":"travel-itinerary-google-sheets","status":"publish","type":"post","link":"https:\/\/templates.yopki.com\/travel-itinerary-google-sheets\/","title":{"rendered":"Free Travel Itinerary Template for Google Sheets (With Budget Tracker)"},"content":{"rendered":"\n

Google Docs is great for a narrative-style itinerary. But if you want sortable columns, automatic budget math, and the ability to filter your entire trip by date, category, or cost \u2014 you want a spreadsheet. You can also browse all itinerary templates<\/a> to find the right format<\/p>\n\n

This free travel itinerary template for Google Sheets combines your day-by-day plan with a working budget tracker. Every dollar you log gets tallied automatically. Every flight, hotel, and activity sits in a sortable, filterable table. Copy it to your Drive and start planning. Or, skip the template and build your itinerary with AI<\/a><\/p>\n\n

\nDownload Travel Itinerary Template Google Sheets (.xlsx)<\/a>\nOpen Travel Itinerary Template Google Sheets (Google Sheets)<\/a>\n<\/div>\n\n

What’s in This Template<\/h2>\n
\"Travel<\/figure>\n\n\n

The spreadsheet has four tabs designed to work together:<\/p>\n\n

Tab 1: Day-by-Day Itinerary<\/h3>\n\n

Your complete trip timeline in a single sortable table. Each row is one activity or event with these columns: date, time, activity name, category (flight, hotel, food, activity, transport), location, address, confirmation number, estimated cost, actual cost, payment method, and notes.<\/p>\n\n

The category column uses a dropdown menu so entries are consistent and filterable. Want to see only your restaurant reservations? Filter by “Food.” Need all your confirmation numbers? Sort by category and they’re grouped together.<\/p>\n\n

Conditional formatting highlights today’s date row in blue, so during your trip you can instantly see where you are in the schedule.<\/p>\n\n

Tab 2: Budget Dashboard<\/h3>\n\n

Set your total trip budget at the top. The dashboard pulls data from the itinerary tab automatically and shows you spending by category with both estimated and actual amounts. A progress bar shows what percentage of your budget you’ve used, and a “remaining” figure updates in real time as you log expenses.<\/p>\n\n

The breakdown includes: flights, accommodation, food and dining, activities and tours, local transportation, shopping, and a miscellaneous category for the unexpected (like that $40 taxi when you got lost).<\/p>\n\n

Tab 3: Flight & Transport Log<\/h3>\n\n

A dedicated table for every leg of transportation: airline\/operator, flight or booking number, departure point, arrival point, departure time, arrival time, terminal, gate, seat, confirmation code, and cost. Works for flights, trains, buses, ferries, and rental cars.<\/p>\n\n

This tab cross-references with the itinerary tab so your transport entries appear in both places without double-entry.<\/p>\n\n

Tab 4: Accommodation<\/h3>\n\n

Every place you’re staying gets a row: property name, type (hotel, Airbnb, hostel), address, check-in date and time, check-out date and time, confirmation number, nightly rate, total cost, Wi-Fi info, and notes. Total accommodation cost calculates automatically based on nightly rates and number of nights.<\/p>\n\n

\n

Plan Your Trip Today!<\/h2>\n

Get a complete, personalized trip template in seconds.<\/p>\n

For more details, see our complete trip planning guide<\/a>.<\/p>\n

Take full control to customize every detail.<\/p>\nPlan My Trip<\/a>\n<\/div>\n\n

How to Use It<\/h2>\n\n
    \n
  1. Copy the template.<\/strong> Open the link below, then go to File \u2192 Make a copy<\/strong> to save it to your Google Drive.<\/li>\n
  2. Set your budget.<\/strong> In the Budget Dashboard tab, enter your total trip budget in the highlighted cell at the top. Everything else calculates from this number.<\/li>\n
  3. Enter your fixed bookings first.<\/strong> Flights, hotels, and pre-booked tours go in first because they have set dates and costs. Fill in the Flight & Transport Log and Accommodation tabs, and these entries auto-populate in the main itinerary.<\/li>\n
  4. Build out each day.<\/strong> In the Day-by-Day Itinerary tab, add activities, meals, and free time for each day. Use the category dropdown to keep entries consistent.<\/li>\n
  5. Share with your group.<\/strong> Click Share<\/strong> and add travel companions. Multiple people can edit simultaneously \u2014 one person adds restaurants while another researches activities.<\/li>\n
  6. Track spending during your trip.<\/strong> As you spend, fill in the “Actual Cost” column. The Budget Dashboard updates in real time so you always know where you stand financially.<\/li>\n<\/ol>\n\n

    Spreadsheet vs. Google Docs: Which Should You Use?<\/h2>\n\n

    Choose Google Sheets if<\/strong> you care about budget tracking, want sortable and filterable data, are planning a complex multi-destination trip, or are traveling with a group that needs to split costs.<\/p>\n\n

    Choose Google Docs if<\/strong> you prefer a narrative layout that reads like a document, want to include photos and maps inline, or are planning a simpler trip where budget tracking isn’t a priority. We have a Google Docs version of this template<\/a> if that sounds better.<\/p>\n\n

    Use both if<\/strong> you want the best of each. Plan and track in the spreadsheet, then copy the finalized itinerary into a Google Doc for a cleaner printable version. Or skip that step and use the Yopki Travel Document Organizer<\/a> to merge your exported PDF with all your booking confirmations.<\/p>\n\n

    Power User Tips<\/h2>\n\n

    Create a currency conversion column.<\/strong> If you’re traveling internationally, add a column with the formula =cost_in_local * exchange_rate<\/code>. Name a cell “exchange_rate” and update it once \u2014 every converted amount updates automatically.<\/p>\n\n

    Use data validation for consistent entries.<\/strong> The template uses dropdown menus for categories, but you can add your own. Go to Data \u2192 Data validation to create custom dropdowns for payment methods, trip companions, or priority levels.<\/p>\n\n

    Set up conditional formatting alerts.<\/strong> Want a warning when a single day’s spending exceeds $200? Select the daily cost column, go to Format \u2192 Conditional formatting, and set a rule to highlight cells above your threshold in red.<\/p>\n\n

    Enable offline mode before traveling.<\/strong> Go to Google Drive Settings \u2192 Offline and toggle it on. Your spreadsheet will be accessible without Wi-Fi \u2014 essential for logging expenses on the go.<\/p>\n\n

    Freeze the header row.<\/strong> The template already does this, but if you add rows and it breaks: go to View \u2192 Freeze \u2192 1 row. This keeps your column headers visible as you scroll through a long itinerary.<\/p>\n\n

    When Your Trip Is Planned<\/h2>\n\n

    Once your itinerary is locked in, export the key information for offline access. Go to File \u2192 Download \u2192 PDF<\/strong> to create a printable version of any tab. For a complete travel packet that combines your itinerary with booking confirmations, insurance docs, and passport copies, use the Yopki Travel Document Organizer<\/a>.<\/p>\n\n

    For a more comprehensive spreadsheet with six tabs covering packing lists and pre-trip checklists, check out our Trip Planning Spreadsheet<\/a>.<\/p>\n\n

    \nDownload Travel Itinerary Template Google Sheets (.xlsx)<\/a>\nOpen Travel Itinerary Template Google Sheets (Google Sheets)<\/a>\n<\/div>\n\n

    FAQ<\/h2>\n\n

    Can I download this as an Excel file?<\/h3>\n

    Yes. Once you’ve copied the template to your Drive, go to File \u2192 Download \u2192 Microsoft Excel (.xlsx). All formulas, conditional formatting, and dropdown menus transfer to Excel. You’ll lose real-time collaboration and offline sync, but the spreadsheet works identically.<\/p>\n\n

    Does the budget tracker work with multiple currencies?<\/h3>\n

    The template uses a single currency by default. To track multiple currencies, add a “Currency” column and an “Exchange Rate” column, then create a formula that converts everything to your home currency. This takes about five minutes to set up and makes international trip budgeting much clearer.<\/p>\n\n

    Can multiple people edit at the same time?<\/h3>\n

    Yes. Google Sheets supports real-time collaboration. Share the spreadsheet with your travel group and everyone can edit simultaneously. You’ll see each person’s cursor and changes appear instantly. This makes it easy to divide planning tasks \u2014 one person handles flights while another researches restaurants.<\/p>\n\n