Everyone knows Google Sheets: every parent, every coach, every treasurer. That is why clubs keep their roster there for years, until the first failure: a broken formula, an older copy in the hands of a new volunteer, dues paid and forgotten. This guide walks you through moving from a spreadsheet to club software in one weekend, without losing records and without making families sign up again.
Thursday: clean the sheet before you move it
An import carries over order, but it also carries over mess. One day of cleanup saves weeks of corrections.
Give each kind of data its own column. The mom’s phone number goes in “parent phone,” the shoe size in “shoe size.” Bring team names to one form: U12, u12 and “2014 boys” are often the same team in a sheet. Split siblings into separate rows, one player per row.
Do the cleanup with two people. One fixes columns, the other reads the numbers and spots oddities: a birth year of 1899, a phone number with nine digits, a team called “test.” The import would catch some of these, but then you lose an evening sorting errors from typos.
Before you export, do three more things:
- delete test rows and players who left two seasons ago,
- fill in birth dates, because without them you cannot sort players into age groups,
- merge duplicate names: two entries for one player means a double charge and a mix-up when a payment comes in.
Before exporting, save a copy of the sheet with the date in the file name, for example “roster-oct-25.xlsx.” The import does not delete the original. Keep the copy as a reference for the first weeks, when someone has to decide which version of the data was right.
Now export to XLSX or CSV.
Friday: create the club and load the roster
The club setup wizard asks for the club name, sport and basic details. It takes about ten minutes and no credit card.
Keep contacts to one rule: one guardian, one phone, one e-mail per row. Two parents with two numbers in one cell is the most common reason a message does not arrive. Add the second parent after the import, as a separate contact.
The import reads the core columns. Anything else goes into custom fields that your club defines.
| Column in your sheet | What the system does |
|---|---|
| first name, last name | a player record in the roster |
| birth date | age and age group |
| team | assigns the player to a team |
| parent phone, parent e-mail | a parent profile linked to the child |
| jersey size, uniform number | a custom field you define for your sport |
After the import, compare the counts. If the sheet had 512 rows, the roster should show 512 players. Then spot-check ten records: dates, teams, phone numbers. Pay attention to age groups, since they come from birth dates, and one typo in a date puts a child in the wrong group.
What the import does not recognize, you fill in the roster. Usually it is a dozen records, not half the club.
Saturday: carry over family balances
This is the biggest trap of a migration. Three years of payment history is thousands of entries, and matching them one by one is not worth it. In many clubs the bank statements have memos like “soccer fee,” a double space or two kids’ names squeezed into one line. Rebuilding that history is a project on its own.
So the rule is different. You do not carry over the payment history. You carry over the balance as of the day of the move: who has a credit of $100 (an example), who owes $60, who is at zero. Note a credit in the comments, and the first month’s charge will use it up.
Here is how to divide the work for that Saturday:
- enter each family’s opening balance, one family at a time, with a second person checking,
- keep the full payment history in the spreadsheet as an archive, for reference and for disputes,
- list families with an unclear balance and settle them before the first charges go out.
Enter overdue balances by hand. In a typical club it is a few dozen families, one evening of work. From then on, the coach sees a flag next to a name. The conversation belongs to the coach or the board. Nothing sends automatic collection messages.
Do not carry over old discount codes. The code for a player with a broken wrist expired with the cast. You can create new ones in the dues module in minutes.
Sunday: one message to all parents
Parents fear one thing: starting over. Answer that in the first sentence of your message. Then give specifics: when, where to log in, whether the fees change.
Hi everyone,
Starting Monday we manage registration, attendance and dues in one system.
We moved every player’s information over as it was. You do not need to create or fill in anything again.
Within two days each family will get a link to set a password. After you log in you will
see the practice schedule, event registration and your balance.
Fees and payment rules stay the same.
For the next two weeks we answer questions at [e-mail] and [phone].
[Club name] Board
Send the e-mail from the club address parents already know. Do not rely on it alone. In many clubs only a share of parents click a link on the first day. Confirm the change in person: the coach at practice, a flyer at the field, a post in the team group chat. After a week, send a second reminder by e-mail.
Track which channel gets logins and keep that one for the next announcement. For a monthly routine to use after the move, see club dues without spreadsheets.
The first two weeks: count logins and payments
The import takes hours. The rollout takes weeks. For the first fourteen days, watch these things:
- Day 1: count how many parents set a password. Under half? Send a reminder with the link.
- Week 1: run the first practice with attendance in the coach app and mark players on the spot.
- Week 2: check the first charges and the sibling discounts on two sample families.
- Every day: note fixes to the roster in one place: a wrong phone, a duplicate name, a team change.
The biggest risk of the first days is two lists side by side. The coach takes attendance in the app while the treasurer still reconciles in the sheet because it is more comfortable. Decide one thing: from the first charge, the spreadsheet is read-only.
Check sibling discounts on two families, one with two kids and one with three. If the second child pays $48 and the third $30 (example amounts), the system calculates it: how family discounts work.
How it works in SportDesk
Roster import from CSV or Excel is part of the Free plan, like everything except the club shop, SMS and the AI assistant. The wizard takes you through the club name and sport, then you upload the sheet. You compare the counts in the roster and enter family balances in the dues module. You record payments by hand, since card payments are coming soon. Parents then log in to the parent portal to see their children and balances. For larger clubs, write to us through the contact form and we will help prepare the data. Create your club in a few minutes.
Sources
- No legal claims are made in this post. Amounts and counts are examples.
This is not legal advice. The product statements above reflect SportDesk as of November 3, 2026.