Event planning spreadsheet template for an offsite away from home: travel, rooms, transfers and key dates in one Google Sheet

An event planning spreadsheet template works well when everyone is already in town. It breaks down the moment the team has to travel.

Then the hard part moves. Who lands where and when, who picks them up, who sleeps in which room, and which contract dates can cost money?

Without a shared place for the travel side, those answers end up in email threads and in three versions of one file.

But one event planning spreadsheet can hold all of it, if every tab runs from a single headcount.

In this guide, we'll show you a Google Sheet you can copy, what each of its five tabs does, and how to fill it in, in order.

Download the event planning spreadsheet template

Open the link below, choose "Make a copy", and the sheet lands in your own Google Drive. Your copy is private to you until you share it.

Make a copy of the Google Sheet

Google asks you to sign in first, so you need a Google account. There is nothing to sign up for with Vantly, and no email address to hand over.

Prefer Excel? Open your copy, then choose File, Download, Microsoft Excel (.xlsx). Check the status board after you open it, because some formulas may behave differently in Excel.

This event planning template for Google Sheets has five tabs:

• Setup and status: the one headcount cell, key numbers and a status board.
• People: one row per traveler.
• Arrivals and transfers: who lands where, grouped into pickups.
• Rooming: who sleeps where, checked against the venue's bedroom count.
• Key dates: the contract dates that can cost money.

Use it as an offsite planning template or a corporate retreat planning template for any trip of one to three nights where people travel in. It has no agenda tab. For the program, see our offsite agenda template.

What's in the template, tab by tab

Every tab follows the same rule: type in the white or yellow cells and leave the grey ones alone. Grey cells calculate from what you enter, so the counts stay consistent across tabs.

Setup and status

This tab holds the numbers the rest of the sheet reads. Type the headcount once, in cell B6. The status board below it lists what still needs attention.

The status board checks People, Travel, Transfers, Rooms and Key dates, and adds up the open items. When the total reaches zero, the plan is complete on paper.

People

One row per person, with the columns from the master tracker in our first-time EA offsite checklist, plus home office and travel mode.

Arrivals and transfers

Names, home office and travel mode come over from People. You add where each person starts, the arrival hub, date, time and trip number, and the same for departure.

A pickup group reads like "Airport A | May 12 10:00 AM". To the right, a wave summary counts the people in each group and the vehicles to request.

A small owner table lets you name one person for each wave. Any wave without an owner shows "Needs owner". For the transport side, see our guide to group transport for company offsites.

Rooming

One row per room, with the building or floor, bed type, up to two occupants, an accessibility note and the check-in and check-out dates. A block to the right checks the plan against the venue.

Count bedrooms, not beds. A room with two beds is one bedroom, a point we cover in private rooms versus shared beds.

Key dates

One row for each date in a signed document that can cost money. Money amounts stay in your vendor deposit tracker. This tab holds only the date and who owns it.

Hotel dates are easy to miss. Our guide to attrition and release dates in a room block explains what each one means.

How to fill it in, in order

Work from the top tab down, and let the status board tell you what is left. Treat the sheet like any corporate event planning template: change the yellow cells and leave the grey ones.

1. Make your own copy, then clear the sample rows marked EXAMPLE. The list of ranges to clear is on the Setup and status tab.
2. Enter the headcount, dates, confirmed bedrooms, people per bedroom and seats per vehicle on Setup and status.
3. Send one short attendee form, with the wording from our team offsite invitation email, and paste the answers into People.
4. Fill in Arrivals and transfers, then name an owner for each pickup wave.
5. List each room on Rooming, typing occupants exactly as their names appear in People, and read the bedroom check.
6. Enter every date from the signed contracts on Key dates, each with an owner.
7. Review the status board once a week, and clear every open item before you send anything to a supplier.

Travelers need to hear all of this too. Our attendee traveler guide gives you wording to send.

Worked example: a team retreat a short drive from the home city

Here is how the sheet reads for a made-up team retreat. It is an illustration only, with no real venue, no named city and placeholder times.

The team has 40 people. Twenty-four leave the home office by coach, six drive, and ten fly in from two other US offices.

