Anyone who plays tennis or padel regularly knows that the impression after a match is not enough: do you really win on clay, or do you only remember the wins? And how often did you convert the break points you got? The free tennis and padel match log sheet records each match in one row and works out your win rates, serve figures, recent form and record against each opponent, so you can see your level on one page.
The problem it solves
When you keep your results in your head or in group chats, you know the result of your last match but not the trend: are you improving or slipping, which surface do you win on, do you always lose to the same player. Here you write the match once and the sheet works out the rest and summarises it by surface, tournament level and opponent.
Steps from opening the file to the summary
- Settings: write your name and choose the sport (tennis or padel), then the surfaces, the tournaments with the level of each (friendly, local, regional or national), and the names of your regular opponents (up to 15).
- Matches: log each match in a row, in date order from oldest to newest: date, tournament, opponent, surface and round.
- Write the sets you won and lost and the total games for and against you, then aces, double faults and first-serve percentage.
- Write the break points you won and the ones you had, and the duration in minutes. The result (win or loss) and the tournament level are worked out by themselves.
- Open Summary to find the win rates, serve averages, form over the last 10 matches, longest winning streak and the head-to-head table against opponents.
- Check the Alert column in "Matches": it shows if you typed a number that does not add up, such as more break points won than available.
Worked example (sample data)
The name and figures below are sample data for an example player with 26 matches logged between 5 March and 30 June 2026:
- Overall: 26 matches, 14 won and 12 lost, so a win rate of 53.8%. Sets: 35 won and 32 lost (52.2%). Games: 329 won and 296 lost (52.6%).
- By surface: indoor 5 wins from 6 (83.3%), hard 4 from 6 (66.7%), grass 4 from 8 (50%), and clay one win from 6 (16.7%). So clay is this player's weak spot in the sample.
- By tournament level: friendly 3 from 5 (60%), local 5 from 12 (41.7%), regional 2 from 4 (50%), national 4 from 5 (80%).
- Serve: an average of 4.96 aces per match, 3.42 double faults, and a first-serve percentage of 59.8%.
- Break points: 110 won out of 190 available, a conversion of 57.9%.
- Duration: 2,729 minutes in total, an average of 105 minutes per match.
- Streaks and last 10 matches: longest winning streak 4 and current streak 1. In the last 10 matches the player won 4 and lost 6, which is 40%.
- Head to head: against "Amr (sample)" 5 matches, 4 won, game difference +19. Against "Hesham (sample)" 5 matches, 2 won, game difference −5. Against "Mustafa (sample)" one match, lost.
- Opponent not listed: one match against an opponent not written in "Settings"; it counts in every total but does not appear in the head-to-head table.
How the numbers are worked out
- Result: a win if your sets are more than your opponent's, a loss if fewer.
- Win rate = wins ÷ matches logged. For example 14 ÷ 26 = 53.8%.
- Break-point conversion = points won ÷ points available. For example 110 ÷ 190 = 57.9%.
- Sets share = your sets ÷ (your sets + opponent's sets). The games share works the same way.
- First-serve percentage is the average of the percentages you typed for the matches, in a form such as 62%.
Limits and tips
- Log matches from oldest to newest and leave no empty row between them, because the winning streak and the last-10 form depend on the order.
- A row without sets is not counted in anything. If the sets are equal, "Alert" says the sets are equal and no result is given.
- Write opponent and tournament names exactly as they are in "Settings", and add them to the list before you type them. Do not delete a row from the middle of any list.
- In padel you may not record aces and double faults; leave those cells empty and they stay out of the averages.
- The sheet is for one player and holds 400 matches, five surfaces, eight tournaments and 15 opponents.
- It is for personal tracking, not a technical assessment or coaching advice, and it does not replace your coach's opinion. It does not record points live, send alerts or book courts.
Try it
Open the sheet and try it online, or download it as Excel. If you want an app for a club or academy with player results, rankings and court booking, request it here.





