Mass Certificate Generator (MCG)
Mass Certificate Generator (MCG) is a GUI program to generate PDF certificates from a CSV/Excel file containing participant data; useful for university clubs and programs to create certificates within no time!
Video Demonstration & Tutorial
Features
1. Tabbed Pipeline Workflow
MCG guides you through a logical sequence of steps using a tabbed interface:
- Template Selection: Select the base PDF template.
- Coordinate Calibration: Define text positioning, where the text will appear on the certificate.
- Font Management: Import and manage custom fonts (TTF, OTF, WOFF).
- Text Body Configuration: Define what text (constant or variable) to overlay.
- Data Import: Load participant data from CSV or Excel files.
- Export Settings: Configure output format and naming. You can save individual PDF or single file containing all certificate pages!
2. Real-time Live Preview
- Dynamic Rendering & PDF Viewer: There is an integrated PDF viewer to show exactly how the final output will look, including font styles, colors, and positioning.
- Debug Mode: Includes a toggle to visualize the text boundary boxes, helping with precise alignment.
3. Dynamic Font & Text Management
- Custom Fonts: Users can add multiple custom font files and assign them nicknames for easy selection.
- Mixed Content: Supports adding multiple "Text Blocks" which can be:
- Variable: Pulled from specific columns in your imported data (e.g., "Full Name").
- Constant: Static text that appears on every certificate.
- Styling Options: Each text block supports individual settings for font, size, color, and formatting (Bold, Italic, Underline).
- Reordering: A simple up/down movement system to change the stacking order of text blocks.
4. Data Integration & Bulk Export
- File Support: Import data from CSV or Excel (.xlsx, .xls).
- Flexible Output:
- Single File: Generate one large PDF containing all certificates.
- Individual Files: Generate a separate PDF for each row of data.
- Smart Naming: Choose a column from the data (like "Name" or "ID") to automatically name the individual exported PDF files.
5. Session Persistence
- Auto-Save/Load: The application remembers your entire configuration—including file paths, font selections, text blocks, and coordinates—across sessions. If you close MCG, it will restore your exact progress when reopened.