Sign up now for a 60 day free trial. No credit card required.
Sign up now and it's free until June!
Venue Account Owners and Venue Administrators can import bookings from an Excel spreadsheet. This is useful for loading booking data in bulk, or to migrate bookings from your old system.
To access the Import function, choose Bookings from the main navigation bar at the top of the page, then click the Import button.
You need to prepare your data in a spreadsheet prior to import. The spreadsheet should have a single worksheet (tab) only, and must be saved as a .XLSX or .XLS file.
The first row of the spreadsheet is for column headers. These must be as shown in the table below. The remaining rows contain the data for your bookings – one row for each booking. You are allowed to import up to 100 customers at once – if you need to import more, please split your data across multiple spreadsheets.
The spreadsheet should have the following columns. You will notice that these are the same fields as you complete when adding a New Booking manually.
Any additional columns in your spreadsheet, or columns with different heading names, are ignored.
Here is an example spreadsheet containing 3 bookings.
Repeat Bookings: You cannot import Repeat Bookings from your spreadsheet. If you have repeat bookings, you can either import each individual booking from the spreadsheet. Alternatively, enter the repeat booking manually.
Once you have prepared your spreadsheet, use the Browse button on the Import Customers page to load the spreadsheet then press the Import File button.
If there are any errors in your data, these will be displayed on the screen. Errors may be because of the format of your spreadsheet or your data, or may be because a room you wish to book is not available, either due to an existing booking or because you tried to book the same room twice at the same time in your spreadsheet. Please go back to your spreadsheet and correct the errors, then try again.
Finally, if you get stuck or you need help in any way, please do not hesitate to contact our Support Team, attaching your data file for their information.