Fantasy Football Draft Spreadsheet

By: Bryan Povlinski

If you do a fantasy football draft online on one of the major sites like Yahoo, ESPN, or CBS Sports you’ll have a lot of rankings and information at your disposal as you’re drafting. However, one of the frustrating things is that you really can’t see the makeup of all the other teams mid-draft without individually clicking to each one separately. It’s difficult to know how many of your opponents have already taken their quarterback or how many running backs the 2 guys ahead of you already have.

This tool allows you to see the makeup of every team on one spreadsheet. However, it does require you to manually enter in each pick as it’s made. It’s only as current as you’re able to keep it. It can be extremely helpful in making decisions based on scenarios that play out throughout the draft.

2017 Fantasy Football Draft Board (positional color coding, count of position per team)

Draft_Board

Here’s how to use the sheet:

1. Click File > Make a copy (which will save to your Google Docs/Google Drive account) and then you will be able to edit the sheet.

2. Prior to the draft you should fill out the tab labeled “Team Names, League Size, and Draft Order.” Everything highlighted in yellow should be customized to your league. You can change the team names to all of the team names in your league. Be sure to enter the league size as well. Then enter the draft order that your league has decided upon. You can erase team names that are beyond the size of your league (for example, if you only have 10 teams then just erase the names Team 11 and beyond).

3. When your draft starts you should begin to manually enter player names on the first tab labeled “Actual Draft Results.” I’ve entered some dummy data into the first round, but you should erase those names (in the yellow highlighted column…not under the team names) and enter in the players that you actually draft.

Update: Thanks to Huyck22, who commented below, the draft spreadsheet now has a color indicator for positions and a count for how many players at each position a team has drafted. I think it looks a lot nicer than the original and it really helps you get a good idea of what each team might do with their next picks. Also, I’ve found that it’s useful to have 2 versions of this spreadsheet open when you’re using it for a live draft. One to enter in the draft results and a 2nd (hopefully bigger screen) open to display the teams. Since you have to enter draft results into the same page as the teams you can do it all from one sheet, but you have to continually scroll up and down – having 2 sheets open prevents that hassle.