ℹ️ Beta: Grading is currently in beta and is only switched on for a small group of clubs while we test it. If you'd like to try it, click the chat button at the bottom of your screen to speak to our team.
To upload your members' grades, open Settings > Grading and, on the Current grades step, click Upload from a spreadsheet. Download your contacts, add each member's grade, then upload the file.
Before you start
- You need to be an owner, or a manager with Access settings.
- Your members need to be in ClubRight already. The upload doesn't add anyone.
- The step and buttons use your word for a grade, so Current grades may read Current belts or Current stages.
Step-by-step
- Open Settings, click Grading. Set-up opens where you left it.
- On Current grades, click Upload from a spreadsheet.
- Click Download your contacts. You get your current members (active or frozen membership) who have an email and no grade in this syllabus yet.
- Fill in Grade for each person, for example "Blue Belt" or "Stage 3". Add Stripes and Date of grade if you have them.
- Under Ready for next grade, put Yes for anyone who's done what they need for their next grade, or No for anyone who hasn't.
- Save it as CSV, choose it under Upload it, and click Upload.
- Check the list. What happens shows what each row will do. Nothing's saved yet.
- Click Save.
Using your own spreadsheet
Save it as CSV with these columns:
- First name, Last name and Email, as they are in your contacts
- Grade, for example Blue Belt or Stage 3
- Stripes, 0 to 12 (optional, martial arts only)
- Date of grade (optional)
- Ready for next grade (optional): Yes or No
Or click Download a template. It has an example row for each of your grades, spelt the way the upload reads them. Replace the example rows with your members. Any left in are skipped.
What to expect
- Only people already in your contacts get a grade.
- Anyone who already has a grade keeps it. Their row says it's left as it is.
- No date of grade? The grade counts as held for six months. You can change it on their profile.
- Yes under Ready for next grade counts their classes, skills and sign-off for their next grade as done. They show as Ready once they've held their grade long enough. After their next grading, ClubRight counts everything itself.
- No counts their classes from their date of grade, and you sign off their skills as normal.
- Left blank, they show as Check until you've looked at them. Sign off their skills, or grade them, as you would anyone else.
- The file can be up to 1 MB.
Troubleshooting
If a row says "Not in your contacts"
Check the name and email match their profile exactly.
If a row says "Two contacts have this name and email"
Set that member's grade by hand on Current grades.
If you see "That file couldn't be read as a CSV"
In Excel, use Save As and pick CSV.
If a grade doesn't match
Spell each grade exactly as it is in your syllabus. "Blue", "Blu" and "Blue Belts" won't match "Blue Belt", and "Stage3" won't match "Stage 3". Grades that don't match are listed on Current grades to set by hand.
Moving to ClubRight?
If your members aren't imported yet, send their grades with your member data. See Migrating to ClubRight from another platform.
Have more questions about grading? Click the chat button at the bottom of your screen to speak to our team.