July 12, 2026 · 6 min read
How to Generate 100 Certificates in a Minute
Stop copy-pasting names into a certificate template one at a time. Here's how to go from a spreadsheet of attendees to a folder of finished certificates in a single run.
A hundred certificates by hand means opening your design tool, typing a name, exporting, renaming the file, and repeating a hundred times. Even at a brisk thirty seconds a certificate, that's the better part of an hour, and it only gets worse the moment someone tells you the attendee list grew to four hundred.
The actual bottleneck isn't the design work, it's the repetition. You already designed the certificate once. What you need is a way to stamp a name (and maybe a date, a course title, or a score) onto that same design, over and over, without touching it by hand each time.
What you'll need
- Your certificate as a PDF. Export it once from whatever you designed it in (Canva, Illustrator, PowerPoint, anything that can export a PDF). This is the template every generated certificate will be based on.
- A spreadsheet with one row per recipient. At minimum, a name column. Most certificates also want a date, a course or event title, and sometimes a score or grade, each as its own column.
Step by step: from spreadsheet to finished PDFs
- Upload the certificate PDF to the AutoPDF editor. It renders on screen exactly as designed.
- Upload the spreadsheet. AutoPDF reads the column headers and, if you haven't placed any fields yet, offers a one-click "Add" button per column, including the name column, so the first field takes one click.
- Place the name field. Click where the recipient's name goes, drag it to the right size, and set the font to match your design. Long names can get clipped by a box that's too short, so this is also where vertical alignment matters: set it to middle, and a name will stay centered in its box whether it renders as one line or wraps to two.
- Add any other fields your certificate needs (date, course, signature line, score) the same way.
- Preview one certificate with real data before generating the rest. Thirty seconds here catches font or alignment issues before they show up on certificate number seventy-three.
- Generate the batch. Every row becomes one certificate. Pick a column, like the recipient's name or ID, to name the output files, and the whole run comes back as a single ZIP.
Design tips that actually matter at scale
- Leave more horizontal room than the longest name needs. "Ed Lee" and "Christopher Alexandropoulos" are both going in the same box.
- Center-align text horizontally for names on most certificate templates, since certificates are usually center-balanced designs.
- Use middle vertical alignment for anything that might wrap to a second line, so it doesn't creep outside its box or sit off-center when it doesn't wrap.
- Pick a font that's actually installed everywhere the PDF might get opened. Sticking to the standard set (Arial, Times New Roman, Georgia, and similar) avoids the certificate rendering differently for whoever opens it.
Beyond 100: what changes at real scale
A hundred certificates is barely a warm-up. The same process holds for a full graduating class, a multi-track conference, or a company-wide training rollout, generation runs as a background job so it isn't limited by how long a single web request can stay open, and a batch can run up to 5,000 rows. You get a live percentage and current-row indicator while it works, and a ZIP link when it's done.