Loading
By Onkar Jadhav · 5 min read & download
Battle-tested spreadsheet layouts featuring automated purse subtraction, squad count validation, and unsold player sorting for organizers running offline auctions.
Each downloads as a .csv you can open in Excel, Google Sheets or Numbers. Figures in the sample rows are neutral points, so they work for any league.
Names, playing roles, contact details, set tier and the base price each player opens at.
Opening purse, spend to date and remaining balance, with a reserve check against squad size.
A running log of every lot: the bid, the winning team, the hammer price and unsold players.
Signed squads by team with total spend and a signature column for owner sign-off.
Excel is fine for preparing data before auction day. It struggles once bidding is live: one person types while everyone waits, a pasted cell can overwrite the formula that tracks a purse, and team owners cannot bid from their own phones.
Read the full comparisonYes. All four templates download as .csv files with no sign-up and no email required. Open them in Excel, Google Sheets, Numbers or LibreOffice.
In Google Sheets choose File, then Import, then Upload, and select the downloaded file. Choose "Replace spreadsheet" and Sheets will split the columns for you.
Remaining purse is opening purse minus spend. Add a reserve check that compares the remaining purse against the number of unfilled slots multiplied by the base price, so a team cannot spend past the point where it can still fill its squad.
A spreadsheet cannot take input from several team owners at once, lags when projected to a screen, and loses its formulas the moment somebody pastes over a cell during live bidding.