Written by

The Conference Planning Calendar Every Event Manager Needs [Free Template]

The Ultimate Conference Schedule Template and Tutorial

You’ve got 7 speakers, 5 rooms, and 3 different session tracks over 2 days. You’re huddled around a bulletin board with your team pinning notecards to a scheduling idea you pulled off Pinterest.

Sound familiar? The problem is: once you get your schedule straight, how do you communicate it to your third party vendors or team members (especially when you need to make last minute changes)? Time to hit Excel.

Luckily, we’ve designed a nice-looking, easy-to-read spreadsheet to keep your session details, speaker information, and other presentation logistics organized and ready to share. We’ve also put together a tutorial for you so you know how to use the template.

Download the Conference Schedule Template

The first step is to download the template by filling out your information below and clicking “Download Now”:



Got it? Good! Now let’s learn how we can use the template to plan our next conference…

How to Use Your Conference Planning Calendar Template

Once you open up the conference planning calendar template, you’ll notice two tabs at the bottom of the Excel spreadsheet. The first, titled “Example Conference Schedule,” is already filled out for a conference we’ll call CadCon 2020. We pre-filled the data in this sheet to give you an idea of how your final calendar should look.

There are two tabs at the bottom of the conference schedule example. Click the one that says 'Conference Schedule Template' to begin planning your next event!

Each row represents a particular session and each column represents a different piece of data that you need to know for that session. These include basic speaker details, different track names and sessions types, presentation titles and the rooms where they will be presented, and learning objectives so your attendees will know what to expect.

If you click over to the second tab, entitled “Conference Schedule Template,” you’ll see the same spreadsheet with blank data. Click this now and let’s get started planning.

Basic Event Details

The first thing you need to do when planning your event is come up with some basic ideas about your event’s structure. Will it be a one day event? A multi-day event? How many sessions can you realistically fit into a day? Does it make sense to have multiple tracks with simultaneous sessions that attendees can choose from?

For the purposes of this tutorial, we’ll use the conference schedule template to plan a three day event with 7 sessions each day. The light rows on the calendar represent each session whereas the dark rows break up each day for visual purposes. No data should be entered in these dark rows.

Note: The schedule can be manipulated to meet your needs by adding or removing rows. If you need an additional session on any given day, simply insert another light grey row.

Now, let’s add in our basic event details.

Event Name

Enter your event name into B3. Copy this name, select the remaining rows in the lighter gray B columns, and paste.

Enter your event name into cell B3 on the conference schedule template then copy this into the remaining rows in the B column.

Event Date

The N column is highlighted with the darker grey color. This is because it represents each day of your event. For a three day event like ours, we simply add the first day into cells N3-N9, the second day into cells N11-N17, and the third day into cells N19-N25.

The 'N' column is highlighted with a darker grey color because it represents each day of your event. There is also a darker grey row separating each day.

Sessions, Speakers, and Presentations

Great! We’re off to a good start. The next thing we need to do is to fill in our 7 sessions. A session can be a presentation, a workshop, lunch, a panel, exhibition hours, or just about anything else.

For this section we’ll focus on Track Name, Session Type, Session Number, Presentation Title, Start Time, End Time, and Room.

Alright, let’s get started.

Session Types & Session Numbers

You can fill these cells out in any order, but I like to start with Session Type because it helps me formulate a basic layout of the day in my head. K3 will kick the day off with an opening session, which I’ll number ‘101’ in cell L3, a lecture will follow after, then a panel and lunch. I’ll continue numbering these in an ascending order (you can number your sessions with whatever convention you’d like).

Columns K and L represent your different session types and numbers. This is usually a good place to start to understand an overhead view of your conference. You can plan your different keynotes, panels, and workshops, while indicating breaks or lunches.

After lunch there will be two simultaneous sessions, a workshop and a panel. For these I’ll number them ‘105A’ and ‘105B.’ Finally, I want to end the day with a trade show and cocktail hours in the expo hall.

I will repeat a similar schedule for days 2 and 3.

Speaker Details

The next thing you want to add is your speaker details. At this point in the planning process you should have chosen your speakers and collected most of their basic details. If you haven’t done this yet, go here to learn how to streamline the speaker management process before you get started.

The next step after determining your session types is to fill out your speaker or presenter details.

This is pretty straight forward. You probably have in mind who you want to be keynotes, who you want as panelists, and who will be part of the lectures and workshops. Simply plug their First Name, Last Name, Email Address, Position, Organization, Biography, and Presentation Role into columns B-I in the light grey cells.

For certain session types, like Lunch or Expo Hours, simply leave these details blank in that particular row.

Presentation Titles & Descriptions

The remaining columns, M and Q-U, will hold information relevant to the actual presentations the speakers will be giving. Now that you have your speaker information added, simply plug in their presentations, session descriptions, and learning objectives and voila! you’ve completed your schedule.

Next Steps?

Now that you’ve got all your event data entered into the conference planning calendar, you can send it off to your program guide printer so they can make a hard copy of your schedule for your attendees, or you can import the data to your conference app or conference website.

The important thing is you now have a way to plan your conference schedule in a clear, well-organized document that can be shared with your own meeting planning team as well as third party vendors.

About Michael Doane

Michael Doane is head of marketing at CadmiumCD. He is focused on educating event planners about the benefits of implementing technology at their trade shows and conferences. Download his free eBook, “The Most Influential Advances in Event Technology“, then connect with him on LinkedIn or Twitter.

3 Responses to " The Conference Planning Calendar Every Event Manager Needs [Free Template] "

  1. […] can also be useful to plan and schedule your sessions, but again, not ideal. Event Tech allows you to plan and build a schedule around the content […]

  2. […] If you’re not quite ready to jump into big software platforms yet, no worries. We put together a simple Excel sheet for you to organize your conference schedule. You can download it here. […]

  3. […] the sheet that you’ve typed the formula into. But you can also use it to look up information from another sheet in the same […]

Leave a Reply

%d bloggers like this: