Softwiro
Free Excel template

Restaurant and cafe table reservations sheet

A free Excel sheet for restaurant or cafe table reservations. You enter your tables with their area (indoor, outdoor or VIP), number of seats and minimum spend, then log each reservation with its date, time, sitting length, number of guests, table, customer name and number, occasion and deposit. The sheet warns you if the same table is booked twice at overlapping times or if a party exceeds the seats, draws an evening grid of tables by half-hour, calculates guests per day, no-show rate and deposits held, and lists repeat customers with their number of visits and last visit.

Excel file (.xlsx) · 173 KB · 8 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

Example from the sheet

Example from the “الحجوزات” tab (Arabic), with the numbers and formulas that are in the file.
التاريخالوقتالمدة (ساعات)الضيوفالترابيزةالعميلالحالةالمقاعدالسعةتعارض
46298124D3عمرو حسينحضر4
46304122D1منى فؤادحضر2
46311126D5شركة النورحضر6
46318122O1سارة عادلحضر2
46325128V2كريم ممدوححضر10
46327124D3عمرو حسينحضر4
46328122D2هدى سالمحضر2
46329125O4سارة عادللم يحضر6

Example from the “الحجوزات” tab (Arabic), with the numbers and formulas that are in the file.

What is inside

  • الإعدادات: The venue name, the date of the evening you want to schedule, the start of the first slot in the grid, the first day of the month you want summarized, and the minimum number of visits for a customer to count as a repeat customer.
  • الترابيزات: Each table's number, area, seats and minimum spend, with the number of reservations on the selected date. Holds up to 30 tables.
  • الحجوزات: The reservations log: date, time, duration, guests, table, customer, phone, occasion, deposit and status (confirmed, attended, cancelled or no-show). The end time, seats, area and capacity and clash alerts appear. Holds up to 500 reservations.
  • جدول السهرة: Tables in rows and 12 half-hour slots in columns for the selected date. The customer's name appears in a booked slot and clashes are colored red, with guests and the number of tables booked in each slot below.
  • العملاء المتكررون: A list of customers whose visits reached the set minimum, sorted by number of visits and then by latest visit, with each customer's phone and number of no-shows.
  • الملخص: The month's reservations by status, no-show rate, cancellation rate and guests who attended, deposits held, deducted, forfeited and refunded, the month's alerts, and guests per day, with three charts.

The file opens on a start tab (“ابدأ هنا”, Start here) that explains how to use it.

What makes it different

The evening grid shows at a glance which table is free in which half hour, the clash and capacity alerts stop a booking that cannot be honored before the customer arrives, and the repeat customers list shows who deserves a call before the busy season.

How to use it

  1. In "الإعدادات" (Settings) enter the venue name, the date of the evening you want to schedule, the start of the first slot (for example 18:00) and the date of the first day of the month you want summarized.
  2. In "الترابيزات" (Tables) enter each table: its number, area (indoor, outdoor or VIP), number of seats and minimum spend.
  3. In "الحجوزات" (Reservations) log each reservation: date, time, sitting length in hours, number of guests, table, customer name, phone, occasion and deposit.
  4. Change the status after booking: "مؤكد" (confirmed) when booked, "حضر" (attended) or "لم يحضر" (no-show) after the time, and "ألغى" (cancelled) on cancellation.
  5. Check the capacity and clash columns in the reservations: red means a table booked twice at overlapping times, and yellow means a party larger than the seats.
  6. Open "جدول السهرة" (Evening grid) to see tables by half-hour for the selected date, and "العملاء المتكررون" (Repeat customers) and "الملخص" (Summary) for the month's figures.

Before you start:

  • Sitting length is entered in hours (1.5 means an hour and a half). Reservation end time = start + duration, and a reservation that starts exactly when another ends is not a clash.
  • A clash appears when another reservation on the same table overlaps in time on the same day. A reservation with status "ألغى" (cancelled) or "لم يحضر" (no-show) is not counted.
  • Capacity: "فوق السعة" (over capacity) appears if the number of guests exceeds the table's seats. If the table is not in the "الترابيزات" (Tables) sheet, "ترابيزة غير مسجلة" (table not registered) appears.
  • No-show rate = no-show / (attended + no-show), that is, only those whose time has come. Confirmed reservations whose time has not yet come are not included.
  • Deposits held = the deposits of "مؤكد" (confirmed) reservations across all dates. Beside it are the month's deposits: what is deducted from the bill of those who attended, what was forfeited for no-shows and what is refunded to those who cancelled. Whether to forfeit or refund is your restaurant's policy.
  • A repeat customer is identified by phone number: anyone with two or more visits (you can change the minimum in Settings), sorted by number of visits and then latest visit. A visit is a reservation with status "حضر" (attended).
  • The evening grid shows 12 half-hour slots from the time you set. The sheet holds 30 tables, 500 reservations and 30 repeat customers in the list.

Excel file (.xlsx) · 173 KB · 8 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

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)Cheat sheet: table reservations (2/3)Cheat sheet: table reservations (3/3)
0 downloads · 3 pages

Still running this on Excel?

This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.

In this sheetIn Custom Software from Softwiro
One file that one person edits at a time, and copies reach you on WhatsApp.A program with a login for each user and permissions you define, and everyone sees the same data.
You type everything and check the numbers by hand.We design the screens around your work steps, so each person records only what concerns them.
Columns and formulas are fixed as the sheet was designed.We build what you need: reports, alerts and screens your way.
Backups and security are your own responsibility.The program runs on a secured server with regular backups.

See Custom Software from Softwiro · Ask for a demo

Frequently asked questions

How do I stop the same table being booked by two customers at the same time?

Enter the reservation time and sitting length. The sheet calculates the end time and writes "تعارض" (clash) in red for any two non-cancelled reservations on the same table whose times overlap on the same day. If the second reservation starts exactly when the first ends, it is not a clash.

How do I calculate the no-show rate for a restaurant?

No-show rate = reservations marked "لم يحضر" (no-show) / (attended + no-show), that is, only those whose time has come. The sheet calculates it for your selected month. Confirmed reservations whose time has not yet come and cancelled ones are not included.

What happens to the deposit if the customer does not show up or cancels?

The summary shows the deposit held for your confirmed reservations, what is deducted from the bills of those who attended, the deposits of no-shows and the deposits of those who cancelled. Whether it is forfeited or refunded is your own policy with the customer, not a rule in the sheet.

How do I find my repeat customers?

The sheet goes by the customer's phone number: every number with two or more visits (you can change the minimum in Settings) appears in "العملاء المتكررون" (Repeat customers) with its number of visits and last visit date. A visit is a reservation whose status you set to "حضر" (attended).

Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html

More free templates for: Restaurants and cafes

More free templates

All templates · Free tools