2024 Fantasy Baseball Cheatsheets for Drafts and Auctions

Welcome back to another installment of Mr. Cheatsheet. For a few short weeks every March, this site puts out content that is designed to put you in a position to win your fantasy baseball leagues by dominating your fantasy drafts and auctions. The crown jewels of that annual content are the cheatsheets that give this site its name and this is the post to introduce them.

For those not aware of what you’re stepping into, these are spreadsheets designed for Microsoft Excel on your desktops and laptops (mobile/web spreadsheet apps do not work). They are highly customizable because fantasy baseball leagues all seem to have very specific and unique rules that can completely alter the value and rankings of the available players in your league. Once you open up these spreadsheets, you’ll input data about your league and then you’ll get customized rankings that show the projected value of each player for your league. The fun doesn’t stop there though. You’ll input your draft results into the spreadsheet during the draft and you’ll see live standings and charts catered to your league during the draft (admittedly this is much harder if you have a draft with a short pick clock).

To sum it up, these are pretty good spreadsheets and will help you with fantasy baseball.

Beyond that, there are four cheatsheets. They’re first broken into whether you’re conducting a standard fantasy draft or holding a fantasy baseball auction. From there, there are two sheets to choose from depending on whether you are in a roto league (a league where you get ranked in categories) or a points-based league (for leagues that score more like fantasy football).

Really, the fun of these spreadsheets is when you just open them up and start playing around. I recommend testing them out before your actual drafts so you can get a feel for them. All in all, I think the spreadsheets are neat and I hope you all like them.

Fantasy Baseball Draft Cheatsheets

There are four types of cheatsheets that you can download here so let’s figure out which cheatsheet is for you first.

The first question to answer is about your draft type. Your league is either conducting a standard fantasy draft or they’re having an auction. A standard draft contains multiple draft rounds and you make a pick each round. An auction would be where each player is put up for bidding and you can use fictional dollars to get the players you want.

Below are two cheatsheets that are for the standard drafts. If you’re in an auction, skip past these.

The second question you need to answer is about what type of scoring your league uses. The two common formats are either roto or points-based. A roto league is where you are ranked from first to last in various statistical categories, either each week or for the whole year. A points league is more like fantasy football where each player on your team accumulates weekly points based on your scoring system and you try to get more points than your fantasy opponent.

So, if you’re in a roto league that’s conducting a fantasy draft then here is the spreadsheet that you want to download:

If you didn’t download that file but you’re still here then that likely means that you’re in a points league. The points league is where you get individual points for each statistic and try to get the most points each week.

If that’s your league type and your league is holding a standard draft then download this spreadsheet to win your league:

Perfect! If you’re in a fantasy baseball draft then you should be good to go now. You can skip to the end if you want to read any final thoughts. Now, for the rest of you…

Fantasy Baseball Auction Cheatsheets

If your league is not conducting a standard multi-round draft and you are bidding on players to put onto your team then, yes, you need a different spreadsheet than what I have above. You need my auction spreadsheets.

You just need to ask yourself which type of league you’re in before you download one of these two sheets.

To quote myself from just a minute ago, “the two common formats are either roto or points-based. A roto league is where you are ranked from first to last in various statistical categories, either each week or for the whole year. A points league is more like fantasy football where you get X number of points for each thing a player does and you try to get more points than your fantasy opponent.”

If you’re in a roto league that is holding an auction-style draft then here is the spreadsheet that you want to download:

That leaves one final cheatsheet. The points league is closer to fantasy football as each player’s stat is assigned a specific point value and you try to get the most points each week. If that’s your league and it’s holding an auction-style draft then download this spreadsheet:

There you have it! Now you can win your fantasy leagues.

Need Help Using These?

You may open these up and find yourself asking a lot of questions. First, I’d check out this FAQ-style post to see if your issue is mentioned in the post. Secondly, I’d search the site to see if the issue has been mentioned before. Thirdly, I’d ask the question in the comments below here and I’ll get back to ya. One of those methods should get you to a solution but I’d start by checking out that post I linked to first.

Found A Bug?

Yeah, that’s going to happen. I’m just one person making these and there are four different spreadsheets to maintain so there may be human error at times. If your cheatsheet is acting strange and you think there’s a bug, contact me or post in the comments below so I can fix it.

Cheatsheet Updates

There will be at least one or two updates to the cheatsheets before the season starts. When a new version comes out, you can copy your league’s data to the new sheet by using the Save & Load tab.

Donations

When I made this site a long time ago, I decided I wanted these spreadsheets to be free so they could help the most people. I stand by that choice after 15 years of doing this site. It’s a great joy to be able to help so many people and that’s the main reason I continue to do this year in and year out.

BUT… this isn’t free for me to run and it also costs me lots of time and energy. There’s money to run the site but there’s really just the time of creating these and maintaining these that is most draining each year. That’s why it means so much to me when people donate to this site and it’s the reason I’m able to keep coming back to this each year.

If you are in a position to do so, you can submit donations through Venmo or PayPal, or you can buy me coffees.

If you can’t afford to donate then just enjoy the sheets and have a happy baseball season.

Good Luck!

Look at you! You should be proud of yourself. You took the initiative to try to win your fantasy baseball league this year and you found this hidden corner of the internet with a great tool for you. Use this spreadsheet to have your best draft ever, but always keep in mind that there’s always a matter of luck involved in this game. There will be unexpected injuries and weird things throughout the season so you just have to roll with the punches. At least you know you’ll have a good draft to start the season though.

Peace and love!