2022/23 NHL schedule and results in Excel .xlsx and csv formats

Hockey playerThe 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!

7 thoughts on “2022/23 NHL schedule and results in Excel .xlsx and csv formats”

  1. So glad you decided to do this years schedule too! I have been using your schedules for a couple years now and they are great. I scrape a lot of data from advanced analytic sites and run models off the team and individual stats and simulations. Your schedule helps me populate the daily matchups.

      1. I have been using them as well. Thank you very much!! Do you have a playoff schedule/scores for this year?

        1. Wow, sorry, I don’t know how I missed your message. I haven’t updated the schedule for the playoffs. I should do that soon. I’m just about to put up next year’s schedule, and I’ll drop you a note when I’ve updated the playoff stuff in the 2022/23 spreadsheet. Probably too late for what you were interested in, but at least it will be there for future reference!

Leave a Reply

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