Importing customers from a file
You find it under Customers. Click Import.
If the club has a list from before, you do not need to type in each person. The import recognises files from Spond, Matchi, KlubbAdmin, Rubic, Court22 and other lists, or the Clubify template. You can drop several files at once. Accepted file types are .csv, .xlsx and .xls.
How to do it
- Click Import under Customers.
- Drop one or more files. Clubify shows which source each file comes from.
- For each file you choose Members or Customers only. For Matchi you choose As in the file or Everyone is a customer.
- In the Check step you see Needs checking, memberships per plan and all persons. Rows without a membership you decide with a membership or Customer only. For each person you can switch between member and customer, and choose the membership.
- In the Import step you see what will happen before you confirm. Nobody gets an email, and nobody is charged.
The same person in several files becomes one customer. Clubify also checks whether the email or phone number already exists, see duplicates.
Dates and consent
The date in the file is used. If it is missing, the date follows the membership. If several rows have no date, you can choose one date for all of them. Photo consent is set only when you tick it.
Does the club have its member register in KlubbAdmin? Drop the export file from there, see the two membership system models.
If something goes wrong
If the file appears to have been imported before, Clubify warns you in the Import step. Check that you are not uploading the same file twice.
The file shows only empty rows. Check that the first row is column headings, not data.
A column is not read correctly. Use the Clubify template, or give the column the same name as in the template.