Skip to content
EventProgrammer

Hotel Rooming List Template Excel (Free)

Free hotel rooming list template in Excel: one row per room, nights calculated for you, rooms per night against your block. Direct download, no sign-up.

Updated 17 November 20265 min read

Guest 1Guest 2Room typeCheck-inCheck-outNights
Aksoy, DenizSingle11 Mar14 Mar3
Demir, CanYalcin, EceTwin11 Mar13 Mar2
Akin, SelinAkin, MertDouble12 Mar14 Mar2
Kaya, ElifSingle12 Mar13 Mar1
Rooms picked up per night / contracted block

What’s in the template

The template is a rooming list you can send to the hotel as it is, plus two sheets that help you check it. Each row is a room, not a guest: guests who share a room go on the same row. Hotels count a block in rooms, so keeping the list the same way lets one formula give you nights and rooms.

Rooming list
A header for event, hotel, version and date sent, and 150 room rows underneath. Room type and billing come from a dropdown; nights are calculated from the dates.
Room nights
Enter the first night and it shows, for 21 nights, how many rooms of each type are taken and the difference against your contracted block. A negative difference is highlighted: block you have not filled yet.
How to use
Short notes on room types, cut-off, versions and personal data.
Example
Three filled rooms: a single, a twin and a double. Don’t send it to the hotel.

What each column means

ColumnWhat goes in it
Guest 1–3Last name, first name, exactly as on the ID or passport. The front desk searches by it.
Room typeSingle, Double, Twin, Triple or Suite. A double is not a twin.
Check-in / Check-outArrival and departure dates at the hotel. The departure day is not a night.
NightsCalculated for you; don’t type over it.
ArrivalFlight and landing time, or “own transport”. It tells the hotel who may ask for early check-in.
BillingMaster account (everything to the organiser), guest pays, or room to master and incidentals to the guest.
Special requestsCot, accessible room, high floor, connecting rooms and so on.
Hotel confirmation no.The hotel fills it in and sends it back; use it for every later change.

Rooming list example

Here is a small rooming list for one hotel, filled in with the template’s main columns. The names are made up.

Example rooming list: Hotel A, version 2
Guest 1Guest 2Room typeCheck-inCheck-outNightsSpecial requests
Aksoy, Deniz—Single11 Mar 202714 Mar 20273High floor
Demir, CanYalcin, EceTwin11 Mar 202713 Mar 20272—
Akin, SelinAkin, MertDouble12 Mar 202714 Mar 20272Cot
Kaya, Elif—Single12 Mar 202713 Mar 20271Accessible room
  • One row per room. Six people are staying, but the list has four rows because there are four rooms. Can Demir and Ece Yalcin share a twin (two beds), Selin and Mert Akin share a double (one bed), and each pair sits on one row. Hotels count a block in rooms, so the list does too.
  • Last name first. Write “Last name, First name”, spelled as on the ID. The front desk searches by last name, and a fixed order makes it easier to spot the same guest entered twice.
  • Dates with the month in words. 03/04/2027 is 3 April in Europe and March 4 in the US; 11 Mar 2027 can only be read one way. Each room has its own dates: Deniz Aksoy arrives a day before the Akins.
  • Nights are check-out minus check-in. The check-out day is not a night, so 11 to 14 March is three nights. This list adds up to 8 room nights; a shared room counts once, not once per guest.

The template also has columns for arrival details, billing and the hotel’s confirmation number; they are left out here to keep the example short.

How to use it

  1. Make one copy per hotel. Put the hotel and version in the file name: Hotel-A_rooming_v1.xlsx.
  2. Fill in the header. Event, hotel, who is sending it and when, so the hotel knows whom to ask.
  3. Add the rooms. For shared rooms, put the second guest on the same row. If your guest list lives in another file, paste the names across.
  4. Check the room nights. Enter your contracted block per night and you see which nights you are over or under before the hotel does.
  5. Send it and bump the version. Go v2, v3 with every change, and list the changed rows in your email.

For what a rooming list is, how it differs from a booking link and when hotels need it, see what is a rooming list.

Before you send it

  • Do names match the ID spelling? Accented characters can break in hotel systems.
  • Are doubles and twins right? A couple landing in a twin room is a classic complaint.
  • Are the check-out dates right? A nights value one off means a date is wrong.
  • Does any night exceed the block on the room nights sheet? Ask the hotel for extra rooms first.
  • Does this file contain only this hotel’s guests?
  • Are the version number and date sent current?