VAKTIN·
NAME·LISTS — rooming lists → the Opera rooming-import template

Drop any tour operator's rooming list — a Nordic Visitor package, a group organiser's spreadsheet, a channel export — and get back a sheet in the full Opera Cloud rooming-import template, every column in order, ready to import: each name split into its parts — Name gets the last name (and middle), First Name the first — room types turned into your property's codes, arrival & departure dates, nationality as its ISO country code, and a running line count filled in; the rest of the template's columns are left blank and ready for the rest of the details. Add several files and they merge into one list. Everything runs in this browser.

How it works ▾
  1. Drop one or more files (.xlsx, .csv, .tsv) — or paste the rows straight from a spreadsheet, an email or a PDF (see the paste box below the drop zone). Three shapes are read automatically: flat tables (columns detected by name — Passengers / Room Type / Check in / Check Out / PAX / Nationalities and many aliases), sectioned Fosshotel group rooming lists (dates in the IN … OUT … header, roommates grouped by Res #), and reservation-sheet name lists with separate First / Middle / Last columns (e.g. a G Adventures sheet — a room's guests are stacked on consecutive rows and rooms are split by a blank row, so each stack becomes one room; dates come from the flight info, nationality from the demonym).
  2. Set the room-type codes for this property in the left rail (e.g. Twin Room → STA). They're remembered per hotel.
  3. Pick which bookings to include — each date section or booking reference is a group you can tick or untick, or use the checkbox on any single row. Only ticked reservations are exported, and the line numbers renumber to match.
  4. Fix anything in the preview — every cell is editable. Mis-split surnames, a wrong date, a missing code.
  5. Export the Opera name-list as .xlsx or .csv, or copy it to paste straight into an existing sheet.

Drop a rooming list here

Excel or CSV — a tour operator's rooming list or a group name spreadsheet. Add as many as you like; they merge into one name list.

.xlsx · .csv · .tsv — unpacked in this browser, no upload, no library
⛨ runs entirely in this browser — no guest data leaves this machine
…or paste a list instead

Copy the rows straight out of Excel, Google Sheets, an email or a PDF — include the header row — and paste below. The columns are figured out automatically; paste again to add another list.

Pasting drops it in automatically.