How to generate certificates from Excel or CSV

1. Prepare the recipient list

Use a heading such as Full name, Participant, or Student name. Cert Generate detects the name column, ignores unrelated columns, removes repeated names, and capitalizes each name. Separate first, middle, and last-name columns are combined automatically.

Email and score are optional. Email addresses are used only when you choose individual email delivery; they are never printed on the certificate.

2. Upload your certificate design

Open the generator and upload a JPG or PNG under 10 MB. Use a design with a blank area for the recipient name. The course title, date, and fixed certificate wording should already be part of the background design.

Read the certificate template preparation guide if you need help finding or exporting a design.

3. Import the spreadsheet or type names

Choose Continue to names, then Excel / CSV. Upload your file and check the recipient count. For a small group, choose Type names manually and enter names like this:

Alex Morgan, Sara Ahmed, Daniel Lee

Each comma starts a new recipient. Blank entries are ignored. If a name includes a comma, use an Excel cell or a correctly quoted CSV field instead of manual entry.

4. Customize names, logos, and signatures

The preview uses the longest name in your list to help you check available space. Choose a font, size, color, and alignment, then drag the name into position. Reduce the size if the longest name runs outside the intended area.

Add your logo, stamp, or signature as an image and adjust its size and position. Multiply mode visually blends light paper, while Remove Paper Background clears bright white, off-white, and soft neutral shadows more directly.

5. Download PNG, JPG, PDF, or ZIP

Choose PNG for lossless images, JPG for smaller individual files, PDF to combine the complete batch into one document, or ZIP to package every certificate as a PNG in one archive.

Keep the tab open while files are generated. If your browser blocks multiple downloads, allow them or use the Save file links on the download page. Extract a ZIP archive before opening its certificates. Check one result before distributing the batch.

Troubleshooting your batch

• No names found: add a clear name-column heading and upload .xlsx or .csv.
• The wrong column was selected: rename the intended heading to “Full name” or “Participant name.”
• Long names overflow: reduce the text size or move the name to a wider part of the design.
• Blurry certificate: upload a higher-resolution original template. Exporting preserves the source dimensions.
• Files disappeared after a refresh: uploads and generated files are held in the current tab session. Upload them again to restart.