October 17th is Spreadsheet Day! Get a $50 credit if you sign up for a paid plan between now and the 17th.

Simple Applicant Tracking Template

FEATURES
Simple Applicant Tracking
Overview

This Applicant Tracking template serves as a database for candidates and their resumes, as well as details about each job opening. Candidates are linked with the appropriate job openings—or at least, the jobs they hope are appropriate. This allows hiring managers to easily collaborate with recruiters and HR on tracking applicants by keeping up with each candidate's status, additional materials, and feedback from your team.

Kanban views make it easy to manage moving candidates and job openings through the interview and job opening lifecycle. Whether you want to prioritize direct referrals, expedite all outstanding phone screens, or just focus on finding a replacement Project Lead for the guy who quit three weeks before launch, you'll appreciate the extra view options of this recruiting pipeline template.

By
Spreadsheet.com
Spreadsheet.com
3
Worksheets
CATEGORIES
What is Applicant Tracking?

It might be better to think of it as "applicants tracking," because if you only had one applicant, you wouldn't really need to track them. But presuming that you have multiple applicants, possibly even for multiple open positions at your company, applicant tracking is a method for organizing all of their information and tracking the status of each applicant in a recruitment tracking spreadsheet.

A recruiting pipeline template like this allows you to get an overview of all candidates at once, allowing for comparison between candidates, and tracking of each individual candidate to see where they are in your pipeline. You can see where each candidate was sourced, who received the highest ratings from your interviewers, and which candidate was rejected for being rude to your receptionist. Never be rude to the receptionist.

Did you know?

The most difficult position to hire new employees for is HR manager. With no HR manager to write up the job description and post the job, attracting and tracking applicants becomes much more difficult. It's like not being able to see anything while you're trying to find your glasses.

Failing to include a salary range in your job postings may seem like it could waste everyone's time with interviews that end up being pointless due to mismatched salary expectations. But it only seems that way because it's true.

Although livestock are frequently tracked by piercing the left ear and attaching a numbered tag, doing this to potential employees breaks several labor laws and is strongly opposed by the SPCA (Society for the Prevention of Cruelty to Applicants).

How does it work?

The Candidates worksheet contains each candidate's name, email address, and resume, as well as the linked Job Opening(s) they are applying for. Selectable tags are included for Source (referrals, job postings, etc.) as well as Status (phone screen pending, interview pending, hired, rejected, etc.). View options in the upper left allow a quick sorting into categories based on these tags.

The main Candidates worksheet also includes Ratings from your team, Background checkmark, and a field for notes on why a candidate was passed over. The Application form view allows candidates to apply and have their information and resume immediately entered into the spreadsheet.

The Job Openings worksheet lists each job's Title, Location, Department, and full Description, ensuring anyone viewing the spreadsheet knows exactly what you're looking for. Alternate view option allows Kanban sorting by selectable job Status (Awaiting approval, Approved, Open, Filled, Closed). Linked candidates are automatically assigned to the appropriate job, so you can quickly view your options for any specific position.

Finally, the Locations worksheet lists each office by State/Region, Country, ZIP Code, and address, along with Photos for easy reference. The Job Openings column is linked to openings on the previous worksheet.

Why do I need a candidate tracking spreadsheet?

If you're just going to hire your nephew anyway, you probably don't.

But if you want to seriously consider all applicants and find the best qualified candidates for the positions you have open, you should approach things systematically. Applicant tracking spreadsheets like this ensure that you're moving candidates through the recruitment pipeline at a good pace, so no one falls through the cracks. An organized overview lets you compare all candidates for the position, their resumes, and ratings, while reviewing the description of the job they're applying for.

If you're a larger organization having trouble sourcing qualified candidates, a candidate tracker like this can also show you where your best leads are coming from, so you can focus your efforts there. And an application form directly linked to the spreadsheet means that candidates who apply are immediately tracked in your system. If the perfect candidate applied and then you somehow lost track of their email, you'd feel terrible. Or at least, you would if you realized it, which you probably wouldn't because you lost track, which is why you need a tracking spreadsheet.

Who uses candidate tracking?

Companies who want to find the right candidate

Compare candidates, resumes, and ratings all in one place, while ensuring that every candidate is moved through your recruitment pipeline properly considered.

Companies with multiple open positions

Comparing five resumes for one position is easy. Juggling 50 resumes across ten positions is a lot more difficult, especially because paper is notoriously difficult to juggle. A spreadsheet organizes everything in one place.

More templates like this one
Employee Directory
An Employee Directory is used to store information about staff in a single location for shared access throughout the organization. It can be used to track and manage a wide variety of information about employees such as: names, job titles, contact information, location, job skills, current projects, work hours, vacation schedule, personal interests, and more.
Employee Directory
An Employee Directory is used to store information about staff in a single location for shared access throughout the organization. It can be used to track and manage a wide variety of information about employees such as: names, job titles, contact information, location, job skills, current projects, work hours, vacation schedule, personal interests, and more.
Team Objectives and Tasks
The Team Objectives and Tasks template helps you track tasks and their status for one or multiple teams and relate them to short-term and long-term objectives.
Team Objectives and Tasks
The Team Objectives and Tasks template helps you track tasks and their status for one or multiple teams and relate them to short-term and long-term objectives.
Meeting Agenda and Attendees
The Meeting Agenda and Attendees template makes it easy to define meeting goals, lay out a detailed agenda, outline action items, and keep track of attendees.
Meeting Agenda and Attendees
The Meeting Agenda and Attendees template makes it easy to define meeting goals, lay out a detailed agenda, outline action items, and keep track of attendees.
Employee Training Management
This spreadsheet is designed to help companies keep track of employee training courses and individual employee requirements. Within this workbook there are separate worksheets for tracking employee information, courses and certifications, scheduled class dates, and course feedback.
Employee Training Management
This spreadsheet is designed to help companies keep track of employee training courses and individual employee requirements. Within this workbook there are separate worksheets for tracking employee information, courses and certifications, scheduled class dates, and course feedback.
Employee Engagement Survey
The Employee Engagement Survey template lets you collect, aggregate, and analyze employee feedback.
Employee Engagement Survey
The Employee Engagement Survey template lets you collect, aggregate, and analyze employee feedback.
Printable Performance Review Form
The Printable Performance Review Form template makes it easy to record employee performance evaluations and distribute them when needed.
Printable Performance Review Form
The Printable Performance Review Form template makes it easy to record employee performance evaluations and distribute them when needed.