Free tool, no sign-up
Free tennis box league spreadsheet
The box league sheet every tennis club pins up, as a spreadsheet that works itself out. Type the names, choose whether each pair plays once or twice, pick each result from a drop-down in the grid, and the table sorts itself, with who goes up and who goes down. In Excel, Google Sheets or LibreOffice. Any box played as the best of three sets or games works the same way, in padel, badminton or pickleball.
An .xlsx file with 4 boxes of up to 8 players, a Settings tab and a Read me. Nothing to sign up for.
Box 1, with nine results in
Each result is picked once, above the dark diagonal. The other half fills itself in.
| No. | Player | Priya | Sam | Jo | Alex | Tom |
|---|---|---|---|---|---|---|
| 1 | Priya | 2-0 | 2-1 | 1-2 | 2-0 | |
| 2 | Sam | 0-2 | 2-1 | 2-0 | 0-2 | |
| 3 | Jo | 1-2 | 1-2 | 2-1 | 2-0 | |
| 4 | Alex | 2-1 | 0-2 | 1-2 | ||
| 5 | Tom | 0-2 | 2-0 | 0-2 |
Green is a win, amber a loss having won a set, red a loss. A typed score is refused: a result is one of 6 from the drop-down.
The table it works out
| Place | Player | Played | Won | Lost | Sets | Points | Moves |
|---|---|---|---|---|---|---|---|
| 1 | Priya | 4 | 3 | 1 | 7-3 | 11 | |
| 2 | Jo | 4 | 2 | 2 | 6-5 | 10 | |
| 3 | Sam | 4 | 2 | 2 | 4-5 | 8 | |
| 4 | Alex | 3 | 1 | 2 | 3-5 | 6 | |
| 5 | Tom | 3 | 1 | 2 | 2-4 | 5 | Down |
Points are 3 for a win, 2 for a loss having won a set and 1 for a loss in straight sets, the same as the box league rules template. Box 1 sends nobody up. Change all of it on the Settings tab.
What is in it
A results grid, a table that sorts itself, and the moves
- A results grid for each box. Names down the side and across the top, the way a box league sheet is always drawn.
- Results from a drop-down. 2-0, 2-1, 1-2, 0-2 or a walkover, and nothing else, so a mistyped score cannot break the table.
- Both halves of the grid. Pick the result once and the other player's side fills itself in, coloured green, amber or red.
- Once or twice, from a drop-down. Played twice, the half below the diagonal turns cream for the second match, and the table counts both.
- A table that sorts itself. Points, then the result between the players level, then set difference, with each player's matches left.
- Who goes up and who goes down, from the Settings tab, with a minimum number of matches to go up.
- Clayside's colours throughout, and every box prints on one page.
Would rather not use a spreadsheet at all? The Sheet is the same box league as a free page that works in a browser, even offline. For running the league itself, read box league spreadsheet template for your club.
Questions
What clubs ask about the box league spreadsheet
Does it work in Google Sheets?
Yes. Open Google Sheets, choose File, then Import, and upload the file. It works in Excel and LibreOffice as it is, drop-downs and colours included.
How do I put a score in?
Find the row player and the column player above the dark diagonal, and pick the result from the drop-down, from the row player's side: 2-0, 2-1, 1-2, 0-2 or a walkover. The same match below the diagonal fills itself in.
Can each pair play twice?
Yes. Each box has a drop-down beside its grid: Once or Twice. Played twice, both halves of the grid turn cream: the first match goes above the dark diagonal and the second below it, and the table counts both.
How many players can a box have?
Up to 8, in 4 boxes. A box of five uses the first five names. For more boxes, copy a Box tab, rename it, and change Boxes in use on the Settings tab.
How are players level on points separated?
By the result between them first. With three or more level, wins over each other count, then set difference, then the order the names were typed. The table does it for you.
Can I change the points?
Yes. The Settings tab has one number for a win, a loss having won a set, a loss in straight sets and a walkover lost, and how many go up and down from each box. Change them once and every box follows.
Can players put in their own scores?
Not in a spreadsheet, unless you share it with everybody and trust them all with every cell. That is the point where most clubs move to an app, where players enter and confirm their own scores and the table updates itself.
More free tools
More free tools for club organisers
Americano and mexicano generator
Partners, courts and who sits out for the whole evening, and a table that keeps itself. Free toolTennis round robin generator
A tennis round robin in singles, fixed pairs or with a new partner each round, in games or matches. Free toolPickleball round robin generator
A new partner every game, who sits out, and a points table for the session. Free toolTournament draw generator
A knockout draw with the seeds on the right lines and the byes where they belong. Free toolLadder spreadsheet
Log each challenge, and the ladder reorders itself and says what every result did. Free toolBox league rules template
Box league rules filled in for your club, ready to copy or print.Every free resource, templates and articles included