Certificate Designer is a Python GUI tool that lets you visually design and generate personalized certificates from Excel data using a drag-and-drop interface. Built with Tkinter and Pillow, it supports live preview, font customization, and bulk certificate creation with zero coding required.
Project description
Certify 🎓 Certificate Designer - Python GUI Tool
A no-code, drag-and-drop certificate generator powered by Python! Create professional certificates from Excel in minutes. 🎉
✨ Features
- 🖼️ Interactive Canvas: Draw text boxes on your certificate template with real-time mouse input.
- 📄 Excel Integration: Auto-map certificate fields from Excel sheet columns.
- 🖍️ Custom Fonts & Styles: Set font style, size, and color for each field.
- 👁️ Live Preview: Preview the first certificate before batch generation.
- 🖨️ Bulk Export: Generate personalized certificates for hundreds of participants.
- 📁 Save as PNG: Certificates saved to a
certificates/folder for easy access.
🚀 Quick Start
1️⃣ Requirements
pip install pillow pandas openpyxl 2️⃣ Run the App bash Copy Edit python certificate_gui.py 🧠 How It Works Load your certificate template image (JPG/PNG).
Load your Excel file (.xlsx) with participant data.
Draw a rectangle for each column (e.g., Name, Event, Date).
Choose your font style, size, and color per field.
Preview the output.
Hit "Generate All" to export certificates!
📁 File Structure
certificate_gui.py # Main GUI logic certificates/ # Auto-created folder with generated PNGs preview.png # Sample preview image 🧩 Tech Stack Python 3.x
Tkinter – GUI interface
Pillow – Image processing
pandas – Excel (.xlsx) reading
openpyxl – Backend engine for .xlsx files
🎯 Use Cases College and school event certifications 🏫
Hackathon participation awards 👨💻
Webinar/Workshop attendance proof 🎤
Volunteer appreciation 🎗️
🙌 Contributing Pull requests are welcome. Feel free to open an issue to discuss improvements or ideas 💡.
📜 License This project is licensed under the MIT License – see the LICENSE file for details.
🧑💻 Developed by Muthukumaran S ✨ Follow me on GitHub: @MuthuKumaran-Dev-10000 (https://github.com/MuthuKumaran-Dev-10000)
Let me know if you want:
- 🎨 Badge styles for dark themes
- 📌 Sample certificate template and Excel
- 📦 To package it into a PyPI installable package
Happy shipping your library! 🚀
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file certifygui-0.2.1.tar.gz.
File metadata
- Download URL: certifygui-0.2.1.tar.gz
- Upload date:
- Size: 4.9 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/6.1.0 CPython/3.12.4
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
ac65242cd4956f2e32677c9b9fef62b7f05f041eb3d2042918da25a717e2d949
|
|
| MD5 |
1356e44e42e3fb2f08c1fd4ca8f0a2ce
|
|
| BLAKE2b-256 |
d9498a096eece145b2cc276aaf5b2bf9a11df4ac764971cb9ada98d9d59cd743
|
File details
Details for the file certifygui-0.2.1-py3-none-any.whl.
File metadata
- Download URL: certifygui-0.2.1-py3-none-any.whl
- Upload date:
- Size: 4.6 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/6.1.0 CPython/3.12.4
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
9f254f9957aa995f0f3bde3ffb538e32a185b85e4c87e24087f356fd4a57f4cf
|
|
| MD5 |
690ec67301e38d314563acdf3302e625
|
|
| BLAKE2b-256 |
d708622f5f6639245cf80b1005b956ee980e60cb6c6dab54c2f311d8933b5991
|