skip to Main Content

NHL Excel Template

4.2 (10 reviews)

NHL 2020-2021 Excel Template to track Schedules, Playoffs, Standings, and much more! Includes History and All-Time Award Winners!



Are you getting ready for the new season of NHL? The 2020-2021 National Hockey League will start on Jan 13, 2021, and it will last for another five months until the last match of the fixture 8th of May.

Finally, the tournament will be played for the 103rd time and 31 teams will compete with each other for the championship. Teams are going to compete in a 56-game in the season.

NHL Excel Template Features:

National Hockey League Template will allow you to track the details of Daily Schedules of the matches, Standings, Cities and Venues info and (once you enter the match scores) NHL rankings of each group.

The template consists of 8 different sections:


Navigates the NHL Workbook to make switching between other worksheets so moving from sheet to sheet will be easier.

NHL Schedule:

Contains the match details like who is teams, dates and arenas they are playing. Basically, you will enter your scores for each team on the schedule and you can go to the necessary monthly by just clicking on the month buttons on the top.


If the teams are tied, put down the scores of overtime in the Overtime Scores column. Within this period, if there are no shots in the overtime, choose the winner of shootouts by selecting from the drop-down menu.

The arrows on the left side takes you to the top of the page once you press it.


Once you input the score details, the table in the “standings” section will automatically rank the teams according to the National Hockey League Standards. The successor team will be moved to the next level.


You will find 3 standings in this sections which are Division Standings, Conference Standings and Wild Card.

In these sheet tabs, teams have been divided according to their division and conference. Once you input the scores properly in previous sections, the tables in this section will dynamically rank and order them.


The columns in the table stand for the amount of Game Played, Win, Lose, Overtime Lose, Points, ROW (Regulation or Overtime Wins), Goals For, Goals Against and the difference.

2019 Draft:

This section shows you the seven round of NHL from Round 1 to Round 7.

Team Info:

This section shows the chosen team’s general information and Championships. You can click on the team cell where yellow arrow points and choose the team from the drop-down menu to display the required season’s properties.


Gives you information about the past National Hockey League History in terms of Competitors, All-Star and All-Rookie Team, Points, Goals, Assists, Plus-Minus, GAA (Goals Against Average), Save Percentage, Wins and Shootouts.

All-Time Award Winners:

Finally you can check all the Trophy and Award owners of the chosen year.


NHL Excel Template Features Summary:

  • Easy to fill NHL Spreadsheet
  • NHL Schedule, Playoff, Standings, Team Info
  • All Time Award Winners and History
  • Full Print Ready
  • Informational notes included
  • No installation needed. Ready to use.
  • Works both on Mac and Windows
  • Compatible with Excel 2007 and later versions
  • Does not include any VBA macros

**This NHL Excel Template compiles the information which is officially available at You can check all the national hockey league season news, standings, schedule & playoffs there. Someka is not associated with The National Hockey League.

This NHL Schedule Excel Template is ready-to-use and provided as is. If you need customization on your reports or need more complex templates, please refer to our custom services.


Watch the video below to see the template in action! Presentantation also includes usage notes, explanations and tips & tricks about the template.



