📊 Recruitment Tracker Template

Quick Start Guide & Setup Instructions

📥 Download Your Template

Choose the format that works best for your needs:

📈 Advanced Excel Template

Full-featured spreadsheet with formulas, dashboard, and reference data

  • Pre-built dashboard with metrics
  • Automatic calculations & formulas
  • 3 sheets included (Tracker, Dashboard, Reference)
  • Ready for immediate use
⬇️ Download Excel

📋 Basic CSV Template

Lightweight format for importing into Excel or Google Sheets

  • Simple column structure
  • Sample data included
  • Works with any spreadsheet app
  • Easy to customize
⬇️ Download CSV

🚀 Getting Started (5 Minutes)

Step 1: Download & Open Click the download button above and open the file with Excel, Google Sheets, or your preferred spreadsheet app.
Step 2: Replace Sample Data Remove the 3 sample candidates and add your actual candidate data. Keep the column headers unchanged.
Step 3: Customize Status Values Use the predefined statuses (Initial Screening, Interview Stage, Offer Extended, etc.) or add your own based on your hiring process.
Step 4: Set Reminders Use the "Follow-up Date" column to track when you need to contact candidates. Enable calendar notifications.
Step 5: Share & Collaborate For Google Sheets: Share the link with your team. For Excel: Use OneDrive or SharePoint for real-time collaboration.

📝 Column Guide & Descriptions

Column Name
How to Use This Column
Candidate Name
Full name of the candidate. Format: First Name Last Name
Position
Job title they applied for (e.g., Senior Java Developer, QA Automation Engineer)
Date Applied
When they submitted their application. Format: YYYY-MM-DD (2026-08-01)
Source
Where you found them: LinkedIn, Indeed, Referral, Job Board, Campus Drive, Direct Application
Status
Current stage in your hiring funnel. See status options below.
Interview Round
What stage of interviews they're in (Technical Screening, Round 1, HR Round, etc.)
Rating (1-5)
Your assessment of candidate quality. 1 = Poor, 5 = Excellent. Helps with ranking.
Feedback
Interview notes, strengths, concerns, or reasons for rejection
Next Steps
What needs to happen next (Schedule Behavioral, Offer Discussion, Archive, etc.)
Follow-up Date
When you need to contact them again. Use for scheduling reminders.
Salary Expectation
Their expected salary or salary range (e.g., ₹15L - ₹18L)
Notice Period
How long until they can start (15 days, 30 days, 60 days, etc.)

📋 Predefined Values Reference

Candidate Status

Initial Screening Interview Stage Offer Extended Rejected On Hold Hired

Interview Rounds

Pending Technical Screening Round 1 HR Round Final Round All Rounds Complete

Candidate Sources

LinkedIn Indeed Referral Job Board Campus Drive Direct Application

💡 Pro Tips for Tracking Success

Data Organization Tips
  • Update candidate status immediately after each interaction
  • Keep feedback concise but descriptive (100-150 characters)
  • Use consistent date formats (YYYY-MM-DD) for sorting
  • Set follow-up dates for all active candidates
  • Archive rejected candidates to a separate sheet quarterly
Efficiency Hacks
  • Use sorting to see all candidates in "Interview Stage" at once
  • Filter by "Source" to track which channels are most effective
  • Add a "Column" column to track candidates by recruiter/team member
  • Use conditional formatting to highlight candidates with imminent follow-up dates
  • Export monthly to analyze hiring metrics and pipeline health
For Excel Advanced Users
  • The Excel template includes formulas—modify them for your specific metrics
  • Add charts to visualize pipeline stages and source effectiveness
  • Use data validation (Data → Validation) to create dropdown lists for Status
  • Set up conditional formatting rules to color-code high-priority candidates

❓ Frequently Asked Questions

Can I use this with Google Sheets?

Yes! Download the CSV version and import it into Google Sheets, or open the Excel file and Google Sheets will automatically convert it. Note: Some Excel formulas may need adjustment in Google Sheets.

How do I add more columns?

Simply insert new columns as needed. Consider adding columns like: Years of Experience, Technical Skills, Interview Feedback Link, HR Comments, Background Check Status, etc.

Can I use this for multiple positions?

Absolutely! Add candidates for all open positions to one tracker. Filter by "Position" column to view candidates for specific roles.

How often should I update it?

Update your tracker daily or after each candidate interaction. This ensures your team has current information and prevents missed follow-ups.

How do I track multiple interviewers' feedback?

Add separate "Feedback" rows for each interviewer, or create additional columns like "Technical Interviewer Feedback" and "HR Interviewer Feedback".

Can I connect this to my ATS?

This template is designed as a standalone tracker. For deeper ATS integration, check if your ATS offers export features to CSV/Excel, then import here.

📚 Related Resources from StaffIQ

For more insights on building and maintaining effective recruitment processes: