Running a Lottery Pool in a Spreadsheet? Here's Where It Breaks

Most office lottery pools live in a spreadsheet: a tab for members, a tab for payments, maybe a column of ticket numbers typed in by hand. If that's your pool, this post is for you. Spreadsheets are a real upgrade over nothing, and we'll give you an honest starting layout. We'll also show you exactly where spreadsheets break, because the failure points are predictable.

A Decent Lottery Pool Spreadsheet Layout

If you're going to use a spreadsheet, structure it like this:

Members sheet: name, contact, date joined, standing notes.
One sheet per drawing (not one running sheet): date, jackpot, who paid and when, ticket numbers, a link to ticket photos, results per ticket.
Rules sheet: the agreed rules with a "last changed" date, including your split threshold, plus a signed paper agreement backing it up.

Per-drawing sheets matter because participation is per-drawing. A single running roster is how "I thought I was in" happens.

Where Spreadsheets Break

1. Anyone can edit anything, anytime

The spreadsheet's greatest strength is its fatal flaw. A cell edited at 9:14 PM, eleven minutes after the drawing, looks identical to one edited at 6 PM. When money is on the line, an editable record is barely a record at all. (Version history exists, but have you ever tried explaining Google Sheets revision history to an angry coworker?)

2. There's no cutoff

The rules say entries close before the drawing. The spreadsheet enforces nothing. The organizer becomes the human cutoff, which means the organizer personally tells a friend "you're too late," or quietly bends the rule and hopes this isn't the week it matters.

3. Typed numbers aren't tickets

A column of hand-typed ticket numbers has two failure modes: typos (checking 30 lines of digits is exactly the task humans are bad at) and trust (the numbers in the sheet aren't evidence of anything; only the physical ticket wins). Photos fix this, but now you're managing a spreadsheet plus a photo thread plus a group chat.

4. The record is scattered

Payments in Venmo, photos in a text thread, numbers in the sheet, rules in an email from 2024. When a dispute comes, assembling the story across four apps is the organizer's problem, under pressure, from people who used to be friends.

5. It all depends on one person

The sheet lives in one person's account and gets updated when they have time. Organizer goes on vacation during a jackpot run? The whole pool wobbles.

What the Fix Looks Like

Each weakness has the same root: a spreadsheet is a notebook, not a referee. It records what people say happened; it can't make anything happen. Purpose-built pool software flips that:

Members upload their own ticket photos: timestamped, visible to everyone, no typing.
The participant list and tickets lock automatically at the cutoff. Nobody has to be the bad guy.
Rules are consented to by every member before they can play, and re-consented when rules change. See how a live agreement works.
Results are checked automatically against every line of every ticket, and the split threshold is applied without anyone touching a calculator.

OfficeLotteryPools does all of the above, free, in the browser, with no app to download. Keep the spreadsheet for your fantasy football league, and give the lottery pool a referee.