Mail merge is the practical answer to producing 50, 200 or 1,000 name badges from a spreadsheet without typing each one. The Word + Excel pairing is the most mature workflow; Google Docs has add-on alternatives that work for smaller runs. Either way, the spreadsheet matters as much as the merge.

Preparing the spreadsheet

Mail merge succeeds or fails on the spreadsheet that feeds it. The format Word expects is a single row per attendee with one column per data field. Use clear, descriptive column headers in row 1 — First Name, Full Name, Organisation, Role, Category — and start data in row 2.

Avoid merged cells, blank rows and trailing empty columns. Word reads the file top-to-bottom, treating any blank row as the end of the data. Trim whitespace from cells, standardise capitalisation, and check for invisible characters that sneak in from copy-paste from PDFs or web forms. A 30-second pre-flight saves hours of reprinting.

Word + Excel mail merge

With your spreadsheet saved as .xlsx (or .csv) and your badge template open in Word, the workflow runs through Word’s Mailings tab.

  1. Mailings > Start Mail Merge > Labels. Select the badge sheet that matches your stock — for example, Avery 5395 from the manufacturer dropdown.
  2. Mailings > Select Recipients > Use an Existing List. Browse to your spreadsheet and select the worksheet containing the attendee data. Word will preview the column structure and ask you to confirm headers.
  3. Mailings > Insert Merge Field. Position the cursor where each data field should appear — for example, click in the first name area, then insert «First Name». Repeat for «Full Name», «Organisation» and any other fields. Apply font, size and alignment to each field as you would normal text.
  4. Mailings > Update Labels. This propagates your single-cell template across every cell on the sheet. Without this step, only the first badge will populate.
  5. Mailings > Preview Results. Cycle through to confirm field mapping is correct. Look for truncated long names, missing data and mis-merged columns.
  6. Mailings > Finish & Merge > Edit Individual Documents. This generates the full set as a new Word document, ready to print.

The new document is a flat, no-longer-merged file — safe to edit individual badges if you spot a problem before printing.

Google Docs alternative

Google Docs doesn’t have native mail merge in the same way Word does, but workable alternatives exist. The most common path uses a Google Sheets add-on — Autocrat, Mail Merge with Attachments, or Avery Label Merge — that maps Sheets columns to Docs template fields.

Install the add-on from the Google Workspace Marketplace, prepare your Sheet with one row per badge, then create a Docs template using merge tags like {{First Name}} where data should appear. The add-on reads the Sheet and produces a merged Docs file.

For events under 50 attendees, manually copying names into a tabled Docs template can be faster than configuring an add-on. Beyond that scale, the add-on workflow is the only practical option in Docs. Word with Excel remains the more mature mail merge environment for any run above 100 records.

Common pitfalls

Long names truncate inside fixed-size badge cells. Test with the longest name in your data before printing the full run; if it overflows, either reduce the font size globally or wrap to a second line.

Capitalisation imported from registration forms is often inconsistent. Some attendees type “JANE DOE”, others “jane doe”. Run a quick proper-case formula in Excel — =PROPER(A2) — before merging, then paste the results back as values.

Special characters and accents (é, ñ, ø) sometimes import as garbled symbols, especially from CSV files saved in non-UTF-8 encoding. Re-export the source file as UTF-8 if accents render incorrectly.

The same pitfalls apply to other mail merge contexts — the place card mail merge guide covers the equivalent workflow for wedding and event place cards.

Printing the merged set

Print one full sheet on plain paper first. Hold it against an unprinted Avery sheet to verify alignment; only then load the badge stock. For printer setup details and template-level troubleshooting, see the name badge Word templates guide. For broader event-day production planning — quantities, categorisation and on-site distribution — see setting up name badges for conferences and events.