100% Free Download

Free Cricket Auction
Excel Template &
Player Draft Sheet

Prefer keeping it offline? Manage your cricket tournament player draft manually with our pre-formatted, formula-locked Excel spreadsheet template. Just enter bids, and the sheet does the rest.

Download Excel Template (.xlsx) Make a Google Sheets Copy
cricket-auction-template.xlsx Size: 42 KB · Version 2.1 (Astro Optimized)
Player NameCategoryBase PriceSold ToSold Price
Rahul SharmaAll Rounder₹5,000Warriors₹25,000
Rohit VermaBatsman₹5,000Titans₹25,000
Amit MishraBowler₹5,000Royals₹5,000

Inside the Excel Template

Automated Purse Calculators

Locked SUM and SUBTRACT formulas automatically deduct player purchase prices from the team's remaining budget. Prevents overdrawing wallets.

Squad Limit Counters

Real-time visual alerts highlight if a franchise exceeds the maximum squad limit (e.g. 15 players) or fails to meet the minimum player requirement.

Category Filters

Pre-configured filter drop-downs allow you to quickly sort players by their role (Batsman, Bowler, All Rounder, Wicket Keeper) or category pools.

How to Use the Template

  1. Step 1: Setup Franchise List: Open the sheet and navigate to the Settings tab. Enter participating team names and set the starting purse limit (e.g., ₹20,00,000 per team).
  2. Step 2: Add Player Registry: List all participating players in the Player Pool tab with their respective categories and base prices.
  3. Step 3: Run the Draft: As the auctioneer calls players on block, enter the winning bid under Sold Price and select the purchasing franchise from the Sold To dropdown menu.
  4. Step 4: Watch Wallet Sync: Roster sheets and wallet balances update instantly in the dashboard tab.

Tired of Manual Spreadsheet Updates?

Excel is classic, but single typos under auction room time pressure can break formulas. Try our Free Live Web Simulator which runs entirely in your browser with automated timers and text-to-speech audio, or upgrade to PlayBid for live mobile bidding!