If you like a candidate but not for that job, the “Consider for another job” option is useful. You can also use color-coding to make it easier to spot active vs rejected candidates. You can modify this column by making a menu of choices, but we chose to leave it fillable so you can get more precise (like referral names).Ĭolumn C: The application status lets you know where a particular candidate is in the process. For example, if an employee refers another person for a position, you can ask them about the candidate. That will let you keep the drop-down menu choices.Ĭolumn A: Put the applicant’s last name first so that it’s easy to sort alphabetically.Ĭolumn B: Knowing the reference can help give insight into the candidate. If you need more, highlight and copy an entire row, then paste it. Row 4–104 (Green): The current template is set up for 100 candidates. You can modify this row to fit your needs. Row 3 (Blue): This row is the header row (auto-filled) that lists the description for each column. Row 2 (Peach): Put the department you are hiring for or the responsible hiring party, whatever information is most important for the team to keep in mind. You can copy and paste this from the official job posting or put a summary of what interviewers should be considering. This is for the edification of your hiring team only. Row 1 (Yellow): Put the job title and description at the top of the page. The Sample tab shows you how you might use the template. This will create another tab that you can rename. Select the sheet you wish to place the copy before and check the box next to Create a Copy. When starting a new hiring process, right-click on the Position TEMPLATE tab and select Move or Copy. You can modify the cells to fit your applicant procedures. Position 1 is ready for you to fill in with your first job. At the bottom of the file, you will see tabs marked Position 1, Position TEMPLATE, and Sample. Position: This spreadsheet was created to be job-specific. Let’s look at each element and how it’s best used. Using a tracking template not only keeps applicant information at your fingertips but also makes it easy to check on status, feedback, red flags, and other information that’s important to the hiring process. Download the Free Excel Recruitment TemplateUsing a tracking template not only keeps applicant information at your fingertips but also makes it easy to check on status, feedback, red flags, and other information that’s important to the hiring process.

Employee availability spreadsheet