Appearance
Download your data
Your club's data belongs to your club. You can take a copy of it at any time. This page has two jobs: take a copy of the whole club, and answer one member who asks what you hold about them. Both jobs produce a zip file. Most of the zip file is spreadsheets. They open in Excel, Numbers, Google Sheets or any program that reads a CSV. Your written content and your uploaded files come out as files, not rows.
Who can do this?
Both jobs: Club Admin only. Treasurer and Membership Manager cannot do them. Taking every member, payment and result away in one file is not the same as working with them on screen. Only the small group who could close the club can do it. To add the health information of a member to their copy, you also need the emergency information permission. A Welfare Officer holds it.
Need a team sheet only?
The membership roster downloads on its own from the Members tab of the console. Filter it to the age categories and genders you need. See Members and households → Export the roster to a spreadsheet. More of your committee can do this than can take a copy of the whole club.
Take a copy of the whole club
Go to Settings → Download your data. Choose New export.
Choose the files that you want. Every file is ticked at the start. Untick each file that you do not need. A secretary who wants the roster for a mail merge does not have to download twenty years of event entries.
The export has thirty-one files. Twenty-eight of them are spreadsheets:
| File | What is in it |
|---|---|
| Members | Everyone on the roster, including juniors and prospects |
| Households | Who belongs with whom |
| Member addresses | Postal addresses, kept separate so the roster stays one row per person |
| Emergency contacts | Names, relationships and phone numbers. Not health information |
| Consents | What each member agreed to, when, and on which version |
| Membership years and fees | Your pricing structure for each membership year |
| Subscriptions | Current and past memberships |
| Invoices | Every invoice, its status and what it came to |
| Invoice lines | What each invoice was made up of, line by line |
| Payments | Every payment attempt, its status and its reference |
| Events | The whole calendar, with dates, places and prices |
| Event participations | Entries, check-ins and results |
| Club records | The record board, with holders and evidence links |
| Affiliations | England Athletics registrations for each membership year |
| Member notes | Notes the committee has written about a member |
| Communication preferences | What each person has asked to be sent, and not sent |
| Poll responses | Who answered which poll, and when |
| Renewals | How each household's renewal went, for each membership year |
| Prospect journeys | How somebody went from first enquiry until they joined |
| Refunds | Money returned to payers, with the reason and the date it settled |
| Payouts | Money arriving in the club's bank from the payment provider |
| Payment methods | What each member pays with, and their Direct Debit reference |
| Expenses | Claims made, and how each was approved and paid |
| Manual entries | Money in and out that the treasurer recorded by hand |
| Planned payments | What the budget expects to pay and receive, and when |
| Affiliation remittances | What the club has paid England Athletics |
| Finance categories | The category names the finance files refer to |
| Budgets | Each budget, line by line, with its membership assumptions |
The other three are your own words and files. They are described under what your website content looks like below.
| File | What is in it |
|---|---|
| Website pages | Every page of your website, as a Markdown file |
| News posts | Every news post, as a Markdown file |
| Documents | Your document library, as the original files, with an index |
What is in your data export lists every column in every spreadsheet. Somebody who has never seen our software can then read the spreadsheets years from now.
We prepare the file in a minute or two for most clubs. The page updates automatically. When the file is ready, the row moves to Ready to download.
Collect the file
Choose Download on the row. The Available until column shows the date when we delete the file. This is seven days after you asked for it.
We delete the file after seven days
This is on purpose. A zip file that contains your entire membership should not stay on our servers indefinitely. Download the file. Keep it in a place that your committee controls. Prepare a new file when you need one. There is no limit on the number of times that you can ask.
The row stays after we delete the file. The club can always see that someone took a copy, who took it, and whether anyone collected it.
Move the preferences before you email anyone
Communication preferences holds what each person has asked not to be sent, including mailing lists that the person has left. If a club moves to another system without this file, the club will email people who asked not to receive email.
What your website content looks like
Your pages, your news and your documents are not records. They do not come out as spreadsheets.
Each page and each post becomes a Markdown file. A Markdown file is a plain text file. It opens in any text editor and imports into most website software. Each file starts with a short block between --- lines. The block holds the title, web address, publication date and author. The writing follows.
Pictures come too, in a files folder. We rewrite the links inside each page to point at those copies. A page still shows its photographs after your old website has gone.
Some parts of a page are not fixed text
A visit to the page fills in some parts automatically: the next few events, the latest news and your membership prices. There is no wording to save for those parts. The file has a short note where each part was. The note says what the part showed. Nothing that you wrote is left out. Anyone who rebuilds the page can see where those parts belonged.
Your documents keep their original names and formats. A signed policy must still be that file. files/documents/index.csv says what each document is, which folder it was in, who looked after it and the date on the policy.
What is deliberately not in it
We never store passwords in a form that anyone can read, so we cannot export them. Sign-in codes and session records are security data. They are not club records. Health information is covered below.
Answer a member who asks what you hold about them
A member has the right to ask what data you hold about them. Open the record of the member from Members. Choose Download their data. You get a file to send to the member.
The file contains a summary page that the member can open in a browser. It is written for someone who is not on the committee. The same information is in spreadsheets behind it. The summary says what the club holds, how much of it, and what is absent on purpose. A member who reads nothing else still gets an answer.
The copy of the member also holds two things that the whole-club export does not hold: the messages that the club has sent to the member, and any support requests that the member has raised. Both are too large to be useful for a whole club. They are the right size for one person.
Every kind of record gets a file, including the kinds where the member has no records. An empty payments file shows that the club holds no payments for the member. A missing file can look like a mistake to a person who checks whether you answered correctly.
Money is recorded against the person who pays
We record invoices and payments against the person who paid. If a parent pays for a junior, those records are in the copy of the parent. They are not in the copy of the junior. The membership of the junior, and what it cost, are in the copy of the junior either way.
Include their health information
We leave out health information unless you tick Include their health information and give a reason. Health information means conditions, allergies, medications and emergency instructions.
This is the safer default for the common case, where a member asks what you hold. If a member asks for everything, tick the box. The file then contains the health information. In both cases the bundle tells the member that health information exists. It also tells the member if you included it. A member therefore does not think that you hold nothing.
The product records that you included it
The product records the tick in the same place as the reveal of health information on screen: who released it, when, and the reason that you typed. The member sees your reason on the summary page in their copy.
You need the same permission that you need to read that information on screen. A Club Admin who is not also set up for emergency information does not see the tick.
What we do, and what your club does
We provide the export. Your club decides what to keep, how long to keep it, and what to send to whom. Your club holds the data. A request from a member is yours to answer. If you are not sure how to respond to a request, ask for your club's own advice. We cannot answer it for you.
If you are moving to another system and want help to get the files into it, message us. We will do what we can with you.
You can read the same archive back in. This is how a club moves from one RunClub HQ to another. See Moving your club to RunClub HQ → From a club archive for what the archive reads today and what it leaves behind on purpose.
Troubleshooting
The download says the file could not be found
We deleted the file after its seven days. A member of your committee may have prepared it so long ago that it has expired. Prepare a new file. This takes a minute or two. Nothing is lost.
I cannot see Download your data in Settings
Only a Club Admin sees it. Ask the person who set up your club to give you the role, or to prepare the file for you.
An export is already being prepared
Your club can prepare one whole-club export at a time. Wait for the export in progress to finish. Then start another. Member data requests are not affected. You can answer one while a club export is running.
See also
- Activity log and platform usage: where exports and downloads are recorded
- Consents: what each member has agreed to
- Welfare officer: how health information is handled day to day
- What is in your data export: every file and column, explained
- Moving your club to RunClub HQ: the same files, read the other way