When kids get involved in sports, the parents do too. Whether you're a soccer mom or soccer dad, you'll likely be asked to be a team manager, team parent, assistant coach, referee, assistant referee, and maybe even a coach. That's how I got involved in coaching with AYSO. To help with the admin tasks and coaching, I ended up creating the soccer team roster template listed below. It will help you create a nice 1-pager that includes admin/contact info, the team roster, game and snack schedule. You can also use it to create a visual lineup for each game.


Soccer Roster Template

for Excel or Word
Soccer Team Roster


⤓ Excel
For: Excel 2007 or later
⤓ Word
For: Word 2007 or later

License: Private Use Only



This soccer roster template contains worksheets to handle creating a team roster, game and snack schedule, a printable lineup sheet, a game stats worksheet and shot chart as well as a way to keep some overall stats.

The game schedule is included on the roster sheet, making a handy 1-page printout to share with parents.

More Screenshots

Soccer Lineup Sheet
Game Stats and Shot Chart

For coaching, the visual lineup sheet is great. At each substitution ("quarters" in AYSO), I can just let the kids look at the lineup instead of having to shout their positions a hundred times and remind them where "left midfield" is. I'll admit that as a youth soccer coach, I'm a bit scatter-brained and I rely heavily on my printed lineup sheet during games so that I can keep track of who is supposed to be where on the field. Creating the lineup in the soccer roster template also makes it easy to print an extra copy to give to my assistant coach.

The lineup sheet was designed to be as flexible and easy to customize as possible. You can define your own system of play and name the positions whatever you want. Still, make sure to follow the instructions within the spreadsheet when setting up the lineup sheet, especially if you need to change the number of players. After you set it up the first time, creating a lineup for a game just involves selecting names from drop down boxes for each position.

When you come up with a particularly good lineup, you can create a copy of that sheet for reference later.

The game stats sheet is something I just started using more recently. In AYSO, the center referee marks who is scoring the goals, but that information doesn't get passed back to the coaches, so the coaches need a way to track this for themselves. The printable lineup card on AYSO.org is also very useful (see the link below).


Soccer Resources for Coaches and Team Managers

  • AYSO Printable Line-Up Card at aysostore.com - An official line-up card that you can edit on your computer (an editable PDF file). This definitely beats having to fill the forms out by hand for every game. Not only that, but the sheet creates 4 copies of the lineup form, so you can keep a copy and give a copy to your assistant coach for keeping track of goals.
  • Soccer Team Sites at shutterfly.com - Though creating a site online can be useful for setting up a soccer team roster and sending and receiving notifications, some parents (like myself) may not like being pressured into creating memberships on websites, or having their child's information and photos posted online. Just be careful and get buy-in from all the parents on your soccer team before creating an online team roster.
  • Free Soccer Systems of Play Videos via the NSCAA channel on YouTube
  • Team Roster Template for Numbers (on the Mac). Though I don't know of a way to link to it, Apple's Numbers program includes a pretty good youth soccer roster template.

Related Content