Skip to main content

Switching Day: Import Your Guest List and Bookings

Frontdesko imports guests from a CSV on the Guests page, previewing before anything is saved, and bookings from an Excel file on the Reservations page. Repeat guests are skipped, and booking rows reuse the guests you already imported.

By the Frontdesko team · Last updated: November 11, 2026

Start Live Demo

What does switching day look like for the guest data? A guesthouse example

Illustrative scenario. A 14-room guesthouse is a made-up property used to show the screens in order. It is not a customer story, and no figures here are real results.

Screen and button names are as they appear in the staff PMS. Times and counts are invented to show the sequence.

TimeWhereWhat happens
Tue 08:30Old systemA manager at a 14-room guesthouse, in a quiet week, exports the old guest list to a spreadsheet, checks the column names and saves it as CSV UTF-8. The property’s rooms, rates and taxes were set up earlier from the onboarding form.
08:45Staff PMS → Guests tabShe clicks Import guests. The button is there because she is a manager. The dialog is titled “Import guests from CSV”. She clicks Download sample CSV and compares its headers (first_name, last_name, title, email, phone and so on) with her sheet.
08:55Import dialogShe clicks Choose CSV file. The preview says “nothing has been saved yet” and shows four numbers: Rows 140, Will import 133, Skipped (already exist) 4, Errors 3. A yellow notice says one column, “Loyalty No”, was not recognised and will be ignored.
09:05Rows with errors listThree rows are listed with reasons, for example: “31/02/1985” is not a date — use YYYY-MM-DD (e.g. 1990-04-23) and title “Herr” not understood — use Mr, Mrs, Ms, Dr or Prof. The Skipped rows list shows four guests who are already in the system, matched by email. She fixes the three rows in the spreadsheet and clicks Choose another file.
09:15Import dialogThe new preview shows Errors 0 and Will import 136. She clicks Import 136 guests and sees “136 guests imported”.
09:40Staff PMS → Reservations listShe clicks Import. The Import Bookings dialog takes an .xlsx file of the arrivals still to come. She had deleted the cancelled rows from the sheet first.
09:45Preview & Map stepIt reads “52 total rows”, “46 individual” and “2 groups (6 rooms)”. In the room type table, “Standard Twin” is Auto-matched. “Fam room” says Needs mapping, so she picks “Family Room” from the list. A warning says row 14 has no price in the file, so the room type’s base rate is used.
09:55Import Results stepShe clicks Import 52 Bookings. It reports “Import completed successfully”, “48 reservations created” (46 single bookings plus the 2 groups) and “52 rooms assigned to reservations”.
10:10Guests tabShe opens a returning guest’s reservation. The guest on it is the profile she imported at 09:15, not a second copy, because the booking row matched by email. The tab’s Duplicates button is there for any strays she finds later.
10:30Old systemGuests who checked in before today stay in the old system until they leave, as the migration checklist advises. She lists them for tomorrow’s overlap check.

This page is the hands-on walk-through. The planning side, covering what to export, the cutover date and rebuilding channel connections, is in the hotel PMS migration checklist.

How does the guest list import work, and what are its limits?

ItemHow it behaves
Where and whoStaff PMS → Guests tab → Import guests. Shown to managers and admins only.
FileA .csv file, up to 5,000 rows and 5 MB per file. Comma, semicolon and tab separators all work. Use “CSV UTF-8” from Excel; plain Windows CSV is also read. The first row must be the column headers.
Columnsfirst_name is the only required column, or a single “name” column that is split at the first space. Optional: last_name, title, email, phone, date_of_birth, gender, nationality, language, id_type, id_number, id_issuing_country, vip, gstin, notes. Header spelling is matched loosely, so “First Name”, “mobile” and “dob” work. Unknown columns are ignored and listed.
Preview firstNothing is saved until you click Import N guests. The preview shows Rows, Will import, Skipped and Errors. Rows with errors are not imported; the rest are.
What counts as a repeatA guest whose email already exists, or whose phone matches an existing guest on its last 10 digits, or who repeats an earlier row in the same file, is skipped. Rows with only a name are not compared, so uploading a names-only file twice creates the guests twice.
FormatsDates of birth as YYYY-MM-DD, or day first as DD/MM/YYYY, DD-MM-YYYY or DD.MM.YYYY. Title: Mr, Mrs, Ms, Miss, Dr or Prof. Language: a code such as en, lt, th, es, fr, de, it, pt, id or fil. VIP: yes/no, 0 to 4, or regular, silver, gold, platinum, diamond.
What it brings overGuest profiles only. Stay history, bills, ID photos and documents do not come across in this file.

How does the bookings import work, and what are its limits?

Past and future bookings come in through a separate import on the Reservations list, which also fills in guests from the same rows.

