Skip to content
UTX Web

For operators

Running a soccer league without spreadsheets

Published The UTX Web team

Lire en français

Most soccer leagues are run by a few volunteers or a small office, with a spreadsheet for each job. One for rosters. One for cards. One for standings. One for the schedule. It works until the season gets busy, and then the spreadsheets start to disagree with each other.

This post walks through where that breaks, and what a league week looks like when one system holds it all. It draws on more than ten years of running League Manager for soccer leagues.

Where the spreadsheets break

Rosters arrive as attachments

Each team manager sends a roster in their own format. Names are spelled three ways. Birthdates are missing. Someone in the league office retypes it all, and the same returning player ends up with two records.

Suspensions are worked out by hand

After every game day, someone reads the game sheets, counts yellow cards per player, checks the league’s rules, and works out who sits out next week. When the rules have exceptions, such as a double yellow, a red card, or a reset for the playoffs, the count gets harder and mistakes get easier.

A wrong suspension is not a small mistake. A player who should have sat out plays, and the result gets protested. A player who should have played sits out, and the team is angry with the league.

Standings wait until Monday night

Results go into one sheet, standings get recalculated, the top scorers list gets updated, and then all of it is copied to the website. By hand. Usually late.

Nobody notices the conflicts

Two games booked on the same field at the same hour. A player registered on two teams in the same division. A banned player back on a roster under a new team. A spreadsheet will hold all of these without complaint.

What changes with one system

The idea is simple: enter each piece of information once, where it comes from, and let everything else follow from it.

Team managers enter their own rosters

In League Manager, team managers get an account, by signing up or through an email invitation from the league. They pick their team from the league’s list, search for players who already exist in the league, add new ones, and submit.

The roster reaches the league office with its status. The manager can still change it until staff import it. Import takes one click: returning players are matched to their existing record, new players are created, and the roster is then locked for the manager. Staff can still build or fix a roster on a manager’s behalf when needed.

That one change removes most of the retyping, and most of the duplicate players.

The game sheet drives everything else

Staff enter each game sheet once: goals, assists, shutouts and cards per player. From that:

  • standings update,
  • the scorer, keeper, assist and points leaders update,
  • suspensions are calculated,
  • the public league site shows all of it.

Game sheets also print, for the referee and the bench.

Suspensions follow your rules

Every league has its own discipline rules. In League Manager they are set per league: how many yellows lead to a suspension, how it escalates, how red, white and black cards count, what happens in the playoffs. Each suspension shows the games to serve and the return game.

The discipline committee keeps the final say. Suspensions can be put under review, overridden, and annotated with internal notes. When a league changes a rule mid-season, the rule gets updated and the count follows it.

Conflicts get flagged before game day

Alerts flag games booked at the same time, players on two teams in the same division or league, and banned players on a roster. Fines tied to suspensions are tracked by team until they are collected. Referees are assigned to games, and staff shifts are scheduled by date, time and field.

Players check the site, not their phone messages

The public site shows standings, recent results, upcoming games, leaders, suspensions, team and player pages, and archives of past seasons, with search. It works on any phone, in French, English or both. The questions the office used to answer by message, like “when do we play?” or “is he suspended?”, are answered by the site.

You can see it running at ligueun.com.

Clubs have a different week

A club office spends its time on registration, not discipline: families, age groups, waiting lists, tryouts and payments that arrive in parts. We also built a separate registration and payments application for a youth club. Parents register their children online. Staff approve registrations, run tryouts and form teams. Receipts print with the club’s tax numbers.

What it does not fix

Software does not write your rules for you. A league that has never written down its suspension rules has to do that first, and that conversation is usually the most useful part of setting it up.

It also does not replace the people who run the league. It gives them back the evenings they spent copying numbers between spreadsheets.

Where to start

If you want to move off spreadsheets, start with two things: your discipline rules, written down, and last season’s rosters, in whatever shape they are in. That is enough to plan a setup.

Tell us how your season is organized, and we will show you how League Manager would handle it.

All posts

Recognize your week in this post?

Tell us how your operation runs today. If none of our products fits, we will say so.

Talk to the team that builds it

No setup fees. No contracts. Cancel anytime.

Or call
514-791-5584
Or email
rafal@utxweb.com