Skip to content
utilnest

Guide

How to make certificates for a whole list of names at once

Design one certificate for a class, course, workshop or event, fill in every name from a list or CSV file, and download them ready to print or to email one by one.

Updated November 16, 20262 min read

Certificate generator

Works in your browser · No sign-up · Free to use

Open Certificate generator

A workshop with 80 participants, a school prize day or an online course: typing every name into a certificate template by hand takes hours, and one typo means starting again. With a list of names, you design the certificate once and get one for every person.

Step by step

  1. Open Certificate generator. It works in your browser, so your list stays on your device.
  2. Pick a Style: Classic, Modern or Minimal.
  3. Pick a Type: Achievement, Completion, Appreciation, Participation, Excellence or Custom. Each type fills in a matching title, such as "Certificate of Completion".
  4. Edit the Title, the Line above the name and the Text below the name, then add the Organisation, the Date and up to two signature lines with a name and a role.
  5. Choose a Colour, the Paper (A4 or Letter) and, if you like, Add logo (a PNG or JPG under 600 KB).
  6. Under Names, choose One name per line and paste your list, or Spreadsheet (CSV) to use a file.
  7. Check the preview, then download.

One PDF or separate files?

  • Download PDF gives one file with a page per person. Use it to print the whole set in one go.
  • ZIP of separate PDFs gives one PDF per person, named after them. Use it to email each certificate to its owner.

The certificates are landscape and the text stays real text, so they print sharply at any size.

Using a spreadsheet

A spreadsheet lets every certificate carry more than a name:

  1. In Excel or Google Sheets, put a header row at the top, such as name, course, grade, and one person per row.
  2. Save or download the sheet as a CSV file.
  3. In the tool, choose Spreadsheet (CSV), then pick the file or paste its contents, and choose the Name column.
  4. Write the other column names in curly brackets anywhere in the texts, for example "for completing {course} with grade {grade}". {name} is always the person's name.

The hint under the text fields lists the placeholders your file offers. If the list has stray spaces, empty rows or duplicates, tidy it first with CSV cleaner.

Before you print

  • Check the longest name in the preview. Very long names and texts are made smaller so they fit.
  • Names in other scripts, such as Arabic, Urdu or Chinese, can't be shown and come out as "?". Names in Latin letters, with accents, work.
  • More than 1,000 people? Split the list and run it in parts.

Signatures

The signature lines print a name and a role under a line, ready to sign by hand. To add a signature image to the PDF instead, open it in Sign PDF, draw or upload your signature and place it on the page.

Questions

How many certificates can I make at once?

Up to 1,000 at a time. For a longer list, split it and run it in parts.

Can I put a course name or grade on each certificate?

Yes. Use a CSV file with a column for it and write the column name in curly brackets in the text, for example {course} or {grade}. Each certificate gets that person's value.

Why does a name show question marks?

The certificates use the standard PDF fonts, which cover Latin letters with accents. Names in other scripts, such as Arabic, Urdu or Chinese, show as "?".

Is my list of names uploaded?

No. Certificate generator works in your browser, so the names stay on your device.