How to Make a Tournament Bracket in Excel (And When to Stop) [2026]

To make a tournament bracket in Excel: round your team count up to the next power of two, give each round its own column, and merge cells vertically so every round's boxes are twice as tall as the last. An 8-team bracket is 4 columns and 7 matches. Add one IF formula and winners advance themselves.

That takes about 20 minutes and works perfectly well. I have run events off a spreadsheet, and for a small knockout it is genuinely fine.

But there is a size where it stops being fine, and most organizers find it on match day. So this covers both: how to build it properly, and the four signs it is time to stop.

Key Takeaways

• Columns = rounds. An 8-team bracket needs 4 columns, a 16-team bracket 5 — that is ⌈log₂ n⌉ + 1.
• Auto-advance with =IF(D5>D6, B5, IF(D6>D5, B6, "")) — one formula, copied down.
• Byes are blank cells against the top seeds, never against random teams.
• Round robin standings need COUNTIFS and SUMPRODUCT — doable, but this is where sheets get fragile.
• Stop when you hit multiple courts, more than one division, live viewers, or a second person entering scores.

How Do You Build a Tournament Bracket in Excel?

Seven steps. These work identically in Excel and Google Sheets:

1. Size the bracket. Round your team count up to 4, 8, 16 or 32. Eleven teams means a 16-slot bracket, so you need 5 blank slots.
2. Set up the columns. Column B holds round one, D the quarter-finals, F the semi-finals, H the final. Leave C, E and G narrow for scores.
3. Type the seeds in bracket order. For 8 teams that is 1, 8, 4, 5, 3, 6, 2, 7 down the column — which produces the pairings 1v8, 4v5, 3v6 and 2v7.
4. Merge cells to build the ladder. Each round-two box spans the two round-one rows that feed it. Round three spans four rows, round four spans eight.
5. Add the borders. Bottom border on each team cell, right border on each pair. That is what makes a grid look like a bracket.
6. Add the auto-advance formula. In the round-two cell fed by rows 5 and 6, enter =IF(C5>C6, B5, IF(C6>C5, B6, "")) where B holds names and C holds scores. Copy it across every later round.
7. Lock the layout. Protect every cell except the score column, so nobody drags a team name into the wrong round at 9am.

The empty string in that formula matters. Without it, unplayed matches show FALSE all over the bracket and it looks broken on the projector.

Want to check your layout against a correct one? The free tournament bracket generator draws the same structure instantly, and you can copy the pairings straight into your sheet.

How Do You Handle Byes in a Spreadsheet Bracket?

Leave the cell blank and put the word BYE in it so nobody thinks you forgot a team.

The count is fixed: bracket size minus team count. Eleven teams in a 16-slot bracket is 5 byes, and they belong to seeds 1 to 5.

Then extend the formula so a bye advances automatically: =IF(B6="BYE", B5, IF(C5>C6, B5, IF(C6>C5, B6, ""))). Otherwise you have to type the name in by hand and the sheet loses its own audit trail.

The full rules on who gets byes and where they sit are in tournament brackets with byes — getting this wrong is the most common spreadsheet bracket mistake I see.

How Do You Build a Round Robin Schedule in Google Sheets?

Different job, harder sheet. A bracket is a ladder; a round robin is a table that has to recalculate every time a score changes.

Start with the fixtures. Six teams is 15 matches over 5 rounds, from n(n − 1) ÷ 2 — build the pairings with the circle method described in how to run a round robin tournament.

Lay results out as one row per match: home team, home score, away score, away team. Never as a grid — a grid cannot be summed cleanly.

Then the standings table needs three formulas per team:

• Played: =COUNTIF($A:$A, $H2) + COUNTIF($D:$D, $H2)
• Wins: =COUNTIFS($A:$A, $H2, $B:$B, ">"&$C:$C) plus the mirror for away matches
• Goal difference: =SUMIF($A:$A, $H2, $B:$B) − SUMIF($A:$A, $H2, $C:$C), again mirrored

