# Restaurant table reservations Excel (free) + online

> Free Excel sheet for restaurant and cafe table bookings: clash and capacity alerts, half-hour evening grid, covers per day, no-show rate and deposits held.

Source: https://softwiro.com/blog/restaurant-table-reservations-free-excel-online.html
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Restaurant table reservations in Excel (free): clash alerts, evening grid and no-show rate

One workbook for tables, reservations with deposits, an evening grid by half-hour, covers per day and repeat customers.

13 November 2026 6 min read

## In short

- Each reservation is typed once; its end time, seats, area and minimum charge come from the table list.
- Two live reservations on one table at overlapping times are flagged red, and a party bigger than its table is flagged over capacity.
- An evening grid of tables by half-hour slot shows who booked, with guests and busy tables under each slot.
- Covers per day, no-show and cancellation rates, deposits held, and a repeat-customer list with visits and last visit.

You run a restaurant or cafe that takes bookings by phone and WhatsApp, and you want to know before the doors open: which table is free in which half hour, whether a table was booked for two customers at once, whether a party is bigger than its table, how many guests to expect tonight, how much deposit you are holding, and which customers keep coming back. The free [restaurant and cafe table reservations sheet](https://softwiro.com/templates/restaurant-table-reservations) (the page is in Arabic) puts all of it in one file, in Excel or online.

## The problem it solves

A paper booking diary does not warn you when you write two bookings on one table, does not tell you how many customers failed to show this month, and does not rank who booked more than once. When the evening fills up you flip pages looking for a table for six after nine. Here each booking is typed once and shows up in the evening grid and in the month's numbers.

## Steps, from opening the file to the report

1. Settings: enter the venue name, the date of the evening you want to see, the start of the first slot (for example 18:00) and the first day of the month for the summary.
2. Tables: each table's number, area (inside, outside or VIP), seats and minimum charge.
3. Reservations: date, time, duration in hours, guests, table (from a list), customer name, phone, occasion and deposit.
4. Status: "مؤكد" (confirmed) when booked, then "حضر" (attended) or "لم يحضر" (no-show) after the time, or "ألغى" (cancelled).
5. Check the alerts: the capacity and clash columns in the reservations sheet.
6. Evening grid, repeat customers and Summary: these are calculated for you.

## What each sheet holds

In "الحجوزات" (Reservations) the sheet works out each booking's end time from its time and duration, writes "فوق السعة" (over capacity) when guests exceed the table's seats, and writes "تعارض" (clash) in red when another non-cancelled booking on the same table overlaps in time. A booking starting the moment another ends is not a clash, and cancelled or no-show bookings are ignored.

"جدول السهرة" (Evening grid) has tables in the rows and twelve half-hour slots in the columns for the chosen date: a cell turns green with the customer's name in each booked slot, and red with ⚠ if the slot is booked twice. Below it are the guests and booked tables in each slot. "العملاء المتكررون" (Repeat customers) lists those who reached the visit count you set, ranked by visits and then by latest visit.

## Walk-through on the sample numbers

The names and numbers below are sample data inside the sheet, not real people. The example has twelve tables and 35 reservations, the chosen month is November 2026 and the chosen evening is Friday 13 November:

- The month's statuses: 30 reservations in November: 11 attended, 14 confirmed, 3 no-shows and 2 cancelled.
- No-shows: 3 ÷ (11 + 3) = 21.4%, and cancellations 2 ÷ 30 = 6.7%.
- Guests: 49 guests attended, 64 are waiting in confirmed bookings, and the average non-cancelled party is 4.5 guests.
- The clash: table D3 is booked for "عمرو حسين" from 18:30 to 20:30 and for "أميرة جلال" from 20:00 to 22:00, so both rows show "تعارض" and the 20:00 slot in the evening grid shows ⚠.
- Capacity: "وليد منصور" booked five guests on table D2, which seats two, so the row shows "فوق السعة".
- Peak of the evening: at 20:30 there are 31 guests on 5 tables, and that figure includes both clashing bookings.
- Deposits: held for all confirmed bookings 2,300; this month's deposits of those who attended 1,500, of no-shows 250 and of cancellations 800. Whether to keep or refund a deposit is your policy with the customer.
- Repeat customers: six, the first being "شركة النور" with three visits and the latest on 12 November, then "عمرو حسين" with three, then "سارة عادل" with two visits and one no-show.

## Common mistakes

- Forgetting to change the status after the time: the booking stays "مؤكد" and is left out of the no-show rate and the customer's visits.
- Typing the duration in minutes: duration is in hours, so an hour and a half is 1.5.
- Typing a phone number in different forms: the sheet recognises a customer by phone, so write the number the same way every time.
- Leaving a cancelled booking as "مؤكد": it keeps holding the table and shows a clash. Change it to "ألغى".
- Counting a deposit as income: it is money paid in advance, deducted from the bill or handled by your policy, so do not add it to sales.

## When to move from a sheet to a system

A sheet suits one venue and one host taking bookings. If booking calls pile up, you want customers to book from a link that shows only the free times, or a reminder message before the booking to cut no-shows, ask for a [custom program from Softwiro](https://softwiro.com/request-sheet).

## Next step

Open the [template page](https://softwiro.com/templates/restaurant-table-reservations), download the sheet, clear the sample bookings, enter your tables and seats, then log tonight's bookings and open the Evening grid. If you also cost your dishes, try the [recipe costing sheet](https://softwiro.com/templates/restaurant-recipe-costing).

## 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: table reservations (1/3)](https://softwiro.com/uploads/cheatsheets/restaurant-table-reservations/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/restaurant-table-reservations/en-1.jpg)[![Cheat sheet: table reservations (2/3)](https://softwiro.com/uploads/cheatsheets/restaurant-table-reservations/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/restaurant-table-reservations/en-2.jpg)[![Cheat sheet: table reservations (3/3)](https://softwiro.com/uploads/cheatsheets/restaurant-table-reservations/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/restaurant-table-reservations/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 do I stop one table being booked for two customers at once?

Enter the booking time and duration; the sheet works out the end time and writes "تعارض" in red for any two non-cancelled bookings on the same table whose times overlap on the same day. A booking that starts when the first ends is not a clash.

### How do I calculate the no-show rate?

No-show rate = no-shows ÷ (attended + no-shows), counting only bookings whose time has passed. The sheet works it out for your chosen month and leaves out confirmed bookings not yet due and cancelled ones.

### What happens to the deposit if the customer does not come or cancels?

The Summary shows the deposit held for confirmed bookings, what is deducted from attendees' bills, the deposits of no-shows and of cancellations. Whether it is kept or refunded is your own policy with the customer, not a rule in the sheet.

### How do I find my repeat customers?

The sheet recognises a customer by phone number: every number with two or more visits (changeable in Settings) appears in the repeat-customer sheet with its visit count and last visit. A visit is a booking whose status you set to "حضر".

## 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)
