Back to blog

    Tour Guide Availability Calendar: How to Collect and Use It

    November 5, 20267 min readOperations

    A tour guide availability calendar records when each guide can work, when they cannot, and how much time they need between tours, so you can assign departures without asking around every week. The reliable way to collect it is to let guides maintain their own availability in one place that your assignment process reads directly. A shared spreadsheet or calendar can work for a small team; it breaks down once availability and assignments live in different tools.

    This article explains why availability collection fails, compares the three common ways to collect it, and shows how to use availability when you assign tours and handle changes. It is part of our complete guide to managing freelance tour guides.

    Why Does Guide Availability Collection Break?

    Most operators start by asking. A message goes to the guide group on Sunday ("Who can work next week?"), answers arrive over two days, and someone copies them into a sheet. It works until it doesn't.

    • Chat polls scatter the data. Answers arrive as messages, reactions and voice notes, some in private chats. Our article on why WhatsApp groups break down for tour guide teams covers this in detail.
    • Spreadsheets go stale. A guide's plans change on Wednesday, but the sheet was filled on Sunday. Nobody updates a cell when the change feels small.
    • Partial availability gets lost. "Free until 2 pm" or "only weekdays" does not fit a yes/no cell, so it ends up in a comment or in someone's memory.
    • Freelancers work for several operators. A slot that was free when you asked may be taken by another company before you assign it.
    • Availability and assignments are separate. If the availability sheet does not know about tours already assigned, the same guide can end up on two departures. That is how many conflicts start, as described in the anatomy of a double-booking.

    The common thread is that availability is collected once, in one place, and used later, somewhere else.

    What Should a Guide Availability Calendar Capture?

    Whatever tool you use, record the same information:

    • Working windows: date ranges, days of the week and hours a guide can work, including recurring patterns such as "weekday mornings".
    • Time off: holidays, exams, other commitments and anything that must never be booked.
    • Buffers: travel or preparation time a guide needs between tours, especially across cities or meeting points.
    • Outside work: tours the guide has with other operators or private clients.
    • Qualifications, kept separately: languages, cities, licences and tour types. These change rarely and belong in the guide's profile, not in the calendar, but you need both to make an assignment.

    Also set a planning horizon and a deadline, for example "next month's availability by the 20th", so you know when the picture is complete enough to plan.

    Three Ways to Collect Tour Guide Availability

    1. A Shared Spreadsheet

    One row per guide, one column per day, and guides type "AM", "PM" or "off". It costs nothing, everyone understands it, and you can see the whole team at a glance.

    The weaknesses are structural. The sheet does not know which tours are already assigned, cannot express a buffer, and does not stop two people overwriting each other. It works for a small, stable team with a firm weekly deadline. Our checklist of signs you have outgrown spreadsheets helps you recognize when that stops being true.

    2. A Shared Calendar

    Calendar tools let each guide mark their own time. In Google Calendar, a guide can share a calendar with specific people and choose "See only free/busy" so you see busy blocks without private details. Teamup suggests one sub-calendar per person, with permission levels so staff can edit their own time, and settings to prevent double-booking.

    This is more current than a spreadsheet because guides update the calendar they already use. But a calendar shows time, not suitability. It does not know that Saturday's tour needs a Spanish speaker with a site licence, so matching is still done by hand, and assignments usually live somewhere else.

    3. Scheduling Software Where Guides Set Their Own Availability

    In purpose-built guide scheduling software, guides enter their availability, time off and buffers in their own account, and the same system holds the tours and their requirements. Availability is checked at the moment of assignment, not copied from another tool.

    The trade-off is setup: tours, requirements and guide profiles have to be configured, and guides need an account. For an operation with many guides, languages or cities, that setup usually costs less than the weekly chasing it replaces.

    Comparison: Availability Collection Methods

    CriterionShared spreadsheetShared calendar (Google Calendar, Teamup)Guide scheduling software
    Who updates availabilityGuides or operator, by handEach guide, in a calendarEach guide, in their own account
    Recurring patterns and time offManual, per cellSupported as eventsDate ranges, weekdays and blockouts
    Travel buffers between toursNot supportedManualConfigurable per guide
    Knows about assigned toursNoOnly if tours are also addedYes, same system
    Matching on language and skillsManualManualUses profile data
    CostNoneVaries by toolSubscription
    Good fitSmall, stable teamsSmall to mid-size teamsMany guides, languages or cities

    How Do You Use Availability When Assigning Tours?

    Availability is a filter, not a decision. A useful order for each departure:

    1. Filter by availability, including buffers and tours already assigned.
    2. Filter by requirements: language, city, licence, tour type and role.
    3. Choose among the remaining guides using fairness, experience and guest needs. Spreading work predictably keeps freelancers on your team; our article on how to assign tours fairly between guides covers practical rules.
    4. Get a confirmation. "Available" means the guide could work, not that they agreed to this tour. Treat an assignment as done only when the guide has accepted it.

    How Do You Handle Availability Changes and Cancellations?

    Availability changes after you plan. Set clear rules:

    • Before assignment: guides update their calendar directly. Do not accept changes by private message only.
    • After assignment: availability changes do not cancel a confirmed tour. Agree a cancellation deadline per tour type and what happens when a guide needs to withdraw.
    • When a guide cancels: find a replacement from guides who are available and qualified at that time. This is where current data pays off, because the shortlist already exists.

    How Availability Works in EasyPlanning

    In EasyPlanning, our tour guide scheduling software, availability is maintained by guides and used by operators, in the same system as the tours. The freelancer documentation describes each step.

    For guides:

    • In Settings → Availabilities, add a date range, a time range and weekdays.
    • In Settings → Blockouts, record holidays and other periods that must not be booked.
    • Set Time between slots in the profile when travel or preparation time is needed.
    • Record work outside EasyPlanning as a Personal tour. It marks the time busy and is visible only to the guide.

    For operators:

    • A guide only sees open departures that match their cities, languages and interests, fall fully inside a declared availability window, and do not clash with blockouts or other tours, including the time between slots.
    • Guides apply for those open departures, and you accept or decline the applications.
    • You can review the available candidates for a departure in the company account.
    • The Utilization and Free Time chart in Reports shows capacity, tour hours and blockouts per guide or for all guides.

    Guides can also add individual tours to Google Calendar, Apple Calendar or Outlook from the .ics file attached to supported emails. That adds a single event; it is not a continuously synchronized calendar.

    FAQ

    What is a tour guide availability calendar?

    It is a record of when each guide can work, when they cannot, and how much time they need between tours. Operators use it to see who can take a departure before assigning it.

    How often should guides update their availability?

    Whenever it changes, with a fixed deadline for each planning period, such as next month's availability by the 20th. Recurring patterns reduce how often guides need to touch it.

    Can I use Google Calendar for tour guide availability?

    Yes, for a small team. Guides can share their calendar with free/busy visibility. It shows time but not languages, licences or assigned tours, so matching stays manual.

    Is availability the same as a confirmed assignment?

    No. Availability means a guide could work at that time. An assignment is confirmed only when the guide accepts that specific tour.

    Stop collecting availability by message

    Guides keep their own availability, time off and buffers, and only see open tours that fit. Try EasyPlanning free for 14 days, no credit card required.