Adding members or importing a spreadsheet

Put people on your member list straight from your own records, without sending anyone an invitation: add one member on a single form, or import your whole register from a spreadsheet. Both can record your club's own member fields (club fields) too.

Members you add or import exist straight away, with their profile and club fields, whether or not they ever sign in. They have no Horsify login until they create an account with the same email, and then Horsify links the two. To bring someone in who will use their own account from the start, invite them instead (Inviting members by email). You can mix all three ways freely.

On this page

Before you start

  • Your organisation needs an active Horsify plan: Basic, or a plan such as Club Site, Club Site Premium or Riding School. Without one, the Members page shows Subscription Required. Basic is priced by how many active members you have, so importing a large register can move you into the next band. See Horsify plans and prices.
  • You need to be an admin, or staff with Members and volunteers at Manage. Staff at View see the list but not the Add member and Import buttons. See Staff access: who can do what.
  • If you help run more than one organisation, choose it under Switch in the organiser menu first.
  • To match a "membership type" column to a priced tier, set up your membership types first (Setting up memberships: fees, add-ons and numbers).

Add one member

  1. Open People → Members and click Add member.
  2. Fill in the form. First name and Surname are required; everything else is optional. The fields are listed below.
  3. Click Add member. The member is created at once and shows on your list.

If the email you entered already belongs to a member of your club under a name that could be the same person, Horsify stops and tells you they are already a member, so you can open and renew their existing membership instead. A different name on the same email (a family sharing one address) is allowed.

Member details

Field Notes
First name, Surname Required.
Email Used to link the person when they create a Horsify account.
Membership number Leave blank to have one generated (when your club generates numbers). Otherwise enter your own.
Membership type One of your active membership types, with its price beside it.
Status Active, Pending, Expired or Cancelled. Starts on Active.
Date joined The membership start date.
Membership expiry When the membership lapses.
Club administrator Tick to make this member an admin of your organisation. Only an admin can save this tick. On a remembered device, Horsify asks for a verification code before it makes someone an admin.

Contact and profile

These are saved on the member's rider profile, the details Horsify fills in on event entry forms: date of birth, phone, street address (two lines), suburb or town, state, postcode, emergency contact name and phone, medical information, and Property Identification Code (PIC).

Club fields on the form

Any club fields you have set up appear here, so you can fill them in at the same time. Fields that copy themselves from the rider profile aren't repeated here.

Import a spreadsheet

Click Import on the Members page. The wizard has four steps: Upload → Map columns → Review → Done. Nothing is saved until you click Import on the Review step, so uploading and mapping are safe to explore.

  1. Upload: choose a .xlsx or .csv file of up to 10 MB. Horsify reads every worksheet, finds the header row itself (skipping title rows above it), and drops blank and junk rows.
  2. Map columns: Horsify guesses what each column is from its heading and shows the spreadsheet column, some sample values and what it will import as. Change any that are wrong. If the file has several worksheets, pick one with the Sheet selector at the top; switching re-guesses the mapping. A note under the table says how many new club fields will be created.
  3. Review: check the rows (see the badges below). Change any row's Action to Create, Update or Skip, then click Import.
  4. Done: Horsify shows how many members were Created, Updated and Skipped, and how many new club fields it made. Rows that failed are listed so you can fix and import just those.

Each column can be imported as:

  • Don't import.
  • A member field: First name, Surname, Full name, Email, Membership number, Membership type, Role, Date joined, Date resigned, Membership expiry, Payment confirmed, Notes, Date of birth, Phone, Address line 1, Address line 2, Suburb / city, State, Postcode, Emergency contact name, Emergency contact phone, Medical info, or PIC (property code).
  • An existing club field.
  • ➕ New club field: makes a new club field named after the column heading.

On the Review step each row shows its number, name, membership number, type and status, with a badge:

Badge Meaning
New No existing member matched; a new member will be created.
Update Matched an existing member, whose record will be updated. For a member with their own login, or a child on a family account, only their membership with your club changes.
Duplicate Repeats another row in the same file.
Error Can't be imported, for example a row with no name.

Rows worth checking carry a warning, such as a membership type that matched none of yours or a suspected duplicate.

A large register is imported 100 rows at a time, and the button shows progress (Importing… 300 of 600). If part of it fails, the summary names the rows left out so you can import just those again. Only an admin can import a change to the role, status or resignation date of an admin or someone with staff access.

