Building a Recruitment Tracker in Excel or Google Sheets

You're managing five open positions. You've got 120 candidates across various stages. Two got rejected last week, three are waiting on hiring manager feedback from 10 days ago, one accepted an offer, another is suddenly not responding, and three more—you're honestly not sure where they are.

This is the tracker problem.

Most recruiters operate in three broken states: Email chaos — everything lives in your inbox scattered across dozens of threads. ATS-only — your ATS is the source of truth but you're checking it manually four times a day. Or Hybrid mess — a spreadsheet nobody updates, an ATS nobody fully logs into, WhatsApp conversations, LinkedIn messages, and notes on your desk.

If you're managing 3+ open requisitions or tracking 40+ candidates, you need a tracker. Not because it's fancy. Because it's how you stop dropping candidates, start seeing patterns, and actually know what's happening in your pipeline.

This guide walks you through building one from scratch—and using it to move from chaos to clarity.

What Actually Is a Recruitment Tracker?

A recruitment tracker is a structured system that records and monitors hiring activity throughout the entire recruitment lifecycle—from requirement open to candidate joining.

Think of it as a status dashboard and decision log rolled into one. It's different from an ATS. It's not fancy. It's not automated. But it's where your recruitment reality lives.

A simple recruitment workflow looks like this:

Requirement Open → Sourcing → Screening → Submission → Interview → Offer → Joining

Your tracker makes it easy to see exactly where every candidate and every position stands within this process.

Why Recruitment Tracker Skills Matter

Yes, Applicant Tracking Systems exist. They're powerful. They integrate with everything.

But here's the truth: Most recruitment leaders started their career with a spreadsheet.

Why should you learn this skill? Because it teaches you how recruitment information should be structured. Once you understand the underlying logic, ATS reports, dashboards, recruitment analytics—all of it becomes easier to understand.

A good tracker helps in five major areas:

• Requirement ManagementYou can immediately identify open positions, priority requirements, hiring managers, required skills, and target closure dates. Requirements stop disappearing inside emails.
• Candidate Pipeline VisibilityEvery candidate has a clearly defined status. You don't remember whether someone was contacted three days ago or is waiting for interview feedback. You check the tracker.
• Follow-Up ManagementRecruitment contains surprising amounts of follow-up. A tracker highlights candidates who have been waiting too long for the next action and prevents candidates from disappearing into silence.
• Recruitment AnalyticsOnce structured data exists, metrics become easy to calculate: sourcing conversion, time-to-fill, source effectiveness, drop-off patterns, hiring manager response times.
• Candidate ExperienceA tracker containing Last Candidate Contact Date and Next Follow-Up Date prevents candidates from falling into communication silence, directly improving experience.

Excel vs Google Sheets: Which Should You Use?

Both work. The choice depends on your situation.

Google Sheets

Best for: Small-to-medium teams (1–4 recruiters), distributed teams, real-time collaboration, agency recruiting, quick setup.

• ProsCloud-based with no syncing headaches. Multiple people editing simultaneously. Easy sharing and permission controls. Mobile-friendly. Zero setup. Built-in version history.
• ConsSlightly slower with large datasets (500+ rows gets sluggish). Limited advanced features compared to Excel. Requires internet connection.

Excel

Best for: Mature recruitment operations, large datasets (1,000+ candidates), established processes, offline workflows, complex formulas and analysis.

• ProsFaster with large datasets. More powerful formulas and pivot tables. Works offline. Most recruiters already know it. Advanced conditional formatting.
• ConsManual syncing if shared (unless using OneDrive, which gets messy). Real-time collaboration is clunky. Easy to accidentally overwrite work. Requires download/re-upload cycle.

My recommendation: Start with Google Sheets. The collaboration alone is worth it. Move to Excel later if you hit performance limits (usually around 500+ active candidates).

Building Your Tracker: The Two-Sheet Foundation

Don't put everything into one giant spreadsheet.

Instead, think about recruitment tracking in three logical levels:

1. Requirement Tracker — High-level view of all open jobs
2. Candidate Pipeline Tracker — Detailed tracking of each candidate against each req
3. Recruitment Dashboard — Summary metrics and analytics

A beginner can start with the first two and gradually build the dashboard.

Sheet 1: Requirement Tracker (High-Level Overview)

This sheet provides a bird's-eye view of all open positions. One row = one position.

