No 1 Recruitment tracker of all time.

Looking for Recruitment Tracker Template or applicants/candidates job tracking system in Microsoft database template of Excel? Recruitment isn’t a 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, then you can get output sheet, which person to hire yet, which reject for whatever reason.

The best ever recruitment template for HR Manager, and other recruiting agencies.

A Recruitment Tracker Spreadsheet is an invaluable HR Excel template that revolutionizes the recruitment process. It serves as a centralized tool for HR professionals to streamline and manage the hiring process from start to finish. This comprehensive spreadsheet allows recruiters to keep track of all candidates, their application status, interview schedules, and key evaluation criteria.

The Recruitment Tracker Spreadsheet offers several key features that enhance efficiency and organization. Firstly, it provides a dedicated section to record candidate information, including their name, contact details, job position, and relevant qualifications. This section acts as a comprehensive database, enabling recruiters to easily search and sort candidates based on specific criteria.

Contents

REQUIREMENTS


  1. Microsoft Excel 2010-2013 and above for Windows
  2. Microsoft Excel 2016 and above for Mac

Benefit of Recruitment Tracker Template

Here is some basic set of the template, make sure you put values, to perform result in the 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 the cost of filling the Job in the 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 get the overview of the template. Whether a one is a 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 result 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 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 the 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.


  1. Enter a list of decline reasons up to 15
  2. 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


  1. Job ID
  2. Job title
  3. Job location
  4. Hiring manager
  5. Department
  6. Job type
  7. Job level
  8. Recruiter name
  9. Job posted date
  10. Positions
  11. Status
  12. Cost
  13. Customized or optional fields
  14. Calculated fields include, completed, number hired, to hire, days in the market, the number of applications and total cost.
  15. 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 the 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 of


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

Automatically 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 to date, job location, hiring manager, job type, job level recruiter, department, hired month, year and completed year and month.

HR Dashboard 

This part of the recruitment dashboard template is designed to show you the performance metrics and is a 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 the 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 the selected filter. It is not only an excellent way of getting aware of the details, in fact, but it is also 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 the 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 the 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 the form of a 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 the month, hired and days to hire. Select any specific month to 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 through this dashboard. It shows days taken for each stage in the recruitment process and covers application, phone screen, manager interview, onsite interview, offer and hire.

Application sources

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

Decline reasons

Now view most of the decline reasons for the rejected candidates through this dashboard. It shows the decline reason list, the 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


  1. Job ID (select it)
  2. All the details are filled in automatically for the current pipeline
  3. 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 Tracker Spreadsheet Excel you just need to comment us after purchase Via Email or here.

Moreover, the spreadsheet includes columns to track the different stages of the recruitment process. Recruiters can update the status of each candidate, such as “Applied,” “Screened,” “Interviewed,” or “Offered.”

This real-time tracking ensures that no candidate is overlooked, and recruiters can easily identify the stage at which each candidate is in the process.

The Recruitment Tracker Spreadsheet also enables recruiters to schedule interviews efficiently. They can record the date, time, and location of each interview, along with the names of the interviewers and any additional notes.

This feature ensures that interview logistics are well-organized, reducing the chances of scheduling conflicts or miscommunications.

Another important aspect of the spreadsheet is the ability to evaluate candidates based on predefined criteria. Recruiters can include relevant skills, qualifications, and experience required for the job, and rate candidates on each criterion.

This evaluation process helps in comparing and selecting the most suitable candidate for the position.

Overall, the Recruitment Tracker Spreadsheet is an essential tool for HR professionals seeking to streamline and manage their recruitment process effectively.

It provides a centralized platform to record and track candidate information, manage the different stages of recruitment, schedule interviews, and evaluate candidates.

By utilizing this HR Excel template, recruiters can enhance their efficiency, reduce administrative burden, and make informed hiring decisions.

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

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

I need this report please

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 🙁

Hi, I would like to have a free tacker as well.

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

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

I really need this free version of recruitment excel tracker, please help me with the same.

Thanks

Please send me your recruitment tracker and spreadsheet. I would really appreciate it. Its going to help a lot.

Thanks Check Email

Hi would be interested in looking at the basic version to see how it could work outside our current CRM

We will send you Recruitment Tracker Video Link and Dashboard copy

Check it now

Thanks

Buddy I requested for Recruitment manager tracker. You have sent me recruitment tracker for employee. please forward it

I would like to try your template , kindly share your free trial template

RECRUITMENT TRACKER SPREADSHEET {HR EXCEL TEMPLATE} is one of the best tracker i have found till date. can you please share me the free version to my mail id

look forward for your help.

Govind

Check Email

I want to get a free version recruitment tracker
Thank you!

Check Email and Give me feed back on (https://www.template124.com/product/recruitment-manager-excel-template-dashboard-tracking/)

Make sure Free Version isn’t includes proper template

Thanks

Hi Admin,

Kindly need the template free version recruitment tracker
Thank you!

Regards,

Check Email

Hi, Recruitment Manager template really captures most of the fields required in a tracker. Could you please share a copy of the same.

Thanks in advance

Please let me have the template free version recruitment tracker.

Thank you

please send me Recruitment tracker template for managers free version.
Thank you

Recruitment Tracker Send to Your Email

Hi,

Appreciate if can share the recruitment template.

Thanks!

please send me Recruitment tracker template for managers free version.
Thank you

Thanks for this, Email send to your address
Kindly check

Hi,

Nice template and very useful. Greatly appreciate if you could send me the recruitment tracker template for managers (free version). Thanks a lot!

Check out, Template124 team sending you Recruitment template

please send the recruitment dashboard template

Thanks Kunal, Free Template send to your

Check email and get recruitment Tracker

Thanks

Hi Admin,

Kindly need the template free version recruitment tracker
Thank you!

Regards,

Tracker Send to Your Email

Thanks

Please share the free version of the recruitment tracker. Thanks

Hi Admin Template124

Kindly need the template free version recruitment tracker
Thank you!

Regards,
deden

Leave a Reply to Rohit Ilkar Cancel reply