How to Make a Fantasy Baseball Spreadsheet

The Complete Guide to Advanced Research in Daily Fantasy Baseball
4.0 (16 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
47 students enrolled
73% off
Take This Course
  • Lectures 26
  • Length 1 hour
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2016 English

Course Description

A step-by-step guide on how to build a Fantasy Baseball Spreadsheet.  Learn how to import stats automatically every day.  You will have batter's stats based on the pitcher they are facing, pitcher's strikeout percentage, projected runs, and more! You will learn how to color code stats to easily see great plays.  There is also a lineups page where you can easily compare lineups for the day!  The Fantasy Basketball course was taken by hundreds of students, in 48 different countries.  Daily Fantasy Baseball brings a millions stats to look at. This spreadsheet will immediately speed up your research.  Save time and take your Fantasy game to a professional level with this easy to follow guide!

What are the requirements?

  • A computer, any computer.
  • No need to buy any software, it's free!

What am I going to get from this course?

  • Learn how to import stats automatically.
  • Color coding stats to instantly see great plays
  • Build a Lineups Page to easily compare different players.

Who is the target audience?

  • All Fantasy Baseball Players!
  • Players with limited time for research.
  • Players that want to take their game to a professional level.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: Introduction

A quick look at what your finished spreadsheet will do.

Section 2: Starting the Spreadsheet

How to start your Google Spreadsheet.  Then exporting the players for the day from DraftKings.

Position Pages

What you came here for!  This is the equation needed to import stats automatically for you every single day!

Section 3: Today's Starting Pitchers and Vegas Odds

Get every Starting Pitcher for the day automatically imported into your spreadsheet.


Using player I.D. numbers is much more accurate than using a player's name.  It can be Jon one place and Jonathan another.


This will get you the day's schedule and the Vegas Projected Runs for each team.

Section 4: Batter Matchup
Batter facing Left or Right Handed Pitcher

Each batter's wOBA vs left or right handed pitchers, depending on who they are facing that day.  wOBA is a great stat to use for Fantasy Baseball.  FanGraphs has a great explanation of it in the attached link.


The ISO for each batter vs left or right handed pitchers, depending on who they are facing that day.  ISO is a great stat to measure power and extra base hits (UPSIDE).  FanGraphs has a detailed explanation in the attached link.


The projected runs for each batter's team.

Conditional Formatting
Section 5: Starting Pitchers

Get today's Starting Pitchers to the SP page.


Each Starting Pitcher's team and player I.D.


Automatically get the throwing hand for each starting pitcher and the projected runs.


Another great stat for pitchers.  Strikeouts per 9 innings pitched.

Conditional Formatting SP Stats
Section 6: Lineups Page and Making an Easy Template

Bringing it all together to make dominant lineups!  Just copy and paste the lineups page from and you will easily be able to compare different lineups during your research.


After your Blueprint is complete, we make a copy of it to start from every day.  Saving a ton of time!


All the work is done!  This is how you will start your spreadsheet every day.  It sets up in just a couple of minutes, allowing you more time building the perfect lineup!

Section 7: Bonus

I've added a few stats and things to my Blueprint that will be helpful.  Check it out!


If you have any questions, feel free to ask on here.  Or share you screenshots of your customized spreadsheet with me on Twitter! @NickMarshGuy

Finished Blueprint

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Nick Marsh, Certified Google Educator, Fantasy Blueprint

I've been playing Fantasy sports for 15 years.  MLB is my absolute favorite and I count down the days to Spring Training. I've played Fantasy Baseball, Football, Basketball, Hockey, Golf, and Bass Fishing (really). I'm a Certified Google Educator and have been using Google Sheets for years. I will help you build an amazing fantasy spreadsheet!

Ready to start learning?
Take This Course