Tag: Excel

2024 MLB schedule and results in Excel .xlsx format

Old-timey image of a baseball batterNote: Schedule last updated April 28, 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.

 

NHL 2022-23 Playoff Schedule and Results spreadsheet in Excel and CSV formats

Hockey playerNote: Last updated August 23, 2023 —  contains complete playoff results.

I have updated my NHL schedule spreadsheet to include the playoff schedule. I’ve made it available in both Excel and CSV formats. It’s the same as the NHL schedule spreadsheet described in this post, with the addition of an additional worksheet containing the playoff schedule. Due to limitations of the CSV format, the CSV file only contains the playoff worksheet.

You can find the Excel spreadsheet here, and the CSV file here.

The new worksheet is called “Playoff Schedule”, and it looks like this:

Screenshot of Playoff Schedule worksheet

Most of the columns in the worksheet are the same as in the original worksheet, with two new ones. The Series column gives the name of the series, such as “East: A1 / WC2” for the series in the Eastern Conference between the top-seed in the Atlantic Division and the 2nd Eastern Conference Wildcard team. The Game # column lists which game in the series (1st game, 2nd game, etc.) this game is. There are a couple of other changes.  In the time columns, if the game time hasn’t been determined yet, it’s listed as TBD.  And, in the Status column, games in the playoffs can’t end in a shootout, so there’s no chance of an SO showing up in that column, and if a game ends in the first overtime period, it’s indicated as OT, if it’s in the second overtime period, 2OT, third is 3OT, etc. As with my regular season spreadsheet, I’ll try to keep this up-to-date every day.

2023/24 NHL schedule and results in Excel .xlsx and csv formats

Hockey playerNote: Schedule last updated April 19, 2024 (end of regular season).

Here’s a copy of the 2023/24 NHL schedule and the results of each of the games played so far in Excel .xlsx format, and here’s another copy in CSV format.  Of course, the season hasn’t started yet, so the results are empty right now, but I’ll try to update them each morning through the regular season.

The Excel file consists of 2 worksheets: one contains the original NHL 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, was won in regulation time, overtime, or in a shootout.  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 Eastern time (which is the time the NHL website shows)
  • Visitor: the name of the visiting team
  • Score: the visiting team’s score if the game has been played, otherwise blank
  • Home: the name of the home team
  • Score: the home team’s score if the game has been played, otherwise blank
  • Status: one of the following:
    • Scheduled: if the game hasn’t been played yet
    • Postponed: if the game has been postponed, but not yet rescheduled
    • Regulation: if the game ended in regulation time
    • OT: if the game ended in overtime
    • SO: if the game ended in a shootout

For example, here’s the first couple lines of the worksheet from a previous year’s file:

In this example, the game was played on January 13, 2021 at 4:30 PM in Saskatchewan and 5:30 PM Eastern time, the home team Philadelphia beat the visiting team Pittsburgh 6-3 in regulation time

Just a brief explanation why I’ve got two time fields in here.  Saskatchewan doesn’t observe Daylight Savings time, so for part of the schedule, we have a one-hour time difference from Eastern time, and for the rest of the schedule, we have a two-hour time difference.  Of course, I’m more interested in the time in Saskatchewan, but to make it easier for other people to use, I’ve also included Eastern time.

The CSV file contains only the As-Played 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!

2022/23 NHL schedule and results in Excel .xlsx and csv formats

Hockey playerThe post you’re currently reading is about the 2022/23 NHL schedule.  If you’re looking for the 2023/24 NHL schedule, you can find it in this post.

Note: Schedule last updated April 15, 2023.

Here’s a copy of the 2022/23 NHL schedule and the results of each of the games played so far in Excel .xlsx format, and here’s another copy in CSV format.  Of course, the season hasn’t started yet, so the results are empty right now, but I’ll try to update them each morning through the regular season.

The Excel file consists of 2 worksheets: one contains the original NHL 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, was won in regulation time, overtime, or in a shootout.  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 Eastern time (which is the time the NHL website shows)
  • Visitor: the name of the visiting team
  • Score: the visiting team’s score if the game has been played, otherwise blank
  • Home: the name of the home team
  • Score: the home team’s score if the game has been played, otherwise blank
  • Status: one of the following:
    • Scheduled: if the game hasn’t been played yet
    • Postponed: if the game has been postponed, but not yet rescheduled
    • Regulation: if the game ended in regulation time
    • OT: if the game ended in overtime
    • SO: if the game ended in a shootout

