Wedding rooming list and hotel allocation for Indian wedding planners
A free Excel template: one row for each guest or family, with hotel, arrival, departure, rooms and allocation status. It works out the nights, the room-nights and the rooms needed on every night.
No sign-up needed. Excel file, 3 sheets. All names in it are fictional.What is inside
A sample of the first sheet, exactly as it opens. Replace the sample rows with your own guests.
| Guest or family | Side | Hotel | Arrival | Departure | Rooms | Nights | Room-nights | Allocation status |
|---|---|---|---|---|---|---|---|---|
| Malhotra family | Groom | Amber Courtyard Hotel | 12 Dec 2026 | 15 Dec 2026 | 2 | 3 | 6 | Allocated |
| Kapoor family | Bride | Amber Courtyard Hotel | 12 Dec 2026 | 14 Dec 2026 | 3 | 2 | 6 | Allocated |
| Dev Sethi | Groom | Pink City Residency | 13 Dec 2026 | 15 Dec 2026 | 1 | 2 | 2 | Waiting for hotel |
| Anita Rao and family | Bride | Pink City Residency | 11 Dec 2026 | 15 Dec 2026 | 2 | 4 | 8 | Room numbers pending |
| Imran Sheikh | Groom | Amber Courtyard Hotel | 13 Dec 2026 | 14 Dec 2026 | 1 | 1 | 1 | Allocated |
Sample data. The second sheet shows rooms needed for each night and each hotel; the third explains how to use it.
One date changes the whole hotel order
The Malhotra family needs two rooms from 12 to 15 December. The night of checkout is not counted. Now their flight moves a day earlier.
Malhotra family · 2 rooms · Amber Courtyard Hotel
Arrival 12 Dec, departure 15 Dec
| Nights stayed | 12, 13, 14 Dec |
| Rooms each night | 2 |
| Room-nights | 2 × 3 = 6 |
Arrival 11 Dec, departure 15 Dec
| Nights stayed | 11, 12, 13, 14 Dec |
| Rooms each night | 2 |
| Room-nights | 2 × 4 = 8 |
In the template, change the arrival date in one cell and the nights, room-nights and the night-by-night sheet change with it.
See this with your guest-list format
Send us the columns your guest sheet uses. In a demo we load it into Aishka OS and show the rooms by night, the room-wise list and the export for the hotel.
Made by the team behind Aishka OS at Indian Wedding Planners (IWP), Singapore, from the rooming lists of its own weddings.