2024 MLB schedule and results in Excel .xlsx format

Old-timey image of a baseball batterNote: Schedule last updated April 30, 2024.

Here’s a copy of the 2024 MLB schedule and the results of each of the games played so far in Excel .xlsx format.  I’ll try to update it each morning through the regular season.

The Excel file consists of 2 worksheets: one contains the original MLB schedule as described in this post; the other, named As-Played Schedule, contains the same contents, with the addition of the scores for each team and whether the game hasn’t been played yet, the starting pitchers for each team, and the pitchers credited with the win, loss, and save.  Here’s a quick summary of the columns:

  • Date: the date of the game
  • Start Time (Sask): the game’s start time in Saskatchewan (where I live!)
  • Start Time (ET): the game’s start time in the Eastern Daylight Time Zone
  • Away: the name of the away team
  • Away Score: the away team’s score if the game has been played, otherwise this field is empty
  • Home: the name of the home team
  • Home Score: the home team’s score if the game has been played, otherwise this field is empty
  • Status: one of two values:
    • Scheduled: if the game hasn’t been played yet
    • Final: if the game is over
  • Away Starter: the probable starter of the away team if the game status is “Scheduled”, or the actual starter if the game status is “Final”
  • Home Starter: the probable starter of the home team if the game status is “Scheduled”, or the actual starter if the game status is “Final”
  • Winner: the name of the pitcher who got the win if the game has been played, otherwise this field is empty
  • Loser: the name of the pitcher who got the loss if the game has been played, otherwise this field is empty
  • Save: the name of the pitcher who got the save if the game has been played and a save was credited, otherwise this field is empty

For example, here’s three example lines of the worksheet:

A screenshot for a few lines of the spreadsheet's As-Played Schedule worksheetIn the first game in this example, the game was played on April 9, 2024, with the Washington Nationals playing against the San Francisco Giants, in San Francisco.  The game has been completed, and Washington won 5-3.  Joan Adon started the game for the Nationals, and Kyle Harrison started for the Giants. Jordan Weems was credited with the win, Ryan Walker was charged with the loss, and Kyle Finnegan earned the save.

The second game in the example is similar, but in the game, no save was awarded, so the Save field is left empty.

The third game is a game that hasn’t been played yet.  In it, it is scheduled to be played on April 10, 2024, with the Dodgers playing the Twins, with the first pitch scheduled for 1:10 PM Eastern.  Bobby Miller has been announced as the starter for Dodgers, and Chris Paddack is expected to start for the Twins.  The score columns and the Win / Loss / Save columns are all blank, because the game hasn’t been played yet.

 

2024 MLB schedule in Excel .xlsx and csv formats

Old-timey image of baseball batterHere’s a copy of the 2024 MLB schedule in Excel .xlsx format, and here’s another copy in CSV format.  If you want a copy of the results as well, you can find an Excel sheet containing the schedule AND results as described in this post.

The Excel file consists of 2 worksheets: one called “Original Schedule” contains the original MLB schedule before any schedule changes due to rainouts, etc.; the other, named About, describes the contents of the Excel file.  Here’s a quick summary of the columns:

  • Date: the date of the game, in the format YYYY-MM-DD
  • Start Time (Sask): the game’s start time in Saskatchewan (where I live!)
  • Start Time (EDT): the start time of the game in the Eastern Daylight Time Zone
  • Away: the name of the away team
  • Home: the name of the home team

For example, here’s the first couple lines of the worksheet:

In this example, the game is scheduled to be played on March 20, 2024 at 4:05 AM in Saskatchewan and 6:05 PM Eastern Daylight time, the away team is the Los Angeles Dodgers, and the home team is the San Diego Padres.

The CSV file contains only the “Original Schedule” worksheet.  It has the same fields as described for the Excel file.  You can easily import this file into Excel or whatever spreadsheet of your choice!