How to Build a Club Fixtures Spreadsheet That Actually Works

Every club has a fixtures list that lives in three places: a coach's notebook, a WhatsApp thread started in August, and the memory of whoever books the bus. By the middle of the season the three versions disagree, and someone turns up at the wrong ground.

A single shared spreadsheet will not win you the league. It does remove a whole category of small, avoidable chaos. Built well, it answers the questions people actually ask: where is it, what time is kick-off, what time do we meet, and who is driving.

One Row Per Fixture, One Tab Per Season

The unit of the spreadsheet is the fixture, not the team. Clubs running a first XV, a second XV, a colts side and a women's team often start with four separate sheets, then spend the season duplicating information that keeps changing — pitch allocations, referee appointments, coach bookings.

Put every team's fixtures on one master tab and add a Team column. Filters do the rest. One click shows the second XV's season; another shows every away trip in November. When the club needs to know whether three sides are at home on the same afternoon, that answer sits on one screen instead of three.

Dates should be real dates, not typed-out text. "Sat 12 Oct" looks fine until you try to sort the season, at which point April ends up above August.

The Columns That Earn Their Keep

Wide spreadsheets get ignored. Every column you add is one more thing to fill in badly, so keep the list tight and only add a field when at least two people will genuinely use it.

• Date — as a proper date value
• Team
• Competition (league, cup, friendly)
• Home or away
• Opponent
• Kick-off
• Meet time
• Venue, with postcode and pitch number
• Travel (own cars, minibus, coach)
• Departure time
• Referee, or who appoints them
• Opposition contact name and mobile
• Score, left blank until full time
• Notes

That last column deserves more respect than it usually gets. It is where "pitch 3, changing rooms at the far end" and "opposition short of a front row, borrowed two" belong.

Meet Times, Travel and Away-Day Detail

Kick-off is the least useful time on the sheet. Meet time is what players need, and meet time is decided by travel, not by the referee.

For home games, work backwards from kick-off — 45 minutes for strapping and warm-up, plus the usual faff. For away games, estimate the drive honestly, then add time for a coach that cannot park outside the ground and a squad that moves slowly. A Saturday morning with roadworks is not the moment to discover the buffer was imaginary.

Two habits worth building in:

• Record the postcode, not just the venue name. "University Sports Ground" can describe two sites three miles apart, and the one with your pitch is not always the one you pictured.
• Name a contact at the host club, with a mobile number. Pitch numbers change on the morning of the game, and so do kick-off times when a referee is double-booked.

Coach and minibus trips

For anything with wheels, departure time matters more than meet time. Note the pickup point, the person counting heads, and give the driver the postcode in writing rather than reading it out from a phone.

Formatting That Stops Mistakes

Twenty minutes on the bones of the sheet will carry it through a season. Freeze the top row. Turn on filters. Use dropdowns for the Team and Home/Away columns so nobody invents a third category halfway through October. Format the date and time columns consistently — one person types 3.00pm, another types 15:00, and mixed formats make a nonsense of sorting.

A touch of conditional formatting to highlight fixtures in the next seven days is genuinely useful. A rainbow of colour-coded rows is not. Protect the header row and lock any formula columns if your tool allows it; it takes one well-meaning edit to turn a sorted season into a shuffled one.

The best fixture spreadsheet is the one a captain can open on a phone in a car park.

Sharing Without Stepping on Toes

One owner. That is the rule that matters most. Usually it is the fixtures secretary or club administrator, with one or two others able to edit and everybody else reading.

If the sheet lives in a cloud tool, set permissions properly instead of emailing copies around. Two attachments called "fixtures final v3" is how clubs end up with three versions of October. Comments and suggestions handle corrections without anyone overwriting the original. A read-only link pinned in the club group is worth more than a weekly screenshot — people stop asking, and start checking.

Getting It Onto Phones and Calendars

Most people will only ever see the fixtures on a phone, often pitchside with one bar of signal. Check that the file opens in the mobile app and is available offline, keep the master tab narrow enough to read without scrolling sideways, and consider a filtered "This Week" view at the top of the sheet.

If your tool exports to CSV or an .ics calendar file, import the season into the club calendar once. Parents and second-team players then get their reminders without anyone typing the same information twice.

The Sunday Ten Minutes

Set aside ten minutes a week to keep it honest. Check the next fortnight, chase the two kick-off times still marked TBC, fill in weekend results, note any travel changes. Do that through the season and the spreadsheet stays boring — which is exactly what you want. Boring means everyone turns up at the right place, at the right time, in the right kit.

Photo: RDNE Stock project / Pexels