Cricket World Cup 2015 – Free Excel Dashboard

Posted on
2015 Cricket World Cup Excel Dashboard

Cricket World Cup 2015 Excel Dashboard is my attempt to capture the world cup in Excel. Though the team I support (India) came close but didn’t win, Australia deserved to win.

I have attempted to calculate all the stats based on raw match data (thanks to ESPNCricinfo). I have tried to keep it really simple and highlight only the most relevant stats. This is my first draft and I hope to enhance this dashboard as time goes by. Please share your suggestions and comments in the comments section below.




Download the Excel dashboard for free – WorldCup2015_Excel_Dashboard




There are three views (Cup, Team and Match).


In the Cup view, you can see the overview of the tournament and the top players and performances. You can also see the points table in the preliminary round.






You can see the progress of the team and also their top players and performances.



You can choose the team from the drop down menu.






You can choose any of the 49 matches from the drop down menu.



You will see the compact match summary on the left, and more detailed scorecards on the right.





On Excel,

  • I have used formulas and conditional formatting as usual, without any macros.
  • I have tried to show flags of countries dynamically, which I have not done in my other templates so far.
  • There are no pivot tables, but there are some tables.
  • The sheets are protected, only to prevent accidental formula edits. Please feel free to unlock the sheets using the password indzara.

Please let me know your feedback in the comments section. I look forward to hearing from you.

You may also be interested in...

Social Media Dashboard Excel Template - Metrics - Sample for August 2016
2016 Olympics - Excel Dashboard

23 thoughts on “Cricket World Cup 2015 – Free Excel Dashboard

  1. Dear,
    I am trying to start a tournament at my local place. I want to put raw data of this tournament in template . Please can you help me in this regard.

    1. Hello

      We are not accepting any customized projects.

      All the best

  2. It helped me alot thanks.

    1. Thanks for the positive feedback

  3. That’s awesome..I need a complete video of this work as i want to implement this for my interstate tournaments.. pls help if possible…

    1. I have downloaded Working file for This However their is a sheet “RawData_Worm”, is it really required ? Is there any formulas linked to this sheet ?
      Pls rply

  4. Where Can i find raw data of cricket (possibly in excel format)…I’m trying to test a Tableau for dashboard visualization

  5. Dear Ind, i have a cricket team playing every Friday one T20, how can i maintain stats for my players. please help.

    1. I am sorry. I don’t have such a template.
      Best wishes.

  6. How add raw data in excel please tell mw

    1. Please unhide the 4 hidden sheets. Input data is entered in those sheets. Thanks & Best wishes.

  7. can u please share steps

    1. Thanks. Will do as time permits. Sorry that I am unable to get to this immediately. Best wishes.

  8. Thanx for video..
    Can you tell me “How to input row data”
    please mail me on

    1. Please unhide the 4 hidden sheets. Input data is entered in those sheets. Thanks & Best wishes.

  9. Nice work in Excel….overall it is awesome..

    1. Thank you. Best wishes.

  10. really nice job ….keep it up…

    1. Thank you. Best wishes.

Leave a Reply

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