How to generate certificates from a spreadsheet

Set up the spreadsheet so any method works

Every merge method reads the same structure: a single sheet, a header row in row 1, and one recipient per row below it. Use short header names with no spaces or punctuation, such as Name, Course, Date, Score, Instructor, because those names become the placeholders in the template. A merge tag written as <<Name>> or {{Name}} must match the header exactly, including capitalization in most tools.

Put the name exactly as it should print. If the sheet has FirstName and LastName columns, either add a FullName column with a formula (=A2&" "&B2) or place two placeholders on the template. Format the date column as text in the form you want printed (March 4, 2026), because merges often reformat true date cells into 3/4/2026 or an ISO string.

Remove blank rows and any totals at the bottom; every non-empty row becomes a certificate. Add a column for the file name if you want control over it (for example smith-jane), and a column for the email address if the certificates will be sent later. Save or export as CSV with UTF-8 encoding so accented names survive.

Method 1: Google Sheets with a Slides template and a merge add-on

Design the certificate in Google Slides on a single slide, sized to the paper you will print on (File, Page setup, Custom, 11 by 8.5 inches for US letter landscape). Where the recipient's data should appear, type tags that match the sheet headers, such as <<Name>>, <<Course>> and <<Date>>. Keep the tags in their own text boxes so the merged text does not reflow the surrounding layout.

Open the Sheet, go to Extensions, and install a document merge add-on from the Workspace Marketplace (Autocrat is the widely documented one). Create a new job, pick the Slides file as the template, map each tag to a column, set the output file name using a tag such as <<Name>>-certificate, choose PDF as the output type, and choose a destination folder in Drive. Run the job. The add-on creates one PDF per row in the folder and writes the link back into a new column on the sheet.

Two practical limits: the add-on needs permission to your Drive and the sheet, which some school and company domains block, and large rosters run slowly because each PDF is rendered server-side one at a time. A few hundred rows is typical; a thousand takes a while but works.

Method 2: Word mail merge from Excel

Design the certificate in Word as a one-page document, landscape, with the background image set behind text. On the Mailings tab choose Start Mail Merge, Letters, then Select Recipients, Use an Existing List, and pick the Excel workbook and the sheet with the header row. Place the cursor where the name goes and use Insert Merge Field to add Name, Course and Date. Preview Results steps through recipients so you can check that long names still fit on one line.

To get separate PDFs, choose Finish and Merge, Edit Individual Documents, which produces one long Word file with a page per recipient, then split it, or Finish and Merge, Print, and select a PDF printer, which produces one file per certificate on most systems. Splitting the merged document into named files usually needs a small macro or a third-party splitter, which is the least convenient step of the Word route.

Microsoft's guidance notes the Excel data must be on one sheet and formatted so Word can read it; the first row must be the headers. Dates and numbers should be text-formatted in Excel, or Word may display them in a raw format.

Method 3: a browser batch tool from CSV to ZIP

The third route skips both office suites. Export the sheet as CSV, open a browser-based certificate generator, upload the CSV, pick a template or drop in your own certificate background as PNG or JPG, map the Name column and any optional columns to text fields on the template, adjust fonts and positions, and download a ZIP with one PDF per row named from the name column.

Benchlet Bulk Certificates works this way and does the merge in the browser, so the roster does not leave the computer, which matters for student rosters and employee training records. A few hundred single-page PDFs render in a minute or two on an ordinary laptop; 1,000 rows work but take noticeably longer because the machine doing the rendering is yours.

This route does not send email. If the certificates need to go out by email, attach the PDFs through a mail merge in Gmail (which supports merge tags and a linked Sheet) or Outlook, using the same sheet with an Email column.

Naming, checking and delivering the files

Name each file from the data, not sequentially: smith-jane.pdf is findable, certificate-047.pdf is not. Lowercase, hyphens instead of spaces, and no accents in the file name avoid problems on shared drives. If two recipients share a name, add the course or date to the pattern.

Before sending anything, open three PDFs at random: the first row, the last row, and the row with the longest name. Check that the name fits on one line, that the date printed in the intended format, and that the page size matches the paper (US letter or A4). A merge that works on row 1 can still overflow on a 32-character name.

For delivery, Gmail's built-in mail merge can send one message per row from a linked Sheet, with sending limits of roughly 100 messages per day on a free account and up to about 1,500 on a Workspace account. For larger batches, upload the PDFs to a shared folder and send links instead of attachments.

Frequently asked questions

Sources

• TCEA: The Autocrat add-on, generate certificates and progress reports from Google Sheets
• Microsoft Support: Use mail merge for bulk email, letters, labels and envelopes
• Google Apps Script sample: Create a mail merge with Gmail and Google Sheets
• Virtualbadge: How to send digital certificates with Office mail merge