Import Your Existing Bookings
How to import existing bookings into Sirvoy using the booking import form or a formatted CSV file.
Table of Contents
Importing your existing bookings to Sirvoy is quick and easy using the built-in import tool.
Note:
- Bookings from Booking.com are imported automatically when you connect to it from your Sirvoy account.
- Airbnb bookings can be imported by following this guide, using the Airbnb connection page after connecting to Airbnb, or both.
Are you importing a handful of bookings?
If you only have a few bookings to bring into Sirvoy, there are two ways to do it:
Option 1: Add Bookings Manually Using the New Booking Page
You can create each booking individually in Sirvoy by entering the same guest and reservation details as in your previous system.
This method works well if you have fewer than five bookings to transfer.
- Go to the New Booking page
- Enter the guest details, room selection, and stay dates
- Click Save to add the booking
Option 2: Manually Fill Out the Booking Import Form
Sirvoy also offers a tool for entering multiple bookings in one place. You’ll enter each room booking on its own row on a spreadsheet-like form and then import the entire form.
This method works well if you have fewer than fifteen bookings to import.
The form follows specific formatting rules. Be sure to use the correct field names, date formats, and data types. You’ll find all the requirements under Booking Import Requirements below.
- Go to Settings > Sirvoy account > Bookings Import.
- Fill in the form, using one row for each room in a booking.
- Use the + button to add more columns if needed—but make sure the column names match the required or optional fields listed further down in this guide.
- For bookings with more than one room, add a Booking ID column and use the same ID on all rows belonging to that booking
- Fix any issues shown (see the Import Errors and Warnings below).
- Click Verify to see if the errors and warnings are resolved.
- Once all errors are resolved, click the Import button that appears.
On the confirmation page, you’ll find links to each booking so you can review them individually.
Are you importing a lot of Bookings?
The import tool allows you to bulk import up to 100 reservations at a time using a CSV file. If you have more, use multiple CSV files.
A CSV file is a simple text file that stores your booking data in a way that can be imported into other systems—like Sirvoy. It’s typically created or edited using spreadsheet software like Excel, Google Sheets, or Apple Numbers.
1. Format a CSV File
The easiest way to create a CSV file is to export your booking data from your spreadsheet software.
Before you export it, the file should follow a few formatting rules so Sirvoy can read it—like using the correct column names and date formats.
See Booking Import Requirements below for the details.
Tips:
- You can either edit your own file to match the required format, or use our premade booking import template to get started faster.
- If you're switching from another hospitality management system, you can usually export your bookings as a CSV file. Open the file in your spreadsheet software, update the formatting to match Sirvoy’s requirements, and export it again as a new CSV.
2. Export The CSV File
Choose your spreadsheet software below to see how to export your data as a CSV file.
Excel (Windows)
- Click the floppy disk icon in the toolbar, or go to File > Save As.
- Name the file and choose the file format CSV (Comma delimited).
- Select where you want to save the CSV file.
- Click Save.
Excel (Mac)
- Go to File > Save As.
- Name your file in the Save as field.
- Select where you want to save the CSV file.
- Choose the file format CSV (Comma delimited).
- Click Save.
Excel for the web
- Go to File > Export > Download as CSV.
Google Sheets
- Go to File > Download > Comma-separated values (.csv)
Numbers (Mac)
- Before exporting, go to System Settings > General > Language & Region > Number Format and make sure the decimal separator is set to a dot (.), not a comma.
- Sirvoy supports number formats like 1,234,567.89 and 1 234 567.89, where the decimal is a dot.
- Go to File > Export To > CSV.
Something else?
Most spreadsheet programs have an option to export or save as a CSV file. Just make sure the file uses commas as separators and follows the format requirements below.
3. Import the CSV File into Sirvoy
- Go to Settings > Sirvoy account > Bookings Import.
- Click Import CSV and select the CSV file from your computer
- Fix any issues shown (see the Import Errors and Warnings below).
- Click Verify to see if the errors and warnings are resolved.
- Once all errors are resolved, click the Import button that appears.
On the confirmation page, you’ll find links to each booking so you can review them individually.
Booking Import Requirements
Required Headers
Include the following column headers in the import tool or CSV file. The order doesn’t matter, but the spelling must match exactly—this means keeping them in English, even if your account is in another language.
Header name (must be exact) |
What it means |
Room ID |
Room ID from your Sirvoy account |
Number of guests |
Number of guests in the room |
Check-in |
Check-in date for the room |
Check-out |
Check-out date for the room |
Nightly price |
Price charged per night for the room |
First name |
Guest’s first name |
Optional Headers
| Header name (must be exact) | Meaning |
| Booking ID | A unique ID to group multiple rooms under one booking. Use the same ID for all rows in the same booking |
| Last name | Guest’s last name |
| Company | Guest’s company name |
| Address | Guest’s street address |
| Postal code | Guest’s postal or ZIP code |
| City | Guest’s city |
| Country | Guest’s country |
| Phone | Guest’s phone number |
| Guest’s email address | |
| Guest comment | Notes or requests from the guest |
| Internal note | Internal note about the booking, not visible to guests |
| Confirmed | Indicates booking status. Use "0" for unconfirmed (a request) or "1" for confirmed |
| Guest name | Name of the person staying in the room, if different from the person who made the booking |
| Room note | Internal note about this specific room in the booking. Not visible to guests |
| Language | Guest’s preferred language. Use a two-letter ISO code like "en" for English |
Supported Date Formats
Sirvoy accepts several date formats. Here's how common examples are interpreted:
| Example | Interpreted as |
| 01/02/2024 | mm/dd/yyyy |
| 01-02-2024 | dd-mm-yyyy |
| 01.02.2024 | dd.mm.yyyy |
| 2024/02/01 | yyyy/mm/dd |
| 2024-02-01 | yyyy-mm-dd |
| 2024.02.01 | ❌ Not valid |
Other Tips
- If a booking includes more than one room, list each room as a separate row using the same Booking ID. That way, the rows will import as a single booking.
- Keep the file under 100 rows. If you have more bookings, split them into smaller files before importing.
Import Errors and Warnings
When you click Verify, you may see symbols indicating problems with your data.
Errors
These must be fixed before you can import. The Import button won’t appear until all errors are resolved.
Examples:
- Room not available on specified dates
- Duplicate booking for same room and date
- Invalid “Room No.”
- Invalid “Phone”
- File exceeds 100 lines
Warnings
Warnings don’t block the import, but you may want to review them to avoid issues later.
Examples:
- Higher than max X for this room
- Invalid or missing “Country” could cause “Phone” to be invalid