Hand operating a laptop with a spreadsheet - itinerary template

Itinerary Template (Excel)

A free Excel travel itinerary with dated activities, booking references, costs, paid status and a cost-per-day chart.

Download the free Excel file

What is in this template

A single planning sheet called Plan and a How to use tab. It works for holidays, business trips, road trips and group travel.

Plan

Enter the trip name, who is travelling and the currency. Then add one row per activity with a date, time, activity, location, booking reference and cost. The Day column shows the weekday from the date. Mark each item Paid? Yes or No. Under the list you get total trip cost so far, the cost still to pay, the number of activities and the number of days with plans. A cost-per-day table and bar chart sit below.

How to use

Steps with links back to the plan.

The sample data

The sample is a four-day Lisbon trip for two people with seven entries. Costs total $432, of which $57 is still to pay. June 10 is the heaviest day at $330 because it includes the flight. The booking references and prices are made up.

How to use it

  1. Type the trip name, travellers and currency.
  2. Add each activity in date and time order.
  3. Paste in booking references so confirmations are easy to find.
  4. Mark items as paid when you book them.
  5. Print the sheet or save it as a PDF to take with you.

Tips

  • Put flights and hotels first. Everything else is planned around them.
  • Leave free time. A day with three or four planned items is easier to follow.
  • Keep a reference column even for free activities, such as the opening hours.
  • Sort by date and time after adding items so the list reads in order.

Free pricing tips for your business

Get short, practical tips on pricing jobs and using our free calculators. No spam, unsubscribe any time.

    Built with Kit

    Frequently asked questions

    Can I plan more than four days?

    Yes. The list holds 40 rows. Add more dates to the cost-per-day table if you need them.

    Does it work for business trips?

    Yes. Use the location and reference columns for meetings and booking codes.

    Does the Day column update itself?

    Yes. It reads the weekday from the date you enter.

    Is the trip real?

    No. The sample trip is invented.

    Need a custom calculator or spreadsheet built for your business?

    Talk to us

    More free tools: All free calculators · Weekly schedule template · Event budget template · How to plan a trip itinerary