Shraman Chaudhuri
GUI Desktop Utility

CERTIFYGO

Automate the creation of hundreds of personalized certificates in seconds. Combine your PowerPoint layout templates with Excel spreadsheets for flawless batch generation.

Automated Generation

KEY CAPABILITIES

01

Excel Data Integration

Seamlessly map rows from .xlsx spreadsheets to certificate recipients, guardian information, roll numbers, or custom event credentials.

02

Dynamic Placeholder Engine

Auto-replaces template tags including <<variable_0>>, <<variable_1>>, <<COURSE_NAME>>, <<CERTIFICATE_NO>>, and <<DATE>> across text frames.

03

System Font Discovery

Real-time font picker scanning all installed system typefaces with live preview, custom point sizes, and hex color code styling.

04

Native PPTX Templates

Design your certificate once in Microsoft PowerPoint or Google Slides, export as .pptx, and let CertifyGo handle slide replication.

05

One-Click Batch Processing

Generates hundreds of personalized certificates in seconds with zero manual formatting or alignment discrepancies.

06

Zero-Dependency Windows App

Pre-packaged standalone desktop executable built with Tkinter and Pillow—no Python runtime installation required for end users.

Data Architecture

TEMPLATE MAPPING

Spreadsheet Input Format

CertifyGo ingests structured Excel sheets (.xlsx). Each row maps sequentially to one complete generated slide:

Column A Column B Column C
Recipient Name Guardian Name Scouts Group / Org
Linus Evans Austin Evans Scouts Group B

Recognized Placeholder Tokens

Place any of the following tags inside text boxes in your PowerPoint layout:

<<variable_0>> Maps to Column A (Recipient Full Name)
<<variable_1>> Maps to Column B (Guardian / Parent Name)
<<variable_2>> Maps to Column C (Custom Team / Organization)
<<COURSE_NAME>> Batch course or event title override
<<CERTIFICATE_NO>> Incremental or spreadsheet-provided ID
<<DATE>> Formatted event or issuance timestamp
Under the Hood

TECH STACK

Python 3.9+
Tkinter GUI
python-pptx
Pillow (PIL)
openpyxl
PyInstaller