Designing bulk certificates and mail merge lists locally
Generating awards for a graduating class, workshop cohort, or volunteer team starts with clean recipient data and consistent typography. Using a private certificate generator without an account lets you make certificates from an Excel list and generate award certificates in your browser using a reusable certificate template.
How to make certificates from an Excel list and CSV
You can type or paste names directly into Names one per line, or click Open a list (CSV or text) to import a .csv or .txt file up to 10 MB. Following IETF RFC 4180 CSV Format Specification conventions, the parser extracts the first column of comma-delimited or tab-delimited rows and strips surrounding quotation marks cleanly.
If row one contains a Name or Full Name header, the importer skips it automatically so no blank header certificate is generated. Inside What it’s for, inserting {name} repeats the recipient’s name in the body text while fitting up to four wrapped lines. If you need multi-column personalization on custom letterhead, switch to the browser-based mail merge PDF tool.
Choosing Classic, Modern, or Minimal layouts with custom logos
Seven preset titles sit in the Title dropdown, including Certificate of Completion, Certificate of Achievement, and Award, and any custom heading fits automatically above the intro line. Up to two signers appear along the bottom baseline alongside Date and Organisation small print.
When Seal is enabled, the renderer draws a 24-point rosette and five-pointed star in your selected accent colour. It shifts between the bottom center and the right margin depending on whether one, two, or three bottom signature columns are active.
Certificate border design, layouts, and paper sizes
Each Design option maps to distinct border geometry, font pairing, and paper coordinates measured at 72 points per inch under the Library of Congress PDF 1.7 Format Description. Pick the certificate border design that fits formal academic diplomas, corporate training completions, or event participation awards.
| Design or paper option | Typography pairing | Border and accent geometry | Best suited for |
|---|---|---|---|
| Classic | Times Roman Bold + Bold Italic | 6 pt outer border, 1.2 pt inner rule, corner squares |
Academic diplomas and formal awards |
| Modern | Helvetica Bold + Helvetica | 6% solid left accent band with 35% opacity stripe |
Corporate training and workshops |
| Minimal | Helvetica Bold + Times Roman name | 0.8 pt light grey perimeter frame |
Clean participation and event awards |
| US Letter | 792 × 612 pt (11 × 8.5 in) |
Landscape North American letter stock | US and Canadian office printers |
| A4 | 841.89 × 595.28 pt (297 × 210 mm) |
Landscape ISO 216 international stock | UK, EU, and APAC printers |
Every preset renders using Standard 14 PDF fonts, which keeps output file sizes compact and guarantees crisp vector text in any viewer. When organizing live conferences or graduations, you can also print matching attendee name badges from the same CSV to keep registration tables consistent.
Should you export one multi-page PDF or separate PDFs in a ZIP?
Export one multi-page PDF when feeding a stack of blank card stock into an office printer, and check One PDF per person (in a ZIP), to email them separately when distributing digital credentials to individual recipients. Both modes use identical typography, margins, and accent colours, differing only in how the finished pages are packaged.
When a single multi-page PDF fits batch printing
Leaving the ZIP checkbox unselected produces a single landscape PDF containing one page per recipient name. This layout lets you open one print dialog, set duplex off, and run an entire cohort through a tray of certificate paper in one pass.
If you plan to sign every certificate digitally before printing or archiving, you can apply a visual or handwritten signature to issued PDFs in one step. Standard 14 fonts keep a 100-page batch compact because no external font binaries are duplicated per page.
When a ZIP archive of individual PDFs simplifies email delivery
Checking One PDF per person (in a ZIP), to email them separately generates an individual single-page PDF for each name and bundles them according to the Library of Congress ZIP File Format Description. That saves you from splitting pages manually before attaching files to individual emails or learning management portals.
Remember that Standard 14 fonts cover the WinAnsi Latin-1 character set. If any recipient name contains characters outside that range, the generator substitutes ? and displays an exact count on the result screen so you can spot affected records immediately.
Print preparation, logo scaling, and local browser privacy
Physical print quality and data privacy depend on how images are prepared and where files are processed. Because Certificate preview renders the real PDF output with a 350 ms debounce, you can verify line wrapping, signer spacing, and logo proportions before exporting a large batch.
Scaling logos cleanly without distorting print margins
Clicking Add a logo accepts PNG, JPG, WebP, GIF, or SVG files up to 10 MB. Using the MDN Web Docs HTML5 Canvas API, the browser scales large images down to a maximum of 1000 × 400 pixels before embedding them centered above the Title at up to 160 × 54 PDF points.
That automatic downscaling prevents multi-megabyte high-resolution logos from bloating a 50-person ZIP archive. If you are assembling an event welcome kit alongside certificates, you can prepare matching printable card layouts locally without uploading data.
Printing landscape certificates at 100% scale on card stock
Heavy paper between 160 and 250 gsm feeds cleanly through most laser and inkjet rear trays when set to heavy media or card stock mode. Always select 100% or Actual size in your print dialog rather than Fit to printable area so outer borders remain evenly balanced.
Tip: Generate a single test page using your longest recipient name first, print it on plain paper at
100%scale, and hold it against your certificate stock before running a full batch.
All CSV parsing, canvas logo resizing, and @cantoo/pdf-lib document assembly execute inside your browser tab. Recipient lists, signer names, and organization logos are never transmitted to external servers.