fantasy football excel spreadsheet 2018

Ultimate Fantasy Football Excel Spreadsheet 2018: Dominate Your Draft with Pro Rankings

By Laura Thomas
AD

If you played fantasy football in 2018, you probably remember the season as a turning point: Patrick Mahomes exploded for 50 touchdown passes, Todd Gurley dominated before a late-season knee issue, and rookie Saquon Barkley looked like a generational talent. Thousands of managers turned to a fantasy football Excel spreadsheet 2018 to organize rankings, calculate auction values, and track draft-day picks. Excel gave them something a basic cheat sheet could not: total control over scoring settings, tiers, and roster construction.

Even years later, a 2018 fantasy football Excel spreadsheet remains valuable. It can help you study historical ADP, rebuild a retro league, or understand which late-round picks actually won championships. Whether you are recreating the 2018 season for a best-ball draft or comparing old projections to real outcomes, a well-built spreadsheet turns raw stats into actionable insight. The sections below explain why the 2018 spreadsheet format still matters and how to build or refine one for yourself.

Why the 2018 Fantasy Football Excel Spreadsheet Still Matters

The 2018 NFL season was a high-octane year for fantasy scoring. Mahomes and Andrew Luck returned elite quarterback production, while running backs like Gurley, Alvin Kamara, Christian McCaffrey, and Barkley made early picks incredibly valuable. A generic rankings list could not account for your league’s unique scoring, roster limits, or trade tendencies. The 2018 fantasy football Excel spreadsheet solved that by letting managers adjust projections on the fly and weigh positional scarcity against their own league rules.

AD
Fantasy Football Tracker Excel Spreadsheet | Draft, Rankings, Matchups (Digital Download)
Fantasy Football Tracker Excel Spreadsheet | Draft, Rankings, Matchups (Digital Download)
Printable Fantasy Football Draft Chart and Form - PDF & Excel
Printable Fantasy Football Draft Chart and Form - PDF & Excel
the fantasy football ranks sheet for each team
the fantasy football ranks sheet for each team

Search demand for archived 2018 templates persists because historical data is useful for more than nostalgia. You can compare 2018 preseason ADP to actual finish, identify which analysts were right about breakout players, and test draft strategies like zero-RB or late-round quarterback. Excel also preserves that data in a format you can sort, filter, and chart. That makes the 2018 spreadsheet a small time capsule for fantasy football strategy.

Historical Scoring Trends from 2018

In 2018, the top fantasy seasons came from players who combined volume and efficiency. Mahomes threw for over 5,000 yards and 50 touchdowns, while Gurley scored 21 total touchdowns in only 14 games. Barkley racked up over 2,000 scrimmage yards as a rookie, and DeAndre Hopkins caught 115 passes for 1,572 yards and 11 scores. A 2018 fantasy football Excel spreadsheet can hold weekly game logs for each player, making it easy to calculate consistency, boom-bust rate, and playoff performance.

a poster with the names and dates for various events
a poster with the names and dates for various events
Sort the League Money Before GW1 — Fantasy Football Mini League Tracker
Sort the League Money Before GW1 — Fantasy Football Mini League Tracker
Fantasy Football Draft Cheat Sheet Printable
Fantasy Football Draft Cheat Sheet Printable

Positional scarcity was also extreme that season. Travis Kelce, George Kittle, and Zach Ertz separated themselves at tight end, while the running back position saw a clear top tier before a steep drop-off. By entering 2018 stats into Excel, you can calculate value-based drafting scores, replacement-level points, and points above replacement. Those calculations show why grabbing Gurley or Barkley early felt mandatory, and why waiting on a quarterback until Mahomes’ ADP rose became a winning strategy.

Building a Custom Draft Board in Excel

A custom 2018 draft board should start with columns for rank, player name, team, bye week, ADP, projected points, auction value, tier, and notes. You can add data validation to create drop-down menus for positions and conditional formatting to color-code tiers. If your league uses 0.5 PPR or 6-point passing touchdowns, you can create a separate scoring tab and link it to your projections. That flexibility is exactly why the fantasy football Excel spreadsheet 2018 approach still appeals to serious managers.

AD

Once the structure is in place, use VLOOKUP or INDEX/MATCH to pull stats from a separate data sheet. Freeze the header row, enable filters, and sort by projected points or ADP. For draft day, you can keep a “Drafted” column with checkboxes and use conditional formatting to gray out unavailable players. Many 2018 templates also included a separate auction tab that calculated inflation and remaining budget after each nomination. That level of customization kept you from reaching for a player who did not fit your build.

