A baseball roster template keeps all your team information organized in one place: players, jersey numbers, positions, parent contacts, lineups, and stats. Below you can download three free baseball roster templates in Excel: a team roster with player and parent contact details, a lineup card with an inning-by-inning fielding rotation, and a stats roster that calculates batting average, on-base percentage, slugging, and OPS automatically.
The templates are designed for youth baseball, Little League, high school, travel ball, adult leagues, and softball teams. Each one is an editable .xlsx file that prints neatly on one landscape page for the dugout, the clipboard, or the team parents’ email.
What Is a Baseball Roster?
A baseball roster is the official list of players on a team. At its simplest, it shows each player’s name, jersey number, and position. Most coaches also keep extra details such as bats and throws, date of birth, age, and contact information for each player’s parent or guardian. Many leagues require coaches to submit a roster before the season starts to confirm player eligibility and age groups.
During the season, coaches use several related documents. The lineup card sets the batting order and the fielding positions for each game. The stats roster tracks each player’s performance over the season. Together, these sheets help a coach manage the team, communicate with families, and make fair, informed decisions about playing time.
Why Use a Baseball Roster Template in Excel?
- All team information is in one file. Players, contacts, lineups, and stats are easy to find and update.
- Ages are calculated automatically. Enter each birth date and the league age is worked out from the cutoff date.
- Lineups are checked for you. The lineup card counts fielders per inning and warns you about duplicate positions.
- Playing time stays fair. Field and bench innings are totaled for every player.
- Stats update instantly. Batting average, OBP, SLG, and OPS recalculate as you enter game results.
- It is easy to share. Print copies for coaches or email the roster to team parents.
What to Include on a Baseball Roster
- Team details: team name, league or division, season, head coach, and home field.
- Jersey numbers: unique numbers for each player.
- Player names: full names as registered with the league.
- Positions: primary and secondary positions, such as SS / P.
- Bats and throws: right, left, or switch hitter, and throwing hand.
- Birth date and age: important for age divisions and pitching rules.
- Parent or guardian contacts: name, phone number, and email.
- Coaching staff and volunteers: head coach, assistant coaches, and team parent.
- Medical or allergy notes: important information kept private and available to coaches only.
How to Set Up Your Team Roster
- Enter the team details. Add the team name, league, season, coach, and home field at the top of the roster sheet.
- Set the age cutoff date. Type the league’s age determination date in the yellow cell so player ages are calculated correctly.
- Add players. Enter each player’s jersey number, name, positions, bats and throws, and birth date.
- Add parent contacts. Record a parent or guardian name, phone, and email for each player.
- Fill in the coaching staff. List coaches and the team parent with their phone numbers.
- Plan your first lineup. Copy the players into the lineup card in batting order and assign a position for each inning.
- Record stats after each game. Add each player’s at-bats, hits, walks, and other numbers to the stats roster.
Download the Free Baseball Roster Templates
All three baseball roster templates are hosted on this website and are free to download and edit in Microsoft Excel. Each preview image matches the download button directly below it. They also work in Google Sheets and LibreOffice Calc.
1. Baseball Team Roster Template
A complete team roster with jersey numbers, player names, positions, bats and throws, birth dates, automatic ages, and parent or guardian names, phone numbers, and emails. A coaching staff section, a team summary with player count, average age, pitchers, and catchers, and a space for medical notes are included.
2. Baseball Lineup Card Template
A game-day lineup card with batting order, jersey numbers, and a fielding rotation for seven innings. Choose each position from a dropdown, and the card counts field and bench innings for every player, checks that each inning has nine fielders, flags duplicate positions, highlights pitchers, and includes a pitch count tracker.
3. Baseball Stats Roster Template
A season batting statistics sheet with games, at-bats, runs, hits, doubles, triples, home runs, RBI, walks, strikeouts, and stolen bases. It calculates AVG, OBP, SLG, and OPS for every player and the whole team, shades the best hitters with color scales, and shows the team leaders automatically.
Tips for Managing a Baseball Team Roster
- Keep one master roster. Update one file and share it, rather than keeping several versions in different inboxes.
- Confirm contact details early. Check phone numbers and emails at the first practice so you can reach families about weather cancellations.
- Assign unique jersey numbers. Duplicate numbers cause confusion for scorekeepers and umpires.
- Know your league rules. Many youth leagues have rules on minimum playing time, continuous batting orders, and pitch counts. Check your league’s current rules before each season.
- Rotate positions in youth baseball. Letting players try several positions helps them develop and keeps the game fun.
- Protect private information. Share contact details only with coaches and team parents who need them.
- Update stats after every game. Stats are much easier to keep accurate when you enter them the same day.
How to Build a Fair Fielding Rotation
In youth baseball, a fielding rotation helps every player get time in the field and on the bench. Start by placing your most reliable players at pitcher, catcher, and shortstop, then rotate the other players through the infield and outfield. Aim for each player to sit no more than one or two innings in a row, and try not to bench the same player twice before everyone else has sat once.
The lineup card makes this easy to check. The Field Inn. and Bench columns show playing time for each player, the Fielders per inning row confirms that each inning has exactly nine players in the field, and the Duplicate positions row warns you if two players are assigned to the same position.
Understanding Baseball Batting Stats
Batting average (AVG) is hits divided by at-bats. A .300 average means the player gets a hit in 30% of at-bats.
On-base percentage (OBP) measures how often a player reaches base. The template uses a simplified formula of hits plus walks divided by at-bats plus walks. The official formula also includes hit-by-pitch and sacrifice flies, which you can add as extra columns if your league tracks them.
Slugging percentage (SLG) is total bases divided by at-bats, where a single counts as one base, a double two, a triple three, and a home run four. It shows a player’s power.
OPS is OBP plus SLG. It combines getting on base and hitting for power into one useful number for comparing hitters.
How to Customize the Baseball Roster Templates
Change the team colors by selecting the header cells and choosing your team’s colors from the Fill Color menu. To add players, insert rows inside the roster table and copy the formulas from the row above. In the lineup card, change the number of innings by adding or deleting inning columns, and edit the position list under Data > Data Validation if you play with a fourth outfielder or use EH for extra hitter.
For softball, the same templates work with only small changes: rename the title, adjust the number of innings, and update the position list if your league uses extra fielders. Add a pitching stats tab if you want to track innings pitched, strikeouts, and walks for your pitchers.
You can also check these important templates like the attendance list template for tracking practice attendance, the weekly calendar template for planning practices and game days, and the contact list template for keeping a separate list of league officials, umpires, and volunteers.
Frequently Asked Questions
What should be on a baseball roster?
A baseball roster should list each player’s jersey number, name, positions, bats and throws, birth date or age, and parent or guardian contact details. It should also show the team name, league, season, and coaching staff.
How do I make a baseball lineup card in Excel?
Download the baseball lineup card template on this page, enter your players in batting order, and pick a position for each inning from the dropdown. The card counts field and bench innings, checks that every inning has nine fielders, and flags duplicate positions.
How do you calculate batting average?
Batting average is the number of hits divided by the number of at-bats. For example, 17 hits in 48 at-bats is a .354 average. The stats roster template calculates it automatically for every player and the team.
Can I use these templates for softball?
Yes. The roster, lineup card, and stats sheets all work for softball. Change the title, adjust the number of innings, and edit the position list if your league uses an extra fielder or extra hitter.
How do I make sure every player gets fair playing time?
Use the lineup card’s Field Inn. and Bench columns. Plan the rotation so each player sits a similar number of innings, avoid benching the same player twice in a row, and check your league’s minimum playing time rules.
