Skip to content
MyHallWizard
  • Home
  • Features
  • Demo
  • Pricing
  • Contact
  • Support
  • Login
Sign Up

Sign up now for a 6 week free trial.  No credit card required.

MyHallWizard

Sign up now for a 6 week free trial.  No credit card required.

Getting Started

  • Importing Customer Data
  • Importing Bookings
  • Set up Invoices and Payments
  • Sign Up for MyHallWizard
  • Create a new venue
  • What happens at the end of my free trial?

Customers and Bookings

  • Price Lists
  • How can I make repeat bookings every other week?
  • How can I make repeat bookings every other month?
  • How to book an event on the 2nd Thursday every month
  • Make a repeat booking for a customer on the 2nd and 4th Thursday of the month
  • Importing Customer Data
  • Importing Bookings
  • Can I send an invoice to a group treasurer instead of the main contact for my Customer?
  • Public calendars
  • Why can’t I send my email?
  • Deleting Customers
  • Calendar Settings
  • Enabling Booking Requests
  • Managing Booking Requests
  • Provisional Bookings
  • GDPR
  • Printing Reports

Invoices and Payments

  • Mark an invoice as paid
  • Can I send an invoice to a group treasurer instead of the main contact for my Customer?
  • Personalising your invoices for your customer
  • Set up Invoices and Payments
  • I accidentally invoiced a cancelled booking
  • Handling Overpayments
  • Credit Notes and Refunds
  • Deposits / Bonds
  • Invoicing
  • Printing Reports
  • Sales Taxes (VAT / GST)
  • Card Payments using Stripe

Configuration

  • Price Lists
  • Personalising your invoices for your customer
  • Set up Invoices and Payments
  • Create a new venue
  • Change the date format
  • Public calendars
  • How to delete a venue
  • Email Templates
  • Calendar Settings
  • Enabling Booking Requests

Managing your Account

  • Inviting users to your account
  • How to delete a venue
  • Managing your subscription
  • What happens at the end of my free trial?

Integrations

  • Export Invoices to Xero
  • RemoteLock
  • iCal feeds
  • Inspire Home Automation
  • Card Payments using Stripe

API

  • public-bookings
  • Home
  • Knowledge Base
  • Customers and Bookings
  • Importing Bookings

Importing Bookings

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.

HeadingMandatory / OptionalNotes
CustomerMandatoryName of the customer.

The customer must already have been set up in your system, and the name in your spreadsheet must exactly match the name on the Customer record. If you are importing bookings from your old system, you should therefore make sure you have imported your customers first.
NameMandatoryThis is the name of the booking as shown on the calendar.  Often it will be the same as the Customer name, but this does not need to be the case.
Booking DateMandatoryThis is the date of the booking.  Note that HallWizard cannot load bookings before 1 January 2019.
FromMandatoryThis is the start time of the booking
ToMandatoryThis is the end time of the booking.  It must be after the start time.
RoomsMandatoryThe names of the rooms being booked.  The names must match exactly the room names set up in your system.

If you are booking just one room, just give its name. If you are booking several rooms, separate each room with a comma (e.g. Main Hall, Side Room)
ExtrasOptionalThe names of any extras needed. The names must exactly match the extra names set up in your system. If several extras are needed, separate each with a comma (e.g. Projector, Use of kitchen)
PrivacyOptionalPrivate or Public. If no value is given, the booking will be public.
AttendeesOptionalThe number of attendees at this event.
DetailsOptionalThis is a detailed description of the booking displayed publicly in the calendar
Admin NotesOptionalThis column can be used for any notes you wish to keep on the booking, but which are not to be made public.  For example, you might want to make notes about any special arrangements you have made with the customer for this booking.
PriceOptionalThe price agreed with the customer for this booking.  Give this just as a number, not as currency.  For example, 13.50.

If you set Price to 0, then the booking will be marked “Do not invoice”. If you do not provide a value for Price, the system will calculate the price of the booking using the Price List which applies for the Customer.

Any additional columns in your spreadsheet, or columns with different heading names, are ignored.

Here is an example spreadsheet containing 3 bookings.  

CustomerNameBooking DateFromToRoomsExtrasPrivacyAttendeesDetailsAdmin NotesAgreed Price
Art GroupArt Group28/04/202014:0016:00Main HallProjector, Use of kitchenPublic15An agreed price of 12.00 will be placed on this booking12
Art GroupArt Exhibition09/05/202008:0019:00Main Hall,Side RoomUse of kitchenPublicThe Art Group are putting on an exhibition of their work at the Village Hall all day on Saturday 9 May.  Entrance £5 including catalogue.  Everyone is welcome.This booking will be marked as “Do not invoice” 0
Jack WintersYoga29/04/202016:3018:00Main HallPrivate10The price for this booking will be automatically calculated by HallWizard 

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.

Related #

Still stuck? How can we help?

How can we help?

Updated on 8 April 2022
Importing Customer DataCan I send an invoice to a group treasurer instead of the main contact for my Customer?
  • Home
  • Login
  • Sign Up
  • Contact
  • Support
  • Terms and Conditions
  • Privacy Policy
  • Cookie Policy
  • Service Status

© 2023 HallWizard Limited

HallWizard Limited. Registered in England and Wales, no. 12763234. Registered office: Office 9, Dalton House, 60 Windsor Avenue, London SW19 2RR

Manage Cookie Consent
We use cookies to optimize our website and our service.
Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Manage options Manage services Manage vendors Read more about these purposes
View preferences
{title} {title} {title}
  • Home
  • Features
  • Demo
  • Pricing
  • Contact
  • Support