microsoft excel fantasy football spreadsheet

How to Create a Custom Hitter Rankings in Microsoft Excel Using FantasyPros Zeile Projections

As the fantasy baseball draft season approaches, it's essential to create custom hitter rankings that cater to your league settings. In this tutorial, we'll show you how to use FantasyPros Zeile Projections and Microsoft Excel to make tailored rankings for your five-category league.

To start, download the FantasyPros Zeile Projections file from the website. This will require a FantasyPros account and Microsoft Excel on your computer. Once downloaded, open the file in Excel. You can also use Google Sheets, but this tutorial is designed specifically for the desktop version of Excel.

The first step is to filter out unnecessary data. Click any cell in the first row and click the 'Filter' button under the 'Data' tab. This will enable you to restrict your data to only players with significant at-bats, preventing your projections from getting diluted by an overwhelming number of low projected totals.

Next, remove irrelevant columns by deleting them or hiding them using the 'Delete' key. In this example, we're focusing on a five-category league that replaces batting average with on-base percentage. Hold down the control key and click the column headers for each category your league does not use to highlight them all.

Now it's time to get rid of the categories you don't want. Double-clicking a category should open it in Excel, allowing you to delete or hide it. In our example, we're removing batting average and replacing it with on-base percentage.

To download a clean CSV file that opens in Excel, click the export button and select 'CSV' as the format. You can also select which sources you want to average the projections from using the 'Pick Sources' button if desired.

With your custom hitter rankings prepared, you're now ready to prep for your draft with our award-winning fantasy baseball tools. Our Fantasy Baseball Tools include the Cheat Sheet Creator, Draft Assistant, and more. By focusing on league settings and creating custom rankings, you'll be well on your way to becoming a better fantasy baseball player.

Remember to check out our Fantasy Baseball Tools as you prepare for your draft this season. With these powerful tools and our expert advice, you'll be able to dominate your league and take your fantasy baseball game to the next level.

Microsoft excel fantasy football spreadsheet