Yes! You can import bookings at any time with our import tool.
How to Import Bookings
- Go to Settings -> Your account -> Import bookings.
- Provide the booking data – either by manually filling out the form or by uploading a CSV file (see requirements below).
- Click VALIDATE.
- Check errors and warnings by hovering over the error/warning symbol and adjusting the form accordingly. (The difference between these is explained below.)
- Click VALIDATE again. Once no errors occur, the IMPORT button will become visible.
- Click IMPORT.
- You see a confirmation page where you can click the links to see each full booking.
Requirements for the CSV File
- Fields are separated by a comma (,). If a field’s data contains a comma, surround it with double-quotes (“). Therefore,
- if you export the CSV file from Excel (Windows), select “comma” as the delimiter.
- if you export the CSV file from Numbers (Apple), make sure you have set dot (.) as the decimal divider under “System Preferences > Language & Region > Advanced -> General”. You might have to restart Numbers before exporting the CSV file.
- The following headers are required: Room No., Check-in, Check-out, Number of Guests, Price per Night, First Name. The order of these headers is not important.
- The following headers are optional: Booking ID, Last Name, Company, Address, Post/Zip Code, City, Country, Phone, Email, Guest Message, Comment, Confirmed, Guest Name (used for a specific room in combined bookings), Room Comment (used for a specific room in combined bookings), Language (two-letter code; e.g. “en” for English)
- The spelling of these headers has to be exactly as mentioned above. This means that you have to use the English headers in all languages.
- If nothing is set under Language, the “Preferred language” of that booking defaults to English. If English is not one of your supported languages, it defaults to your account language.
- For dates, it’s recommended to use ““YYYY-mm-dd” or “dd-mm-YYYY”.
- Rows can be combined to a single booking when provided with a matching Booking ID. If so, note the following details:
- Some fields are ignored in rows after the first related row.
- First Name & Last Name are only ignored if they both match the first related row. Otherwise, both will be merged and imported as Guest Name for that room – but only if Guest Name does not already include other data.
- Comment is only ignored if it matches the first related row. Otherwise, it will be imported as Comment for that room – but only if Room Comment does not already include other data.
File must not exceed 200 lines. If a file is larger than that, it needs to be split into several files under 200 lines each.
Difference Between Errors And Warnings
Upon validation of the data, you might see some errors and/or warnings in certain cells. By hovering over the symbol, you will see the reason for it.
- Room not available on specified dates -> If the room is already booked.
- Booking for room [roomname] on [day] occurs more than once -> If there is another booking for the same room and date in the same file.
- Invalid “Room No.” -> If room doesn’t exist or is misspelled.
- Invalid “Phone”. Possibly due to invalid or missing “Country” -> If the phone number can’t be validated and the country is either missing or invalid.
- This file is too big for import, max amount of lines: 200. Please split it into smaller parts -> File exceeds 200 lines. See point 6 about requirements for the file.”
Warnings, on the other hand, don’t prevent you from importing the bookings. They just notify you that some details might not be according to your settings or might be missing in the final import. Some examples of warnings are:
- Higher than max ([number]) for this room -> If “Number of Guests” in the file is higher than the “Max. number of guests” you actually allow for this room type in your settings.
- Invalid or missing “Country” could cause “Phone” to be invalid -> If the country code is missing or wrong (e.g. “UK” instead of “GB”).
The above is also explained in this video: