π 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.
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
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 see | Why, and the fix |
|---|---|
| Dates come out in the wrong format | The raw date value came through. Easiest fix: turn the date into text in Excel first (e.g. 27 September 2026) |
| Numbers grow long decimals | Same reason. Turn amounts and counts into text in Excel first |
| A name wraps onto two lines | One long name. Shrink the font a little in that spot, or widen the box |
| Someone's page reads oddly | A blank cell in the list leaves a hole in the sentence. Fill the list first |
4 β The limits of this method
- One separate file per person takes a lot of extra clicks β Mail Merge joins everything into one file by default.
- Naming each file after the person (βJohn Smith_Excellence.pdfβ) is not something the built-in feature does.
- With two or three templates (certificate, completion, confirmation letter) you start over each time.
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 / monthWhere 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