How rows are matched to existing members

  • A row is matched by membership number first; then by email, when the name could be the same person ("Sam" still matches "Samantha"); then by name, ignoring case and extra spaces. A match is an Update; otherwise the row is New.
  • Members who joined through Horsify (the join form, an invitation, signing up) are matched by the name on their own profile, so importing your register after they joined doesn't add them twice.
  • A row matched by email or name shows who it matched. If that's a different person, change the row to Create.
  • A row sharing an email with an existing member under a different name stays New (families share addresses) but is flagged with that member's name. If it is the same person under another name (a married name, say), choose Skip and update their record instead.
  • The membership type is matched to your active types, exactly first and then closely. If nothing matches, the text is kept in the member's Notes so you can sort it out later.

The importer also understands:

  • Blanks, N/A, nil, none, -, TBC, TBA, unknown and ? as empty.
  • Dates are accepted as real dates, Australian day-first dates (e.g. 3/04/2007 = 3 April), or a bare year (2024 is read as 1 January 2024).
  • A "payment confirmed" column as Paid when it says yes or paid, or holds a date.

An import can't change the personal details of a member who has their own login. For a member with their own Horsify account, or a child on a family account, an Update row changes only their membership with your club. Their phone, date of birth, address, emergency contact and medical notes are shared with every club they belong to, and their phone can be used to sign in, so they keep those up to date themselves. Members you added or imported, with no login, are updated in full.

Club fields: your own member fields

Club fields are the member fields your club defines beyond Horsify's own: Horse Registration No., Committee Role, Working-with-Children Check. They show on every member's Club fields panel, and both the Add form and the import can fill them.

Making club fields from a spreadsheet. A column imported as ➕ New club field becomes a field on your organisation's Member Profile template (Horsify makes the template the first time it's needed). When Horsify suggests the new field itself, it guesses the type from the sample values: dates become a Date field, yes/no values a Checkbox, anything else Text. A column you switch to ➕ New club field yourself becomes a Text field. After the import the fields are part of the template and can be edited on any member, like fields you made by hand.

Fields that depend on other answers. The Member Profile template is edited in the same form designer as your entry forms, so it has a Logic tab. A rule can show, hide or require a club field depending on another (Working-with-Children Check number only when Committee role is filled in). Rules apply on the Add member form and each member's Club fields panel; a field a rule hides is not checked and not saved. The import doesn't apply rules: it writes the columns you mapped. See Building an entry form.

Fields copied from the rider's profile are read-only. A club field set to fill itself from the rider's Horsify profile (a "Date of Birth" field linked to the profile's date of birth) always shows the profile's value. It isn't editable on the Add form, and the import skips it. To change it, change the profile field (date of birth, phone, address and so on).

When imported members create an account

Until they sign up, members you added or imported show a No Horsify account badge on the list. When one of them creates a Horsify account with the same email, Horsify:

  1. Links the member record to the new account.
  2. Hands the profile you recorded to that account, so the date of birth, address and emergency contact you imported carry across instead of the person starting with an empty profile.

Some of the people you add may already have an account. As soon as you add a member or finish an import, and again overnight, Horsify links each record whose email and name match a confirmed Horsify account. A record it can't be sure of (a different name on the account, a shared family address) stays unlinked; open the member and save to link it yourself. See How member records link to riders' accounts.

Tip: Include an email column in your import, and an email on the Add form, whenever you have one. It's what lets Horsify join an imported member to the account they create later.
Important: Give each person their own email address. Families often share one, and a shared address makes trouble later: when one of them creates a Horsify account, every member record carrying that email links to their account, children's records included. Where a child has no address of their own, record them as a dependant under the parent rather than as a separate member row on the parent's email.

Questions and answers

Is it safe to import the same register again?

Yes. Existing members are matched and offered as Update, so you can import a corrected file without making duplicates. Set rows you don't want to touch to Skip.

Someone is on my list twice. What now?

The Members page shows a possible duplicates link under the toolbar. Mark each pair Not the same person, or Ask Horsify to merge them. See Your member list.

Will Horsify number the members I import?

Only when your club has automatic numbering on and the number is left blank. Your own numbers are kept as they are.

Can PaperSync create members from paper forms?

No. PaperSync reads scanned paper pages but doesn't create members, so add those members here.

Related guides


Still need a hand? Open the Help bubble at the bottom of any Horsify page to ask a question or send us a message, or email support@horsify.com.au.
More guides on this topic: Members and volunteers.
Tags
Setting up memberships: fees, add-ons and numbers
Inviting members by email