# Court booking sheet Excel (padel, football) free

> Free Excel sheet to book padel, football and tennis courts by the hour: peak pricing, overlap alerts, daily grid, occupancy per court and hour, revenue.

Source: https://softwiro.com/blog/sports-court-booking-free-excel-online.html
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Padel and five-a-side court booking sheet in Excel (free)

Book courts by the hour without overlaps, price peak hours automatically and see which court and hour are empty.

13 November 2026 5 min read

## In short

- Give each court a normal and a peak hourly price with the peak window; the price of each booking is worked out from those hours.
- Two bookings that overlap on the same court show "overlap" in red, and cancelled bookings are ignored.
- The daily grid shows courts by hour with the customer's name in each booked hour.
- Occupancy is shown per court, per hour and per part of the day, with revenue, balances and top customers, in a summary with four charts.

You rent padel, five-a-side football or tennis courts by the hour and want three things: never to sell the same hour twice, to have the price worked out by peak hours, and to see which court and which hour are empty so you can fill them. The free [padel and five-a-side court booking sheet](https://softwiro.com/templates/sports-court-booking) does it from two things you type: your courts with their prices, and your bookings.

## The problem it solves

Hourly booking repeats hundreds of times a month, and each mistake means a crowded court or a wasted hour. A player calls and hears "seven o'clock is free" while it is booked in another notebook. Someone forgets that 19:00 costs more than 10:00 and prices it wrong. Nobody knows the occupancy of the courts or who still owes money. The sheet writes "overlap" in red when two bookings clash, prices each booking from the court's own rules, and shows occupancy.

## How it works, step by step

1. In الإعدادات (Settings) type the day you want scheduled, any date inside the month you want summarised, and the opening hour (8, say) and closing hour (24 for midnight).
2. In الملاعب (Courts) write each court, its type, the normal hourly price, the peak hourly price and the peak start and end hours.
3. In العملاء (Customers) write the customer or team and phone so they appear in the pick list.
4. In الحجوزات (Bookings) record each booking: date, court, start hour (a number like 18), number of hours, customer, discount, deposit, paid and status.
5. Read the تنبيه (Alert) column: "overlap" for two clashing bookings, and "outside hours" for a booking that starts before opening or ends after closing.
6. Open الجدول اليومي (Daily grid) and الملخص (Summary) to read occupancy and revenue.

The core rules: **price = peak hours × peak price + other hours × normal price**, **due = price − discount**, **balance = due − paid**, and **occupancy = booked hours ÷ (courts × days in the month × daily opening hours)**.

## What each sheet does

- الملاعب (Courts): the pricing rules of each court, with the month's bookings, hours, revenue and occupancy.
- العملاء (Customers): each customer's bookings, hours, amount due, balance, no-shows and rank.
- الحجوزات (Bookings): price, peak hours, end time, amount due, balance and alert on every row.
- الجدول اليومي (Daily grid): courts in rows, hours in columns, the customer's name in each cell, overlaps in red.
- الملخص (Summary): the month's numbers, revenue per court, occupancy per hour and per part of the day, revenue for six months, and the top five customers.

## A walk-through with the sample numbers

These figures are sample data inside the sheet, not a real club: five courts (Padel 1, Padel 2, Five-a-side A, Five-a-side B, Tennis 1) and bookings in October 2026; the examples look at October.

- A 19:00 booking for two hours on Padel 1: both hours are peak (18 to 24), so the price is 2 × 450 = 900.
- A 17:00 booking for two hours on Padel 2: only one hour is peak, so 300 + 450 = 750.
- The 10 October 18:00 booking on Padel 1: the price is 900 and the customer paid a 200 deposit, so the balance is 700.
- Tennis at 16:00 for two hours: peak starts at 17, so 200 + 300 = 500.
- An overlap: on 24 October one booking on Padel 2 runs 19 to 21 and another 20 to 21, so both show "overlap".
- A no-show: a Five-a-side A booking on 15 October is priced 600 with a 200 deposit, so only 200 is due. The cancelled Padel 1 booking on 21 October has nothing due.
- The daily grid for 10 October: on Padel 1 Kareem Hassan appears at 9 and Youssef Nasser at 18 and 19, so it has 3 booked hours, 18.75% of 16.
- October summary: 146 bookings (cancelled excluded) and 221 hours, so occupancy is 8.9% of 2,480 available hours (5 courts × 31 days × 16 hours). Revenue is 97,250, collected 93,500 and the balance owed by the month's customers 3,750. The highest-earning court is Five-a-side A at 26,000, and the busiest hour is 20:00 with 50 court-hours.

## Common mistakes

- Typing the court with different letters: choose it from the list, otherwise it shows "court not found" and no price is calculated.
- Typing the start time as text like "6 pm": type a number (18) and the hours as a number.
- Forgetting the peak hours in Courts: if they are blank, every hour is treated as normal.
- Leaving a cancelled booking as "confirmed": it holds the hour and shows a balance. Choose "cancelled".
- Reading occupancy without checking opening hours: change the opening and closing hours in Settings to match yours.

## When the sheet is not enough

It suits one centre where one or two staff type the bookings. If you want players to book for themselves, pay the deposit online, get a reminder message, or have several staff working at once, Softwiro can [build you a program around your way of working](https://softwiro.com/contact). If you follow your own matches and training, see the [tennis and padel match log](https://softwiro.com/templates/tennis-padel-match-log), and for gym subscriptions the [gym memberships sheet](https://softwiro.com/templates/gym-memberships).

## Your next step

[Open the template page and try it online or download the Excel file](https://softwiro.com/templates/sports-court-booking), clear the samples, type your courts and peak prices, then log tomorrow's bookings and look at the daily grid.

## Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

[![Cheat sheet: hourly court booking (1/3)](https://softwiro.com/uploads/cheatsheets/sports-court-booking/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/sports-court-booking/en-1.jpg)[![Cheat sheet: hourly court booking (2/3)](https://softwiro.com/uploads/cheatsheets/sports-court-booking/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/sports-court-booking/en-2.jpg)[![Cheat sheet: hourly court booking (3/3)](https://softwiro.com/uploads/cheatsheets/sports-court-booking/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/sports-court-booking/en-3.jpg)

0 downloads · 3 pages

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| One file that one person edits at a time, and copies travel by WhatsApp. | A program with a login for each user and permissions you set; everyone sees the same data live. |
| You type and check every number by hand, and one wrong cell breaks the result. | Screens built around your steps: each person records only their part, and the calculations run on their own. |
| Limited size; the file slows down as the data grows. | Holds years of data without slowing down, with instant search and filters. |
| Fixed columns and reports, as the sheet was designed. | Reports, alerts, printing and WhatsApp built around how you work. |
| Backups and security are your own responsibility. | A secured server with automatic backups and a log of who changed what and when. |

### Extra features in the app

- A login for each user with permissions, and a log of who changed what and when
- Automatic reminders and alerts by WhatsApp and email
- Photos, files and documents kept with each record
- Instant search and filters, with reports exported to PDF and Excel
- Works from a phone anywhere, with automatic backups

[Ask for your custom system](https://softwiro.com/contact)

## Questions this raises

### How does the sheet price peak hours?

It counts the booked hours that fall inside the court's peak window; price = peak hours × peak price + other hours × normal price.

### How does it detect two overlapping bookings on a court?

It compares the non-cancelled bookings on the same date and court; if one starts before another ends and ends after it starts, both show "overlap" in red.

### How do I record a team or academy that books every week?

Copy the booking row, make the new date = the date + 7, and choose the type "weekly fixed" so its revenue shows separately in the summary.

### What happens when a customer does not show up?

Choose "no-show": the amount due becomes the deposit you keep, and the hour still counts in occupancy. "Cancelled" has nothing due and no occupancy.

### How many rows does the sheet hold?

30 courts, 200 customers and 2000 bookings; the daily grid shows the first 12 courts.

## Have a system to build?

Softwiro designs, builds, and operates production systems. Describe what you need and we will come back with a scope rather than a slogan.

Start a project

[All writing](https://softwiro.com/blog.html)
