How to generate certificates in bulk

Issue personalized certificates in bulk: turn a spreadsheet of attendees or students into PDF certificates and email each one automatically.

To issue certificates in bulk, design one certificate in Microsoft Word with placeholders like {{ Name }} and {{ Course }}, list your recipients in a spreadsheet with one row per person, and use certificate software to generate a personalized PDF for every row. With TemplateDocs you can upload the spreadsheet as a CSV file and download a zip file of certificates, email each certificate to its recipient, or create a certificate automatically whenever a row is added to Google Sheets, Airtable or your CRM.

The process is exactly the same whether you're issuing certificates for conference and webinar attendees, workshop participants, course completers, award winners, or more. Follow the step by step guide below to get started.

How to generate certificates in bulk

In this article:

What to look for in bulk certificate software

Most certificate tools can fill in a name. For issuing hundreds of certificates after an event or a course, check that the software can:

TemplateDocs covers all of these. The steps below show how.

Step 1: Turn your certificate into a template

Start from your own certificate design in Word, or download the sample template below. Any layout Word can produce works: landscape pages, borders, background artwork, logos, signatures and script fonts. Replace every detail that changes per person with a tag in double curly braces:

On the certificateTag
Recipient name{{ Name }}
Course or event name{{ Course }}
Completion or attendance date{{ CompletionDate }}
Certificate of completion template with Name, Course and CompletionDate tags

Click the certificate to download it as a Word template.

Format each tag the way the value should look. The font size and style are preserved. Then upload the document as a new template in TemplateDocs.

Step 2: Prepare the recipient list

Depending on how you intend to generate the certificates, prepare the recipient list in one of two ways:

  1. If you plan to use Option A: download all certificates as a zip file or Option B: email each certificate from a CSV file, create a CSV file as described below.

  2. If you plan to use Option C: create a certificate for every new row in a Google Sheets, an Airtable base or your CRM, simply make sure that the data source has a column for each tag, and move on to the next step.

Creating a CSV file

List one recipient per row, with the column names in the first row. Name the columns after your tags, so they're matched automatically.

Add an Email column if you plan to email the certificates.

NameEmailCourseCompletionDate
Alex Leealex@example.comCPR BasicsNovember 4, 2026
Sam Taylorsam@example.comCPR BasicsNovember 4, 2026

A few tips:

Step 3: Choose how to generate

There are three ways to generate certificates in bulk. Pick the one that matches your use case best.

Zip fileEmail from CSVEvery new row
Best forCertificates you'll print or send yourselfEmailing a whole list after an eventIntegrating with your existing platform
OutputOne zip file with all certificatesOne file per row, emailed and saved to your storageOne file per new row, emailed and saved to your storage
Rows at once *Up to 25Up to 100No limit
* The limit is for a single batch. Repeat the process as many times as you need until all certificates are generated.

Option A: Download all certificates as a zip file

  1. Open the certificate template and switch to the Quick Document tab.
  2. Choose PDF, then click Bulk...
  3. Upload your CSV file.
  4. Check that each column is mapped to the right tag. Columns named like a tag are matched automatically.
  5. Check the preview, then click Generate N Documents.
Bulk Generate Documents dialog with certificate CSV columns mapped to the template tags and a three-row preview

Keep the browser tab open until the batch finishes. The zip file with one certificate per row downloads automatically.

Back to top

Option B: Email each certificate from a CSV file

A workflow generates each certificate and delivers it in the same run. Set it up once and reuse it for every course or event.

1. Create the workflow from the template

  1. Open the certificate template. On the Overview tab, choose Collect with a form.
  2. Choose Simple form and click Continue.
  3. Keep Send an email on, name the workflow, and click Create workflow.
Template Overview tab asking how to use the template, with Collect with a form, Trigger from an event and Quick document options

TemplateDocs creates a workflow with a form that has a field for every tag, a Document step that fills in the certificate, and an Email step. A few adjustments turn it into a certificate workflow:

  1. In the form designer, add an Email field for the recipient's address.
  2. In the Document step, change the format next to the Document name from DOCX to PDF.
  3. In the Email step, replace the To Address with the Email form field (type @ to insert it). Write a subject and message.

2. Save a copy to cloud storage (optional)

