How to Create Place Cards for Events Using Microsoft Word & Excel

Microsoft Word and Excel are the tools many people already have open when they start planning an event. It makes sense to use them — your guest list is probably already in a spreadsheet, and Word can handle the design side. This guide shows you exactly how to set up a place card mail merge using Word and Excel, plus an honest look at when the manual approach runs out of steam.

---

What You'll Need

• Microsoft Word (any version from 2016 onward)
• Microsoft Excel with your guest list
• Cardstock paper (65–80 lb recommended)
• A printer

If your guest list is in Google Sheets, export it as .xlsx or .csv first — Word's mail merge works with both formats.

---

Part 1: Prepare Your Excel Guest List

The quality of your mail merge depends entirely on how clean your data is. Get this right first.

Recommended Column Structure

Data Cleaning Checklist

Before running your merge, check:

• No blank rows in the middle of your list
• All names are spelled correctly (check twice)
• Name column has a clear header in Row 1
• No special characters in headers (avoid "Guest's Name" — use "Guest Name")
• Consistent capitalization (Word can't auto-capitalize for you)
• Table numbers formatted as numbers, not text with spaces

Save your Excel file and note its location — you'll need to navigate to it during the merge.

---

Part 2: Set Up Your Word Template

Step 1: Create the Place Card Layout

1. Open a new Word document
2. Go to Mailings → Start Mail Merge → Labels
3. In the Label Options dialog, select Avery US Letter from the vendor list
4. Find 5388 (the 3.5" × 2" place card, 6 per sheet) and click OK
5. Word creates a document with a 6-cell grid — each cell is one place card

If you prefer a tent card format, use Avery 5302 for a 4.25" × 1.33" slim tent, or set up custom dimensions for a folded 3.5" × 2" tent.

Step 2: Design the First Card

Click into the first cell (top-left card) and design your place card:

• Add a font: Highlight the cell and choose your font. For elegant events, try "Cormorant Garamond" or "Playfair Display" if installed; for classic formal use Times New Roman in larger sizes
• Center the text: Select all content in the cell (Ctrl+A within the cell) and click Center alignment
• Add a border: Right-click the cell → Table Properties → Borders and Shading — add a thin box border
• Adjust padding: In Table Properties → Cell → Options — increase cell margins to 0.1" for breathing room

Don't type a guest name yet — that's what the merge field will do.

Step 3: Insert the Merge Field

With your cursor in the first cell:

1. Go to Mailings → Select Recipients → Use an Existing List
2. Navigate to and select your Excel file
3. If prompted to choose a sheet, select the sheet containing your guest list
4. Back in the document, go to Mailings → Insert Merge Field
5. Select Full Name (or First Name, then space, then Last Name for separate columns)
6. You'll see «Full_Name» appear in the cell — this is the placeholder

Format the merge field exactly as you want the final name to appear — font, size, color all carry through.

Step 4: Propagate to All Cells

This step confuses many first-time users:

1. After setting up the first card, go to Mailings → Update Labels
2. This copies your merge field to all 6 cells on the page
3. You'll now see «Full_Name» in all 6 cells

Step 5: Preview the Merge

Click Mailings → Preview Results to see your actual guest names instead of field codes. Use the arrows to page through and spot any issues:

• Name too long? Reduce font size on those records
• Capitalization wrong? Fix it in Excel and refresh
• Wrong names? Check your Excel column headers

Step 6: Complete the Merge

When the preview looks right:

1. Go to Mailings → Finish & Merge → Edit Individual Documents
2. Select "All" and click OK
3. Word generates a new document with all your guests — 6 cards per page, one guest per card
4. Save this new document immediately

---

Part 3: Printing Your Place Cards

Printer Settings for Word

1. Load cardstock into the manual/straight-through paper tray
2. Go to File → Print
3. Set Paper Size to Letter (8.5" × 11")
4. Set Scale to 100% / Actual Size — this is critical
5. Print Quality: High or Best
6. Click Print

Pro tip: Print one test page on plain paper first. Hold it over a blank Avery 5388 sheet against a window — text should align with the card outlines.

After Printing

• Let inkjet prints dry for 3–5 minutes before stacking
• For Avery perforated sheets, gently tear apart along the perforations
• For plain cardstock, use a rotary trimmer for clean cuts

---

Part 4: Common Mail Merge Problems and Fixes

"My names are showing as {MERGEFIELD Full_Name}" instead of actual names

You're seeing field codes instead of values. Press Alt + F9 to toggle between field codes and values. If the preview still shows codes, make sure you've connected to the Excel file (Mailings → Select Recipients).

The merge only shows 6 guests, not all of them

You need to run Mailings → Finish & Merge → Edit Individual Documents to generate the complete document. Previewing only shows you how the merge looks — it doesn't generate all the pages.

Guest names are truncated

Font is too large for the cell. Either reduce font size or increase row height (Table → Properties → Row → Specify height).

Mail merge ran but the formatting is inconsistent

This usually happens when merge fields inherit mixed formatting. Select all text in the first cell, clear all formatting, and reapply a single font/size. Then click Update Labels again.

Excel columns aren't showing up in Word's merge field list

Check that Row 1 of your Excel sheet contains your headers. If headers are in Row 2 (with a title in Row 1), Word won't see them correctly. Delete the title row so headers are in Row 1.

---

Part 5: Beyond Word — When to Use a Dedicated Tool

Word mail merge works, but it has real friction:

• Setup takes 20–30 minutes even when you know the steps
• Every step has sub-steps that can go wrong
• Fixing formatting after the merge is tedious
• Adding a new guest after the merge means starting over

For events where this matters — especially weddings where the guest list changes weekly — Place Card Maker removes all of this friction.

The workflow is simply:

1. Open Place Card Maker
2. Choose a template
3. Go to /import-data and upload your Excel or CSV
4. Download the complete PDF — all cards generated automatically

There's no mail merge configuration, no field codes, no page propagation. The tool handles all of it, and updating your guest list means uploading a new file.

Try Place Card Maker free →

---

Use Cases: When Word Excels, When to Switch

---

Summary

Microsoft Word and Excel are a functional combination for place cards — especially if you're already comfortable with mail merge. The key steps are:

1. Prepare a clean Excel guest list with clear headers
2. Set up a Word label document using Avery 5388
3. Connect to your Excel data source and insert merge fields
4. Update labels to propagate across all cells
5. Finish & merge to generate the complete document
6. Print on cardstock at 100% actual size

For anyone who wants to skip the configuration and get straight to printing, Place Card Maker does the same job without the setup.