You want to create dozens of award or completion certificates from a spreadsheet without setting up mail merge.
Create certificates for a full list of recipients without Word or other mail-merge software. Place names, course titles, and dates over a certificate background (PNG, JPG, or PDF) or a built-in template. Download one PDF or a ZIP of individual PDFs.
How to use it
- Add a recipient list by dropping in an XLSX, CSV, or TSV file, selecting one, or pasting a table and selecting Read list. Include a header row such as
Name,Course,Date, followed by one recipient per row with columns separated by tabs or commas. Header and name columns are detected automatically and can be changed in Advanced settings. You can create up to 500 certificates at once. Select Try an example to load eight sample recipients and a text layout. - Choose a background and page size. Upload a PNG or JPG image, or a PDF (only its first page is used), or choose one of the built-in templates: Classic Border, Double Border, or Minimal Border. Page sizes are A4 portrait, A4 landscape, or the original background size.
- Place text fields by dragging a column name onto the preview or clicking it. Select a field to change its font, size, width, alignment, color, or weight. Choose Sans (default), Display, Serif, or Handwriting for each field. The default size is 30 and color is #222222. Drag a selected field or use the arrow keys to move it. Long text shrinks automatically to fit its field. Review recipients using Previous and Next. After reading the list, place at least one text field to enable downloads.
- Download one page per recipient in a single PDF, or choose a ZIP with one PDF per person. Individual files are named
{name}_certificate.pdf; duplicate names get a number such as{name}_2_certificate.pdf. Choose 150 or 300 dpi for print quality.
Create dozens of certificates from one spreadsheet
Preparing certificates for a graduation or awards event often means setting up mail merge, linking fields, and checking every page. It is easy to miss a typo in a name. This tool handles the process in your browser. Add a list and a certificate background, or start with a built-in template.
A spreadsheet or CSV with a header row is the easiest format, but you can paste a table too. The tool detects the name column. If your list has several columns, confirm the name column in Advanced settings. Duplicate names get a number in their individual filenames. If you have certificate IDs, include that column so you can check each file.
A PDF or image background gives the most consistent look. If you do not have one, try the Classic Border, Double Border, or Minimal Border template. Place fields over the background and make the name field wide enough. Long names shrink to fit, but a narrow field can make text hard to read.
Review the first recipient and page through the list to check names, course titles, and dates before downloading. A single PDF is convenient for printing; a ZIP is useful when you need to send certificates individually. Text in the completed PDF is not selectable or copyable because it is rendered as an image.
What this helps with
- Set up mail merge in Word or another editor → Upload a list and place fields by dragging them onto the page.
- Copy a certificate template and change every name by hand → Create certificates for the entire list with one layout.
- Save each certificate image and convert it to PDF one at a time → Download one combined PDF or a ZIP of individual PDFs.
Limitations
- You can create up to 500 certificates at once. Split larger lists into batches.
- Text in the finished PDF is not selectable because it is rendered as an image. Keep the original recipient list if you need searchable text.
- Large lists and 300 dpi require more memory and time. For dozens of recipients, try 150 dpi first and use 300 dpi only when you need higher print resolution.
- Only the first page of a PDF background is used. Put the page you need first before uploading a multi-page PDF.
- Duplicate names get suffixes such as
_2and_3in individual filenames. Check them using a certificate ID if available. - Long names shrink to fit the field width. Make the name field wider if the text becomes too small.
- With Original background size, PDF backgrounds keep their page dimensions; image backgrounds use a page size based on 150 dpi.
- This tool does not send email. Download the PDFs and share them yourself.
- Fonts support different character sets. If a name contains a character that is unavailable in the selected font, a notice appears and only that character is rendered in Sans or the device default font. Check the preview.