Recruitment isn’t difficult task anymore, when you have this “Excel” base tracker for monitoring not only present statistics but also you can overview past data. This template made by Template124 for our “HR Manager” help. Spreadsheet of excel makes this easy, just you input some basic information with hiring date, than you can get output sheet, which person to hire yet, which reject for whatever reason.

REQUIREMENTS


  • Microsoft Excel 2010-2013 and above for Windows
  • Microsoft Excel 2016 and above for Mac

Benefit of Recruitment Tracker Template

Here is some basic setting of template, make sure you put values, to perform result in further sheet.


  1. Enter info. In “Settings sheet“.
  2. Fill jobs data in the Jobs sheet.
  3. Enter every application you receive.
  4. Time saving and effortless records.
  5. Evaluate each application.
  6. Can be used for vacant positions, or replacing an employee
  7. Enter the date in Applications sheet.
  8. Enter ‘HIRED’ or ‘NOT HIRED’ in the Application Status column.
  9.  Enter the Decline Reason if the candidate was not hired.
  10. Enter cost of filling the Job in Cost field.
  11. View Dashboard anytime
  12. Look out for the change, after each new selection.
  13. View the performance of recruitment process.
  14. Regularly save your work.

Home spreadsheet- Design & Layout

This sheet is actually designed to help you get started with and getting the overview of the template. Whether a one is pro in excel or if he is a beginner, he is able to perform efficiently on this template through understanding this spreadsheet. Tips to avoid mistakes are beneficial as you are dedicating your time and effort while using this template, therefore any mistake may results in losing the data or affecting the whole calculation process, therefore go through the tips and utilize them. Instructions and simple data entry processes are also added up in the this spreadsheet, therefore you can understand how to get the best results from this template.

Settings Sheet of Recruitment Tracker Template

This is the first sheet of the template, actually requiring your working and it must be filled carefully as it can be followed for whole of the template.

Recruitment stages


  • Enter unique recruitment stages
  • Can handle up to 6 (including hiring)
  • Leave blank, for the stages not required
  • Stages include application, phone screen, MGR interview, onsite interview, offer and hire.

Application sources

It shows where most of the applications are received.


  • Enter list of application sources (up to 15)
  • Application sources may include, LinkedIn, website, indeed, agency and more.

Decline reasons

Add decline reasons for the application here.


  • Enter list of decline reasons up to 15
  • Decline reasons may include, technical, culture, salary, experience or other.

Jobs Sheet in Excel- Hiring Manager Basic Info

This spreadsheet of the tracker provides jobs information. It must be filled manually, while some fields are filled in automatically and they are colored green. Don’t interfere with these cells. Don’t insert anything above row 5. It consists of:

Download


  • Job ID
  • Job title
  • Job location
  • Hiring manager
  • Department
  • Job type
  • Job level
  • Recruiter name
  • Job posted date
  • Positions
  • Status
  • Cost
  • Customized or optional fields
  • Calculated fields include, completed, number hired, to hire, days in market, number of applications and total cost.
  • Required fields are also shown

Blue Color Values {Insert Manually}

Green Color Values {Automatically}

Makes sure You “do not enter any values in Green Color”

Applications Statistics & Monitoring Sheet

For smooth results, you are required to enter all the new applications received for the position in this spreadsheet. It will show all the information related to applications received. Most of the table is required to fill in manually, while cells which will show automatic calculations are colored green. Don’t interfere with these cells and start filling after row 5. It consists of:


  • Job ID for which the application was sent.
  • Candidate name that is the applicant.
  • Application source (Select from the sources options on the right)
  • Application date (when it was received)
  • Phone screen date (when it was held)
  • Interview date (when it was held after phone)
  • Onsite interview
  • Offer date
  • Hired date
  • Application status (select from the hired or not hired)
  • Decline reason
  • Comments (any additional comments can be added here)
  • Customized columns for anything you are interested in

Automatic calculated columns include, job title, stage, error, hired date, job status, days in market, job row, number to hire, job days in market, job cost, job posted date, job location, hiring manager, job type, job level recruiter, department, hired month, year and completed year and month.

Application-Sheet-HR-Tracker

