1. Upload your participant list
In Google Sheets: File → Download → Microsoft Excel (.xlsx) or Comma-separated values (.csv). Include column headings in the first row. Upload the downloaded file here.
Google Form team layout detected
Student 1, Student 2 and Student 3 receive separate participation certificates. Faculty guides receive mentorship certificates. Empty and N/A name cells are skipped. A guide listed for multiple submissions receives a certificate for each submission.
If supplied, IDs use submission row and recipient slot, e.g. SF-WPD-2026-R0002-S1. Set the issue date below; submission timestamps are not used as issue dates.
2. Match your columns
For other spreadsheets, only the name column is required. If the sheet contains names only, set the common title, role and date in Certificate details below. Imported certificate IDs are optional. Batch wording follows each role automatically; for custom wording, use placeholders {name}, {title}, {role}, {date} and {book}.
3. Check and generate
| Row | Name | Title | Role | Status |
|---|
Preview shows the first 100 certificates. The ZIP includes all valid rows. For other spreadsheet layouts, dates must be DD/MM/YYYY, YYYY-MM-DD or Excel date cells.
Upload a spreadsheet to begin.
Certificate details
How to use this file
- Open this HTML file in Chrome, Edge, Firefox or Safari.
- Select a type and role, then enter the name and title.
- Set the date, check the wording and download the PDF.
- To use on your own website, upload this file as index.html in the chosen folder.
For multiple recipients, upload your Google Sheets export above and download the ZIP. No installation or internet connection is required. Details are processed in the browser and are not saved.