How to make certificates from an Excel list

You have a spreadsheet with one row per person and you need a certificate for each of them. There are three common ways to do it. Which one is best depends on how many certificates you make and how often.

Step 1: get the spreadsheet right first

Whatever tool you use, a clean list saves most of the work:

• One row per certificate, with headers in the first row.
• Simple column names such as Full_Name, Course_Title, Completion_Date, Cert_ID. Avoid spaces and symbols.
• Names spelled as people want them printed. Fix ALL CAPS, nicknames and stray spaces now.
• Dates typed as text in the format you want printed (for example “14 November 2026”), so no tool reformats them.
• A unique certificate number per row, so you can confirm a certificate later.

Our free spreadsheet checker finds blank names, duplicate IDs and encoding problems before you start.

Option 1: Microsoft Word mail merge

1. Design the certificate in Word, landscape.
2. Go to Mailings → Start Mail Merge → Letters, then Select Recipients → Use an Existing List and pick your Excel file.
3. Insert merge fields where the name, course and date go.
4. Choose Finish & Merge → Edit Individual Documents to create every certificate.

Good for: people who already know Word. Watch out for: the merge gives you one long document. Saving one PDF per person needs a macro or another tool, and dates and numbers from Excel often need format switches to print correctly.

Option 2: Google Slides or Docs with an add-on

Add-ons such as Autocrat merge rows from Google Sheets into a Slides or Docs template and can save a PDF per row to Drive, or email it. Setup takes a while the first time (template tags, mapping, output folder), but it works well once it’s running.

Good for: teams that live in Google Workspace. Watch out for: your recipients’ data passes through the add-on and your Drive, and large batches can hit Google’s daily quotas.

Option 3: a bulk certificate generator

A dedicated tool skips the template building: you upload the spreadsheet, pick a design, map columns to the certificate and download every certificate as separate PDFs in a ZIP, or one merged file for printing.

With BulkCertPDF it works like this:

1. Upload your .xlsx or .csv file (or start from a template).
2. Pick one of eight designs and add your logo and signatures.
3. Type merge tags such as {{Full_Name}} into the wording. Any column can be used.
4. Click through the preview to check long names and odd rows.
5. Export a ZIP with one named PDF per person, or a single print PDF.

The spreadsheet is processed in your browser and never uploaded. It’s free for up to 25 certificates a month.

Which should you choose?