Set Up the Rooming List Spreadsheet

Rooming lists provide a list of all guests associated with a specific business block and date range. Agents or guests can submit a rooming list file that you can import into the block. This eliminates the need to type guest names, dates, and other information into OPERA Cloud.

Consider the following when setting up the group rooming list:

• Files must be in Microsoft Excel .xls or .xlsx formats.

• Begin each column with headings at cell A1. Upon import, the spreadsheet's column headings map to corresponding rooming list field names. Each reservation then creates using the data in those columns.

• Only columns with data import.

• Only mapped columns import. If a column that you want imported does not map, you can manually map it. The topic Mapping Columns for an Imported Block Rooming List provides more information.

• You must map spreadsheet columns to the following Manage Rooming List screen fields: Name, Arrival Date, Departure Date, Room Type, Email Type if an email address is supplied, ID Type if an ID Number is supplied, and Rate Code if the controls for Rate Code Mandatory Block Header is active.

Example 3-1 Sample Rooming List Spreadsheet