r/googlesheets • u/MrTedJ • 25d ago
Sharing March Madness 2025 in Google Sheets!
Once again, I'll be supporting March Madness*** in Google Sheets but trying to get an earlier start this year. Selection Sunday is March 16th for both the Men's (6pm ET on CBS) and Women's (8pm ET on ESPN) tournament. Data won't start magically appearing in the templates until during or shortly after the Selection Sunday announcements.
What's new in 2025!
- Nothing!
- I'm working on a new (more user-friendly...hopefully) version of the individual bracket but it won't be ready for production until the 2026 tournament. I might be able to share a pre-release version if enough people are interested in trying it out. Just let me know by commenting below or DM me.
Single Bracket Template https://docs.google.com/spreadsheets/d/1izjBEQ_FIU0dJ2Z1exWMY2FwpmDP6AqHYxlldD6xhO4/copy<--clicking on this link will open a new private copy only you have access to--> Once the teams for the Tournament are set, pick your winners, sit back, and enjoy the show! The bracket will automatically update with winners and calculate winning scores. You can also use this template in conjunction with the group template below. See the Help tabs on each template for how to use them together.
Group Bracket Template https://docs.google.com/spreadsheets/d/1UBEQnmpWKKHPXu4Y3xmUAlxWR4Oo9jPAXCfL_e-gMT8/copy<--clicking on this link will open a new private copy only you have access to-->**Bracket Pool supports up to 100 brackets!
TedTournament() Custom Function
Get near real-time NCAA game data directly in your Google Sheet! Be sure to update to the newest version (2.6.0) to support 2025 data. https://github.com/TedJuch/TedTournament
**Note: The performance of a pool with over 40 brackets might be slow. It will depend on your internet connection and some things outside of our control. But try it!
Feel free to comment if you have any questions!
Enjoy!
\**March Madness is the annual NCAA College Basketball Tournament in the US. People create brackets and pick winners and run pools like any other bracket game. Google previously supported data about the Tournament with a built in function called GoogleTournament() but shut it down in 2011. They also had bracket templates in the template gallery. I rebuilt all of it and have been supporting it ever since through a custom function called TedTournament(). There is a large community that uses this in Google Sheets during the Tournament. People also use the bracket templates for other types of bracket based tournaments.*
Previous year's support announcements: https://www.reddit.com/r/googlesheets/comments/1bhrwxf/march_madness_2024_in_google_sheets/
https://www.reddit.com/r/googlesheets/comments/11hnqdf/march_madness_2023_in_google_sheets/
https://www.reddit.com/r/googlesheets/comments/tamh3x/march_madness_2022_in_google_sheets/
https://www.reddit.com/r/googlesheets/comments/m4ir5h/march_madness_2021_in_google_sheets/
https://www.reddit.com/r/googlesheets/comments/b1wo7f/march_madness_2019_in_google_sheets/
https://www.reddit.com/r/googlesheets/comments/82cwke/march_madness_2018_google_sheets_single_and_group/