Appearance
Moving from a spreadsheet
Many clubs keep their members in one spreadsheet. You can use that spreadsheet to start. You email us the file. We do this with you, as part of the club setup. We bring the file in on your club's Bring members across page. You check each step. Nothing changes in your member records until you have seen what the import will do.
Who can do this?
Sending us the file and checking what came back: your club's Club Admin or Membership Manager. We run the import during onboarding. The page appears only after we switch it on for your club. Adding one person by hand afterwards: Club Admin or Membership Manager.
What comes across
Your roster comes across as member records, one record per person. Each record holds the detail that your file has for that person. This can include name, date of birth, gender, phone number, address and emergency contact. It can also include when they first joined and their parkrun ID. It can include their England Athletics registration number, or URN, where you have it.
Your file may not say when someone first joined. The import then leaves that date blank. It does not use the day of the import. Your joining figures then count only people who joined this year.
- Current members: we put each person into the membership year you choose. We use the membership type that your file gives them. This records the membership that they already have. It creates no invoice and no payment. They are ready to renew when the time comes.
- Lapsed and resigned members come across with that status and no membership. Your club keeps them. Renewals do not reach them.
- Families are grouped into households. One person can then renew for everyone.
The import sends nothing to anybody. It creates and updates records. It does not email your club. It creates no sign-ins.
How we match your file to the members you already have
Most clubs have already imported their England Athletics roster by the time the spreadsheet arrives. Many of the people in the file are therefore here already. We match each row first. Only a person we cannot find becomes a new member.
- By England Athletics number, then by name and date of birth. Suppose we match a row with confidence to a person from your England Athletics roster. The row then fills in that record. It adds the phone number, the address and anything else the record lacks. Their name, number and details stay as England Athletics has them.
- Anyone else we match has only their blanks filled. Where your file and their record disagree, we keep their record. You can ask us to use the file's values instead. We show you how many details that would change before you decide. We never overwrite a date of birth or an England Athletics number.
- Anyone we are not sure about: we hold the row for you. You decide if the row is this member, a new member, or a row to leave out. We also hold two rows that look like the same person.
Households work the same way. Where your file says who belongs together, we use that. Where it does not, we suggest groups. A group can be a junior with the adult whose email they share. It can also be people with the same surname at the same address. You accept or split each group.
What does not come across
- Sign-ins. Imported people have no account until you give them one. You choose when.
- Consents. The member app asks for consents once, at first sign-in, on your club's own current wording.
- Medical information. The import leaves out any column that looks like medical detail. Members add their own to their profile.
- Money already collected. A spreadsheet of who paid what is a record of the past. It is not a set of memberships. Your treasurer keeps it for the accounts. RunClub HQ starts from the membership year you set up.
- Anything nobody can explain. Suppose a column headed Status has six values and no key. We ask you what the values mean. We do not guess.
What to get ready before you send it
You do not need to reformat the file. It helps if you know what the file contains. A CSV file and an Excel workbook both work.
- Put everybody in one file, one row per person. Include juniors and anybody who has lapsed. Do not split the file into a sheet per membership type. We read only the first sheet.
- Give every column a heading, even if only you understand the heading.
- Check dates of birth. The import uses them to match each row to a member you already have. An approximate date of birth holds the row for you to decide, or makes a duplicate.
- Say which people are current. Most club spreadsheets list everyone who has ever been a member. Only your committee can tell us which of them are members now.
- Say who belongs with whom. Two parents and three juniors at one address are a household. A family number or a shared column saves you from confirming each household.
- Say what your codes mean. Examples are M/F/J, Full/Assoc/2C or a colour-coded cell. A two-line note is enough. We remember what each of your words means. A second file from the same system then uses the same meanings.
- Send us the file. Email it to the person who set up your club. Or attach it to a message through Getting help. If your file holds health information, tell us. We then agree how to send it.
If your club is affiliated to England Athletics, start there instead
England Athletics holds a cleaner list of your members than most club spreadsheets hold. It needs no file from anybody. See Getting your members in. Your spreadsheet is still worth sending afterwards. It is usually where the email addresses, phone numbers and households are. England Athletics does not share those.
Check the import before anything changes
Before the import writes anything, the page shows what it would do. It gives one sentence and then the detail row by row. The sentence says how many new members, how many England Athletics records filled in, how many existing members updated, in how many households, and how many memberships on which types. The page lists anything that needs you. The import cannot bring anything across while that list has items.
We go through the page with you. When the numbers look like your club, we choose the membership year to record the current members into. This is your current membership year unless you say otherwise. Then we bring the members across.
If something comes in wrong
You can undo an import while nothing depends on it. You can undo the whole file, or one row that was wrong. Undo deletes the members that the import created. It puts back what the import changed on the members you already had, down to their status.
You cannot undo an import once a person it brought across has had any of these happen since the import:
- They have been given a sign-in.
- They have paid, been invoiced or renewed.
- They have been merged with another record.
- Someone has changed their details or their recorded membership.
You also cannot undo the import for a new member who has since become part of anything else in the club. Examples are a check-in, a message or another member's emergency contacts. By then the import is your club's history. You correct a wrong detail on the member's record, as for any other member. The page says exactly which of these applies.
Undo closes after 30 days
We delete the file you sent as soon as its members are brought across. We delete our working copy 30 days later, because a club's member list is personal data. After that you cannot undo the import at all, as a whole or one row at a time.
What happens next
- Check the import. Check the number of members. Check a few names and a few dates of birth. This takes 10 minutes. It is the reason to import before you invite anybody.
- Import your Direct Debits, if your members pay through your club's own GoCardless account. See From GoCardless.
- Give out sign-ins, starting with your committee. See Running a pilot → Step 5. The email from your file is already filled in when you choose Enable login.
- Send welcome emails, in batches that you choose. See Bulk-welcome imported members.
What your members see
Nothing, until you decide. An imported person has a record and no account. They get no email, no notification and no sign-in.
When you are ready, you enable a sign-in for a person. That person gets an invitation. They follow the invitation and sign in with a link or a 6-digit code. They complete a short form with the details you did not have and the club's agreements. Then they are in.
Add one person by hand
To add a few people, you do not need us. Choose Members → All Members → Add Prospect to add one person. Use it for the three people who joined after you sent us the file. Do not use it to load a club.
See also
- Moving your club to RunClub HQ — all the arrival paths in one table
- Getting your members in — the England Athletics roster import
- From another membership platform — if the spreadsheet came out of a system
- Give an imported member a sign-in — recipe