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
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.
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?
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.
In what order should I import my data?
- The property. Room types, room numbers, rates and taxes come first. The onboarding form on our site collects them.
- 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.
- Forward bookings. Import arrivals still to come, after removing cancelled rows and checking dates. Spot-check the first fortnight of arrivals guest by guest.
- 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 DemoRelated guides
More on switching PMS
PMS Migration Checklist
The planning side of a switch.
Import Bookings From Email and iCal
Ongoing partner bookings.
PMS Onboarding Support
How setup help works.
Onboarding Form
Set up your property details.
GDPR for Hotels
Handling guest data lawfully.
Pricing
What is free and what is paid.