Auction Academy · Strategy
Fantasy football auction spreadsheet: record and check every sale
Use one master sale record with the player, club, winning manager and price. Add a separate manager summary for spend and squad places. Check the whole record before leaving the auction. A spreadsheet is useful for auction night; it does not prove that every row is ready for product import.
What should an auction spreadsheet record?
Nominate one recorder. Other managers can view the master sheet and keep their own planning notes. Give the recorder responsibility for entering confirmed sales. This avoids two different owners or prices appearing for the same lot. Keep planned valuations in a separate sheet so they cannot be mistaken for winning prices.
Separate sales from summaries
Use one row per sale. Record a stable player identity and current club from your reviewed player list. Names alone can be ambiguous. Match manager labels to the league's accepted members. Record the final price in one agreed unit, such as millions, and state that unit beside the column.
For each manager, show total spend, money left and occupied places. If a 14-player group has ten managers, the final record should contain 140 distinct player ownership rows. That is a checking example, not a required league size. Count the rows and distinct players separately: 140 rows containing a repeated player still leave somebody without a complete squad.
Reconcile a disputed sale
Suppose the recorder shows Player A sold to Manager Red for £12m. A manager's notes show £13m. Pause before the next sale. Ask the auctioneer and buyer to confirm the last accepted bid. Correct the master record, then recalculate Red's balance. Do not resolve the difference by creating a second sale row. Keep a short note of the correction so later checks can explain it.
At the end, read each squad and total while the group is present. Check the configured squad size, a legal XI, club limits, duplicate ownership and total spend. These checks prevent a transcription dispute becoming a season problem. Save the agreed final version separately from working notes.
Prepare the handover
Auction League accepts complete-squad CSV or pasted rows in its supported format. The source export uses Player,Club,Price,Manager. An auction workbook can also contain Position; this is not a reason to assume every workbook column is an import field. Use the current product template and preview.
A preview is a check, not an accepted squad. Resolve errors against the original sale record. Do not guess a similar player name or change a manager to make an error disappear. After acceptance, compare the recorded squads with the agreed auction version before managers make selections. The group still runs the bidding outside the product.
Next: read setup and organiser duties. Check your league's scoring and transfer rules before migration; a matching CSV format does not make an unsupported house rule available.
Common questions
Does a balanced spreadsheet prove the squad is valid?
No. Check player identity, unique ownership, configured squad size, positions and club rules as well as money.
Can two people record sales?
They can keep notes, but choose one master record and reconcile it before product entry.
Put the plan into practice
Read six real auction prices from our founding league.
Ready to bring your group? Run your auction, then enter the final squads in the app.
Create your league ↗