Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Sirvoy home
  • Login
  • Contact
English (US)
US English (US)
FR French
DE German
ES Spanish
NL Dutch
SE Swedish
FI Finnish
NO Norwegian
DA Danish
  • Home
  • Getting Started
  • Import Bookings

Import Your Existing Bookings

How to import existing bookings into Sirvoy using the booking import form or a formatted CSV file.

Written by olad

Updated at November 29th, 2025

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Getting Started
    Setup Guides Import Bookings
  • About Sirvoy
    General Technical Security & Backups
  • Rooms & Room Types
    Rooms & Room Types Categorizing Room Types Offer Add-Ons or Extras
  • Bookings
    Modify Booking View Bookings Message Templates & Automated Messaging Communication Scheduling Housekeeping and Tasks
  • Rates & Restrictions
    Rates & Discounts Restrictions Promotion & Coupon Codes
  • Booking Engines
    Website Builder Installing on Your Website Adjusting the Booking Engine Design & CSS Input Fields Guest portal Tracking
  • Channel Manager
    Setting Up New Channels Mapping Your Room Types General Rates & Availability Updates Overbookings
  • Financials
    Setting Up a Payment Solution Managing Payments Invoices & Receipts Accounting Taxes & Surcharges
  • My Account
    Customize Your Account Subscription Statistics Export & API
+ More

Table of Contents

Are you importing a handful of bookings? Are you importing a lot of Bookings? Booking Import Requirements Required Headers Optional Headers Supported Date Formats Other Tips Import Errors and Warnings Errors Warnings

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.

  1. Go to the New Booking page
  2. Enter the guest details, room selection, and stay dates
  3. 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.

  1. Go to Settings > Sirvoy account > Bookings Import.
  2. 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
  3. Fix any issues shown (see the Import Errors and Warnings below).
  4. Click Verify to see if the errors and warnings are resolved.
  5. 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)

  1. Click the floppy disk icon in the toolbar, or go to File > Save As.
  2. Name the file and choose the file format CSV (Comma delimited).
  3. Select where you want to save the CSV file.
  4. Click Save.
 
 

Excel (Mac)

  1. Go to File > Save As.
  2. Name your file in the Save as field.
  3. Select where you want to save the CSV file.
  4. Choose the file format CSV (Comma delimited).
  5. Click Save.
 
 

Excel for the web

  1. Go to File > Export > Download as CSV.
 
 

Google Sheets

  1. Go to File > Download > Comma-separated values (.csv)
 
 

Numbers (Mac)

  1. 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.
  2. 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

  1. Go to Settings > Sirvoy account > Bookings Import.
  2. Click Import CSV and select the CSV file from your computer
  3. Fix any issues shown (see the Import Errors and Warnings below).
  4. Click Verify to see if the errors and warnings are resolved.
  5. 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
Email 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
 

 

import bookings sirvoy booking upload sirvoy transfer reservations import csv sirvoy add old bookings existing reservation import booking data migration bulk booking import sirvoy booking form

Was this article helpful?

Yes
No
Spot something odd? Let us know.

Related Articles

  • Limiting How Far Ahead You Are Bookable on Channels
  • Creating Booking Engines Only for Extras

Need a hand with Sirvoy?

You're in the right place.

  • Sirvoy
  • Login
  • Contact

    ©2025 Sirvoy . All Rights reserved.

    Expand