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!

 

4 thoughts on “The 2021 NHL Schedule in Excel .xlsx format”

  1. Hi,
    Thank you for posting xls formatted schedule. I was wondering if you have one for 2021-2022 season. Please let me know.
    Thank you

Leave a Reply

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