skip to Main Content

Recruitment Tracker Excel Template

4.75 (16 reviews)

Excel Recruitment Tracker Template will make hiring process easier and more organized. Includes HR reports and dashboard. Works in Mac & Windows.

Learn more about License Types


Someka refunds icon

30-Days
Return

Someka one time payment icon

One-Time
Payment

Someka direct download icon

Instant
Download

TEMPLATE DESCRIPTION

Undoubtedly people are the most important asset of companies, and surely, this asset needs to be stable. As part of this bigger picture, companies spend a lot of time and effort recruiting people for their teams. Recruitment Tracker Excel Template aims to help human resources professionals in making the recruitment process easier and more efficient.

Recruitment Tracker Excel Template Features:

Having recruitment data and the ability to efficiently analyze them can help decision-makers a lot. These decisions include but are not limited to the timing of recruitment campaigns and which channels to place them. We often see that the number of candidates is significantly higher in one quarter and significantly lower in another.

Also, the trends of application sources are shifting too. This can help channel all energies, efforts, and costs in a time and place where we will get the right people.

This Excel template has four main sections:

Recruitment-Tracker-Excel-Template-S01-1

Dashboard:

The recruitment dashboard will give you clear and useful insights into what is the overall situation in the company. Here you can see the number of candidates from the first consideration until hiring, the hiring costs, the active job openings, the percentage of the source distribution of the candidates, and the monthly distribution of job applications.

To show the results and analysis more clearly, the dashboard is divided into two separate parts which are candidates and vacancies statistics.

Recruitment-Template-Someka-Update-S08

In order to make everything as user-friendly and efficient as possible, there are some filters for custom reporting. You can display stats based on your monthly selections, based on months & years, years only, job IDs, department, or based on recruiters. You can also apply multiple or all filters at once, and the charts will update accordingly in real-time.

Recruitment-Template-Someka-Update-S02

Please keep in mind that the date filters on top of the dashboard only affect the recruitment pipeline, sources of applications, and final decision charts of candidate statistics.

Note! The year selections will be specified according to the data you have entered on the vacancies and candidates sheets. So, please fill in the data first to be able to select a year from the dropdown buttons.

Recruitment-Template-Someka-Update-S07

There is a separate date filter selection for the number of applications by month. If you leave the year selection is empty, the chart will show all of the results. Otherwise, you can filter the chart according to the year selection.

Vacancies:

The Vacancies section is where you can add job openings with all the necessary details. Recruitment Tracker Template supports up to 1000 vacancies which are dynamically connected to the rest of the template.

On this page, you can write the opening date, recruiter name, vacancy status, start date, hiring cost, etc. Here it is very important to input dates and costs for the dashboard to give you accurate stats.

 

Recruitment-Template-Someka-Update-S03

The error check column is created for helping you while you are filling in the data. Please do not forget to check that column to avoid any confusion or duplication in the data.

Candidates:

After configuring the vacancies, you can then add all job applications to the candidate’s pipeline tracker page. You should first select the job ID for which the candidate has applied, and then you can enter all other details. Recruitment Tracker Template supports up to 3000 candidates.

According to the job id you selected, the department, job applied for and recruiter column will be filled automatically based on the vacancies sheet. Please do not try to change the grey-colored columns manually.

In addition to the selection phase and decision information, there are 3 informational decision columns for HR View, Hiring Manager View, and Decision Maker View. It is totally up to you whether or not to fills these areas as they’re only for informative purposes. To fill them, just enlarge the grouping for manager views (First “+” sign). Their decision will not be displayed on the dashboard.

Recruitment-Template-Someka-Update-S04

**We also added panel decisions in case more than 1 person is involved in the hiring process. You can also keep notes on each step and phase the candidates are in.

Recruitment-Template-Someka-Update-S09

Settings:

The settings section is designed to accommodate unique business needs. We recommend starting from this part before moving on to other sections. This will make the user experience even better, as you can adjust things based on your needs right from the start.

You can change/add/remove the recruiters, departments, application sources, vacancy status, selection phases, and currency. In addition, here you can also change the final decision and hire decision labels in a way that suits you the best.

Recruitment-Template-Someka-Update-S10

 

Recruitment Tracker Excel Template Features Summary:

  • HR Recruitment Process in Excel Template
  • Innovative reporting system
  • Recruitment Plan for HR Departments/Managers
  • Works both on Mac and Windows
  • No installation needed, ready to use.
  • Professional design and suitable for presentations
  • On Sheet Instructions
  • Print-Ready
  • Compatible with Excel 2010 and later versions

Recruitment Tracker is a ready-to-use Excel Template and provided as-is. If you need customization on your reports or need more complex templates, please refer to our custom services.

PRODUCT VIDEO

Watch the video below to see the template in action! Presentantation also includes usage notes, explanations and tips & tricks about the template.

FREQUENTLY ASKED QUESTIONS

USER REVIEWS & COMMENTS

