How to import guest names and contact information onto a Master Reservation in RMS using a CSV file via the Area tab - also referred to as a Rooming List import or Guest Import on a Master Reservation.
Overview
A Master Reservation (also known as a Group Reservation) is a group of reservations that links multiple guests travelling together under a single master name and reservation number.
A Rooming List is a document provided by an organiser that details each guest's name and contact information for all reservations within the group. It can be imported from a CSV (comma-separated values) file via the Area tab to quickly populate guest information across all sibling reservations, saving time on manual data entry. This is also referred to as a Guest Import on a Master Reservation.
Please Note! RMS is highly configurable. Some Terminology, User Access & Permissions, Images, Labels, and Functions used in these articles may differ from your setup. For more information, see Understanding RMS Help Centre Articles.
Important! The import only accepts the file that RMS creates when you export the Area List from the same Master Reservation. Export the Area List, add the guest names to the file, then import it back into the Master Reservation.
Alternative Functions
Quick Add on the Guest tab of a Master Reservation enables manual entry of guest surnames and given names across all sibling reservations without importing a file - useful for small groups where a CSV is not available.
The Replace Guest option on an individual reservation can be used to change the Guest Profile associated with a specific sibling reservation within the group.
The Area List on the Area tab can be used to print or export a summary of all reservations in the group, including Area, Guest Name, and key reservation details. Its Export option also creates the CSV file used for this import.
Import Information
The Rooming List import file must be the CSV file exported from the Area List of the same Master Reservation, with the guest names added. RMS uses the file's columns to find each sibling reservation, so the following rules apply:
- Do not add, remove, rename or reorder columns. A file with different columns, such as a file built from scratch, imports nothing and RMS shows no message.
- Do not change the Res Id, Category, Area, Arrive or Depart values. These must match the sibling reservation.
- Enter a Surname on every row you want to import. Rows without a Surname are skipped and listed in an error message; the other rows still import.
- Rows can be deleted. A file that contains only some of the sibling reservations imports those rows only.
- Fields within the file must not contain commas.
Field Order
The exported Area List file contains the following columns, in this order:
| Order | Field Name | Filled in by RMS? | Notes |
|---|---|---|---|
| 1 | Res Id | Yes | Reservation number of the sibling reservation. Do not change. |
| 2 | Category | Yes | Do not change. |
| 3 | Area | Yes | Do not change. |
| 4 | Surname | No | Required on every row you want to import. |
| 5 | Given | No | Guest's given name. |
| 6 | Mobile | Yes, from the Master guest | Replace with the guest's mobile number if known. |
| 7 | Yes, from the Master guest | Replace with the guest's email address if known. | |
| 8 | Arrive | Yes | Do not change. See Date Format below. |
| 9 | Depart | Yes | Do not change. See Date Format below. |
The export lists one row for each adult on each sibling reservation. For example, a sibling reservation with 2 adults appears on two rows with the same Res Id. Enter a different guest on each row to add every adult, or delete the rows you do not need.
Date Format
The Arrive and Depart dates must stay in the format the export creates: YYYY-MM-DD HH:MM:SS (for example, 2026-02-28 00:00:00). Any other format, including DD-MMM-YYYY (25-JAN-2026) and DD/MM/YYYY (28/02/2026 00:00), fails with the message Error: Invalid date format.
Important! Microsoft Excel can change the date format when it opens and saves a CSV file. Before importing, check that the Arrive and Depart values still read like 2026-02-28 00:00:00, or edit the file in a plain text editor instead.
Import Guest Names on a Master Reservation
Export the Area List
The Area List export creates the Rooming List file for the Master Reservation.
Open the Master Reservation in RMS.
- Select (Master) in the Navigator Pane.
- Navigate to the Area tab.
- Select the Options icon (three dots).
- Select Area List.
- Select the Export icon in the Area List window.
RMS downloads a CSV file named Reservation_List.csv. The Layout and checkbox options in the Area List window do not affect the exported file.
Add the Guest Names
Add the guest details to the exported Area List file before importing it.
- Open Reservation_List.csv.
- Enter the Surname and Given name on each row, and update Mobile and Email if known.
- Delete any rows you do not want to import.
- Save the file in CSV format, keeping the dates as described in Date Format above.
Import the Rooming List
Import the completed file from the Area tab of the same Master Reservation.
- Select (Master) in the Navigator Pane.
- Navigate to the Area tab.
- Select the Import CSV icon.
- Locate the completed Area List file on your computer.
- Select the file and choose 'Open'.
RMS shows how many rows were imported, for example 2 out of 7 records imported successfully, and lists any rows that could not be imported.
Tip! To verify the import was successful, open an individual sibling reservation and navigate to the Guest tab to confirm the correct guest name has been added. The Guest tab on the Master Reservation lists the guests for every sibling reservation in the group.
How the Import Updates Guests
The Rooming List import adds guest profiles to the sibling reservations. It does not change the Master Reservation's own guest.
- Sibling reservation still using the Master's guest: RMS creates a new Guest Profile from the row and makes it the primary guest on that sibling reservation, using the Mobile and Email from the file.
- More than one row for the same sibling reservation: the first row becomes the primary guest and each further row with a different name is added as an additional guest.
- Sibling reservation that already has its own guest: a row with a different name is added as an additional guest. The existing primary guest is not replaced.
- Row with the same name as the existing guest: the row is skipped and nothing is changed, including the Mobile and Email.
To change the primary guest on a sibling reservation that already has its own guest, use Replace Guest on that reservation.
Import Messages
The Rooming List import shows the following messages when a row cannot be imported.
| Message or result | What to do |
|---|---|
| Surname must be supplied on sibling reservation [Res Id] | Enter a Surname on that row, or delete the row, then import again. |
| Area of CSV record doesn't match on sibling reservation [Res Id] | The Area on that row has been changed. Export a new Area List and copy the guest details across. |
| Error: Invalid date format | Change the Arrive and Depart values back to the exported format, for example 2026-02-28 00:00:00. |
| No message appears and no guests are updated | The file's columns do not match the Area List export, or every row repeats a guest the reservation already has. Export the Area List again and use that file. |
Related Articles
Comments
0 comments
Please sign in to leave a comment.