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!
ty – schedule makes my life easier, appreciated. GL to all Canadian teams
Thanks for sharing this, it’s very helpful!
Excellent, glad you like it!
Excellent, thank you very much! Do you know where I can get the scores in regulation minus empty net goals (i.e. the scores without counting empty net goals)?
Hmmm, that would be interesting! Sorry, I don’t know where you could get that.
Shane this is fantastic. Thanks.
Do you create for MLB?
Hi John, I haven’t in the past, but that’s a good idea. I should do it this year.
Hey John, I’ve created the requested spreadsheet. I’ll try to update it every day! You can find it in this post.
Nice work, Shane. If you’re not the guy who creates the NHL regular season schedule for them, who is, and what software (if any) do they use, or do they use a combination of a program and hand-scheduling? Uncle Google is of no help to me here.
BTW, I developed a scheduling system from scratch for one of the largest defense contractors in the US back in the late 90’s that worked like a charm with only two people doing the scheduling for a plant that had 500 workers and ~24 programs, many of which were multi-million dollar contracts. We were 98% on-time with deliveries most months, and it was all done by hand on a series of excel spreadsheets.
I realize the NHL schedule is vastly different and more complex in some ways and am very curious how it’s done. I’ve heard the MLB used to do their schedule by hand – a married couple did it for ~25 years! But now they are using a computer?
Just curious and thanks for your work and reply in advance!
Hi Harry, nope, it’s not me that does it for the NHL! I’m not sure who does. I did read an article about how the NFL does theirs a few years ago, but I can’t remember where I saw that. Scheduling programs are hard! I’m impressed with the scheduling system you did!
Thanks for your quick reply and kind words, Shane. I have to think a programmable scheduling program would not have the type of complexity to do such a schedule for the NHL, unless it was used in a preliminary way and then reviewed and finished by hand. I cannot imagine it would be very much fun after the first year of doing it though, can you? It would be so tedious, and as with any scheduling job, it is typically a thankless work. I will download your Excel file and have a look at it, anyway. You must have spent many hours of your spare time on it, while my spare time is writing and photography and enjoying a good scotch in the evenings!
Pleasure to have talked with you, sir.
H
Yeah, I’d think that coming up with the schedule wouldn’t be so bad, but then resolving all the building conflicts and things like that would be a bear to deal with!