Conference agenda template
A conference agenda fits neatly in a spreadsheet: one row per session, one column per detail. This template has the twelve columns AgendaKit imports, filled in with a made-up one-day event — Harbourline Dev Day on Friday 14 May 2027, with two tracks across three rooms — so you can see how each column is used before you replace it with your own program.
14 sample sessions · 12 columns · UTF-8 · opens in Excel, Google Sheets, Numbers or LibreOffice
What's in the sample
The sample day starts with registration and an opening keynote in the Main Hall, then runs a Frontend track and a Platform track in the Main Hall and Room B, with two longer hands-on workshops in the Workshop Lab. There is a lunch break, two panels with a moderator, and a closing social. Every name and session is fictional.
The columns
Keep the header row. Column names aren't case-sensitive and the order doesn't matter. If your own spreadsheet uses different names — “Session” instead of “title”, say — the column mapper lets you match them when you import, and it recognizes common alternatives on its own.
| Column | Needed? | Format | Example |
|---|---|---|---|
id | Optional | Any short text that stays the same for this session. When you import again, rows with the same id update the existing session instead of adding a new one. | hdd-04 |
title | Required | The session title as attendees should see it. | Accessible forms that people finish |
description | Optional | Plain text. Your spreadsheet adds the quotes needed when it contains commas. | Labels, error messages and focus order… |
date | Expected | YYYY-MM-DD, the local date at the venue. | 2027-05-14 |
start | Expected | HH:MM, 24-hour, in the event's time zone. | 10:15 |
end | Expected | HH:MM, 24-hour, later than start. | 11:00 |
room | Optional | The room name, spelled the same way on every row. | Room B |
track | Optional | One or more track names, separated by semicolons. | Frontend;Platform |
speakers | Optional | Names separated by semicolons. Add (moderator) or (host) after a name to set the role; no suffix means speaker. | Dana Whitfield (moderator);Wren Okafor |
type | Optional | One of: talk, workshop, panel, keynote, break, social, other. | panel |
tags | Optional | Short labels separated by semicolons. Attendees can filter by them. | accessibility;forms |
capacity | Optional | A free-text note shown with the session. | 24 seats, first come |
“Expected” means a session needs it to appear at the right time in the agenda. Rows whose times can't be read, or that end before they start, are shown as errors in the import preview and skipped. Speaker bios, titles, photos and links aren't part of the CSV — add them in the Speakers screen after importing.
A short sample
Here are the header and three rows from the template, as they look in a plain text editor:
id,title,description,date,start,end,room,track,speakers,type,tags,capacity
hdd-04,Accessible forms that people finish,"Labels, error messages and focus order: a practical checklist with before-and-after examples.",2027-05-14,10:15,11:00,Room B,Frontend,Tomás Lindqvist,talk,accessibility;forms,
hdd-05,Workshop: Your first offline web app,Bring a laptop with Node.js installed. We build a small service worker step by step.,2027-05-14,10:15,11:45,Workshop Lab,Frontend,Mei Tanaka;Jonas Brandt (host),workshop,pwa;hands-on,"24 seats, first come"
hdd-06,Panel: What we learned running on-call,"Three engineers compare rotas, runbooks and the alerts they deleted.",2027-05-14,11:15,12:00,Main Hall,Platform,Dana Whitfield (moderator);Wren Okafor;Sam Adeyemi,panel,operations;on-call,Notice the quotes around descriptions and capacity notes that contain commas, the semicolons between speakers and tags, and the (moderator) and (host) suffixes.
Spreadsheet tips
Keep dates and times as text
Spreadsheets like to “help” by turning 09:00 into 9:00:00 AM or2027-05-14 into 14/05/2027. Before you type, select the date, start and end columns and format them as plain text (in Google Sheets: Format › Number › Plain text; in Excel: Format Cells › Text). Always use the 24-hour clock: 14:30, not 2:30 PM.
Use the venue's local time
Enter every time as it will read on the clock at the venue, in the event's time zone. Don't convert times for remote speakers or viewers — the attendee agenda labels the time zone and has a “your time” toggle for people following from elsewhere. For a multi-day event, check the date column carefully on sessions near midnight.
Separate multiple values with semicolons
Commas separate columns, so use semicolons inside the track, speakers and tags columns:Frontend;Platform or Mei Tanaka;Jonas Brandt (host). Spell each room, track and speaker name exactly the same way on every row — “Room B” and “Rm B” would end up as two different rooms.
Save as CSV UTF-8
UTF-8 keeps accented names such as Lucía and Tomás intact. When you save:
- Excel: File › Save As, then choose “CSV UTF-8 (Comma delimited)”.
- Google Sheets: File › Download › Comma-separated values (.csv).
- Numbers: File › Export To › CSV, with text encoding set to Unicode (UTF-8).
- LibreOffice Calc: File › Save As › Text CSV, character set Unicode (UTF-8), field delimiter comma.
If accented letters look garbled when you open the template in Excel, import it with Data › From Text/CSV and pick UTF-8 as the file origin.
Importing it into AgendaKit
- Create a workspace and an event, and set the event's dates and time zone.
- Open the event's Import screen, choose CSV and select your file.
- Check the column mapping. Matching names are filled in for you; match any others by hand.
- Review the preview: new and changed sessions, rows with errors that will be skipped, and warnings for sessions that overlap in the same room.
- Apply the import, give each track a color, then add speaker photos and bios in the Speakers screen.
- Publish as Unlisted, check it on your phone, and switch to Public when you're ready.
Common mistakes
- An end time earlier than the start time, often from mixing up 12- and 24-hour times.
- Speakers separated by commas instead of semicolons. Use semicolons so each name becomes its own speaker.
- The same room typed two ways, creating a phantom room with half the sessions in it.
- Changing the
idof a session between imports, which adds a copy instead of updating it. - Saving in a spreadsheet's own format (.xlsx, .numbers, .ods) instead of CSV.
Ready to import your program?
Create a free workspace, add your event, and import the template to see it as a live agenda.