The 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!
Hi Shane, I’ve just found your blog. I have very little experience using spreadsheets beyond very basic stuff (I use Google Sheets most).
How might I get the current NHL schedule into a spreadsheet so that I can update it as it goes along? Ideally a new tab for each month but don’t know if that’s possible.
Also, again I don’t know if this is even possible, but can they update scores themselves?
Cheers Matthew
Hi Matthew, you should be able to open either of my two files in Google Sheets, either the XLSX or the CSV. I’d recommend the XLSX, as it’s nicely formatted. Download a copy from this article, then drop it somewhere in Google Drive, then you can open it from there. In my spreadsheets, the entire schedule is all in one tab, but you could create new tabs and cut-and-paste the appropriate games into the new tabs.
I think it might be able possible to get the spreadsheets to update themselves, but I’ve never tried that. I wrote a Python script to read the NHL website and get the schedule, then pull out the information I want and put it into the CSV file. Then, to create the XLSX file, I copy the data from the CSV file into the XLSX file. If you wanted to try getting the spreadsheets to update themselves, I suppose it’s possible to write a macro to do that, but I’ve only got very limited experience doing that, so I’m not really sure how it would be done.
I hope this helps!