Guide · Events and stages
Run of show template: type each item and its minutes, get the clock times for Google Sheets, Excel or print
By Blink Brief · Updated · How pages are made
Type the start time and one line per item in the builder below (minutes, what happens, who): it works out every start and end time as you type. Copy for Sheets or Excel puts the table on your clipboard to paste into a spreadsheet, Download CSV saves it as a file, and Print or save as PDF prints it with a Notes column for the stage. Change one number and every later time moves with it.
Build the run of show
The example is a conference morning that starts at 9:00 AM. Replace its lines with yours: one line per item, with the minutes first, then what happens, then who runs it or who speaks.
Build a run of show from minutes
Put commas between the three, or paste rows copied from a spreadsheet. Change a number and every time after it moves. What you type is read in this browser tab and never uploaded; close the tab and it’s gone.
| Start | End | Min | Item | Who |
|---|
This builder needs JavaScript. Without it, in Google Sheets or Excel:
- Head five columns Start, End, Min, Item and Who, and type one item per row with its minutes in Min.
- Type the start time in the first Start cell, such as 9:00 AM.
- In the first End cell enter =A2+C2/1440, and in the next Start cell enter =B2.
- Copy both formulas down the rows, and format the Start and End columns as time.
- Minutes first. “20, Talk: lessons from year one, Priya Raman” is 20 minutes. Rows pasted from a spreadsheet work too, with the minutes in a column of their own.
- Changeovers and breaks are items. Give each its own line (“5, Changeover”), so the times after it stay true.
- A cue with no length takes 0 minutes: “0, Doors close”.
- 12-hour or 24-hour: choose under Clock. An event that runs past midnight shows “(+1 day)” beside the time.
The line above the table gives the count, the total length and the first and last time, such as “9 items · 2 h 20 min · 9:00 AM to 11:20 AM”: the fastest check that the programme fits the room booking.
What a run of show holds
Asana’s template page says a run-of-show template “gives you a well-defined, minute-by-minute breakdown of your event day”, in a format that “works for in-person conferences, hybrid events, webinars, podcasts, and live streams”. The builder gives you the five columns every run of show starts from:
- Start and End: the clock time each item begins and finishes.
- Min: its length in minutes.
- Item: what happens.
- Who: the speaker, or the person who runs it.
Once the table is in a spreadsheet, add the columns your team works from. Asana’s example layout has sections for “Event Information, Detailed Timeline, Content and Speakers, Technical Details, Vendor and Logistics, and Contingency Plans”; in a sheet those become columns such as Slides, Microphone, Lighting and Notes.
Paste it into Google Sheets or Excel
- Press Copy for Sheets or Excel. The table goes to the clipboard with a header row and a tab between the columns, the form a spreadsheet reads as cells.
- Open an empty sheet in Google Sheets or Excel and click cell A1.
- Paste. Start, End, Min, Item and Who fill columns A to E, one item per row.
Download CSV saves the same table as run-of-show.csv, a file both apps open. Share the sheet with the team, and when the programme changes, change the minutes here and copy again.
Print it for the stage
Print or save as PDF opens your browser’s print window with only the run of show on the page: a title line with the total length and the first and last time, then Start, End, Min, Item, Who and an empty Notes column to write cues in. Choose Letter or A4, portrait; “Save as PDF” in the same window makes a file to email. One copy each for the host, the stage manager and the sound desk.
Run the day from it
The run of show says when each item ends; a countdown the speaker can see is what holds it there. Open the free Stage Timer on a laptop or tablet facing the stage, set the item’s minutes and press Start: the time turns amber at 2 minutes, red at zero, and then counts up the overtime, so the host knows how much to recover.
- An item ran over: change its minutes in the builder and read the new times for the rest of the day.
- Speakers in a meeting app: Zoom, Teams and Google Meet each have a guide.
- Speeches with green, yellow and red signals: the speech timer with a log.
Weddings and church services
- A wedding: the wedding run of show starts from a reception timeline, cocktail hour to send-off.
- A church service: a countdown before the service, for the minutes before it starts.
Questions
What is a run of show?
The schedule the people running an event work from: every item in order, with its start time, its length and who is responsible. Asana's template page says a run-of-show template "gives you a well-defined, minute-by-minute breakdown of your event day".
Is there a run of show template for Google Sheets or Excel?
Build it on this page and paste it in: type the start time and one line per item, press Copy for Sheets or Excel, click cell A1 of an empty sheet and paste. The five columns (Start, End, Min, Item, Who) land in five columns. Download CSV gives the same table as a file both apps open.
How do I make a run of show?
List every item in order with the minutes it takes, changeovers and breaks included, and name who runs each one. Give the builder on this page the start time and it works out each start and end. Then add the columns your team needs in the sheet, such as cues for sound and slides.
What happens to the run of show when one item runs long?
Change that item's minutes in the builder and every later start and end time moves with it. During the event, a countdown the speaker can see keeps each item to its minutes: the free Stage Timer turns amber at 2 minutes and red at zero.
Sources
- Asana: Run-of-show template: what a run of show is, and the sections of its example. Read on 19 November 2026.