16 reviews for Recruitment Tracker Excel Template

  1. Dalila E

    Hi, I am just evaluating your recruitment tracker template and teh
    vacancies are showing position filled when status is vacant

    • Someka

      Hello Dalila,

      It is about position status. Please check the yellow notes from the below image. If you don’t watch, we suggest you watch the template tutorial video.

      Template Tutorial Video: https://youtu.be/1WTyPTJWym4

      Recruitment-Tracker_review1

      Hope this helps!

  2. Felicity Martinson

    Thank you Someka, we started following up our recruitment process easily via this product. It improved our HR processes. Thank you again!

  3. MaisyP

    nice excel and useful for my work. Can I add an additional navigation button on this excel?

    • Someka

      Hello Maisy,

      First, you should unlock your sheet to add any shape, including a navigation button.
      You may copy and paste one of the existing buttons.
      When you click on the shape, you may format the colors, etc. from the Shape Format tab:

      recruitment-tracker_shape-format_image

      You may edit the links by Right-Clicking on the button and then select Edit Link. You may give any links from the Edit Hyperlink wizard:

      recruitment-tracker_shape-edit1

      recruitment-tracker_shape-edit2

      Hope this helps!

  4. Dion

    Great!

  5. Cheri A

    love this excel! tiny request, how do I add years to my excel spreadsheet’s drop down menu so that I can see them?

    • Someka

      Hello Cheri,

      The year dropdowns are automatically changed according to the earliest and latest dates on your Vacancies and Candidates sheets.
      For example, if we add a dummy title with an opening date in 2025, then the Year dropdown on the Dashboard will extend till 2025:

      recruitment-tracker_image

      Hope this helps!

  6. Morena

    good. a little question, how can change final decision pie chart color? Not hired and no decision colors are almost same. I need change color

    • Someka

      Hi Morena,
      After purchasing and unprotecting your workbook, you may self-customize our products according to your particular needs, including changing colour.

    • Morena

      Also, I want to change my chart type, please help me

    • Someka

      Hello Morena,
      Regarding the question you asked, as default, we do not add a feature to change chart type but you can do that using the Excel function easily.
      Just select the chart -> Go to Design Tab-> Click Change Chart Type. You will see all available charts for the data we’ve visualized and change the chart design as you see fit!
      Hope this helps! Otherwise please do not hesitate to contact us with any of your questions.

  7. Severo P

    I purchased this. The only 2019 and 2020 years avaliable in the drop down

    • Someka

      Hi Severo,

      The Year dropdowns are totally dynamic in this template; they change according to your data input.
      If your data for Vacancies and Candidates sheets have only 2019 and 2020 years, then the dropdown on the Dashboard will give you only these years.
      For example when we add a New Title on 17-02-2022, then the filter on the Dashboard will go till 2022.

      recruitment-tracker_dropdown_image1

      Hope this helps!

  8. Weaam

    this template is really helpful

  9. Jake Reyes

    Great product and very useful. I just want to know how to change the currency type in the tracker. Thanks

    • Someka

      Thank you!
      Please go to Settings section and write down the currency you want to seel on the Dashboard!

  10. Vrushali

    I took package for HR-Recruitment Interview tracker .I just want it to be more customized or some more columns to be added like candidate education, experience details etc. Please suggest for that.

    • Someka

      Hi Vrushali,
      Thanks a lot for your interest!
      Once you download the template you can also modify it according to your needs as well. Additionally, you can use the “comment” column that we have already created to add more info about the candidates. But, if you would like to add more complicated features and you don’t have any knowledge about Excel that much, we suggest you apply our customization process.
      Best regards,

  11. Rosario

    said as if we simply want to know what their decision is, open the grouping for management views (first “+” symbol). (Their decision will be hidden from view on the dashboard.)
    how do I do this where is the first + sign?

    • Someka

      Hello Rosario,

      Under the Candidates sheet, you will see two plus (+) signs on the top side of the table. Please see the image below.
      When you click on these signs there will populate extra columns, which also includes the manager views:

      recruitment-tracker_column_2

      Hope this helps!

  12. Wayne Wickham

    Can the recruitment dashboard report or filter by Dept.? If not, is the tracker easily customizable to filter by Dept.?

    • Someka

      Hi Wayne,

      Thanks a lot for your interest!

      We have put four different filter options on the template dashboard section. But, you can not filter the dashboard according to the department selection.

      recruitment comment pic1

      We have noted your suggestion to consider when we decide to update the template in the future. But, for now, you can apply our customization process to add the filter option you needed.

      Regards,

  13. Wilma

    great excel. thank yu Someka. please change your logo with yours.

    • Someka

      Hi Wilma,

      You can remove the logo or replace it with your own logo for each sheet. For Free Versions, you are not allowed to remove the logo or alter any copyrighted material in the template.
      You can do it in the full version. Please check how to do that in this link.

      how-to-remove-someka-logo

      Hope this helps!

  14. Cal Tatum

    I love this excel and share this my team. I think that I should change my licence_ can you help me?

    • Someka

      Hello Cal,

      We may surely upgrade your license from single-user to multi-user. Just email us at contact@someka.net and our team will contact you with a link to upgrade your license.

  15. Ania B.

    This tool guides you throughout the process, provides to record essential information that you might needed on each step of interview. Just need some changes but I can do it by myself, it is completely editable. Thanks!

  16. Paolo Petrovic

    Search, find, view all candidates, decisions given past and present with a button click. The dashboard shows you exactly what you need to see all in the same screen. Overall great experience!

Leave a customer review

Only verified users who have downloaded and used the template may leave a review.

RELATED EXCEL TEMPLATES