School annual day certificate maker – the whole register at once
Make your school annual day certificates in one go: pick a participation, merit or student-of-the-month design, add the school logo, the Principal’s and Class Teacher’s names, and paste the award line from the presets below. Then upload the class register from Excel – every student gets their own certificate with their name on it, as A4 PDFs in one ZIP for printing, or sent straight to each parent’s WhatsApp. Free, no login, no watermark.
1. Pick a design
4. Download or send
File type
2. Write the details
What the certificate is for – up to three lines on the certificate.
Optional, PNG or JPG
3. Add the names
Any language works – English, हिन्दी, ગુજરાતી, العربية…
One design, the whole class register – not one certificate at a time
An annual day or annual function usually means a certificate for every child who performed – 200, 400, sometimes the whole school – plus a handful of awards: best student of the year, student of the month, best outgoing student, 100% attendance. Free templates online are a single picture or a Word file, so you type a name, save, type the next one. Here you set the design and the wording once and add the register; each certificate is drawn with its own name (long names are made smaller to fit) and saved as a PDF, JPG or PNG named after the student.
Everything happens in your browser. The student list and the school logo are not uploaded anywhere unless you choose to send on WhatsApp, there is no account to create, and nothing is printed except what you write – no watermark, no “made with” line. The designs are free to use for schools, preschools, junior colleges and coaching classes.
How the certificate looks: logo, school name and two signatures
Every design has the same parts. Fill them in once and they are printed on every certificate in the batch – only the student’s name changes.
| Part of the certificate | Example for an annual day |
|---|---|
| Logo (top) | Your school crest as a PNG with a transparent background |
| Organisation | Sunrise Public School, Vadodara |
| Title | Certificate of Participation |
| Line above the name | This certificate is presented to |
| Name (from your list) | Ananya Deshpande |
| Line under the name | for her wonderful performance in the group dance at the Annual Day 2026–27, “Rang Tarang”. |
| Date | 19 December 2026 |
| Left signature | Mrs. Kavita Rao – Class Teacher |
| Right signature | Dr. Rajesh Mehta – Principal |
Annual day certificate format – presets per award, ready to copy
These are the three lines you change on every design: the title, the small line above the name and the line under it. Copy a row, change the year, the function name or the class, and the preset is ready. The line under the name is up to three lines on the certificate, so keep it to one sentence.
| Award | Title | Line above the name | Line under the name |
|---|---|---|---|
| Annual day participation | Certificate of Participation | This certificate is presented to | for taking part with enthusiasm in the Annual Day celebrations 2026–27. Thank you for making the evening memorable! |
| Annual function – performer | Certificate of Appreciation | This certificate is proudly presented to | for a wonderful performance on stage at our Annual Function 2026–27. Your talent lit up the evening! |
| Best student of the year | Best Student of the Year | This certificate is awarded to | for excellence in academics, discipline and conduct throughout the academic year 2026–27. |
| Student of the month | Student of the Month | Congratulations to | for being the Student of the Month for December 2026 – kind, curious, hard-working and always ready to help. |
| Best outgoing student | Best Outgoing Student | This certificate is proudly awarded to | for being an all-round role model in studies, values and school life during the years at our school. We wish you every success ahead. |
| Academic merit / topper | Certificate of Merit | This certificate is awarded to | for securing the first rank in Class 8 in the academic year 2025–26. Congratulations on this outstanding achievement! |
| 100% attendance | Certificate of Regularity | This certificate is presented to | for 100% attendance throughout the academic year 2025–26. Well done for never missing a day! |
| Best class / house discipline | Certificate of Excellence | This certificate is awarded to | for exemplary discipline, punctuality and teamwork in the academic year 2026–27. |
| Anchor / compere | Certificate of Appreciation | This certificate is presented to | for confidently hosting the Annual Day 2026–27 and keeping the audience with us all evening. |
| Teacher or volunteer | Certificate of Appreciation | With gratitude to | for the hard work and long rehearsals that made our Annual Day 2026–27 a grand success. |
| Preschool / KG | Little Star Award | Well done, | for dancing, singing and shining so brightly at our Annual Day 2026–27! |
Need more lines for report cards, remarks and awards? Certificate wording for students
Which design for which award
Student of the month – stars: the bright, friendly design, picked first. Student of the month, little star awards and preschool or KG annual day certificates.
Participation – modern blue: every child who performed, anchored or helped – the biggest batch, often the whole school.
Merit – maroon: best student of the year, toppers, academic merit and best outgoing student – it reads as the formal, framed one.
Appreciation – navy and gold: teachers, volunteers, parents’ committee members and chief guests.
Print the whole register from Excel
One row per student, with a header row. Only the name column is printed on the certificate. The Parent phone column carries over to the sender, and every other column – Class, Section, Award, Item – can be used in the WhatsApp message to the parent.
The line under the name is the same for the whole batch, so make one batch per award: filter the sheet to Award = Participation, save it as its own sheet or CSV and make those certificates; then the merit list, then the special awards. Three or four batches cover an annual day.
Want the class printed on the certificate (“…of Class 6-B”)? Filter by class and section, put the class in the line under the name, and make one batch per section – the class teacher’s name can change with it.
Sort the sheet by class and section first, so the ZIP and the printed pile come out section by section, ready to hand to each class teacher.
Write names exactly as they should be printed – check spellings against the admission register. A misspelt name is the one mistake every parent notices.
Up to 2,000 names per list. Blank rows and a title row above the headings are fine; if the wrong column is picked as the name, choose the right one from the list.
| Name | Class | Section | Award | Item | Parent phone |
|---|---|---|---|---|---|
| Ananya Deshpande | 6 | B | Participation | Group dance | 98765 43210 |
| Kabir Malhotra | 10 | A | Best Outgoing Student | – | +91 91234 56789 |
| Fatima Shaikh | 3 | C | Student of the Month | – | 09876501234 |
| श्रेया पटेल | 8 | A | Academic Merit | – | 91 99887 76655 |
How to make school certificates with names
- 1
Pick a design
The student-of-the-month star design is picked for you; participation, merit and appreciation are next to it.
- 2
Write the details once
Paste the preset for the award, type your school name and the function date, and add up to two signatories – usually the Class Teacher on the left and the Principal on the right. Add the school logo.
- 3
Add the register
Upload the Excel (.xlsx, .xls) or CSV sheet and pick the name column, or paste one name per line. Use the arrows under the preview to check the longest names.
- 4
Print or send
Download all as a ZIP with one A4 landscape PDF per student for printing, or JPGs for WhatsApp. Or press “Send on WhatsApp” to send each parent their child’s certificate.
Send each certificate to the parent from the same sheet
Printed certificates are handed out weeks after the function, or never reach the children who were absent on prize day. A certificate on the parent’s WhatsApp the evening of the annual day gets saved, forwarded to grandparents and kept. Rapid Sender (free to try, not made by WhatsApp) sends each parent their own child’s certificate from the school’s WhatsApp number, one message at a time.
With a Parent phone column in the sheet, press “Send on WhatsApp”. The sender opens with the certificate attached, the name in the same place and a message filled in. Change it to one of these – {{name}}, {{class}}, {{section}}, {{award}} and {{item}} are filled in from your sheet:
- Annual day
Dear Parent, thank you for being with us at the Annual Day 2026–27! 🎭 Please find *{{name}}*’s (Class {{class}}-{{section}}) participation certificate for the *{{item}}* attached. We are proud of every child who took the stage.
- Award
Dear Parent, congratulations! 🏅 *{{name}}* of Class {{class}}-{{section}} has received the *{{award}}* award this year. The certificate is attached – please convey our best wishes to {{name}}.
- Student of the month
Dear Parent, we are happy to share that *{{name}} is our Student of the Month* for December 2026! 🌟 The certificate is attached. Thank you for your support at home.
- Best outgoing
Dear Parent, it gives us great pride to name *{{name}} the Best Outgoing Student* of the batch 2026–27. 🎓 The certificate is attached. We wish {{name}} every success in the years ahead.
- Hindi – participation
आदरणीय अभिभावक, वार्षिकोत्सव 2026–27 में सहभागिता के लिए *{{name}}* (कक्षा {{class}}-{{section}}) का प्रमाण पत्र संलग्न है। 🎭 आपके सहयोग के लिए धन्यवाद।
- Hindi – award
आदरणीय अभिभावक, हार्दिक बधाई! 🏅 *{{name}} को इस वर्ष {{award}}* पुरस्कार से सम्मानित किया गया है। प्रमाण पत्र संलग्न है।
- Gujarati
આદરણીય વાલીશ્રી, વાર્ષિકોત્સવ 2026–27 માં ભાગ લેવા બદલ *{{name}}* (ધોરણ {{class}}-{{section}}) નું પ્રમાણપત્ર આ સાથે મોકલ્યું છે. 🎭 આપના સહકાર બદલ આભાર.
Sending the annual day invitation to parents first? Annual day invitation message
Doing it for the whole school with Rapid Sender
Making and downloading the certificates is free for any number of students, up to 2,000 per list. Sending on WhatsApp is free for the first 50 messages per number; a school sending to 400 parents needs a credit pack after that, from ₹149 for 250 messages. You connect the school’s WhatsApp once by scanning a QR code, send a test to yourself, then start; messages go out one by one with a short gap. Send only to parents who gave the school their number for school updates.
Circulars, fee reminders and results on WhatsApp too? WhatsApp for schools
Printing tips
Download as PDF for printing: each certificate is one A4 landscape page. Print at 100% / actual size on 170–250 gsm card or certificate paper.
Print one test page first and check the margins and the logo on your school printer.
Leave the signature lines for ink if the Principal signs every copy; for a large batch, type the names and designations so they are printed and only sign the special awards.
Make one ZIP per section and hand it to the class teacher – the files are named after each student, so missing ones are easy to spot.
When to make them
Most Indian schools hold the annual day or annual function between December and February, after the half-yearly exams and before the finals; the best outgoing student award for Class 10 and 12 is often given at the farewell in January or February. Make the participation certificates as soon as the item list is final, keep the awards for after the staff meeting that decides them, and send everything the evening of the function.
Frequently asked questions
What is the format of an annual day certificate?
School logo and name at the top, a title such as “Certificate of Participation”, a line such as “This certificate is presented to”, the student’s name, one sentence on what it is for (“for a wonderful performance in the group dance at the Annual Day 2026–27”), the date, and two signatures – usually the Class Teacher and the Principal.
What does “best outgoing student” mean?
It is the award for the best all-round student of the batch that is leaving the school – usually Class 10 or Class 12 – judged on studies, conduct, leadership, sports and co-curricular activities over the years, not only marks. It is given at the farewell or the annual day.
What should a student of the month certificate say?
Say the month and why: “Congratulations to Ananya for being the Student of the Month for December 2026 – kind, curious, hard-working and always ready to help.” Name one or two qualities the class teacher actually saw that month.
Can the class and section be printed on each certificate?
The name changes on every certificate; the line under it is the same for a batch. Make one batch per section and put “of Class 6-B” in that line. In the WhatsApp message to the parent, {{class}} and {{section}} are filled in for each student from your sheet.
Can I add the school logo and the principal’s signature?
Add the logo as a PNG or JPG – it is printed at the top of every certificate. Under the two signature lines you type the names and designations, such as “Dr. Rajesh Mehta – Principal” and “Mrs. Kavita Rao – Class Teacher”; sign the printed copies by hand.
Is there a best student award certificate format in Word?
You do not need one: pick the merit design, paste the “Best Student of the Year” preset and add the name. It downloads as a print-ready A4 PDF or JPG. With Word you type and save every name one by one.
School certificate kaise banaye?
Design chuniye, school ka logo, naam, date aur Principal–Class Teacher ke naam ek baar likhiye, phir Excel register upload kijiye ya naam paste kijiye. Har student ka certificate uske naam ke saath ban jaata hai – sab ek ZIP mein PDF ke roop mein download kijiye, ya parents ko WhatsApp par bhejiye. Free hai, koi watermark nahi.
Is the student list uploaded anywhere?
Not for making or downloading the certificates: the sheet and the logo are read and the certificates are drawn in your browser. Only if you choose to send on WhatsApp do the parents’ numbers, the message and the certificate go through Rapid Sender to be delivered from the school’s own WhatsApp.
Is Rapid Sender part of WhatsApp?
No. Rapid Sender is an independent tool, not affiliated with WhatsApp or Meta. It sends from your own WhatsApp account, which you connect by scanning a QR code.
Ready to send your message?
Upload your list, write your message and connect your WhatsApp. It is free and takes a few minutes.
Start sending