Are you looking for resources to improve your department's day-to-day workload? We've chosen the best Excel spreadsheets for human resources: performance appraisals, annual leave, timekeeping, work climate, organogram and payroll. And it's all free!
Usage of Excel spreadsheets in HR
The personnel department manages and stores and large quantity of information, which also increases as the company grows. It’s easy to manage when the company is still small. But once the company has more than 50 staff, and in addition to hiring specialised HR professionals, as studies recommend, it's also important to use the appropriate tools to help you grow and stay efficient. Excel spreadsheets for human resources suddenly become obsolete, especially when you reach this point.
The future lies with HR software such as Kenjo that enable teams to grow, to become more productive thanks to task automation, and to make better decisions based on objective data. However, we have an intermediate solution for those departments that still opt for traditional systems: preconfigured Excel templates for human resources. We gathered a selection of the best on the market, some of which are created by Kenjo.
Excel template for performance appraisal
The performance appraisal template is one of the most useful of the free templates for human resources available. It was created by Kenjo and enables you to upload a record for each employee, where you can register all the appraisals you carry out during the year.
Can you customise it to suit your needs? Of course, just enter the questions you normally ask at appraisals and classify them using the pre-set categories we've created for you.
Apart from storing information, the Excel template also enables you to generate charts to analyse the performance of each employee or team throughout the year, and even draw comparisons with their colleagues. You can also compare the results of several teams according to the department or manager. Click on the link below to download our performance evaluation template.
Excel template for annual leave
How do you track your team’s annual leave? You’ll find it much easier, faster and more secure with this human resources Excel template. Just enter each employee’s information and start to use it. It was inspired by our absence and annual leave software, so you’ll be able to access each employee’s record and an overall calendar where you can see, at a glance, the entire team’s absences with colour-coded identification. Click on the following link and download our Excel template for holidays and absences.
This will enable you to track annual leave for every employee, the number of absences, and thanks to the calendar, you will be able to better coordinate your staff by visualising those who are available on a daily basis. See a full explanation in this video:
The Working Time Regulations stipulate a maximum 48-hour week for all UK employees. Employees can opt out if they choose, but employers have the responsibility of tracking time and attendance of all staff, mainly to ensure that they are not doing too much overtime. Tracking time and attendance is also extremely important for remote workers, who need to keep track of hours worked, as well as those with flexible working agreements. Employees with children under 17 years old have the right to request flexible working, after the Children and Families Act came into force in June 2014
What system are you using to keep track of time and attendance? Some Excel templates allow you to simply enter clock-in and clock-out times and it will automatically calculate the number of hours, as well as any overtime worked. Download a template here.
Workplace survey template
Work climate includes a range of factors such as motivation and employee satisfaction. Gauging and understanding how the team perceives the company, as well as their own job role, will give you an idea about the atmosphere within the company, enabling you to make improvements that will increase your productivity and the well-being of your workforce. To do this, it's fundamental to ask staff to complete workplace surveys from time to time.
You can use a template (download here) which generates a human resources dashboard with the survey results. See detailed instructions on how to use an Excel template here:
Excel template for recruitment
Another essential tool for a HR department is an Excel template for recruitment. It's vital to outline a recruitment plan when launching a recruitment process, and have a document that allows you to track it. When it comes to making a decision, you will have all the candidate information at your fingertips so that you can draw comparisons and select the best person for the job.
This recruitment template will enable you to classify candidates, indicate at which stage of the process they currently are and see all the observations you have made along the way.
Whether your company has a vertical or horizontal structure, having an organigram is important so that reporting lines are clear to everyone. This will give you a handy and clear view of the company structure, the different teams, job roles and departments. It’s a key tool for improving communication and is very useful, for example, while onboarding new staff members.
Click here to see a range of different organigram models that you can customise and adapt to your organisation. It’s important to keep it up to date after every promotion, and when someone joins or leaves the company.
Payroll template for Human Resources
Payroll administration is one the most important functions of a HR department. With a platform like Kenjo, you could save up to 40% of the time spent on this type of administrative task. Nevertheless, if you’re still using Excel then it’s always better to use a template.
There is no official payroll template but the HMRC offers useful information on the most important aspects a payslip should include. You can create your own or choose an online platform to help you. This template gives you a base to work from and allows you to quickly and easily create payslips for your team.
The NPS, or Net Promoter Score is a method created by Fred Reichheld to measure the satisfaction of employees, clients, etc. They are asked to answer questions such as “How likely are you to recommend this (product, service, company) to a friend or family?” and the person has to give a rating from zero (least likely) to 10 (most likely). In this way, three types of profile are established: Promoters, Passives and Detractors.
Hotjar has created an automatic calculator that helps you determine how many Promoters, Detractors you have in your company and discover your NPS.
Digitise your HR department with Kenjo
Take the quality and efficiency of your work to the next level and leave Excel templates behind. Digitise your HR department with Kenjo human resources software. You will be able to manage your payroll, recruitment processes, annual leave and absences, workplace surveys, etc. all in one place, and share the information with your team and become more agile in your day-to-day work. We calculate that, on average, you’ll save 40% of the time spent on administrative tasks.
You may also be interested in our article about the 3 best human resources software.