How To Create A Fantasy Football Draft Spreadsheet

This step-by-step tutorial shows you how to create a fantasy football draft spreadsheet in Excel. The video starts with how to import fantasy football stats into your Excel spreadsheet to make sure they are always up to date. Next the video prepares the data for analysis and demonstrates one way to analyze the performance data. The tutorial finishes with tips and tricks for keeping track of picks on draft day.

RESOURCES

📈 Practice workbook used in this video

🎥 How to download the practice workbook

⌚️ Timestamps
0:00 Intro
0:23 Data sources
0:46 Import data
1:30 Clean data
3:06 Analyze data
4:10 Develop conclusions
4:34 Tips keep track of picks
5:11 Thank you

SUPPORT

👍 If you learned something please give this video a thumbs up

🔔 Subscribe to my channel

🛒 Support me with your Amazon purchases

Disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.

[christiangiven]

Perfect timing Pete! Draft’s on Sunday night.

[joesymonds]

Legend! I spent ages looking for a way to do exactly this.

[jakemartin]

Great stuff here. Perhaps this year will be year I get to the championship…. with Pete’s help!

[benfithian]

Awesome, I used this video to help me put together my draft spreadsheet. I owe you a beer when I win ;)

[beccanolan]

Definitely gonna use this my next draft day! Thank you

[chrisdaman]

Man, you look like Tony Romo! Nice tut!

[carlynicolay]

This content makes me want to join a fantasy football team

[twodatnation]

You lost me at the V lookup part. Is there a link to how you built those out?

[KyleSorenti]

1st technological advancement in fantasy football since computers were invented

[courtalley]

Hello, is there a way to create a fantasy league if you've already chosen your players without having individual emails? Basically, I'm looking for something that you can put 10 players into a team, create 6 different teams, and then weekly check your points.

[Goldenlion]

how could I do this with ESPN existing rosters for a keeper league?

[billcolton]

Best way to split player's name? from last and first name?

[tacco]

Hey how can I do this for RBs WRs and TEs not just QBs

[billcolton]

Anyway you can redo this video, but with step by step instructions?

[mattscodellaro]

Now I know why it takes you so long to draft a player 😂