Recruitment Tracker 2024 – Free Recruitment Template in Excel
As a hiring manager/recruiter, are you currently navigating the challenges of talent acquisition? If you’re in search of a simple yet powerful solution to streamline your recruitment process and gain valuable insights through key recruiting metrics, we’ve got you covered, so read along!
Introducing our simple yet versatile Recruitment Tracker Excel template, designed to help you efficiently manage and monitor applicant progress. With this template
With the recruitment dashboard, you’ll gain instant visibility into the number of applicants moving through your hiring process and pinpoint where they drop off. Furthermore, our hiring tracker enables you to effortlessly identify the key reasons why certain candidates were not chosen, facilitating smarter hiring decisions.
Download Recruitment Tracker
Recruitment Tracking – Simple & Effective
This Excel template is designed for Microsoft Excel, but if you are looking for a Google Sheet template, please visit Recruitment Tracker in Google Sheets. We also have a comprehensive Recruitment Dashboard in Microsoft Power BI.
This template is designed to handle one job opening only, check our Recruitment Tracker Dashboard in Excel that handles multiple job openings and multiple hires with additional features.
Lets take a look at each of the components of the recruitment tracking Excel template. We will go over the dashboard first and then the data entry steps.
Recruitment Tracker Dashboard
Our meticulously designed dashboard is fully automated, allowing you to gain key insights almost immediately.
Key Hiring Metrics (KPIs)
As a recruiter, it’s crucial to know how effective and efficient your recruiting process is. The metrics in the dashboard give you just that!
Take a look at all the additional, key recruitment metrics available in the premium Recruitment Dashboard in this article.
Know how many applications were received and how many are open; See how many offers are given and the average days it takes to hire an open position. These insights drive important hiring decisions like how to fill a position faster, thereby reducing time to hire and much more.
Need more metrics and visuals on the quality of applications, active pipelines, do take a look at our Premium Recruitment Dashboard Template using Microsoft Excel.
Recruitment Funnel
To know at which stage candidates are more likely to drop off is crucial. The recruitment funnel shows you just that:
Time taken for each stage
Determine whether there’s a bottleneck – if a specific stage in your recruitment process is causing significant delays and prolonging the time it takes to fill a job vacancy.
Open Applications in each stage
Know exactly how many applications are in which stage of recruiting with the following visual:
Source Contribution
You can identify which application sources bring you better quality of candidates as you can compare the offer % through these channels. This aids in your recruiting source channel decisions.
Application Decline Reasons
Understanding the reasons for candidate rejections will enable you to pinpoint any shortcomings in the application process. Likewise, comprehending why candidates reject your offers empowers you to adjust the job description or align expectations effectively with your company’s leadership.
Once an opening is closed with a successful recruit, you can view the details of the new recruit with this visual:
Data Input
To get the amazing dashboard, the data entry steps are really simple and straightforward:
All that’s needed is just two steps, which are explained here:
Step 1: Customize the template for your needs
In the Settings sheet, define your recruitment tracking templates’ key details like the stages of application, source channels and the decline reasons as per your organization.
Step 2: Enter Job Details
The Applications: This is where you’ll enter all the information related to the candidates/applicants for the open position.
Begin with the job title, the recruiter and the job posting date
Step 3: Enter Applications information
Once applicants start coming in, the details can be entered as shown below along with their source in the respective columns.
- Enter the candidate name and the source of the application (example: LinkedIn, Indeed, etc.)
- As candidates flow through various stages of their recruitment funnel, enter the dates when the candidate reaches a particular stage (Application received, phone screen, hiring manager interview, etc.).
- Once a hiring decision is made, enter the hire date and joining date in the corresponding columns.
- If the candidate gets rejected, give the status as “Not Hired”, enter the decline reason in the column for the same.
- We have additional columns for your comments and cost. Enter them if available.
That’s all the data entry steps that are needed to get your fully automated recruitment applicant tracking system in place.
Now, you can open the Dashboard sheet and use the metrics and visuals for crucial hiring decisions or present them to senior management.
Happy recruiting!
Do you have any queries or looking to customize the recruitment tracker, please reach out to us at support@indzara.com
Recommended Template
If you are looking to manage multiple jobs and get advanced reporting, please try Recruitment Tracker Dashboard Excel Template
-
$69
151 Comments
Hi,
I downloaded the free tracker but I cannot use it because it is protected by a password.
Thanks for using our template.
Please use “indzara” as a password.
Best wishes
Hello
Why does the active pipeline only track 4 stages? What if I have more stages that I want to track and reflect on the active pipeline. Will the formula stay the same?(=COUNTIFS(T_Apps[WAITLISTED],””,T_Apps[STAGE],HELP!B4))
Thanks for using our template.
Please review our premium Recruitment Manager at https://indzara.com/product/recruitment-manager-excel-template/. It can handle more stages.
Best wishes
Hi
I am trying to put Hired date in the dashboard, its not reflecting in the main record, what i belive once i write the date, the cell should become blank and the value should be transfered to main record
Please advise on this
Thanks and Regards
Mahmood Shahbaz
Hello
Please enter the dates in the Applications tab and refresh the dashboard.
Thanks
Hi, Can you add a stage in the process to the pipeline and funnel. We use a one way video interview before the in person interview. I would like to track the dates of the one way video interviews similar to the other stages.
The ideal stages to include would be Application, Phone Screen, One Way Video Interview, In Person Interview , Offer.
Thanks for the feedback.
Have you checked our premium template “Recruitment Manager”? This can be customized as per your needs. Please visit https://indzara.com/product/recruitment-manager-excel-template/
Best wishes
Hi, I watched the video and I am not clear on where to enter in my data … applicant, phone screen etc. I don’t see the spreadsheet. Is it only there if you actually purchase the template?
Hello
Thanks for using our template.
The free version is just a tracker of all the applications received. However, the paid version has a sheet to record the details of the applications received.
Best wishes
Ok, so I have to purchase it to use it?
The Recruitment Tracker above (https://indzara.com/2015/09/recruitment-tracker-free-excel-template/) is a free template to download. You will find the link inside the blog post. You can use this to track applications for a single job at a time.
The Recruitment Manager template (https://indzara.com/product/recruitment-manager-excel-template/) is a premium template available for purchase. This can be used to track applications for multiple jobs, with automated recruitment dashboard.
Please let us know if there are any questions.
Thanks & Best wishes.
Hi I would like to purchase the Recruitment Manager Template. How can i go about this? Also is there a way to add these list to Excel sheet – Budgeted positions for 2018 and forecast for 2019/2020.
Thanks for your interest.
We are currently not taking new customization projects. However, customers can make modifications by adding sheets as needed.
Please let us know if there are any questions.
Thanks & Best wishes,
Loved it! However, I would like to add the source where I got the resume from and the candidate phone number. Can I do it without messing up the spreadsheet?
Thanks. Glad to hear. Please add more columns to store additional information. You can add columns except for in-between the stages.
Best wishes.
Awesome template for the single position.
Cheers
Saket
Thanks for your feedback.
Best wishes
Hi,
I tried to track several recruitment in different tabs of the same workbook but it messed up summary dashboard. Do you necessarily need a new workbook to track another recruitment?
Thanks
Hello
The template uses a hidden sheet where calculations are made. So, just copying the summary sheet will not duplicate the calculations. Each position’s data has to be in a separate workbook. Or you can try the https://indzara.com/product/recruitment-manager-excel-template/ which allows tracking multiple positions in the same file.
Best wishes.
How do you get the stage to calculate if you decline the applicant before phone interview due to lack of experience?
Hello
In this free template, you can track the dates only. Maybe based on the credentials you can reject an application and not call for a phone interview.
However, the premium template has many features where an applicant can be rejected based on their credentials and that can be tracked as well. Please visit https://indzara.com/product/recruitment-manager-excel-template/
Best wishes
Is this good for only single position?
Yes, this template can track only one position. For multiple positions and more features, please see Recruitment Manager template https://indzara.com/product/recruitment-manager-excel-template/
Thanks & Best wishes.