ItemHow it behaves
Where and whoStaff PMS → Reservations list → Import. Available to roles with the Import Bookings permission, which admins, managers and sales staff have by default.
FileAn .xlsx file only; CSV is not accepted here. The first sheet is read, and its first row must be the headers. Three steps: Upload File, Preview & Map, Import Results.
Columns it recognisesBooking code, guest name (or separate first and last name), room type, room number, check-in, check-out, nights, adults, children, total or daily rate, source, phone, email, notes, group number and name, rate plan, market. Headers are matched loosely.
NamesIf the sheet has separate first-name and last-name columns, they are used as written. With a single guest-name column the import reads it as “LastName FirstName”, so a sheet written “John Smith” would swap them. Add separate columns if yours is the other way round.
GuestsEach row reuses an existing guest when the email matches, else when the phone matches, else when exactly one guest has the same first and last name. If two guests share the name, a new guest is created.
Room typesEvery room type name in the file must be matched to one of yours before the import can run. Similar names are matched for you; the rest say Needs mapping. A row whose room type is not mapped is skipped with a warning.
Repeats and groupsRows whose booking code already exists in your hotel are skipped. Rows sharing a group number become one group booking with a room per row.
DatesReal Excel date cells work. Dates typed as text work as 31.12.2026 or 2026-12-31, but text with slashes is read month first, so 05/06/2026 is 6 May. Rows with a missing or unreadable date, or a check-out that is not after check-in, are skipped.
Prices and roomsTotals or nightly rates come from the file. With no price, the room type’s base rate is used and a warning says so. A room number that matches one of your rooms is assigned; otherwise a warning says the room was not found.
What it does not readEvery imported row arrives as a Confirmed reservation. A status column is not applied, so cancelled rows in the file would come in as confirmed: delete them first. Payments already taken in the old system are not imported.
If it failsEach import runs as one step, so a failed import does not leave half a file behind.

In what order should I import my data?

  1. The property. Room types, room numbers, rates and taxes come first. The onboarding form on our site collects them.
  2. Guests. Import the guest CSV before the bookings if your booking sheet has names but no email or phone, because the bookings import can then reuse those profiles by name. If your sheets carry emails or phones, either order avoids duplicates. If the guest file gives you trouble, skip it: it should never delay your go-live.
  3. Forward bookings. Import arrivals still to come, after removing cancelled rows and checking dates. Spot-check the first fortnight of arrivals guest by guest.
  4. Channels last, one at a time, as the migration checklist explains. Ongoing partner bookings can then arrive by email or iCal import.

What does it cost?

The PMS, including these imports, is part of the free product with unlimited rooms, together with the booking engine, guest app and POS. Only the channel manager and the AI assistant are paid, at $35, $42 or $54 a month by room band. See pricing.

Frequently Asked Questions

How do I import a guest list into a hotel PMS from a CSV?

In Frontdesko, open the Guests tab and click Import guests, which managers and admins can see. Download the sample CSV, match your headers to it, choose your file, check the preview, then click Import. Nothing is saved until you confirm the preview.

What columns does the Frontdesko guest import need?

Only first_name, or a single name column. Optional columns are last_name, title, email, phone, date_of_birth, gender, nationality, language, id_type, id_number, id_issuing_country, vip, gstin and notes. Unrecognised columns are ignored and listed in the preview.

Will the guest import create duplicates if I upload the same file twice?

Not for guests with an email or phone number: a guest whose email exists, or whose phone matches on its last 10 digits, is skipped. Rows with only a name are not compared, so a names-only file uploaded twice creates the guests twice.

What are the limits of the CSV guest import?

A .csv file of up to 5,000 rows and 5 MB. Comma, semicolon or tab separated; export from Excel as CSV UTF-8. Rows with errors are not imported, but the other rows are. The file creates guest profiles only, without stay history, bills or documents.

Can I import past bookings and stay history from my old system?

Bookings come in through the Import button on the Reservations list, from an .xlsx file. Every row arrives as a Confirmed reservation, because a status column is not applied, and payments are not imported. Remove cancelled rows first.

Why were first and last names swapped on my booking import?

With a single guest-name column, the import reads it as LastName FirstName, so a sheet written John Smith is swapped. If your sheet has separate first-name and last-name columns they are used as written, so add those columns.

Do imported bookings reuse the guests I already imported?

Yes. A booking row reuses an existing guest when the email matches, else when the phone matches, else when exactly one guest has the same first and last name. If two guests share the name, a new guest is created.

Why did a booking import read my dates wrongly?

Dates typed as text with slashes are read month first, so 05/06/2026 becomes 6 May. Use real Excel date cells, or write dates as 31.12.2026 or 2026-12-31. Rows with an unreadable date, or a check-out that is not after check-in, are skipped.

Does importing data cost extra?

No. The PMS, including its imports, is part of the free product with unlimited rooms. Only the channel manager and AI assistant are paid, at $35, $42 or $54 a month by room band.

Bring your guest list across without retyping it

Free PMS, guest app and booking engine with unlimited rooms. Start with a live demo.

Start Live Demo

Read the migration checklist

Related guides

More on switching PMS