How to Create a Baseball Spreadsheet in Excel

baseball image by Tomasz Plawski from

It's been said that baseball statistics, like bikinis, don't cover everything, but they do cover the interesting parts of the sport. Whether you're coaching or managing a little league team, or tracking the numbers for players in your fantasy baseball league, getting accurate statistics about the players you're watching can be important for a number of reasons. Handling your own statistics is something you can do on your own computer with Excel; every major baseball statistic--and there are more than 70 of them--can be entered in an Excel workbook.

Enter the following headers in row 1: column A: Pitcher's Name. In column B1: Date. In column C, Earned Runs. In Column D: Number of Innings Pitched. In column E: Earned Run Average.

Enter the following formula in column E2: "=(C2*9)/D2". Once you've entered the requisite information in columns C and D, it will give you an Earned Run Average in column E for that particular pitcher on that particular day. Copy the formula in E2 down through the rest of column E -- in general, you'll want two to three rows per game on your schedule, to handle starting pitchers and relievers.

For each pitcher, enter the name, the date played, and the other information given by the headers in row 1.

Switch to Sheet 2 in Excel by clicking on the tab at the lower left hand corner of the Excel workbook.

Enter the following column headers on sheet 2. Player Name in column A, Date in column B, Number of Hits in Column C, Number of At-Bats in Column D. In Column E, enter the label Batting Average.

Enter the following formula in cell E2: "=C2/D2".

Copy and paste the formula in cell E2 down through the spreadsheet.

Enter the information for all of your players in columns A through D and update the sheet as you go through the season.

Most recent