Tag: Excel

Note: Schedule last updated March 6, 2026.

Here’s a copy of the 2025/26 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, and the name of the starting goalies for each team.  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
• Visitor Goalie: the starting goalie of the visiting team
• Home Goalie: the starting goalie of the home team

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 December 31, 1975 at 6:00 PM in Saskatchewan and 7:00 PM Eastern time, the visiting team Central Red Army and the home team Montreal played to a 3-3 tie in regulation time, the starting goalie for the visitors was Vladislav Tretiak, and the starting goalie for the home team was Ken Dryden.

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.

In addition to the columns shown in the example, there are also a number of fields related to historical betting information. As odds change right up to game time, these fields are only filled in after the game has ended. The odds are a concensus of a number of betting sites available to me. These fields are:

• O/U: the number of goals for the Over/Under bet
• Over: the odds that the Over bet pays
• Under: the odds that the Under bet pays
• Away ML: the odds that the Money Line bet on the Away team pays
• Home ML: the odds that the Money Line bet on the Home team pays
• Home PL Spread: the spread for the home team on the Puck Line bet
• PL Away: the odds that the Puck Line bet on the Away team pays
• PL Home: the odds that the Puck Line bet on the Home team pays

I’ve also added some formatting to the odds fields. If the bet would have paid off, the odds are in green; if the bet would have lost, the odds are in red; if the bet would have been a push, the odds are black.

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!

Note: Schedule last updated April 18, 2025 (end of regular season).

Here’s a copy of the 2024/25 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!

Note: 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:

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.

If you’re looking for the 2024/25 schedule, you can find it here!

Note: 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!

The 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!

Note: 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:

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.

The 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!