HR Dashboard 

This part of the template is designed to show you the performance metrics and is very important tool to help you make smarter and flexible decisions for your business. With the filters, this is even easier. Filters include, job status, job completed per month, job location, recruiter, department and job level.

Select any slicer and view the details for it in form of automated dashboards, covering the entire metrics for it.

Dashboard for all

This is entirely automated, based on the information filled in the previous spreadsheets and on the basis of selected filter. It is not only excellent way of getting aware with the details in fact it is designed to keep the user focus in it as well. The funnels cover, hired, apps per hire, days to hire, cost per hire, open positions and days in market. For any changing in the previous spreadsheets, don’t forget to refresh the table to get the latest, updated results.

Recruitment Funnel

It shows the visual presentation of the recruitment process. It may be required in meeting or conference process, so that recruitment procedure can be discussed among top management or recruiter manager or among company partners. It shows applications percentage, phone screen interview, manager interview percentage, onsite interview percentage, and offer and hires percentage as well in form of funnel.

Monthly metrics

Any details for the specific month are shows through this dashboard. It covers monthly metrics for the past 12 months and shows month, hired and days to hire. Select any specific month for look upon these details in that particular month.

Pipeline efficiency of hiring

Now analyze your company hiring process and how efficiently it is actually carried out thorough this dashboard. It shows days taken for each stage in recruitment process and covers application, phone screen, manager interview, onsite interview, offer and hire.

Application sources

Details information of the applications sources are shown by this dashboard. It show details analysis through consisting of application sources list, number hired, percentage of hired, and conversion rate.

Decline reasons

Now view most of the decline reasons for the rejected candidates through this dashboard. It shows decline reason list, number of applications and percentage of applications rejected.

Active pipeline

Visualize active pipeline through this dashboard. It shows recruitment and pending applications as well.

Job Report Sheet of HR Tracker 

This part of the spreadsheet shows details for any specific job and position. This is required for detailed analysis as well as helpful in making discussions within company premises. It consists of:


  • Job ID (select it)
  • All the details are filled in automatically for the current pipeline
  • For the pending applications fill in the tables consisting of candidate name, status and comments.

Candidates Sheet

An additional spreadsheet is designed to help you get to the selected candidate instantly through adding his contact details in it, however it is for optional use. Added fields are candidate ID, first name, last name, location, email phone, skills, strengths, weaknesses and notes.

So What about “Template124” template of “HR manager” for “Free Customization” of

Recruitment-Management-Syst

Recruitment Tracker Spreadsheet Excel you just need to comment us after purchase Via Email or here.

18 thoughts on “Recruitment Tracker Spreadsheet {HR Excel Template}

Download link is attach, go and get your template now of (Rescruitment Tracker.

If you want Free Version of “Recruitment Tracker” than Comment us and get Free Template Now.

Thanks

I want to get a free version recruitment tracker please.

I really want to get a free version of your recruitment tracker spreadsheet. It will really help me in my recruitment process. Please? I badly need this 🙁

great sheet, very useful

Would like to have a free version for trial. Thanks!

Thanks for Reply

Go to that link (https://www.template124.com/product/recruitment-manager-excel-template-dashboard-tracking/) submit your review about this product and get Free Template now.

We already send template to mention Email above

Thanks

I would like to have a free version for trial. Thanks!

Always looking for a better way.

Thanks for AMUDHA, MARILYNNE MANCUSO

Makes Sure this is Free version not Trial version

Thanks

Kindly send free version.

I really want to get a free version of your recruitment tracker spreadsheet. It will really help me in my recruitment process. Please? I badly need this 🙁

I would like a free version of the recruitment tracker please

Hi,

Can I have this nice template

I would like to try to use the free version before buying the product. Please share with me.

hi M.Akhan

Make sure this is only one sheet file, for more detail about Recruitment Tracker you must Visit this link (https://www.template124.com/recruitment-manager-template/) and see video (How to Working)?

Thanks

Can you share free recruitment tracker and hr dashboard please. Thank you.

Get your File and notify us about this recruitment tracker

Thanks

Leave a Reply

Your email address will not be published. Required fields are marked *