10 reviews for NHL Excel Template

  1. Donald T Pidgeon Jr

    Good Day!!!

    I have a question regarding the standings. On the spreadsheet for the East Division, it shows Pittsburgh in second and the New York Islanders in third. The standings on the website show the order reversed (Islanders in second and Pittsburgh in third). The reason is a change the NHL made in the tie-breaking policy last season (see step 2):

    1. The fewer number of games played (i.e., superior points percentage).
    2. The greater number of games won, excluding games won in Overtime or by Shootout (i.e., “Regulation Wins”). This figure is reflected in the RW column.
    3. The greater number of games won, excluding games won by Shootout. This figure is reflected in the ROW column.

    The NHL added a new column in the standings called Regulation Wins (RW) and this supersedes the ROW column on the tie-breaking procedure. The Islanders have 18 RW and Pittsburgh has 16 RW so that is why the Islanders are in second and Pittsburgh is in third.

    Please let me know if you have any questions or need any more information.

    Thank you.


    • Someka

      Hi Donald,

      Thanks a lot for the time you spare to write this review. Our development team has contacted you to talk further about your comment, please check your mailbox. Besides, we are also happy to update the template if necessary changes need to be made.

  2. Donald T Pidgeon Jr

    Good Day!!!

    Will there be an updated spreadsheet showing the playoff format adopted by the NHL this season as a result of the COVID pandemic??

    The top four teams in each conference will play a round robin schedule for seeding and teams placed 5 through 12 will face each other in a qualifying round (5 vs 12, 6 vs 11, 7 vs 10, and 8 vs 9).

    The four qualifying round winners will then play the top four seeds based on the results of the round robin.

    Please advise when you have the opportunity. Please let me know if you have any questions.

    Thank you.

    • Someka

      Hello Donalds!

      It is your reviews that help us constantly improve our customer’s experiences by knowing what we are doing right and what we can work on to improve. Thank you so much and we appreciate you taking the time to send us this review.
      We’ve just passed along this to our development team and they are going to contact you about the template! If you have any other feedback about our templates, just let us know. We’d be very happy to hear more from you!

  3. Dean Smith

    I am using your NHL template for a while, and like it. My question pertains to adding up points. I’m pushing for the NHL to go to the way European Soccer calculates points. Three points for a win in regulation, two for an overtime win and one for an overtime loss. Can your system accommodate also this?

    • Someka

      Hi Dean,
      Thanks a lot for your feedback! Yes, you can do this with our template but, one of our developers should be assigned to you for this and customize the template according to your needs. You can learn our customization process from here: Hire an Excel Expert

  4. Dmitriy

    Thanks Someka for this NHL template. What about the KHL Excel Template? Do you plan to create it?

    • Someka

      Hello Dmitriy,
      Thank you for your feedback! We’ve included it in our future template ideas list. Once we decided to develop a template for KHL, we’ll let you know!

  5. Jens Demuynck

    The template doesnt register one of the first games of the Tempa Bay Lightning good. They lost after OT but in the standings they doesnt get a point for the loss. Even the matches played isnt changed.

    • Someka

      Hello Jens,

      Thank you for your comments and feedback on this matter.
      It’s our priority to make the template easy to use for all of our users in a very accurate way and thanks to users like you, we are continuing to develop a better product.
      We’ve just passed along this issue to our development team and they have already finished to update the template. You can download the last version and let us know if you have more feedback like this. That would be awesome to hear those from you!

  6. Don

    I like the template. Thank you for the update. One issue – the Tampa Bay Lightning have played three games so far but the standings only reflect two games played.

    • Someka

      Hello Don, thank you for letting us know about this. Your feedback helps us get better. We’ve already put this issue as our priority and just updated the tool with new version. You can download it and let us know if everything is ok! We look forward to seeing you again 🙂

  7. Miles

    The standings does not recognizes OT with a shootout winner right. I wrote 0-0 in the OT columns and selected the Shootout winner, but the defeated team does not get the 1 point they deserved for getting in OT. The same if a winner is determined in OT.

    • Someka

      Hello Miles!

      Thank you for the wonderful review and taking your time to send us feedback on it. We just wanted to let you know that the fault has just fixed by our developers with your contribution and it is very much appreciated.

  8. Jens Demuynck

    Please help, once i put some results the standings tab doesn’t automatically update?

    • Someka

      Hello Jens!

      Thanks for reaching out! Our developers has already contacted you regarding the issue you ran into. If you have more feedback/concerns about the template please feel free to contact us!

  9. Nic

    Love this template, it’s really good and easy to use. I’m trying to build something myself that’s similar to this but struggling to get a steer on how to do the wildcards. Any advice would be greatly appreciated.

    • Someka

      Hello Nic,

      Thank you for your feedback! Appreciated!

      You can contact our developers and ask all the questions you may have. Just submit your query here: Custom Services

  10. Marmanu

    Please help. I have not been able to open the file location.
    PS. I do not want to ruin your ratings.

    • Someka

      Hello Marmanu,

      As far as we understand, you can not able to use the template after you download it, right? Did you unzip your file before starting to use it? Because otherwise it will be opened in a readable format and you can not enable the editing option.

      Hope that helps!

Leave a customer review

Your email address will not be published. Required fields are marked *