For example, here’s the first couple lines of the worksheet from a previous year’s file:

In this example, the game was played on January 13, 2021 at 4:30 PM in Saskatchewan and 5:30 PM Eastern time, the home team Philadelphia beat the visiting team Pittsburgh 6-3 in regulation time

Just a brief explanation why I’ve got two time fields in here.  Saskatchewan doesn’t observe Daylight Savings time, so for part of the schedule, we have a one-hour time difference from Eastern time, and for the rest of the schedule, we have a two-hour time difference.  Of course, I’m more interested in the time in Saskatchewan, but to make it easier for other people to use, I’ve also included Eastern time.

The CSV file contains only the As-Played 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!

NHL 2021-22 Playoff Schedule and Results spreadsheet in Excel and CSV formats


Hockey playerNote: Last updated June 27, 2022 —  contains complete playoff results.

I have updated my NHL schedule spreadsheet to include the playoff schedule. I’ve made it available in both Excel and CSV formats. It’s the same as the NHL schedule spreadsheet described in this post, with the addition of an additional worksheet containing the playoff schedule. Due to limitations of the CSV format, the CSV file only contains the playoff worksheet.

You can find the Excel spreadsheet here, and the CSV file here.

The new worksheet is called “Playoff Schedule”, and it looks like this:

Screenshot of Playoff Schedule worksheet

Most of the columns in the worksheet are the same as in the original worksheet, with two new ones. The Series column gives the name of the series, such as “East: A1 / WC2” for the series in the Eastern Conference between the top-seed in the Atlantic Division and the 2nd Eastern Conference Wildcard team. The Game # column lists which game in the series (1st game, 2nd game, etc.) this game is.

There are a couple of other changes.  In the time columns, if the game time hasn’t been determined yet, it’s listed as TBD.  And, in the Status column, games in the playoffs can’t end in a shootout, so there’s no chance of an SO showing up in that column, and if a game ends in the first overtime period, it’s indicated as OT, if it’s in the second overtime period, 2OT, third is 3OT, etc.

As with my regular season spreadsheet, I’ll try to keep this up-to-date every day.

2021/22 NHL schedule and results in Excel .xlsx and csv formats

Hockey playerThe post you’re currently reading is about the 2021/22 NHL schedule.  If you’re looking for the 2023/24 NHL schedule, you can find it in this post. Or, if you’re looking for the 2022/23 NHL schedule, you can find it in this post.

Note: The regular season has concluded, so the spreadsheet now covers the entire regular season.  It will not be updated further.

Another note: I’ve added another spreadsheet that also contains the playoff schedule.  You can read about it, and download the spreadsheet, from this post.

Here’s a copy of the 2021/22 NHL schedule and the results of each of the games played so far in Excel .xlsx format, and here’s another copy in CSV format.  Of course, the season hasn’t started yet, so the results are empty right now, but I’ll try to update them each morning through the regular season.

The Excel file consists of 2 worksheets: one contains the original NHL 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, was won in regulation time, overtime, or in a shootout.  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 Eastern time (which is the time the NHL website shows)
  • Visitor: the name of the visiting team
  • Score: the visiting team’s score if the game has been played, otherwise blank
  • Home: the name of the home team
  • Score: the home team’s score if the game has been played, otherwise blank
  • Status: one of the following:
    • Scheduled: if the game hasn’t been played yet
    • Postponed: if the game has been postponed, but not yet rescheduled
    • Regulation: if the game ended in regulation time
    • OT: if the game ended in overtime
    • SO: if the game ended in a shootout

For example, here’s the first couple lines of the worksheet from last year’s file:

In this example, the game was played on January 13, 2021 at 4:30 PM in Saskatchewan and 5:30 PM Eastern time, the home team Philadelphia beat the visiting team Pittsburgh 6-3 in regulation time

