Create hundreds of personalized certificates in one click by combining your PowerPoint certificate template with recipient data from Excel.
Put field names in the first row of your Excel file. Each following row becomes one generated certificate. You can put fields in any order, as you need them - it's up to you. The fields you use are also flexible - these don't have to be the same as shown in our samples.
| name | company | title | date of achievement | course name |
|---|---|---|---|---|
| Jane Smith | Acme Training | Senior Analyst | 2026-08-10 | Advanced PowerPoint Automation |
| John Doe | Example Corp | Project Manager | 2026-08-10 | Presentation Mail Merge Basics |
Every column name from Excel becomes a placeholder field that you can insert into the PowerPoint certificate template as a text box, title, subtitle, or any other text on the slide.
name becomes {{name}}.company becomes {{company}}.title becomes {{title}}.date of achievement becomes {{date of achievement}}.course name becomes {{course name}}.{{ date of achievement }} matches date of achievement, but spaces inside the column name are preserved exactly. If the Excel column contains two spaces inside the name, use the same two spaces in the placeholder. Capitalization is also significant: Date Of Achievement is different from date of achievement.
To include participant photos, logos, or QR codes inside the certificate template, refer to the documentation for images in PowerPoint templates and QR codes in PowerPoint templates.
Certificate_{{name}}.pptx can produce files like Certificate_Anna_Smith.pptx and Certificate_John_Doe.pptx.