Venue Account Owners can import customer data from an Excel spreadsheet. This is useful for loading customer data in bulk, or to migrate data from your old booking system.
To access the Import function, choose Customers from the main navigation bar at the top of the page, then click the Import button. (Note: only the Venue Account Owner can import data. If you do not see the Import button, you should contact your Venue Account Owner and ask them to perform the import for you)
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 customers – one row for each customer. 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 Customer manually.
| Heading | Mandatory / Optional | Notes |
|---|---|---|
| Name | Mandatory | Name of group or person. The Name needs to be unique in your Venue Account – you must not already have a Customer set up with the same Name, and you must not have two rows in your spreadsheet with the same Name. |
| Contact Name | Mandatory | Contact for bookings and invoices. If Name is a person, it is likely Contact Name will be the same. You are allowed to use the same Contact Name for more than one Customer (after all, some people run many groups!) |
| Category | Optional | The name of the Category you want to associate with this customer. It must exactly match the name in the Customer Categories table. (e.g. Personal) |
| Optional | Must be an email address. | |
| Phone | Optional | |
| Address Line 1 | Optional | |
| Address Line 2 | Optional | |
| Town | Optional | |
| County | Optional | |
| Postcode | Optional | |
| Country | Optional | |
| Do Not Invoice | Optional | Must have the values TRUE (if you will not be invoicing this customer) or FALSE (meaning that you do charge this customer). If you do not provide a value for Do Not Invoice, it defaults to FALSE. |
| Invoice Contact Name | Optional | If an Invoice Contact Name is given, then invoices will be generated using the invoice contact details given in the Invoice Email or Invoice address fields. Otherwise, invoices are generated using the Email or address fields above. |
| Invoice Email | Optional | |
| Invoice Phone | Optional | |
| Invoice Address Line 1 | Optional | |
| Invoice Address Line 2 | Optional | |
| Invoice Town | Optional | |
| Invoice County | Optional | |
| Invoice Postcode | Optional | |
| Invoice Country | Optional | |
| Price List | Optional | This must be the name of the Price List you use when invoicing the customer. You must set up your Price Lists before you can use them. If you do not provide a value for Price List, it defaults to Standard Rates. If Do Not Invoice is TRUE, you do not need a Price List, as you will not be charging this customer. |
| Comments | Optional | This can be used for additional information. |
Any additional columns in your spreadsheet, or columns with different heading names, are ignored.
Here is an example spreadsheet containing 3 customers. This example assumes that an additional Price List called “Residents Discount” has been set up prior to import.
| Name | Contact Name | Category | Address Line 1 | Address Line 2 | Town | County | Postcode | Country | Phone | Do Not Invoice | Invoice Contact Name | Invoice Email | Invoice Address Line 1 | Invoice Town | Invoice Postcode | Price List | Comments | |
| Art Group | Jessica Ellis | Creative | Studio 52 | 5 Elliot Grove | Kingport | Norfolk | NR8 2JJ | United Kingdom | jellis@example.com | 01545 21526 | FALSE | Standard Rates | The Art Group uses the main hall and the kitchen. | |||||
| Tidy Village Campaign | Sam Smith | Political/Lobby Group | ssmith@yoga4you.org.uk | TRUE | ||||||||||||||
| Joan Peacock | Joan Peacock | Personal | 6 Church Cottages | Tavernham | NR8 9JD | 01545 657895 | Frank Brown | f.brown@example.com | 23 Acacia Gardens | Tavernham | NR8 7AS | Residents Discount |
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. 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.