Just a brief explanation why I’ve got two time fields in here.  Saskatchewan doesn’t observe Daylight Savings time, so for part of the schedule, we have a one-hour time difference from Eastern time, and for the rest of the schedule, we have a two-hour time difference.  Of course, I’m more interested in the time in Saskatchewan, but to make it easier for other people to use, I’ve also included Eastern time.

The CSV file contains only the As-Played 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!

2021 NHL schedule and results in Excel .xlsx and csv formats

Hockey playerThe post you’re currently reading is about the 2021 NHL schedule.  If you’re looking for the 2023/24 NHL schedule, you can find it in this post. If you want the 2022/23 schedule, it’s in this post.  And the 2021/22 schedule is here.

Here’s a copy of the 2021 NHL schedule and the results of each of the games played so far in Excel .xlsx format, and here’s another copy in CSV format.  They are up-to-date up to last night, and I’ll try to update them each morning through the regular season.

The Excel file consists of 2 worksheets: one contains the original NHL 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, was won in regulation time, overtime, or in a shootout.  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 Eastern time (which is the time the NHL website shows)
  • Visitor: the name of the visiting team
  • Score: the visiting team’s score if the game has been played, otherwise blank
  • Home: the name of the home team
  • Score: the home team’s score if the game has been played, otherwise blank
  • Status: one of the following:
    • Scheduled: if the game hasn’t been played yet
    • Regulation: if the game ended in regulation time
    • OT: if the game ended in overtime
    • SO: if the game ended in a shootout

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

In this example, the game was played on January 13, 2021 at 4:30 PM in Saskatchewan and 5:30 PM Eastern time, the home team Philadelphia beat the visiting team Pittsburgh 6-3 in regulation time

Just a brief explanation why I’ve got two time fields in here.  Saskatchewan doesn’t observe Daylight Savings time, so for the first part of the schedule, we have a one-hour time difference from Eastern time, but once the rest of the country leaps forward, we have a two-hour time difference.  Of course, I’m more interested in the time in Saskatchewan, but to make it easier for other people to use, I’ve also included Eastern time.

The CSV file contains only the As-Played 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!

The 2021 NHL Schedule in Excel .xlsx format

Hockey playerNote: If you’re looking for the 2021/22 NHL schedule in Excel or CSV format, you can find it in this post.

Here’s a copy of the 2020/21 NHL schedule in Excel .xlsx format.

In a previous post, I posted a copy of the original 2020/21 NHL schedule in CSV format.  I’ve seen quite a few people looking for a schedule in Excel .xlsx format.  Although you can quite easily import a CSV file into Excel, I thought I might import it myself, apply a little bit of formatting to the file, and make it available, too.  You can get it here.

Update: you might also be interested in a spreadsheet that also contains the results.  You can read about it in this post.

Be aware that this is the schedule as of January 12, 2021.  In my original post, I said that I wouldn’t be surprised if the schedule changes, either due to weather-related game cancellations, or, more likely, changes due to COVID.  Well, that has definitely happened, even last night when the St. Louis Blues and Vegas Golden Knights game was postponed due to COVID.  That is NOT reflected in this schedule; this is the original schedule before any changes were made.

This spreadsheet contains 5 fields.  The first field is the date of the game, the second field is the game’s start time in Saskatchewan (where I live!), the third field is the game’s start time in Eastern Time (which is the time the NHL website shows), the fourth field is the visiting team, and the fifth field is the home team.

Here’s a screenshot of the first few lines of the file:

First two lines of schedule spreadsheet

The first line, obviously, is the header line, giving a brief description of each of the fields.  The second line, and all subsequent lines, list the games in the schedule, one for each game.  For the first game shown here, we can see:

  • the date of the first game is January 13, 2021
  • the game starts at 4:30 p.m. Saskatchewan time
  • the game starts at 5:30 p.m. Eastern time
  • the visiting team is the Pittsburgh Penguins
  • the home team is the Philadelphia Flyers

Just a brief explanation why I’ve got two time fields in here.  Saskatchewan doesn’t observe Daylight Savings time, so for the first part of the schedule, we have a one-hour time difference from Eastern time, but once the rest of the country leaps forward, we have a two-hour time difference.  Of course, I’m more interested in the time in Saskatchewan, but to make it easier for other people to use, I’ve also included Eastern time.

If you can make use of this file, have fun!