Workshops and webinars
Send every attendee a participation certificate without editing a file per person.
Make hundreds of certificates from one spreadsheet
Design a certificate once, add your list of names, and get one for every row as PDF, PNG or JPG. Your files stay on your computer, and there is no watermark.
Free, no account. Open your Excel file, load a CSV or paste your list.
Features
What the studio does
- Design on the page
- Drag, resize and rotate text, photos, logos, QR codes and shapes right on the certificate, with undo and redo.
- Your design or ours
- Upload a blank PNG, JPG, WebP or PDF, or start from one of 13 ready designs with starter wording.
- Open Excel files
- Open an .xlsx workbook or a CSV, paste cells from Excel or Google Sheets, or type into an editable table.
- Any language
- Hindi, Tamil, Arabic and other scripts get a matching font, right-to-left text just works, and you can upload your own font.
- Values from your columns
- Write {Name} or {Course} in any text and every certificate fills in its own row.
- Long names handled
- Text can shrink to fit its box, and Check all rows lists any row that still does not fit.
- Photos for everyone
- Drop a folder or ZIP of photos: each is matched to its person by name or ID, with the face centred. Each certificate can carry its own QR code too.
- PDF, PNG or JPG
- One PDF, one PDF per person, or a ZIP of images, at half, full or double size.
- Named from your data
- File names come from a pattern like {ID}-{Name}, and repeats get a number instead of overwriting.
How it works
From list to certificates in four steps
Template
Upload a blank certificate, or pick a ready design.
Data
Open your Excel file or a CSV, or paste the cells.
Design
Place the text, photo and QR code, and put {Column} names where values go.
Export
Check every row, choose the format and rows, then download.
Uses
Who it saves an afternoon for
Schools and tutors
Hand out completion and achievement certificates to a whole class or course.
HR and training teams
Certify employees after a course, with the ID from your records in a QR code.
Events and volunteers
Issue certificates or photo badges for a long list of recipients.
How to make certificates in bulk from Excel or CSV
Making certificates one at a time in a design tool means editing the same file over and over. Bulk generation flips that: you design one template, keep the names in a spreadsheet, and the tool produces one certificate per row.
- Get a blank certificate as a PNG, JPG or PDF, or use one of the ready backgrounds in the studio. A larger image prints sharper.
- Put your list in a spreadsheet: a header row, then one row per certificate. Typical columns are Name, Course, Date and an ID.
- Open the certificate studio and add your list in the Data step: open the Excel workbook or a CSV, or paste the cells straight from Excel or Google Sheets. With a CSV, use UTF-8 so accented and non-English names stay intact.
- In the Design step, add text, and put a column name in braces, like {Name}, wherever a value should appear. Drag, resize and rotate on the page, and set the font, size, colour and alignment.
- Step through the certificates with the arrows to see each one, then press Check all rows to find empty values or names that do not fit.
- In the Export step choose PDF, PNG or JPG, the size, the rows and the file names, then download the result.
What you can export
The export step lets you choose the format, the size (half, full or double your template), the range of rows and a pattern for the file names.
| Format | Good for | Notes |
|---|---|---|
| Printing and emailing | One PDF with a page for each certificate, or one PDF per person in a ZIP. Text is real text: sharp in print, searchable, and small files. | |
| PNG | Editing later, sharing on screen | Lossless, so the files are larger. Comes as a ZIP. |
| JPG | Emailing many certificates | Smaller files, with a quality setting. Comes as a ZIP. |
Photos and QR codes on each certificate
For ID-style certificates, event badges or a class of students, name each photo after the person or their ID (Priya Nair.jpg or DA-001.jpg) and drop the whole folder or a ZIP onto the studio. Every photo is matched to its person on its own, the face is centred in the frame, and a check screen shows anyone still missing a photo.
A QR code element can hold text with column values in it, such as a verify link ending in {ID}, so every certificate carries its own code.
Tips for clean results
- Look at your longest name first. Use the Find a name box to jump to it, and turn on shrink-to-fit for the name box.
- Run Check all rows before exporting. Fixing a typo later means exporting again, not editing one file.
- Export a few rows on their own as a test, using the From row and To row boxes.
- Save your project file once the layout is right, so you can open it again for the next batch.
For a longer walkthrough on preparing your list, see how to make certificates from Excel in bulk.
Frequently Asked Questions (FAQ)
Yes. Open the .xlsx workbook directly in the data step, load a CSV, or copy the cells in Excel or Google Sheets and paste them in. The first filled row is read as the column names and every other row becomes one certificate. Dates and numbers come through as they show in Excel, and if the workbook has several sheets you can pick one.
There is no fixed cap and no paid tier. Every certificate is drawn on your own device, so a very long list uses a lot of memory. If your device slows down, export in ranges of a few hundred rows at a time using the From row and To row boxes.
Yes. Upload a blank PNG, JPG, WebP or PDF (the first page of a PDF is used). If you have no design, pick one of 13 ready designs (completion, participation, appreciation, internship, sports, attendance, volunteer, school and more) and change the text, fonts and colours.
Text that takes values from your columns (write {Name} or {Course} inside it), a photo that is matched to each row, a logo or signature image, a QR code with its own content for each row, and lines, boxes and ovals. There are 15 fonts, Noto fonts for Hindi, Bengali, Tamil, Telugu, Arabic, Urdu and other scripts, and you can upload your own TTF, OTF or WOFF font.
Yes. Names in other scripts are drawn in a matching Noto font on their own, with letters joined correctly, and Arabic, Urdu and Hebrew run right to left automatically. Load the list as .xlsx, or as CSV UTF-8, so the letters stay intact.
A text box can shrink its text until the name fits, down to a smallest size you set. The "Check all rows" button before you export lists rows where a value is empty, a name still does not fit at the smallest size, or a photo is not found.
PDF, PNG or JPG. PDF can be one file with a page per certificate, or one PDF per person in a ZIP. Text in the PDF is real text, so it prints sharp and can be selected and searched, and the template is stored once, which keeps files small. PNG and JPG come as a ZIP. You can save at half, full or double the size of your template, and export only a range of rows.
From a pattern you write, such as {ID}-{Name}. The default is {#}-{Name}, where {#} is the row number. Characters a file name cannot hold are removed, and if two rows would get the same name the second one gets a number, so nothing is overwritten.
Yes, for a whole class at once. Name the photos after the people (Priya Nair.jpg) or their ID or roll number (DA-001.jpg), then drop the folder or a ZIP of them onto the studio. Each photo finds its certificate on its own, with no file names to type, and a photo frame is placed on the certificate for you. A check screen shows every person next to their photo, and you can drag a leftover photo onto anyone who is missing one. Faces are found and centred in the frame automatically, and you can move or zoom any photo by hand.
If no column matches the file names, the photos are given to the rows in order of their file names (the first photo to the first row), so a folder exported in the same order as your list still lines up. You can also choose which column to match by, or drag photos onto people on the check screen.
Yes. Your work is kept in your browser as you go, so a reload or a closed tab does not lose it: the studio offers to continue where you left off. Save project also downloads a file with your template, layout, data, photos and uploaded fonts to open on another day or another computer.
No. Your template, spreadsheet and photos are handled in your browser and are not sent to a server. The fonts are the one exception: they load from Google Fonts when the studio opens, and for a PDF with real text the font files are fetched from unpkg.com. No names or data are sent with them.
It is free, needs no account, and adds no watermark or logo to your certificates.