Interaktives Fantasy-Football-Draft-Sheet - Übersichtsblatt - Teamaufstellung - Fantasy-Football-Vorlage zum Ausdrucken - Digital
Interaktives Fantasy-Football-Draft-Sheet - Übersichtsblatt - Teamaufstellung - Fantasy-Football-Vorlage zum Ausdrucken - Digital
Printable Fantasy Football Draft Board - FREE
Printable Fantasy Football Draft Board - FREE
Fantasy Football Excel Templates 13 Fantastic Vacation Ideas For Fantasy Football Excel T...
Fantasy Football Excel Templates 13 Fantastic Vacation Ideas For Fantasy Football Excel T...
Poster: Fantasy Football 10 Team Draft Board, 34x22in.
Poster: Fantasy Football 10 Team Draft Board, 34x22in.
an image of a table with numbers and words on the clock like a good nabers
an image of a table with numbers and words on the clock like a good nabers
the table for each team's roster and their positions in which they are playing
the table for each team's roster and their positions in which they are playing

Key Features of a Winning 2018 Fantasy Football Excel Spreadsheet

Not every spreadsheet is built for winning. A strong 2018 template combines projections, ADP, league scoring, roster requirements, and playoff schedule analysis in one workbook. It should be dynamic enough to update when news breaks, such as a suspension, trade, or injury. During the 2018 preseason, Le’Veon Bell’s holdout and injuries to players like Jerick McKinnon changed draft boards overnight. A spreadsheet with flexible formulas helped managers react faster than those relying on static PDFs.

The best 2018 fantasy football Excel spreadsheets also included a draft tracker, tier-based rankings, and a strength-of-schedule tab. Some advanced versions used macros to automate pick entry or calculate auction inflation. Even if you prefer simple formulas, the goal is the same: reduce manual errors and make split-second decisions easier. When every pick matters, a clean interface and accurate formulas can be the difference between a playoff berth and a last-place finish.

AD

Player Projection Formulas and VLOOKUP Tricks

Projection formulas in Excel can be as simple or complex as you want. Start with columns for passing attempts, completions, yards, touchdowns, interceptions, rushing attempts, rushing yards, receptions, receiving yards, and total touchdowns. Then apply your league’s scoring rules with a formula like =PassYds*0.04 + PassTD*4 - INT*2 + RushYds*0.1 + RushTD*6 + Rec*1. For 2018, you can pull historical stats from Pro-Football-Reference or another trusted source, paste them into a data sheet, and let Excel do the math. This removes bias and keeps every player on the same scoring scale.

Fantasy Football 101 COMPLETE BUNDLE | Classroom League + 2026 NFL Statistics |
Fantasy Football 101 COMPLETE BUNDLE | Classroom League + 2026 NFL Statistics |
a spreadsheet showing the number of items in each column
a spreadsheet showing the number of items in each column
Kit de draft Fantasy Football 2026 | Tableau de draft en direct, antisèche PPR (Excel, Google Sheets)
Kit de draft Fantasy Football 2026 | Tableau de draft en direct, antisèche PPR (Excel, Google Sheets)
the fantasy football team sheet is shown
the fantasy football team sheet is shown

VLOOKUP is useful when your player names are in the first column of a data table. For example, =VLOOKUP(A2, Stats!A:Z, 12, FALSE) can pull projected receiving yards for the player in cell A2. However, VLOOKUP breaks if you need to look left or if a player name has a typo. INDEX/MATCH is more flexible: =INDEX(Stats!Z:Z, MATCH(A2, Stats!A:A, 0)). Wrap either formula in IFERROR to show a blank or zero instead of an ugly error. These tricks make your 2018 spreadsheet reliable even when you add rookies or rename teams.

Schedule Analysis and Playoff Matchups

The 2018 fantasy playoffs took place in Weeks 14, 15, and 16 for most leagues. A winning spreadsheet should isolate those weeks and color-code matchups based on opponent defensive strength. You can calculate average fantasy points allowed to each position, then rank players by their playoff schedule. In 2018, the Chicago Bears’ defense emerged as a fearsome unit, while the Jacksonville Jaguars declined from their 2017 dominance. Those shifts mattered when deciding between two similarly ranked players.

AD

Use Excel to sum projected points for Weeks 14 through 16 and compare that total to a player’s full-season average. You might find a receiver with a tough early schedule but a soft playoff path, making him a buy-low trade target. You can also add columns for home/away splits and prime-time performance if you want extra nuance. In 2018, managers who weighted playoff matchups correctly often gained an edge in December. A dedicated schedule tab turns that edge into a repeatable process rather than a gut feeling.

If you are revisiting 2018 for a retro league, a historical draft study, or simply to sharpen your Excel skills, start with a clean template and customize it to your scoring system. Add your own notes, build a few charts, and test formulas against real 2018 results. The more you work with the data, the more you will notice patterns that still apply to modern fantasy football. A good spreadsheet never goes out of style, even if the players and ADPs change.

AD