To keep a copy of every certificate, add a Google Drive, Dropbox or OneDrive step after the Document step, and choose the folder to save to.

3. Start the batch

  1. On the Workflows page, open the workflow's menu and choose Bulk Start (or Bulk Test if it is not published yet).
  2. Upload your CSV file and check the column mapping and the preview.
  3. Click Continue, review any validation results, then click Start N runs.
Workflows page with the Course Certificates workflow menu open on Bulk Start
Bulk Start Workflow dialog with certificate CSV columns mapped to the form fields and a three-row preview

Each row starts its own run, so every recipient gets their own email with their own certificate. You can close the progress screen at any time; the runs continue in the background. The workflow's Run History shows each run, its input data and the generated certificate.

Back to top

Option C: Create a certificate for every new row

Instead of exporting a CSV file after every event, let a workflow watch your spreadsheet. Each time a row is added, or a student is marked as completed, the workflow creates that person's certificate and emails it.

1. Create the workflow from the template

  1. Open the certificate template. On the Overview tab, choose Trigger from an event.
  2. Choose Google Sheets (or any of the other supported data sources, including Airtable, Notion, and more) and click Continue.
  3. Keep Send an email on, name the workflow, and click Create workflow.

The workflow opens with the trigger selected.

Template Overview tab asking how to use the template, with Collect with a form, Trigger from an event and Quick document options

2. Connect your data source

This guide uses Google Sheets as an example. Other sources, such as Airtable, Notion or HubSpot, work the same way: connect your account, choose the table or list to watch, and choose when a certificate is created. Each trigger's documentation covers its exact settings.

  1. Click Sign in under Account, then pick the spreadsheet and the sheet. Turn on Table contains header if the first row holds the column names.
  2. Choose when a certificate is created:
    • Row added - every new row gets a certificate. This suits attendance lists that grow after each session.
    • Row changed - pick a Column, such as Status, and add a Rows must match condition, such as a Status of Completed. Only the people who finish get a certificate.

3. Set up the certificate and the email

  1. In the Document step, open the Tag Mapping and map each tag to its column under the sheet's Row. Type @ in a tag's field to pick the column, or click Get suggestions to let TemplateDocs map the tags for you.
  2. In the same step, change the format from DOCX to PDF.
  3. In the Email step, insert the row's Email column into the To Address, and write a subject and message.
Document Mapping dialog with the Name, Course and CompletionDate tags mapped to the columns of the Google Sheets row

You can save a copy to cloud storage the same way as in Option B. To keep track of who received a certificate, add a Google Sheets - Write row step that fills a Certificate sent column.

4. Test and publish

Other data sources

Google Sheets and Airtable are just two of the apps that can start the workflow. The same flow works with other triggers:

Back to top

Frequently asked questions

Can I send each certificate to its recipient by email?

Yes. Use a workflow with an Email step, and insert the recipient's email field into the To Address. Each row in the CSV file sends its own email with its own certificate attached.

Can I save a copy of each certificate to cloud storage?

Yes. Use a workflow with a Google Drive, Dropbox or OneDrive step, and choose the folder to save to.

Can each certificate have its own QR code?

Yes. Add a tag to the template, name it whatever you prefer, for example {{ QrCode }}. Then, set its type to QR Code in the template's Quick Document tab, or in the Document step's Tag Mapping when you use a workflow. Add a matching column to your data source (for example "QrCode") with each recipient's verification link. Each certificate gets a code that points to its own link. See QR Codes for size and color options.

Can I use Google Sheets or Airtable instead of uploading a CSV file?

Yes. Connect Google Sheets, Airtable and other data sources to automatically create a certificate whenever a row is added or marked as completed. See Option C.

How many certificates can I issue?

As many as you need. With a Google Sheets or Airtable trigger, every new row creates its own certificate, with no limit. CSV uploads run in batches of up to 100 rows for a workflow, or 25 for a Quick Document, so for a longer list you can split the file and start one batch per file.

Will the generated certificates look exactly like my Word design?

Yes. Only the tags change. Fonts, borders, background images, page orientation and layout are kept as they are in your Word document.

What does it cost?

Each generated certificate uses credits, like any other document. You can start for free. See Credits and the pricing page for details.

Automate Your Document Workflows

Collect data with forms, apply your business logic, and deliver polished Word and PDF documents automatically.