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

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

Customers and Bookings

  • Printing Reports
  • GDPR
  • Provisional Bookings
  • Managing Booking Requests
  • Enabling Booking Requests
  • Calendar Settings
  • Public calendars
  • Deleting Customers
  • Importing Customer Data
  • Importing Bookings
  • 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
  • Why can’t I send my email?
  • How can I charge different prices for some customers?
  • Can I send an invoice to a group treasurer instead of the main contact for my Customer?

Invoices and Payments

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

Configuration

  • Enabling Booking Requests
  • Calendar Settings
  • Create a new venue
  • Set up Invoices and Payments
  • Public calendars
  • Email Templates
  • Change the date format
  • Personalising your invoices for your customer
  • How to delete a venue
  • How can I charge different prices for some customers?

Managing your Account

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

Integrations

  • Export Invoices to Xero
  • RemoteLock
  • iCal feeds
  • Inspire Home Automation
  • Home
  • Knowledge Base
  • Customers and Bookings
  • Importing Customer Data

Importing Customer Data

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.

HeadingMandatory / OptionalNotes
NameMandatoryName 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 NameMandatoryContact 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!)
CategoryOptionalThe 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)
EmailOptionalMust be an email address.
PhoneOptional
Address Line 1Optional
Address Line 2Optional
TownOptional
CountyOptional
PostcodeOptional
CountryOptional
Do Not InvoiceOptionalMust 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 NameOptionalIf 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 EmailOptional
Invoice PhoneOptional
Invoice Address Line 1Optional
Invoice Address Line 2Optional
Invoice TownOptional
Invoice CountyOptional
Invoice PostcodeOptional
Invoice CountryOptional
Price ListOptionalThis 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.
CommentsOptionalThis 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.

NameContact NameCategoryAddress Line 1Address Line 2TownCountyPostcodeCountryEmailPhoneDo Not InvoiceInvoice Contact NameInvoice EmailInvoice Address Line 1Invoice TownInvoice PostcodePrice ListComments
Art GroupJessica EllisCreativeStudio 525 Elliot GroveKingportNorfolkNR8 2JJUnited Kingdomjellis@example.com01545 21526FALSEStandard RatesThe Art Group uses the main hall and the kitchen.
Tidy Village CampaignSam SmithPolitical/Lobby Groupssmith@yoga4you.org.ukTRUE
Joan PeacockJoan PeacockPersonal6 Church CottagesTavernhamNR8 9JD01545 657895Frank Brownf.brown@example.com23 Acacia GardensTavernhamNR8 7ASResidents 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.

Still stuck? How can we help?

How can we help?

Updated on 16 September 2021
Deleting CustomersImporting Bookings
  • Home
  • Login
  • Sign Up
  • Contact
  • Support
  • Terms and Conditions
  • Privacy Policy
  • Cookie Policy
  • Service Status

© 2022 HallWizard Limited

HallWizard Limited. Registered in England and Wales, no. 12763234. Registered office: 2nd Floor, 2 Woodberry Grove, London N12 0DR

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