The retreat runs two nights at a venue a short drive from the home city. The venue confirmed 22 private bedrooms, with two people per bedroom.

The six drivers need no pickup, so they appear only on People. The 24 coach riders fill two vehicles of 14 seats. Each fly-in wave gets one vehicle and one named owner.

On Rooming, 40 people at two per bedroom need 20 bedrooms. The venue confirmed 22, and the sheet lists 20 rooms, so the bedroom check reads OK.

Now say the headcount grows to 46. Change cell B6, and the headcount check reads SHORT, because 46 people need 23 bedrooms and the venue confirmed 22.

The People check also shows six people still to add. You see the gap before the rooming list is due, not at check-in.

Sharing the sheet with the venue, the planner and Finance

Keep one live sheet and share view-only links. Do not email copies, because the venue ends up working from an old one.

• Venue: Rooming and the arrival times from Arrivals and transfers.
• Transport provider: the pickup groups and the departure groups.
• Finance: Key dates, next to the budget sheet for Finance.
• Your planner or team: Setup and status, so everyone sees the same open items.

Never share the People tab itself. Dietary, accessibility and emergency contact details go only to the supplier who needs them.

The "who owns what" decision sheet in our guide on how to plan a staff retreat helps you name the owners.

When a local planner helps

A local planner helps most when the team travels. Someone who knows the destination can build the transfers, match rooms to the venue and chase the contract dates while you run the rest of the event.

Vantly works across the US with more than 1,000 local planners.

Tell us the dates, headcount, region and needs for your company offsite, corporate retreat, sales kickoff or incentive trip. Cutoffs, transfer times and terms vary by venue and supplier, so confirm each in writing.

Vantly matches that brief with a local planner, who produces a turnkey event proposal with prices. We send it within 48 hours, at no cost. Any price still waiting on a vendor's confirmation is marked as an estimate.

From there, your local planner handles the venues and vendors, and you deal only with Vantly instead of many small vendors, with clear, structured invoices that are easy to reconcile.

Get a custom quote

You can also browse sample events, which a planner tailors to your team, or find a local planner.

Frequently asked questions

How do I make an event planning spreadsheet?

Start with one tab for the basics and the headcount, then add a People tab with one row per person. For an event away from home, add arrivals, rooming and key dates. Our template has all five tabs.

Does Google Sheets have an event planning template?

For an offsite where people travel in, copy the sheet. It adds transfers, rooming and key contract dates on top of the basics.

What should an event planning spreadsheet include?

A headcount, a people list, travel details, rooming and the dates that matter. For an offsite, add a pickup group for each arrival wave and a check of rooms against confirmed bedrooms. Keep amounts in your deposit tracker.

How do you organize airport transfers for a group?

Group arrivals by hub and time window, then request vehicles sized to each group. Name one owner per wave and write one late-arrival rule. The Arrivals and transfers tab does the grouping and counts the vehicles for you.

What is a rooming list?

A rooming list shows who sleeps in which room, with check-in and check-out dates. The venue or hotel usually needs the final version by a cutoff date in the contract. Our Rooming tab also checks it against the confirmed bedrooms.

Is there a company retreat planning spreadsheet I can copy?

Yes. Make a copy of the Google Sheet. It is built for a company retreat away from the home city, with sample rows you clear before you start.

Can I use it for a day event in town?

Yes, in a lighter way. Keep the Setup and status, People and Key dates tabs, and ignore Arrivals and transfers and Rooming. You still get the headcount check and the contract dates, without the travel layer.

Should a planner run the sheet?

You can run it yourself, or a local planner can keep it current while you focus on the program. Share the dates, headcount and region with Vantly, and we confirm whether a suitable local planner is available.

Related guides

• Offsite agenda template
• First-time EA company offsite checklist
• Event vendor deposit tracker
• Company offsite budget sheet for Finance
• How to plan a staff retreat
• Group transport for company offsites
• Hotel attrition and release dates in a room block

• 
• 
• 
• 

Hand all of this to a local planner

Send your dates, rough headcount and where your team is based. We match your brief with a planner who books that region, and they send back a turnkey proposal with prices.

Get my retreat proposal

Free, personalized initial proposal within 48 hours. No commitment.