How to Print Name Tags from Google Sheets with Mail Merge

You've got a conference next week, 200 attendees on a spreadsheet, and a stack of blank name badge sheets sitting on your desk. The last thing you want to do is type each name one by one into a template. The good news? You don't have to. With a simple mail merge workflow connecting Google Sheets to your label template, you can go from a raw attendee list to a printed stack of professional name tags in under ten minutes.

Whether you're organizing a corporate retreat, a school fundraiser, or a weekend workshop, FoxyLabels makes it surprisingly easy to pull names, titles, and other details straight from your spreadsheet and onto printable badge sheets. Let's walk through every step of the process so you can skip the tedious manual work and focus on running a great event.

Setting Up Your Google Sheets Data for Perfect Name Tags

Before you touch a template or fire up any add-on, the quality of your final name tags depends almost entirely on how well your spreadsheet is organized. Think of your Google Sheet as the engine behind the whole operation. If the data is messy, your badges will be messy. A few minutes of cleanup now saves a lot of frustration later.

Structuring Your Columns

Open Google Sheets and create a new spreadsheet (or open your existing attendee list). Your first row should contain clear, descriptive column headers. At a minimum, you'll want columns like:

Keep your headers simple and free of special characters. "First Name" works perfectly. "First_Name!!!" does not. Most mail merge tools pull data by matching these header names to placeholders in your template, so consistency matters.

Cleaning Up Common Data Issues

Here are the most frequent problems that cause ugly name tags, along with quick fixes:

• Inconsistent capitalization. If some names read "JOHN SMITH" and others read "john smith," your badges will look unprofessional. Use the Google Sheets formula =PROPER(A2) to convert any name to title case ("John Smith").

• Extra spaces. Trailing or leading spaces are invisible but wreak havoc on alignment. Use =TRIM(A2) to strip them out.

• Missing data. Scan your list for blank cells. A missing first name means a badge that just says a last name floating awkwardly in space. Filter each column to find blanks and fill them in before merging.

• Duplicate entries. Use Google Sheets' built-in "Remove duplicates" feature (found under Data > Data cleanup) to catch attendees who registered twice.

How Many Badges Per Sheet?

This matters more than people realize. Popular name badge sheets like the Avery 5395 format hold 8 badges per page (2 columns by 4 rows), while smaller adhesive name labels like the Avery 5390 might fit more per sheet. Knowing your layout before you start helps you estimate how many sheets to load into your printer. If your event has 200 attendees using an 8-per-page format, you need 25 sheets. Buy a few extras for reprints and test prints.

Once your data looks clean and complete, you're ready to pick a template and start the merge. You can browse the FoxyLabels template catalog to find the exact layout that matches your badge sheets, whether they're Avery, OnlineLabels, or another popular brand.

Choosing the Right Name Badge Template and Setting Up the Merge

With your data polished, the next step is connecting it to a template that matches the physical badge sheets you'll be printing on. This is where many people get stuck, either picking the wrong template size or struggling with complicated desktop software. The Google Workspace ecosystem makes this much simpler than it used to be.

Finding Your Template

Flip your package of name badge sheets over and look for a product number. You'll usually see something like "Avery 5395," "Avery 74459," or a similar code. That number is your key to finding a perfectly matched digital template.

Head to the FoxyLabels template catalog and search for your product number. Each template page shows you the exact dimensions, the number of labels per sheet, and a visual preview of the layout. This removes all the guesswork about margins and spacing, which is the number one cause of misaligned prints.

If you don't have a specific product number, you can browse by category. Look for "Name Badges" or "Name Tags" and filter by the dimensions that match your sheets. Common sizes for stick-on name tags are 2-1/3" x 3-3/8", while insert-style badge holders often use 3" x 4" cards.

Connecting Google Sheets to Your Template

Once you've selected your template on FoxyLabels, the platform works as a Google Workspace add-on. Here's the streamlined process:

1. Install the FoxyLabels add-on from the Google Workspace Marketplace if you haven't already. It integrates directly into Google Sheets and Google Docs.

2. Open your attendee spreadsheet in Google Sheets.

3. Launch FoxyLabels from the Extensions menu. The add-on will detect your spreadsheet data automatically.

4. Select your template. Choose the name badge template that matches your physical sheets.

5. Map your fields. The add-on lets you drag and drop merge fields (like {{First Name}} and {{Company}}) onto the badge layout. Position them where you want each piece of information to appear.

6. Preview the merge. Before printing, scroll through a preview of every badge to catch any issues, like a name that's too long and overflows the badge boundary.

This entire setup takes about five minutes once you've done it the first time. For future events, you can reuse the same template configuration and just swap in a new spreadsheet.

Customizing Your Badge Design

Plain black text on a white badge works, but you can do better. Consider these design touches:

• Increase the font size for first names. Most people look at the first name on a badge first. Making it 20-30% larger than other text improves readability at a glance.

• Add your event logo or company logo to a corner of the badge. This gives the tags a branded, professional feel.

• Use color coding if you have different attendee types. Speakers might get a blue accent bar, sponsors a gold one, and general attendees a standard white background. You can even drive this dynamically from a column in your spreadsheet.

• Include a QR code that links to the attendee's LinkedIn profile or a digital business card. Some advanced setups support this through formula-generated URLs in your spreadsheet.

For detailed walkthroughs of specific configurations, the FoxyLabels tutorials page covers everything from basic text badges to complex multi-field designs with images.

