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.
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.
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).
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.
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.
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.