Points are 3 × wins + draws. Sort on points, then goal difference, then goals scored — and here is the catch: Excel will not break a head-to-head tie for you. That rule needs a human, mid-tournament, with three captains watching.

If you would rather not write any of that, the round robin generator produces the fixtures and a live standings table in the browser, with nothing to save.

Where Do Spreadsheet Tournaments Break?

Not while you build them. They break on the day, and always in the same five places:

• A team withdraws. In a bracket you can patch it. In a round robin every already-played result against them is now disputed, and your formulas keep counting them.
• Two courts, one sheet. Spreadsheets have no concept of time or venue, so nothing stops you scheduling a team on two courts at once. You will only notice when both referees call for them.
• Two people editing. Google Sheets survives this; a file on a laptop does not. Somebody sorts a column while somebody else is typing and the standings silently detach from the names.
• Participants asking "when do we play?" A spreadsheet has no public view. So you become the public view, and you answer that question about 200 times.
• The three-way tie. Three teams on 6 points. Your sort ranks them by whatever column happens to be next, and no formula in the sheet knows your published tie-break rule.

None of these are Excel's fault. A spreadsheet is a calculator, and a tournament is a scheduling problem with live viewers — different tools.

When Should You Stop Using a Spreadsheet?

Four thresholds. Hit one and a sheet still works. Hit two and your day gets worse:

• More than one court. The moment matches run in parallel you are solving a scheduling problem, not filling a table.
• More than 16 teams. A 16-team group stage is 31 matches; 24 teams is 51. That is a lot of manual rows to keep correct while people are shouting.
• More than one division. Each division doubles the tabs and the chances of pasting a result into the wrong one.
• Anyone outside your desk needs to see it. Sponsors, parents, players. A shared sheet link is not a results page, and you should not hand edit access to 60 people.

Below all four, keep the spreadsheet — it is free and you already know it. Above them, the honest maths is that a 30-team event costs about 4 to 6 hours of manual scheduling and score chasing, which is worth more than any tool's monthly fee. What to look for is in free tournament management software.

Frequently Asked Questions

Does Excel have a tournament bracket template?

Yes. Open File then New and search "tournament bracket" — Microsoft ships several sizes. They are fine for a knockout, but none of them handle scheduling, standings or tie-breakers, so they only solve the drawing half of the job.

How do I make winners advance automatically in Excel?

Use =IF(C5>C6, B5, IF(C6>C5, B6, "")), where B holds team names and C holds scores. The final empty string keeps unplayed matches blank instead of showing FALSE. Copy the formula into every later round.

How many columns does a tournament bracket need?

One per round, plus one for the winner: ⌈log₂ n⌉ + 1. An 8-team bracket needs 4, a 16-team bracket 5, a 32-team bracket 6. Add narrow score columns between them.

Can Google Sheets run a round robin tournament?

It can, using COUNTIFS for wins and SUMIF for goal difference. It cannot resolve head-to-head tie-breaks, and it has no way to stop you double-booking a team across two courts. Both of those are decided by hand.

Is a spreadsheet good enough for a real tournament?

For a single-court knockout of 8 to 16 teams, yes — I have done it. Once you add a second court, a second division, or an audience that wants live results, the spreadsheet becomes the bottleneck rather than the tool.

How do I put byes into an Excel bracket?

Type BYE in the empty slots opposite your top seeds — as many as bracket size minus team count. Then wrap your advance formula in =IF(B6="BYE", B5, …) so those teams move forward without a score being entered.

Excel Brackets: Recap

• Round up to a power of two, one column per round, merge cells to double the height each round.
• Seed order for 8 teams is 1, 8, 4, 5, 3, 6, 2, 7 down the first column.
• One nested IF makes winners advance; add a BYE check for odd team counts.
• Round robin standings are possible with COUNTIFS and SUMIF, but head-to-head ties stay manual.
• Stop at two courts, 16+ teams, multiple divisions, or anyone outside your desk needing to see results.

Past that point, create a free tournament on Tournamyx Scores — paste the same team list, get a scheduled bracket, live standings and a public link your players can open without asking you anything. The rest of the planning is in the complete guide to organizing a tournament.