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 familySideHotelArrivalDepartureRoomsNightsRoom-nightsAllocation status
Malhotra familyGroomAmber Courtyard Hotel12 Dec 202615 Dec 2026236Allocated
Kapoor familyBrideAmber Courtyard Hotel12 Dec 202614 Dec 2026326Allocated
Dev SethiGroomPink City Residency13 Dec 202615 Dec 2026122Waiting for hotel
Anita Rao and familyBridePink City Residency11 Dec 202615 Dec 2026248Room numbers pending
Imran SheikhGroomAmber Courtyard Hotel13 Dec 202614 Dec 2026111Allocated

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.

Moving the arrival from 12 to 11 December adds two rooms on the night of the 11th: eight room-nights where there were six.
Before

Arrival 12 Dec, departure 15 Dec

Nights stayed12, 13, 14 Dec
Rooms each night2
Room-nights2 × 3 = 6
After

Arrival 11 Dec, departure 15 Dec

Nights stayed11, 12, 13, 14 Dec
Rooms each night2
Room-nights2 × 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.