Tournament Schedule Template (Excel + Google Sheets) [2026]

A tournament schedule template is one grid: time slots down the rows, courts across the columns, one match in every cell.

That is the whole structure. Everything difficult about building it happens before you type a single team name.

I have built this grid by hand for events up to 406 teams, and it fails in exactly two places every time.

You get the slot count wrong, or you book a team onto two courts at once.

Both are arithmetic problems with arithmetic answers. Twelve teams in three groups of four is 23 matches and 12 slots on two courts — six hours at half-hour slots.

Below is the layout, the two formulas that keep the sheet honest, and the clash check that almost no downloadable template includes.

Key Takeaways

• A schedule template is slots down, courts across, one match per cell. Build it as rows, not as a picture.
• Never size a stage by matches divided by courts. Sum the per-round ceilings instead.
• Twelve teams in three groups of four is 23 matches and 12 slots on two courts, about six hours.
• Two formulas carry the sheet: a derived clock time, and a clash check that catches a team booked twice in one slot.
• A spreadsheet handles the plan fine. It does not handle a delay, which moves every later slot.

What Goes in a Tournament Schedule Template?

Six columns, and four of them you type.

• A — Slot number, starting at 1
• B — Court, pitch or table number
• C — Home team
• D — Away team
• E — Clock time, derived from the slot
• F — Clash flag, derived from A, B, C and D

Resist the urge to draw the grid visually, with courts as columns and slots as rows.

It looks like the thing you want to hand out. It also fights you at every step.

One row per match is what a spreadsheet is actually good at. You can sort it, filter it, count it and check it.

It is also the layout every round robin fixture list is published in, for the same reason.

The pretty grid comes later, from a pivot table, once the data underneath is known to be correct.

This is the same layout logic behind a bracket in Google Sheets: one row per fixture, nothing clever.

How Many Time Slots Will You Need?

This is where schedules go wrong, and it is always the same mistake.

You cannot divide total matches by court count. Rounds are sequential.

A knockout round cannot start before the round feeding it has finished. A round robin round cannot overlap itself, because a team would be on two courts at once.

So the honest number is the sum of the per-round ceilings. For each round, divide its matches by your court count and round up.

Take twelve teams in three groups of four. Each group plays three rounds of two matches, so every round across the stage is six matches.

Six matches on two courts is three slots. Three rounds, so nine slots for the group stage.

Six teams qualify. A knockout of six runs rounds of two, two and one, which is three more slots.

Twelve slots in total, about six hours. Flat division happens to give twelve here too, which is exactly why the error survives in the wild.

Change one input and it breaks. The same 23 matches on three courts is nine slots, not eight — because a round of six matches still needs two slots on three courts.

The per-format derivation is in the tournament schedule formula, and the match calculator runs it for any field from 4 to 64 teams.

Slot length is its own decision, and court allocation covers it. Match time plus five to ten minutes of turnover is the working rule.

How Do You Turn Slots Into Clock Times?

Never type a time twice. Put the start time and the slot length in two cells and derive everything else.

Start time goes in B1. Slot length in minutes goes in B2.

The first slot's clock time is simply `=$B$1`. Every slot after it is the one above plus the slot length:

=E2 + TIME(0, $B$2, 0)

Fill that down column E. Now when the first whistle slips twenty minutes, you change one cell and the whole day re-times itself.

That is also how the app models it: slot one anchors, and each later slot sits one duration after the last.

How Do You Catch a Team Booked on Two Courts at Once?

This is the check worth building, and it is the one I have never found in a template you can download.

Matches collide in two different ways, and each needs its own formula.

The first is a court collision: two matches in the same slot on the same court. Put this in a helper column.

=COUNTIFS($A$2:$A$500, $A2, $B$2:$B$500, $B2) > 1

The second is the collision that actually ruins a tournament: the same team in two matches in the same slot.

A team can sit in either the Home or the Away column, so you have to count both columns, for both teams in the row.

=IF($C2="", "", IF(MAX(COUNTIFS($A$2:$A$500,$A2,$C$2:$C$500,$C2) + COUNTIFS($A$2:$A$500,$A2,$D$2:$D$500,$C2), COUNTIFS($A$2:$A$500,$A2,$C$2:$C$500,$D2) + COUNTIFS($A$2:$A$500,$A2,$D$2:$D$500,$D2)) > 1, "CLASH", ""))

Put it in column F, fill it down, and conditionally format the word CLASH in red.

The empty-cell guard at the front is load-bearing. Without `IF($C2="", "", ...)` every blank row counts the other blank rows and flags itself.

The function behaves identically in both tools. Microsoft documents COUNTIFS and Google documents COUNTIF with the same argument order.

One honest warning. This flags a clash after you have made it. It does not stop you making one.

Where Does a Schedule Template Break?

Three places, and only one of them is about size.

A delay. Your sheet derives clock times from a single start cell, so one overrun means every later slot is wrong until you retype something. Catching up mid-event is a different problem from planning.

A format that feeds itself. Group tables, qualifiers and a knockout draw cannot be typed in advance, because you do not know who is in them. A spreadsheet needs a second pass at the halfway point.

Sharing. A link to a sheet is either read-only, in which case nobody can score, or editable, in which case anyone can delete a column.

Size matters least. The grid stays correct at 64 teams. It just takes longer to maintain than the tournament takes to run.

If your event runs across two days, note that one stage should not span midnight — splitting a tournament across two days explains why that is a stage boundary, not a formatting choice.

Frequently Asked Questions

What should a tournament schedule template include?

Six columns: slot number, court, home team, away team, a derived clock time, and a clash flag. Four are typed and two are formulas. Anything else — group names, referee, division — is optional and belongs to the right of those six.

How do you calculate how many time slots a tournament needs?

Sum the per-round ceilings, never total matches divided by courts. For each round, divide that round's matches by your court count and round up, then add the rounds together. Twelve teams in three groups of four is nine group slots plus three knockout slots on two courts.

Can you use the same template for a knockout bracket?

Yes, and you should. A knockout is just a schedule where later rows have blank team names until earlier results are in. Keep the one-row-per-match layout and add a round column. Drawing a visual bracket in cells is a separate job with separate formulas.

How do you stop a team being scheduled twice in the same slot?

Count every appearance of each team within that slot, across both the home and away columns, and flag any count above one. A single COUNTIFS pair does it. Guard the formula against empty rows or unfilled fixtures will flag themselves as clashes.

Is Excel or Google Sheets better for a tournament schedule?

Google Sheets, for one specific reason: a standings range wrapped in SORT re-ranks itself on every result, and you can share a read-only mirror without handing out edit access. Excel is better offline. Both run the same COUNTIFS clash check.

When should you stop using a schedule template?

When results need to reach people who are not sitting at your laptop. The grid is fine for planning any size of event. It stops working the moment twelve teams want to know who they play next and the only copy is a file on your machine.

Tournament Schedule Templates: Recap

• Build it as rows, not as a picture: slot, court, home, away, clock time, clash flag.
• Size the day by summing per-round ceilings. Matches divided by courts understates almost every schedule.
• Derive clock times from one start cell and one slot-length cell so a delay is a single edit.
• Add the team clash check. A template that lets you double-book a team silently is worse than no template.
• The grid handles the plan. It does not handle delays, qualifiers, or sharing results with people who are not you.

Once you have the slot count the plan is done, and the running is the hard part.

Tournamyx takes a team list and a court count, lays the fixtures out a round at a time, and publishes one public link spectators open with no account — so the sheet stops being the only copy. Free for events up to 8 players.