Requirement ID	Job Title	Department / Client	Priority	Status
REQ-001	Senior Java Developer	Product Engineering	High	Sourcing
REQ-002	DevOps Engineer	Infrastructure	High	Interviewing
REQ-003	Data Analyst	Analytics	Medium	Sourcing

Essential columns: Requirement ID, Job Title, Department/Client, Location, Work Model, Experience Required, Primary Skills, Number of Openings, Priority, Requirement Open Date, Target Closure Date, Recruiter Owner, Requirement Status.

Sheet 2: Candidate Pipeline Tracker (Detailed Activity)

This is where most day-to-day recruitment happens. Each row represents one candidate against one requirement.

Section 1: Candidate Information

• Candidate IDCAND-001 — Allows you to connect the same person to multiple requirements
• Candidate NameFull name for easy reference
• Email AddressPrimary contact
• Phone NumberFormatted consistently for tracking
• LinkedIn ProfileURL is more useful than just a name for quick reference
• Current LocationBangalore, India
• Current CompanyTCS
• Total Experience7 years
• Relevant Experience6 years (Java/Spring) — often differs from total

Section 2: Requirement Connection

Connect the candidate to a specific position using Requirement ID. Allows you to run analytics like "How many candidates do we have for REQ-001?"

Section 3: Sourcing Information

• SourceLinkedIn, Naukri, Indeed, Referral, Company Database, GitHub, Employee Referral, Career Page, Agency
• Date SourcedWhen was the candidate first identified?
• Date ContactedWhen was the candidate first approached?
• Response StatusInterested, Not Interested, No Response, Follow-Up Required, Future Opportunity

Section 4: Screening Information

Once a candidate expresses interest, screening begins. Track current salary, expected salary, notice period, availability, location preference, work authorization, key skills assessment, screening notes, recruiter recommendation (Strong Fit / Potential Fit / Not Suitable).

Section 5: Candidate Stage (The Core Column)

This may be the most important column in your entire tracker. Create a dropdown with standardized stages. Avoid free text. Standardization is essential for analytics.

• SourcedCandidate identified but not yet contacted
• ContactedRecruiter has reached out
• ScreeningActive screening conversation
• QualifiedScreening completed, candidate is suitable
• SubmittedProfile sent to hiring manager or client
• ShortlistedCandidate moved forward after review
• Interview ScheduledInterview is booked
• Interview CompletedInterview done, feedback pending
• Second InterviewAdvanced to next round
• SelectedOffer decision made
• Offer ReleasedOffer sent to candidate
• Offer AcceptedCandidate accepted offer
• JoinedCandidate has joined
• RejectedCandidate rejected or disqualified
• WithdrewCandidate dropped out
• On HoldCandidate paused, may revisit later

Section 6: Interview Tracking

Track: Interview Round (1st / 2nd / Final), Interview Date, Interview Type (Technical / Managerial / Client), Interviewer(s), Interview Status, Interview Feedback, Next Round Date, Next Action.

Section 7: Offer and Joining Tracking

Track: Selection Date, Offered Compensation, Offer Release Date, Offer Acceptance Date, Expected Joining Date, Actual Joining Date, Offer Status, Joining Status, Dropout Reason.

Section 8: Follow-Up Columns (The Game Changer)

Add three critical columns:

• Last Action DateWhen was the candidate last contacted? 2026-08-15
• Last Action TypeWhat happened? Called for screening
• Next ActionWhat needs to happen next? Send technical round details
• Next Follow-Up DateWhen should recruiter follow up? 2026-08-22

Now your tracker is more than a database. It's a daily recruitment action system.

Setting Up Your Spreadsheet: Step-by-Step

Step 1: Create Headers (5 minutes)

Create Sheet 1: "Requirements" and Sheet 2: "Candidates". Add column headers from the sections above. Freeze the header row. Google Sheets: View → Freeze → 1 row. Excel: View → Freeze Panes.

Step 2: Add Dropdowns for Standardization (10 minutes)

This is non-negotiable. Dropdowns prevent chaos. Create dropdowns for: Current Stage, Requirement Status, Priority, Source, Interview Status, Offer Status, Recruiter Owner, Screening Outcome.

Step 3: Add Sample Data (10 minutes)

Add 5–10 sample rows from your existing pipeline. Why? You'll find issues. Better to find these with fake data than after tracking 50 candidates.

Step 4: Add Conditional Formatting (10 minutes)

