Excel template for a padel league: download it free and build the table
Setting the club league up in Excel is the first thing everyone does, and it makes sense: it's right there, it's free, and in one afternoon you've got the fixtures done. And it works. Up to a certain size it works really well. Here's our template, how to use it in five minutes, and then a straight answer on where it stops being enough.
Download it here
Four sheets: Pairs, Schedule, Results and Standings. The round robin schedule is already generated for 6, 8, 10 and 12 pairs.
Free, no sign-up and no email. Opens in Excel, Numbers and Google Sheets.
Related: How to run a padel tournament without Excel (and without the WhatsApp chaos) ·Round robins, Mexicano or elimination: which format to pick
What's in the template
Four sheets and nothing else. The less there is to touch, the less breaks halfway through the season.
Pairs
The league list: pair name, both players and a phone number or email. Whatever you type here is what shows up in the schedule and the standings, so get it right the first time and don't change it later.
Schedule
One tab per size: 6, 8, 10 and 12 pairs. The round robin is already split into rounds. With 6 pairs that's 15 matches over 5 rounds; with 8, 28 matches over 7 rounds; with 10, 45 over 9; with 12, 66 matches over 11 rounds. All you add is the dates.
Results
One row per match: round, pair A, pair B and the score by sets (6-3, 4-6, 10-8). You type the games and that's it. No need to mark the winner: the sheet works it out.
Standings
Points, played, won, lost, sets for and against, games for and against and both differences. All formulas: nothing gets typed in here, it fills itself as results come in.
How to use it in five minutes
Five steps. Do them in this order and the league is ready before your coffee goes cold.
1. Fill in the Pairs sheet
One name per row, starting at the first empty one and with no gaps in between: the formulas count consecutive rows and a gap throws the table off. Add a phone number for one of the two, you'll thank yourself later.
2. Open the tab for your size
If there are 8 pairs, use the Schedule 8 tab and delete the other three. If you're an odd number —7, 9 or 11— take the next even tab and name the last pair "Bye": whoever draws them sits that round out.
3. Spread the rounds across weeks
Put a date in each round's header. One match per pair per week is the pace people keep up without complaining. With 8 pairs that's 7 rounds, so nearly two months of league: check bank holidays before you lock the calendar in.
4. Enter the scores as you go
In the Results sheet, as matches finish. Do it the same day, because WhatsApp scores pile up and by round three you can't tell which was which. If a match gets postponed, leave the row empty: the standings only count what's been played.
5. Don't touch the standings
It recalculates every time you enter a result. If you start sorting it by hand or dragging rows around, you break the formulas and from then on the table lies to you. It's the number one mistake by a distance.
How the formulas work
You don't need to understand them to use it, but if you do you can adapt it to however your club runs things.
Points: 3, 1 and 0
Three points for a win, one for a loss you actually turned up for, zero for a no-show. It's the split that works best in club leagues: it rewards winning, but it also rewards showing up on a cold Tuesday in November and playing when you know you're going to lose. If you prefer 2-1-0, change the 3 in the points column formula and you're done.
Sets and games
The sheet reads each score, counts how many sets each pair won and adds up the games across all their matches. That's where the four sets and games columns come from, plus the two differences, which are what actually decide things when points are level.
Tiebreaks
The table sorts by points, then set difference, then game difference. Head-to-head isn't in the formula: if two pairs end up identical across all three, go to the Results sheet, see who won when they met and make the call. It happens once every three leagues, but it happens.
Tip: before the league starts, enter two dummy results and check the standings move the way you expect. Then delete them. One minute now saves you a mess in round 5.
Where it falls short
This template isn't a trick to get you downloading the app. It's a template that works. But there are seven specific situations where Excel stops helping and starts creating work, and it's only fair to spell them out:
| Situation | With Excel | With an app |
|---|---|---|
| More than 12 pairs | You extend the grid by hand. With 14 pairs that's 91 matches over 13 rounds: a whole afternoon of fixture juggling. | The schedule generates for any number, whether it's 14 pairs or 24. |
| Rescheduling a match | You change the date on your sheet and then message all four players on WhatsApp, one by one. | You change the date and all four get the notification. |
| Players seeing the standings | You resend the file or a screenshot after every round. And again when someone loses it. | A public link, always up to date, that they check whenever they want. |
| Players entering results | They send it on WhatsApp and you copy it across, same day if you're lucky. | Whoever just played enters it from their phone and you just confirm. |
| A withdrawal mid-league | You decide by hand what to do with the matches that pair already played and check row by row. | You pull the pair out and the table recalculates under the rule you pick. |
| Home and away | You duplicate the schedule, swap home and away and renumber the rounds by hand. | You tick home and away when you create the league. That's it. |
| The file shared over WhatsApp | Three versions end up doing the rounds and nobody knows which is the good one. A February classic. | One table in the cloud. There are no versions, there's one. |
The exact moment to make the jump
There's no need to drop Excel for the sake of it. There are three fairly clear signals, and when two show up at once the sheet is costing you more than it saves:
You go past 12 pairs
Beyond that the schedule stops fitting on one screen, the matches multiply and every change means checking dozens of rows.
The league runs longer than 6 weeks
The longer it runs, the more postponements, injuries and people dropping out halfway. A two-month league builds up changes that a spreadsheet handles badly.
You get more than 5 messages per round
If every week you get five "who are we playing?" and "how are we doing?", you're not running the league anymore: you're the league's search engine. More tabs won't fix that.
If two of the three sound familiar, it's worth looking athow FenixPlay handles league management before the next season starts, even if you finish this one in Excel.
The no-Excel alternative
When the template gets too small, the answer isn't a bigger template. You canset your padel league up straight in the app and do exactly the same job without writing a single formula:
Frequently asked questions
Conclusion
If it's your first league and there are eight pairs, the template is more than enough: download it, type the names in and go play. You don't need anything else, and anyone telling you otherwise is selling you something. The day you're fifteen pairs, the league runs three months and you're getting five messages a week, come back here. Excel isn't the enemy, it just has a ceiling, and it helps to know where it is before you hit it.
Run your league without fighting the spreadsheet
Download the template and start today. And when the league grows, move it to FenixPlay in five minutes.