Here’s a machine-readable copy of the 2021 NHL schedule

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 CSV file of the NHL schedule, ready to be imported into Excel or your favourite spreadsheet.

Update: I’ve also made an Excel xlsx file available.  See the post here.

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

I’m quite excited, because the new NHL season is about to start! I was looking for a copy of this season’s schedule in a machine-readable format, but I wasn’t able to find one.  So, I created one.  You can get it here.

Be aware that this is the schedule as of January 12, 2021.  I wouldn’t be surprised if the schedule changes, either due to weather-related game cancellations, or, more likely, changes due to COVID.

This is a CSV (comma-separated value) file, with 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.  You can easily import this file into Excel, Google Sheets, or whatever spreadsheet you like to use.

Here’s the first couple lines of the file:

Date,Start Time (Sask),Start Time (ET),Visitor,Home
2021-01-13,4:30 PM,5:30 PM,Pittsburgh Penguins,Philadelphia Flyers

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 example line 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!

3 thoughts on “Here’s a machine-readable copy of the 2021 NHL schedule”

  1. Thank you for this! This is the first time that I will try and track some of the daily game data, so I am just getting my feet wet. I hope that you are enjoying the season thus far.

    1. Hi Scott:

      Although it’s a different season this year, with teams only playing within their own division, it’s a pretty good season so far! I hope you are also enjoying the season.

      In the next day or two, I plan on putting up another spreadsheet (both Excel and CSV) that contains the game results for the year so far. You might be interested in that.

      Keep your stick on the ice!

      Shane

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.