How to Collect Employee Sizes and Addresses Without Spreadsheets 2026
Introduction
Collecting employee shirt sizes and shipping addresses with spreadsheets creates privacy risks, manual cleanup, and fulfillment mistakes. This article explains how companies can replace spreadsheets with redemption links, company stores, and on-demand swag workflows that capture accurate details at checkout.
Why Are Spreadsheets a Problem for Employee Size and Address Collection?
Spreadsheets are simple to start, but they become messy fast. They require employees to enter personal information manually, then someone has to clean, sort, and transfer that data into a fulfillment process.
For small teams, a spreadsheet may work once. For onboarding programs, employee appreciation gifts, remote teams, conference merch, or holiday campaigns, it can quickly become a bottleneck.
Common spreadsheet problems include:
- Incorrect sizes
- Missing apartment numbers
- Duplicate responses
- Outdated addresses
- Privacy concerns
- Manual copy-and-paste errors
- Inventory over-ordering
A spreadsheet also forces the company to guess how many smalls, mediums, larges, and extra larges to buy. That often leads to leftover boxes of unused merch or not enough of the sizes employees actually need.
What Is the Better Way to Collect Employee Sizes and Addresses?
The better way is to let employees choose their own size and enter their own shipping address through a secure redemption link or online company store. This removes manual data collection and connects size selection directly to the order.
Instead of asking, “What size are you?” in a spreadsheet, companies can send employees a link where they select the approved item, choose their size, and enter their address at checkout.
With Merchloop, that process fits naturally into a zero inventory model. Every item is printed or embroidered after the order is placed, which means companies do not need to pre-buy piles of apparel in guessed sizes.
That is especially useful for distributed teams, new hires, client gifting, and one-off campaigns where addresses and sizes change constantly.
How Do Redemption Links Work for Employee Swag?
Redemption links let employees claim approved swag without the company collecting size and address information manually. The employee clicks the link, selects their item or size, and submits their shipping details.
For example, a company could send a new hire a branded welcome hoodie link. The employee chooses medium, large, or another available size and enters their home address directly.
This keeps the process simple:
- The company selects the swag item or collection.
- Employees receive a link.
- Employees choose their size.
- Employees enter their shipping address.
- The order is produced and shipped.
For HR, People Ops, and Marketing teams, this removes the awkward “please send me your shirt size and home address” workflow.
How Does Merchloop Help Companies Avoid Size Guessing?
Merchloop helps by producing items after employees place their orders. That means companies do not have to guess sizes upfront or hold inventory.
Because Merchloop is built around on-demand swag, teams can offer apparel without committing to bulk quantities. There are no minimums, so one employee can order one item, or hundreds of employees can each order their own size.
This is especially helpful for premium apparel from brands like Nike, The North Face, TravisMathew, Marine Layer, and YETI. Instead of pre-buying expensive branded items in bulk, companies can make them available through an online store or redemption workflow.
What Information Should Employees Enter Themselves?
Employees should enter the information most likely to change or be entered incorrectly. That includes apparel size, shipping address, recipient name, and sometimes phone number or email for delivery updates.
This reduces errors because the person receiving the item is the person confirming the details.
A good swag collection flow should capture:
- Name
- Apparel size
- Shipping address
- Product selection
- Optional department or location
- Optional gift message
This also keeps sensitive information out of shared spreadsheets. Instead of an HR coordinator managing dozens or hundreds of addresses, the platform captures the information as part of the order.
Spreadsheet Collection vs Redemption Link Collection
Spreadsheets can work for very small one-time projects, but redemption links are cleaner for ongoing swag programs. The best choice depends on how often you send merch and how much manual work your team can handle.
| Method | Best Use Case | Pros | Cons |
|---|---|---|---|
| Spreadsheet | Very small one-time orders | Free, familiar, easy to start | Manual cleanup, privacy concerns, size errors, address mistakes |
| Google Form | Basic internal surveys | More structured than a spreadsheet | Still requires exporting and manual fulfillment |
| Bulk Pre-Order | Events with fixed quantities | Can work for in-person distribution | Requires size guessing and inventory storage |
| Merchloop Company Store | Ongoing employee swag and gifting | Zero inventory, no minimums, address capture, size selection, transparent pricing | Best when companies want a branded store or repeatable swag process |
What Makes an On-Demand Swag Model Better?
An on-demand swag model is better because items are made after someone orders them. That reduces waste, avoids overbuying, and lets each employee choose the correct size.
Merchloop’s model is built around zero inventory, no minimums, and in-house production. Orders are printed or embroidered under one roof at a US-based production facility.
Standard production is typically 7–10 business days, with rush options available when timing is tight. That makes the process practical for onboarding, employee recognition, milestone gifts, event follow-ups, and client campaigns.
How Can Companies Use a Free Company Store?
A free company store gives employees one place to choose approved branded items. With Merchloop Lite, companies can set up a free company store with no monthly fees, no setup fees, and no design fees.
This is useful when swag is not just a one-time campaign. Instead of creating a new spreadsheet every time someone needs a shirt, jacket, tumbler, or welcome gift, the store becomes the central hub.
Employees can order approved items as needed, while the company avoids inventory, storage, and manual fulfillment.
What About Pricing and Budget Control?
Transparent pricing helps companies know what each item costs before orders are placed. Merchloop uses per-item pricing with no hidden fees, which makes budgeting easier than sorting through surprise setup charges or unclear add-ons.
This is important because swag costs are not just about the product. Companies also have to think about decoration, fulfillment, shipping, storage, and administrative time.
With transparent pricing, teams can compare costs more clearly and decide what items make sense for different programs.
For example:
- New hire welcome gifts may need premium apparel.
- Event follow-ups may use lower-cost drinkware.
- Executive gifts may feature premium brands.
- Employee appreciation campaigns may offer a small curated collection.
When Should Companies Still Use a Spreadsheet?
A spreadsheet can still be fine for a tiny one-time order. If five local employees are picking up shirts in person, a spreadsheet may be enough.
But once shipping addresses, remote employees, multiple sizes, or premium items are involved, spreadsheets become riskier.
Use a spreadsheet only when:
- The group is very small
- No home addresses are needed
- The order is not recurring
- One person can easily verify every detail
- Inventory waste is not a concern
For most growing teams, a store or redemption link is a cleaner long-term solution.
How Does In-House Production Improve the Process?
In-house production gives companies more control over quality, timing, and communication. Merchloop’s parent company, Stoked On Printing, has operated since 2011, and Merchloop launched in 2018 as its online swag store platform.
Because printing, embroidery, and fulfillment happen under one roof, the process is more connected than a model that relies heavily on separate outside vendors.
That matters when companies need consistent branding, reliable decoration, and clear production timelines. Standard production is 7–10 business days, and rush options may be available depending on the item and order details.
Why Does This Matter for Remote and Hybrid Teams?
Remote and hybrid teams need swag workflows that do not depend on office pickup or bulk boxes. Employees may be in different states, time zones, and living situations, so address accuracy matters.
A redemption link lets each person provide their own address when they are ready to claim the item. That reduces back-and-forth messages and helps avoid shipping branded merch to old addresses.
It also makes employee gifting feel smoother. Instead of making employees fill out an awkward spreadsheet, they get a simple branded experience.
What Is the Best Workflow for Collecting Sizes and Addresses?
The best workflow is to choose approved products, send employees a redemption link, let them enter their own details, and produce items on demand. This keeps the process simple for both the company and the recipient.
A practical workflow looks like this:
- Pick the item or collection.
- Confirm branding and decoration.
- Set budget or eligibility rules.
- Send the redemption link.
- Let employees choose sizes and enter addresses.
- Produce items after orders are placed.
- Ship directly to each recipient.
This replaces the spreadsheet with a cleaner, more accurate system.
How Can Merchloop Help?
Merchloop helps companies collect sizes and addresses through an online swag store and on-demand ordering model. Teams can offer branded products without ordering inventory upfront.
The biggest advantages are:
- Zero inventory
- No minimums
- Free company store setup
- In-house production
- Premium brands
- Transparent pricing
- US-based production
- 7–10 business day standard production
For companies tired of chasing shirt sizes and cleaning up address spreadsheets, Merchloop creates a more scalable way to manage employee swag.
FAQ
How do I collect employee shirt sizes without a spreadsheet?
Use a redemption link or online company store where employees choose their own size during checkout. This removes manual size collection and reduces ordering mistakes.
Can employees enter their own shipping addresses?
Yes. With a redemption link or company store, employees can enter their own shipping address when they claim their swag, which helps prevent address errors.
Does Merchloop require minimum order quantities?
No. Merchloop supports no minimums, so companies can order one item at a time or support larger employee campaigns.
How long does Merchloop production take?
Standard production is typically 7–10 business days, with rush options available depending on the item and timeline.
Is Merchloop good for remote employee swag?
Yes. Merchloop is a strong fit for remote and hybrid teams because employees can choose sizes, enter addresses, and receive swag directly without the company holding inventory.
