Free T-Shirt Size Collection Templates (Google Form, Excel & Spreadsheet)

Why Templates Save You Time When Collecting Sizes

Every group order starts the same way: someone has to collect shirt sizes. Whether you're coordinating 15 family members for a reunion tee, outfitting a 50-person company team, or organizing a bachelorette crew, you need to gather the same basic information from every person — name, size, and sometimes a style preference.

Starting from scratch each time wastes time you don't have. A ready-made template gives you structure immediately: the right columns, the right fields, a layout your group can actually use. You share it, people fill it in, you place the order.

In this guide, we'll walk you through three popular DIY template formats — Google Form, Google Sheets, and Excel — with exact setup instructions for each. Then we'll show you where templates fall short and introduce a faster alternative that handles everything automatically.

If you want a broader look at all your options, check out our full guide: how to collect shirt sizes for your group.

Google Form Template for T-Shirt Sizes

A Google Form is the cleanest DIY option for collecting shirt sizes. Each person fills out their own form — no shared editing, no accidental overwrites — and responses automatically flow into a linked spreadsheet you can review any time.

Step-by-step: setting up your t-shirt size Google Form

Step 1 — Create a new form

Go to forms.google.com and click the "+" button to start a blank form. Sign in with your Google account if prompted.

Step 2 — Set your title and description

Name the form something clear like "Smith Family Reunion — Shirt Size Submission". In the description, add a sentence explaining what it's for and your deadline: "Fill this out by May 10 so we can place our order on time."

Step 3 — Add a Name field

Click "Add question". Set the question text to "Your Name" and the type to "Short answer". Toggle it to Required.

Step 4 — Add an Email field

Add another question: "Email Address", type "Short answer", toggle Required. This lets you follow up with non-responders or contact the right person if there's a sizing question later.

Step 5 — Add a Size dropdown

Add a question: "Shirt Size". Set the type to "Dropdown". Add the following options in order:

• Small (S)
• Medium (M)
• Large (L)
• X-Large (XL)
• 2X-Large (2XL)
• 3X-Large (3XL)

Toggle the field to Required. If you're ordering both men's unisex and women's fitted styles, consider adding a separate "Style" question (see Step 6).

Step 6 — Add a Style Preference field (optional)

If your order includes multiple shirt styles, add a "Style Preference" multiple choice question with your available options, e.g., "Unisex / Men's fit" and "Women's fitted". Note that sizes differ significantly between these styles, so make this field clear.

Step 7 — Link to a Google Sheet for responses

Click the "Responses" tab at the top of the form editor, then click the green Sheets icon ("Link to Sheets"). This creates a new Google Sheet where every form submission appears automatically, one row per response. You can share this sheet with co-organizers.

Step 8 — Share the form link

Click the purple "Send" button and copy the link. Drop it in your group chat, text thread, or email. Anyone with the link can fill it out — no Google account required on their end.

Step 9 — Monitor and follow up

Check the linked Google Sheet periodically to see who's submitted. Compare against your group list and manually follow up with anyone who hasn't responded by 48 hours before your deadline.

Google Sheets Template for T-Shirt Orders

A shared Google Sheet works well when you want people to fill in their own row, or when you're entering sizes yourself as they come in via text or email. It's more flexible than a form, but more chaotic — people can edit each other's rows by accident.

Spreadsheet layout

Set up your sheet with the following columns in Row 1 (bold them for clarity):

Pre-fill Column A with your group member names. This makes it clear who still hasn't responded (empty rows in Column B). Add a summary section below your data rows with COUNTIF formulas to tally each size:

=COUNTIF(B2:B51, "S") — for Small count
=COUNTIF(B2:B51, "M") — for Medium count

How to share it

Click "Share" in the top right of Google Sheets. Change access to "Anyone with the link" and set permissions to "Editor" if you want group members to fill in their own row. If you prefer to enter sizes yourself (safer — fewer accidental edits), set it to "Viewer" and just collect sizes via messages.

Excel Template for T-Shirt Orders (Offline)

If your group works offline or you prefer Microsoft Office, an Excel template follows the same layout as the Google Sheets version. It's particularly useful when you're collecting sizes in person — at a team meeting, a family gathering, or a school event.

Spreadsheet layout

Use the same five-column structure: Name, Size, Style, Date Submitted, Notes. Add a summary table below with COUNTIF formulas just like the Sheets version. In Excel, the formula syntax is identical.

Useful Excel additions

• Data Validation for the Size column: Select Column B cells, go to Data → Data Validation → List, and enter "S,M,L,XL,2XL,3XL". This creates a dropdown in each cell, preventing typos like "med" or "Xl".
• Conditional formatting: Highlight empty cells in Column B to make it visually obvious who hasn't filled in their size yet.
• Freeze top row: View → Freeze Panes → Freeze Top Row, so your column headers stay visible as you scroll.

Sharing an Excel file

If you want real-time collaboration similar to Google Sheets, upload your Excel file to OneDrive or SharePoint and share a link. Otherwise, you can email the file and ask people to reply with their size, then enter it yourself. The latter is more work but gives you more control.

The Limitations of DIY Templates

DIY templates — whether Google Form, Google Sheets, or Excel — are a genuine improvement over chasing people through text messages. But they share a common set of limitations that become more painful as your group grows.

No size charts built in

When someone opens your form or spreadsheet, they see a size dropdown. They don't see what those sizes actually mean in inches. So they guess. And guesses lead to the most frustrating outcome in group shirt orders: someone getting a shirt that doesn't fit.

The only fix is to link to a size chart separately and hope people check it — which many won't. See our t-shirt size chart guide for accurate measurements you can share alongside your template.

Manual tracking of who's responded

Templates don't know who's supposed to respond. They just collect responses from whoever fills them out. You have to manually cross-reference your group list with the submissions to figure out who's missing — then chase them down yourself.

No automatic reminders

Templates are passive. They sit there and wait. Sending reminders to non-responders is entirely your job, done manually, often multiple times.

No connection to ordering

After you collect sizes with a template, you still have to re-enter those numbers somewhere to actually order shirts. That's another manual step, another opportunity for errors, and more time spent on data entry.

Totals require spreadsheet formulas

You have to write COUNTIF formulas (or count by hand) to know how many of each size you need. For most people this is a minor annoyance; for those less comfortable with spreadsheets, it's a genuine obstacle.

Skip the Spreadsheet: Collect Sizes Automatically with GGROUPT

If the limitations above sound frustrating, it's because they are. They're not bugs in any specific template — they're the fundamental constraints of using a general-purpose tool for a specific job.

GGROUPT is built specifically for group shirt size collection. Here's how the experience is different:

For members: 30 seconds, on any device

The organizer shares a link. The member clicks it and sees the actual shirt they'll be receiving. Right next to the size selector, there's a visual size chart with chest and length measurements. They pick a size that actually fits, submit, and they're done. No account needed, no spreadsheet to navigate.

For organizers: live dashboard, instant totals

As responses come in, your GGROUPT dashboard updates in real time. You can see exactly who has responded and who hasn't. Size totals are calculated automatically — no formulas, no counting. When you're ready to order, your size breakdown is already there.

Connected to ordering

GGROUPT connects size collection directly to the order. Once your group is done submitting, you move from collection to order in a few clicks — no re-entering data, no copy-pasting from a spreadsheet to a vendor portal.

It's free to start, and setup takes under five minutes. No spreadsheet formulas required.

Comparison: Google Form vs. Spreadsheet vs. GGROUPT

If you're in a situation where a template genuinely works — a very small group, everyone is tech-savvy, and you don't mind a bit of manual work — use one. The Google Form template in particular is solid for its purpose.

But if you want to eliminate manual data entry, give your group members an actual size chart, and move from collection to order without copying data from one place to another, GGROUPT is the smarter tool for the job.