ε€€VALUES

πŸ… One template, many certificates

If you are making thirty certificates by changing the name and saving thirty times β€” you don't have to. Word can do it for free.

1 β€” Get the list into a table

In Excel, make a table whose first row is the column names. That is all.

Name Department Award John Smith Accounting Excellence Mary Jones Marketing Merit

The first row (Name, Department, Award) becomes the names of the blanks in your template. Avoid empty rows and merged cells β€” keep it a clean rectangle.

2 β€” In Word: Mail Merge

Open your certificate in Word β†’ Mailings β†’ Select Recipients β†’ Use an Existing List β†’ choose the Excel file β†’ put the cursor where the name goes β†’ Insert Merge Field β†’ Name β†’ do the same for Department and Award β†’ Preview Results and step through β†’ Finish & Merge β†’ Edit Individual Documents β€” thirty pages in one file
Always preview

Look at the first page and the last. Lines that shift or a name that wraps onto two lines almost always show up first with the person who has the longest name. Finding it after printing thirty sheets wastes paper.

3 β€” Where it usually breaks

What you seeWhy, and the fix
Dates come out in the wrong formatThe raw date value came through. Easiest fix: turn the date into text in Excel first (e.g. 27 September 2026)
Numbers grow long decimalsSame reason. Turn amounts and counts into text in Excel first
A name wraps onto two linesOne long name. Shrink the font a little in that spot, or widen the box
Someone's page reads oddlyA blank cell in the list leaves a hole in the sentence. Fill the list first

4 β€” The limits of this method

If you do this every week

We sell a small Windows program: give it a list and a template and it makes one file per person, named from the list (John Smith_Excellence), in Word, Excel or Hangul templates. At the end it tells you how many it made and which rows it skipped.

No internet needed, nothing leaves your computer. A monthly subscription you can cancel any time.

πŸ“ Smart Form Filler β€” $1.99 / month

Where this comes from

Menu names are from current Microsoft 365 Word.
Everyone’s situation is different. The numbers here are examples β€” swap in your own.

VALUES is a small shop that makes tools to take work off your desk Β· More guides Β· The tool shelf Β· Bookshop Β· Free downloads Β· Seller information