Make important actions visually obvious. Example: Highlight overdue follow-ups in red, high-priority reqs in yellow, interview-stage candidates in light blue.

Step 5: Add Formulas (15 minutes)

Days in Current Stage: =IF(ISBLANK(D2),"",TODAY()-D2) tells you how long a candidate has been sitting in their current stage.

Count Candidates by Requirement: =COUNTIF(Candidates!D:D,A2) automatically counts how many candidates are associated with each requirement.

Funnel Metrics: Count candidates by stage then calculate conversion rates between stages.

What to Track and What NOT to Track

The rule: If you can't act on the data, don't track it.

Real Examples: How Different Teams Use This

Example 1: Small Recruitment Agency (3 Recruiters)

• Context3 recruiters, 12–15 open requisitions, 80–100 candidates in pipeline
• StructureRequirements sheet + Candidates sheet + Summary sheet with funnel by req, source quality, time-to-hire
• Weekly WorkflowEvery Monday 2 PM, each recruiter updates their candidates (15 minutes). Hiring manager calls: you look at tracker, filter by Req ID, tell them "7 in pipeline. 2 in technical round, 1 in manager round, 2 more going to screening Friday."
• Time Investment20 minutes per week total

Example 2: Corporate TA (Single Recruiter, High Volume)

• Context8 open requisitions, 200+ candidates in various stages
• StructureExcel with Requirements sheet, Candidates sheet, Recruitment Funnel Dashboard, Source Effectiveness sheet, Manager Scoreboard
• Weekly WorkflowUpdate candidates (45 minutes), review bottlenecks (15 minutes), monthly metrics review (1 hour)
• PayoffData to show leadership: "We're closing hires in 45 days average, referral source has 60% interview conversion rate, we're losing 30% of offers to counteroffers."

Building Basic Recruitment Metrics

Example month:

• 150 candidates sourced
• 60 candidates screened
• 30 candidates submitted
• 12 candidates interviewed
• 4 candidates offered
• 3 candidates joined

Conversion rates:

Stage Transition	Calculation	Rate
Sourced → Screened	60 ÷ 150 × 100	40%
Screened → Submitted	30 ÷ 60 × 100	50%
Submitted → Interviewed	12 ÷ 30 × 100	40%
Interviewed → Offered	4 ÷ 12 × 100	33%
Offered → Joined	3 ÷ 4 × 100	75%

Now you can ask: Why is Submitted → Interviewed only 40%? Bad submissions? Hiring manager busy? Why is Offered → Joined only 75%? Are offers too low? Candidates getting counteroffers?

Your Daily and Weekly Routine

Every Morning (5 minutes):

1. Sort by "Next Follow-Up Date" (overdue items on top)
2. Review High-Priority Requirements — which need immediate sourcing?
3. Check Candidates Requiring Follow-Up — who needs calls today?
4. Review Interviews Today — confirmation calls? Prep needed?
5. Check Offer Candidates — anyone approaching joining date?

Every Day End (10 minutes):

Update: New candidates sourced, screening outcomes, submissions, interview schedules, interview results, candidate communication notes, hiring manager feedback, offers released, joining updates, and most important: Next Follow-Up Date.

Every Monday (15 minutes):

Review all candidates without a "Next Follow-Up Date," check for candidates stuck in any stage for 10+ days, review "On Hold" candidates, check source pipeline, plan next month's sourcing focus.

Common Mistakes (And How to Fix Them)

• Too Many Columns UpfrontYou add 40 columns, stop updating after row 10. How to fix: Start with 15 columns. Add more only when you actually need data from them.
• Inconsistent Data EntryOne person enters "Java, Spring, Kafka" another enters "JAVA, Spring Boot". How to fix: Use dropdowns everywhere possible. Don't allow free text for fields that repeat.
• Free-Form Notes Nobody Reads"Discussed salary, seems interested, might have other offer" — vague and useless. How to fix: Be specific. Structure your notes. Use templates.
• Tracking But Not ActingYou see 5 candidates in "Screening" for 20+ days but have no rule about it. How to fix: Define your SLAs. "Candidates can't sit in Screening for more than 7 days. Move to interview or close."
• Not Updating the TrackerIt's 2 weeks behind. Nobody trusts it. How to fix: Assign update responsibility. Every Monday 2 PM, 15 minutes updating. Calendar reminder. Hold people accountable.