Printing, Troubleshooting, and Getting Professional Results Every Time

You've cleaned your data, picked the right template, and mapped your fields. Now comes the moment of truth: actually printing these badges. This step trips up more people than you'd expect, but a few smart practices will save you from wasted sheets and misaligned text.

Running a Test Print

Never, ever send your full batch to the printer without a test run first. Here's a reliable method:

1. Print one page on plain paper first. Don't waste a badge sheet. Print the first page on regular copy paper.

2. Hold the plain paper up against an actual badge sheet. Align them together and hold them up to a light source. Check whether the text falls cleanly within the badge boundaries.

3. Adjust margins if needed. If the text is consistently shifted in one direction, most printers have a margin adjustment in their settings. Nudge it a millimeter or two and test again.

4. Print one actual badge sheet. Once the plain paper looks right, run a single badge sheet through. Confirm everything lines up on the real material.

This test-and-adjust cycle might feel tedious, but it typically only takes two or three attempts. Compare that to discovering 25 sheets are all misaligned after you've printed the entire batch.

Printer Settings That Matter

Your printer settings can make or break the output. Pay attention to these:

• Paper size. Make sure it's set to US Letter (8.5" x 11") or A4, depending on your badge sheets. An incorrect paper size setting is the most common cause of scaling issues.

• Scaling. Set this to "Actual size" or 100%. Never use "Fit to page" or "Shrink to fit," because that will rescale your carefully measured template and throw off all the alignment.

• Print quality. "Normal" is fine for text-only badges. If you've included logos or color elements, bump it up to "High" or "Best" for crisper results.

• Paper type. If your printer has a setting for label sheets or cardstock, use it. This adjusts how the printer feeds the sheet, reducing the chance of jams.

Troubleshooting Common Problems

Even with careful preparation, things occasionally go sideways. Here are the fixes for the most common issues:

Text is cut off on some badges. This usually means a name or company is too long for the badge space. Go back to your spreadsheet and abbreviate the long entries, or reduce the font size in your template for that field. Some people add a "Display Name" column with shortened versions specifically for badge printing.

Badges are shifted by half an inch. Your printer is likely adding extra margins. Check for a "borderless printing" option, or manually adjust the margins in your template by the offset amount you're seeing.

Some badges are blank. This points to empty rows in your spreadsheet, or rows where the key fields (like First Name) are blank. Go back to your data cleanup step and filter for empty cells.

The printer jams on badge sheets. Label sheets are thicker than regular paper. Feed them one sheet at a time through the manual/bypass tray if your printer has one. Also make sure you're loading them face-up or face-down according to your printer's specifications (check the little diagram usually printed near the paper tray).

For a deeper dive into the full process of creating event badges from spreadsheet data, check out this guide on how to print name badge labels from Google Sheets for any event.

Scaling Up for Large Events and Repeat Use

Printing 30 name tags for a team lunch is one thing. Handling 500 badges for a multi-day conference is a completely different challenge. The good news is that a mail merge workflow scales beautifully once the foundation is in place.

Batch Processing Large Attendee Lists

When your attendee list crosses into the hundreds, a few extra strategies keep things manageable:

• Sort your spreadsheet strategically before merging. Sort alphabetically by last name so that the printed badges come out in an order that's easy to organize at the registration table. Alternatively, sort by group, department, or table assignment if that's how you'll distribute them.

• Use multiple sheets for different badge types. If speakers, sponsors, and general attendees get different badge designs, split them into separate tabs in your Google Sheet. Run the mail merge once per tab with the appropriate template. This keeps things organized and avoids complex conditional formatting.

• Print in manageable batches. Rather than sending 60 pages to the printer at once, print 10-15 at a time. This makes it easier to catch problems early and reduces the risk of paper jams from a thick stack of label sheets.

Handling Last-Minute Changes

Events are chaotic. New registrations come in the morning of, someone's name was misspelled, and a speaker changed their title overnight. With a mail merge workflow, handling changes is straightforward:

1. Update the Google Sheet with the corrected information.

2. Re-run the merge for just the affected rows. You can do this by temporarily hiding or filtering out the rows you've already printed correctly.

3. Print only the replacement badges.

This flexibility is one of the biggest advantages of the spreadsheet-to-badge workflow over pre-ordering printed badges from a vendor. You maintain full control right up to the moment attendees walk through the door.

Creating a Reusable System

If you organize events regularly, build a system you can reuse:

• Create a "master" Google Sheet template with all your standard columns already set up

• Save your FoxyLabels template configuration so you don't have to remap fields every time

• Keep a checklist of printer settings that work with your specific printer and badge sheets

• Document which badge sheet product number you use so you can reorder without guessing

• Store a few extra blank badge sheets with your event supplies

This reusable approach means each new event takes minutes to set up instead of starting from scratch. You'll already know which template works, which printer settings to use, and how to structure your data.

Unlocking Advanced Features

As your events grow in complexity, you may want features like batch printing with different badge designs, conditional formatting based on attendee type, or integration with registration platforms that export to Google Sheets. The FoxyLabels pricing page outlines the different plan tiers and what each one unlocks, so you can pick the level that matches your needs.

Printing name tags from a Google Sheet doesn't have to be the headache it once was. With clean data, the right template, and a reliable mail merge tool, you can produce professional event badges without any design skills or expensive software. Start with your attendee spreadsheet, connect it to a matching badge template through FoxyLabels, and let the merge do the heavy lifting. Your registration table will thank you.