Fantasy Football Draft Excel Spreadsheet 2019: The Ultimate Cheat Sheet to Win Your League
If you played fantasy football in 2019, you probably remember the rush of draft day: laptops open, highlighters uncapped, and a printed cheat sheet that was already outdated by Round 4. A fantasy football draft Excel spreadsheet 2019 solved that problem by putting rankings, average draft position, projections, and roster tracking into one flexible workbook. It was not just a digital list of names. It was a live command center that helped you react when running backs flew off the board and receivers you loved kept falling.
Even years later, that 2019 template still has value. You can use it to study old drafts, rebuild a retro league, or borrow the formulas and layout for a current season. The core ideas behind a strong Excel draft board do not expire: compare value against cost, group players into tiers, and know exactly how many starters you still need at every position.
Why the 2019 Fantasy Football Draft Excel Spreadsheet Still Matters
The 2019 NFL season had a unique fantasy landscape. Todd Gurley's knee concerns, Melvin Gordon's holdout, Ezekiel Elliott's contract situation, and Andrew Luck's sudden retirement all changed draft-day values. A well-built Excel spreadsheet allowed drafters to adjust projections on the fly instead of relying on a static magazine cheat sheet. The same principle applies now: news breaks, ADPs shift, and your draft board must move with the market.
Beyond that, 2019 was a turning point for accessible fantasy data. More sites offered downloadable projections, and Excel became a practical place to combine multiple sources. You could average rankings from ESPN, Yahoo, CBS, and FantasyPros, then add your own notes. That process created a personal draft board rather than a generic list that every league mate was using.
Understanding the 2019 Draft Landscape
In 2019, the top of most drafts was running back heavy. Saquon Barkley, Christian McCaffrey, Alvin Kamara, and Ezekiel Elliott often formed the first tier. McCaffrey exploded that season, but in August many drafters still debated whether he was a top-three pick in standard formats. A spreadsheet helped you separate public opinion from your own projections.
Wide receivers like Michael Thomas, DeAndre Hopkins, Davante Adams, and Julio Jones carried high floors. Tight end was top-heavy with Travis Kelce, George Kittle, and Zach Ertz, then fell off quickly. If your Excel board did not account for that positional cliff, you could miss the last elite tight end while reaching for a running back you did not need.
Creating a Baseline Ranking System
Start with a master player list and columns for team, bye week, position, projected points, ADP, and your personal rank. In Excel, you can use simple formulas like =AVERAGE(B2:E2) to blend multiple projection sources into one consensus number. Then sort by projected points or value-based score, not just name recognition.
Add columns for risk, upside, and notes. A 2019 example: Lamar Jackson was a late-round quarterback with rushing upside, while a safer pocket passer might have ranked higher in standard projections. Your spreadsheet could flag Jackson as a target if your league awarded four points per passing touchdown and bonus points for rushing yards. That kind of customization is where Excel beats a printed sheet.
Essential Components of a 2019 Excel Draft Board
A useful draft board needs more than rankings. It should track who has been drafted, which teams are on the clock, and what positions are disappearing. In a snake draft, your next pick can feel like an eternity away. A good spreadsheet shows you how many players at each position are likely to vanish before you pick again.
Build separate tabs for Rankings, Draft Board, Team Rosters, and Notes. The Rankings tab holds your cheat sheet. The Draft Board tab mirrors the actual draft order and updates as picks are made. The Team Rosters tab shows every team's roster construction, which helps you identify opponents who still need a quarterback or tight end. The Notes tab stores injury news, beat writer reports, and your own gut calls.
Value-Based Drafting and Tier Formulas
Value-based drafting, often called VBD, compares a player's projected points to a baseline starter at the same position. In a 12-team league that starts one quarterback, two running backs, three receivers, one tight end, and a flex, the baseline changes by format. Excel can calculate that baseline with formulas and subtract it from each player's projection to show true value.
For 2019, VBD often pushed running backs and elite receivers to the top because the gap between the RB1 and RB12 was larger than the gap between the QB1 and QB12. Tier formulas can make this even clearer. Use conditional formatting to color players in the same tier the same way. When Tier 1 running backs are gone, your board should visually tell you to pivot to wide receiver or tight end instead of reaching for a Tier 3 back.
Conditional Formatting and Scarcity Alerts
Conditional formatting turns a plain spreadsheet into an interactive draft assistant. For example, you can write a formula that highlights a player in green when his ADP is at least eight picks later than your current pick. That signals a potential value. You can also highlight players in red once fewer than three starters remain in their tier.
Scarcity alerts are especially useful during positional runs. In 2019, a run on quarterbacks in the middle rounds could push Patrick Mahomes, Deshaun Watson, and Aaron Rodgers off the board quickly. If your spreadsheet counted remaining Tier 1 and Tier 2 passers, you knew whether to grab one or wait for the next wave. Use COUNTIF and COUNTIFS functions to build those live counts.
How to Build and Customize Your 2019 Spreadsheet for Modern Use
You do not need advanced Excel skills to create a strong draft workbook. Start with a blank sheet, create an Excel Table for your player data, and freeze the header row so labels stay visible as you scroll. Use data validation for positions, teams, and draft status. Then add a few formulas for VBD, tiers, and roster counts. The goal is clarity under pressure, not spreadsheet perfection.
To modernize an old 2019 template, replace outdated projections with current data and keep the structure. The 2019 season is a historical reference, but the layout, formulas, and conditional formatting rules remain useful. You can also import ADP from a CSV file, paste it into a new tab, and use VLOOKUP or XLOOKUP to match players by name. That saves hours of manual entry.
Scoring Settings and Roster Requirements
Scoring settings change everything. A full PPR league inflates pass-catching running backs and slot receivers. Standard scoring rewards touchdown-heavy backs and deep threats. Superflex or two-quarterback leagues push passers into the first round. Your spreadsheet should have a scoring tab where you enter points per reception, passing touchdown value, and bonus rules, then calculate adjusted projections.
Roster requirements matter just as much. If your league starts three receivers and a flex, receiver depth becomes more important. If it starts only two receivers, running back scarcity may dominate. In 2019, Christian McCaffrey was a monster in PPR, while Derrick Henry's late-season breakout made him more valuable in standard formats. Excel lets you model those differences before your draft begins.
Mock Draft Tracking and In-Draft Updates
Use a mock draft tab to practice against your own board. Log every pick, compare it to ADP, and note where you panicked or waited too long. After a few mocks, patterns appear. Maybe you consistently reach for quarterbacks too early. Maybe you let elite tight ends slip. The spreadsheet exposes those habits without emotion.
During the real draft, update the pick number, team, and player name as selections are announced. Conditional formatting can strike through drafted players automatically. A pivot table can summarize each team's roster by position. When your pick arrives, you see not only the best player available but also how your roster is built and which positions are running dry. That combination of value and need is what wins drafts.
Take a proven 2019 Excel draft spreadsheet, strip away the outdated projections, and keep the engine underneath. The formulas, tiers, scarcity alerts, and roster trackers are still a powerful way to prepare for any fantasy football season. Build your own version, test it in a mock, and refine it until the workbook feels like second nature. When draft day arrives, you will spend less time scrambling for information and more time making confident picks.