Contact me in telegram (Most Preferable)

Kazi Rifat Morshed

Undergraduate Student (B.Sc. Engg.) of Computer Science and Engineering (CSE)

MCG Logo

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.