All articlesUniversities

How to run campus placements without spreadsheets: a TPO’s playbook

Registrations in Google Forms, eligibility in Excel and updates on WhatsApp work — until 800 students and 40 companies arrive at once. Here is a simpler system, step by step.

OfferNod Team · 12 Nov 2026 · 2 min read

Most placement offices in India run on a familiar stack: a Google Form for registrations, an Excel sheet for eligibility, a WhatsApp group for announcements and email threads with every recruiter. It works for a small batch. At scale it breaks in predictable places — duplicate students, outdated CGPAs, missed deadlines and no reliable record of who got which offer.

Step 1: Make students register themselves — once

Instead of collecting the same details for every drive, ask each student to build one complete profile at the start of the year: personal and contact details, programme, roll number, CGPA and backlogs, Class 10 and 12 marks, internships, projects, skills and documents. Share a single registration link and an invitation key so only your students can join.

Step 2: Verify at the source

The biggest value a placement office adds is trust. Check each profile against university records — CGPA, backlogs, marksheets — and mark it verified. Recruiters spend less time screening, and students with honest profiles stand out.

Tip: send a profile back with a short note instead of rejecting it. Students fix the issue and resubmit, and you keep a record of what changed.

Step 3: Write eligibility rules, not filters

For every drive, save the rule as data: minimum CGPA, maximum active backlogs, eligible branches and batch. The list of eligible students should update itself when a student’s record changes — no re-filtering spreadsheets the night before a drive.

Step 4: Track every application and offer in one place

Record applications, shortlists, interviews and offers against each student. When the season ends you have accurate numbers for NAAC, NIRF and your own reports — and you can see at a glance which students still need help.

Step 5: Bring off-campus activity back into your records

Students increasingly apply on their own. If verified students apply to jobs or get shortlisted outside campus drives, those outcomes should still reach your records, so your placement numbers reflect reality.

A simple weekly rhythm

  • Monday: review new registrations and verify or send back.
  • Tuesday: publish upcoming drives with eligibility rules.
  • Wednesday–Thursday: drives and interviews; record results the same day.
  • Friday: remind students with incomplete profiles; review the offers report.

OfferNod gives placement offices self-registration with invitation keys, verification, eligibility, applications, offers and reports — free for universities.

See OfferNod for universities