HR Excel Templates

Human Resources (HR) Excel Templates
Human Resources (HR) Templates

Human Resources Templates

Microsoft Excel can be valuable tool for HR (Human Resources) professionals. Whether you are part of a large organization or a small one, Excel comes in handy to help manage data related to hiring or hired employees. In addition to effectively organizing and retrieving data, it can also help create & implement processes. Please find below a collection of Excel templates that are designed to help HR related tasks.

If you have any suggestions for a new template, please contact me with specific requirements.

Free Human Resource Excel Templates

PTO (Paid Time Off) Balance Calculator for Hourly Employee

Download this free Excel template to track and calculate Employee’s PTO accrual balances based on hours worked by the employee. Automatically calculates current PTO balance and projected future balance.

Employee Timesheet 2020 – Excel Time card & Work Hours Calculator

Download this free Excel template to print weekly, Biweekly & monthly timesheets by just entering the time card entries like time in, time out & break time. Contains automated calculations
& reports on multiple timesheets.

2020 Leave Tracker & Vacation Tracker Free Excel Template

Download this free Excel template to calculate employee attendance, provides a calendar view of leave for multiple employees and also print an annual employee report. Track vacation of multiple employees including partial days of leave.

New Employee Checklist 2020 – Free Excel Template

Download this free Excel template to track the onboarding activities of a new employee. This template is extremely customizable and provides a printable checklist for each employee. Maintain data of all employees in one file.

Recruitment Tracker 2020 – Free HR Excel Template for Recruiters

Download this free Excel template to track status of the applicants (candidates) in an organized way. Get an instant view of how many applicants are in the recruitment pipeline and where in the funnel applicants are dropping off.

Employee PTO Tracker & Calculator 2020 – Free Excel Template

Download this free Excel template to calculate PTO balances where PTO is accrued based on tenure. This simple sheet associated with data validations can be used as a vacation tracker and also a PTO vacation accural calculator.

Employee Vacation Planner 2020 – Free Excel Template

Download this free Excel template to assess the coverage of team members’ availability during a month. This Excel template can be used every month to ensure that you are aware of exact coverage and plan the work accordingly.

Free Human Resource Google Sheet Templates

PTO Balance Calculator (Hourly) – Free Google Sheet Template

A Simple Google Sheet template to help you to track the PTO balances of hourly employees. Download this free Google Sheet template to track and calculate Employee’s PTO accrual balances based on hours worked by the employee.  If you need a PTO Calculator that calculates accrual based on employee tenure, please see PTO Calculator (Salaried [...]

PTO Balance Calculator (Salaried) – Free Google Sheet Template

A simple Google Sheet Template that can be used as a vacation tracker and PTO vacation accrual calculator. This Google Sheet template can also be used to track and calculate Employee’s PTO (or leave or vacation) accrual balances. This template is designed for Google sheets, but if you are looking for an Excel template, please [...]

Employee Leave Vacation Tracker – Free Google Sheet Template

Whether you are a HR Manager, a Small Business Owner or a Project Manager it is important to track leave/vacation/time-off taken by employees.  This Google Sheet Template is developed to help people in tracking leave/vacation in an organized way, calculating employee attendance. This Google Sheet Template presents a calendar view of leave across multiple employees [...]

Employee Timesheet – Free Google Sheet Template

If you are an employee, no more wondering ‘How many hours did I work?’ or searching for ‘How to calculate hours worked?’. This timesheet template makes it easy by automating all the calculations. If you are an HR (Human Resources) professional who needs a work hours calculator for the employees in the company or team, [...]

New Employee Checklist – Free Google Sheet Template

This Google Sheet is developed as a solution to document the completion of activities in a checklist. The HR departments in companies can use a copy of this template to track or document the new employee on-boarding activities. Ideally, there is a list of onboarding activities each employee has to complete during the onboarding process. [...]

Employee Vacation Planner – Free Google Sheet Template

As a team leader or a manager of a team, it is important to know the staff coverage available every day, especially during the holiday season. This Google Sheet Template is developed to provide a simple and effective solution to help assess the coverage of team members’ availability during a particular month.  This Google Sheet [...]

Recruitment Tracker – Free Google Sheet Template

For a simple and effective solution to manage the recruiting process and truly understand its performance via effective Recruiting metrics, use this Google Sheets recruiting template to track status of the applicants (candidates) in an organized way. Get an instant view of how many applicants are in the pipeline and where in the funnel applicants [...]