Browse software
Home › Free tools › Bulk certificate generator

Bulk certificate generator — certificates from Excel, free

Make a certificate for everyone on your list at once. Upload an Excel or CSV file, paste from Google Sheets, or type the names; choose one of six designs or your own template. Long names are fitted, every certificate gets an ID and a QR code, and you download one PDF, a ZIP with a PDF for each person, or print them. Free, unlimited, no watermark.

1Names — your list
Which column is which
2Design
3Wording

{Course} and other fields are filled from your list and printed in bold. Words in [square brackets] are left out when a field inside is empty — e.g. [ with a score of {Score}]. **Two stars** make words bold.

4Organisation, date, ID & QR
Logo
Logo

Used when the list has no ID column: CERT-2026-0001, 0002…

Put your own check page here to let people verify a certificate, e.g. https://yourschool.com/verify?id={ID}

5Signatures & seal
Signature 1
Signature 2 (optional)

No picture? The name is written in a handwriting font. A PNG with a clear background looks best.

How to make certificates in bulk from Excel

  1. Make a list in Excel or Google Sheets with a header row — for example Name, Course, Date, Score, Email. One person per row.
  2. Upload the .xlsx or CSV file, or copy the cells and paste them. Check that the name column is matched to {Name}.
  3. Pick a design — or upload your own certificate template — and set the wording, logo and signatures.
  4. Look through the people with ‹ and ›. Long names shrink to fit by themselves.
  5. Press All in one PDF, or ZIP — a PDF each to get one file per person, named after them.

This bulk certificate generator is free, and it has no limit on the number of names and no watermark. It works on a computer or a phone.

Six certificate designs

Classic gold

A gold double border with corner ornaments, the name in handwriting and a gold seal. For schools, academies, awards and certificates of appreciation.

Modern

A dark band with your logo, the certificate ID and date, a large name and a QR code. For training courses, companies and workshops.

Diploma

An ornamental blue frame with a red ribbon seal and two signatures, like a university or institute diploma.

Minimal

Clean and left-aligned with the date, ID and hours in a row and a small QR code. For webinars, conferences and online courses.

School

Bright colours, stars and a medal for primary schools, summer camps, sports days and star student awards.

Your own design

Upload a certificate template you made in Canva, Word or PowerPoint as PNG, JPG or PDF and drag the name and other fields onto it.

Certificate of completion, achievement, appreciation and participation

Pick the wording with one click and change it as you like:

CertificateTypical wording
Certificate of completionThis is to certify that … has successfully completed {Course}.
Certificate of achievementThis certificate is proudly presented to … for outstanding achievement in {Course}.
Certificate of appreciationThis certificate is presented to … in sincere appreciation of the valuable contribution to {Course}.
Certificate of participationThis is to certify that … has participated in {Course}.
Certificate of excellence… is hereby awarded to … in recognition of excellent performance in {Course}.
Training certificateThis is to certify that … has completed the training {Course} ({Hours} hours).

Mail merge certificates without Word

Mail merge certificates in Word, PowerPoint or Google Slides need a template, a data source and some setup, and they often break with long names. Here every column of your list is a field you can use: {Name}, {Course}, {Date}, {Score}, {Hours} or any column name. Each row becomes one certificate, names are fitted to the space, and certificate IDs and QR codes are added for you. To email them, download the ZIP and the email list with each person's address and file name.

E-certificates with ID and QR code

Every certificate gets a certificate ID — from your list, or numbered for you such as CERT-2026-0001. The QR code holds the ID, name, course and date, or a link to your own verification page, for example https://yourschool.com/verify?id={ID}.

Printable certificates in A4 and Letter

Choose A4 or US Letter, landscape or portrait. The PDF keeps text sharp at any size, so certificates print clearly at home or at a print shop. Use Print to send all of them to your printer at once.

Frequently asked questions

Is this bulk certificate generator free?

Yes. Make as many certificates as you need, for lists of any length. There is no sign-up, no monthly limit and no watermark on your certificates.

How do I generate certificates from Excel?

Put the names in an Excel sheet with a header row (for example Name, Course, Date), upload the .xlsx or CSV file, check which column is the name, pick a design and press the PDF button. Every row becomes one certificate.

Can I generate certificates from a Google Sheet?

Yes. Select the cells in Google Sheets including the header row, copy them, press Paste from Google Sheets or Excel and paste. You can also download the sheet as CSV and upload it.

Is this like mail merge certificates in Word?

It does the same job without Word: each column of your list fills a field such as {Name}, {Course} or {Date}, and you get one certificate per row. It also fits long names, numbers the certificates and adds QR codes.

Can I use my own certificate design?

Yes. Choose Your own design and upload your certificate as PNG, JPG or PDF (for example one made in Canva or Word). Then drag the name, course, date, ID and QR boxes to where they belong and download.

How do I send the certificates by email?

Download the ZIP with one PDF per person and the email list. The list has each person's name, email address and the name of their PDF file, ready for Gmail, Outlook or any mail merge tool.

Which certificates can I make?

Certificates of completion, achievement, appreciation, participation, excellence and training, for students, employees, trainees, volunteers and event attendees. Change any wording to your own.

Is my list of names uploaded anywhere?

No. The list is read and the certificates are made in your browser. Names and email addresses are not sent to our server. Only the design settings are remembered on this device, and the list too if you tick Remember.

Related