Excel Templates | Excel Spreadsheets | Printable Tournament Bracket



Printable Tournament Bracket

Posted on August 9, 2009
Filed Under Sports |



What a competitive England Community Shield match which won by Chelsea on Penalty Kick. It made me cannot concentrate on updating my site for a while … :-). So, I think, this 2009/2010 English premiership season will be interesting. Manchester United without Cristiano Ronaldo is still competitive, but Chelsea with Carlo Ancelloti will be a real threat. And don’t forget about Liverpool with its ambition. I wish I could make the fixtures spreadsheet….

Okay, let’s get back to the new template I would like to share. This is a printable tournament bracket template. I put a title printable, because there is no automatic formula in the bracket to finalize the tournament result. I just put the formula to setup the tournament bracket and place all the players or teams in their corresponding place based on their seeded in the first round matches bracket. Once you finished setting up the bracket and entering all the players/teams, you can modify the layout of the brackets (put title, picture etc) and print it.

Printable Tournament Bracket

And this is a single elimination tournament brackets with single up-down layout. I provide 16 team bracket, 32 team bracket, 64 team bracket and 128 team bracket with all first round matches are already set with common first round matches rules. You can use this for your football tournament, basketball tournament, tennis tournament or any sports tournament that use single elimination system.


Printable Tournament Bracket Setup

Guidance to setup this tournament bracket is as follows :
1. Go to setup worksheet, put maximum players/teams where this is a dropdown cell that will provide only 4 option, 16,32,64 or 128. In seeded column, the number will be revealed based on your choice.
2. Put the number of box scores that you want to be displayed in the bracket. Maximum box score that can be displayed is five and minimum is zero, which means that there will be no box scores. If you want to see how the formula working, just go to the bracket worksheet and see how the box score is displayed based on your preference.
3. Fill all of tournament players or teams in Player name/Teams name. If the number of teams is less than the maximum number that you set, just leave it blank. There is excel formula that will put “Bye” in the first round matches to replace that blank cells as you can also see in the sample bracket.
4. I put samples in this template where you can see in the file itself or just enlarge the picture above.
5. And there is first round matches preference next to the teams table that will place your tournament participants in the brackets. You can change this preference if you want the matches to be setup based on your tournament policy.
6. After you finished with the setup, go to your bracket and start adjusting and modifying the layout.

I made this tournament bracket as a basic template for my upcoming automatic bracket template. Let me know if you found any error, because I was finishing this template at the same time with the Community Shield Match, and probably there will be any error that I missed to see :-).

You can download the file here.


You can read and download my other templates below :

Tags: , , , , , , , , ,

Comments

6 Responses to “Printable Tournament Bracket”

  1. Greg on August 18th, 2009 9:53 am

    Thanks for your help. I am currently trying to put together a softball tournament and you info was a tremendous help.

    Thanks again

  2. Kevin on August 21st, 2009 3:52 pm

    Thanks so much for this template. Ping Pong Palooza now looks a lot more professional.

  3. Asif on December 5th, 2009 11:42 am

    Many thsnks for this it was really helpful and time saving.

  4. Sonic on December 21st, 2009 4:16 pm

    Thanks. A great tool for organizers. It’s a keeper!

    A request - Could you add button to randomize all names except for top 8/16 seeds?

    -sonic

  5. Mike on January 20th, 2010 4:01 pm

    Looking at your tournament brackets and am a little confused on the setup sheet. When I change the value in B2 to 16 the content of cells B24-B39 are no longer displayed but are visible again when i increase the value in B2. I can see why the values in column A are not displayed but not column B. What is controlling this?

  6. Mike on January 21st, 2010 4:40 pm

    No need to answer the previous query! Took me a while to get there but now that I’ve discovered Conditional Formatting I have all the answers I need.

    Very impressive collection of spreadsheets.

Leave a Reply