Travel Itinerary Template for Excel
Free · No sign-up · Works in Excel, Excel Online and Excel for MacPlan your trip day by day in the free browser planner, then export it as a CSV and open it in Excel. You get a real spreadsheet — one row per stop, with columns you can sort, filter and total — not a locked PDF you have to retype.
What you get in the spreadsheet
The export has ten columns, structured so Excel can work with them immediately:
| Column | What it holds | Useful for |
|---|---|---|
| Day / Date | Day number and the calendar date in ISO form | Sorting chronologically in any locale |
| Day title | The name you gave that day | Grouping with SUMIF or a pivot table |
| Time / Duration | Start time and length in minutes | Spotting overloaded days |
| Type | food, sight, shop, hotel, other or transit | Filtering to just meals or just transit |
| Title / Location | The stop and its address | Building a checklist or mail merge |
| Notes | Your notes, or the opening-hours hint | Keeping reminders next to each stop |
| Cost (USD) | Plain numbers, no currency symbol | =SUM() straight down the column |
How to open the itinerary in Excel
- Build your trip. Open the planner, add your days and activities. Everything autosaves in your browser.
- Click CSV. The button sits in the planner toolbar next to Print and Export PDF. The file downloads immediately — nothing is uploaded anywhere.
- Double-click the file. Excel opens it as a spreadsheet. On Windows, if a text import wizard appears, choose Delimited and tick Comma.
- Save as .xlsx. Use File → Save As and pick Excel Workbook. CSV cannot store column widths, colours or formulas, so converting first means your formatting survives.
Three things worth doing once it's in Excel
- Total the budget. Put
=SUM(J2:J100)under the Cost column. For a per-day figure,=SUMIF(A:A, 1, J:J)totals day one. - Filter by type. Select the header row, hit Data → Filter, then narrow to
foodto see every meal, ortransitto audit how much of the trip is spent moving between places. - Check your pace. Sum the Duration column per day. Anything past about 600 minutes of scheduled activity is a day that will feel rushed in practice.
Why plan in the browser instead of straight in Excel?
A blank spreadsheet gives you no structure — you end up inventing columns, and the transit between stops usually gets left out entirely. The planner already knows what a day of travel looks like: it lays out a timeline, keeps transit legs between activities, and totals costs as you type. Excel is excellent for slicing that data afterwards; it is a slow place to invent the plan in the first place.
You can also keep both. Export to CSV whenever you want to crunch numbers, and keep planning in the browser, where the itinerary stays formatted and printable.
Other formats
The same itinerary exports to PDF, print and Google Sheets. The CSV file imports straight into Google Sheets via File → Import, and into Apple Numbers by double-clicking.
Frequently asked questions
Is this Excel travel itinerary template free?
Yes. Building the itinerary and exporting it to CSV for Excel is completely free, with no sign-up and no watermark.
Why is the export a CSV instead of an .xlsx file?
CSV opens natively in Excel with a double-click, works in every Excel version including Excel Online and Excel for Mac, and imports into Google Sheets and Numbers too. Once open, save it as .xlsx to keep formatting and formulas.
Will accented or non-English place names display correctly?
Yes. The file is written as UTF-8 with a byte order mark, which is what tells Excel to read the encoding correctly, so names like Kabukichō or Sensō-ji arrive intact rather than as mojibake.
Can I total my trip budget in Excel?
Yes. The Cost column holds plain numbers with no currency symbol, so SUM works directly. Use SUMIF against the Day column for per-day totals.
Ready to build it? Open the free travel itinerary template and click CSV when you're done.