Google Sheets HR Dashboard Templates
A hR dashboard tracks your people: hiring, attrition, attendance, training and pay in one place. Pick your industry below to see a live preview of the Google Sheets version.
Choose your industry
Retail HR DashboardGoogle Sheets · $29E-commerce HR DashboardGoogle Sheets · $29SaaS HR DashboardGoogle Sheets · $29Restaurant HR DashboardGoogle Sheets · $29Café & Bakery HR DashboardGoogle Sheets · $29Hotel HR DashboardGoogle Sheets · $29Real Estate HR DashboardGoogle Sheets · $29Construction HR DashboardGoogle Sheets · $29Manufacturing HR DashboardGoogle Sheets · $29Logistics HR DashboardGoogle Sheets · $29Clinic HR DashboardGoogle Sheets · $29Hospital HR DashboardGoogle Sheets · $29Dental Practice HR DashboardGoogle Sheets · $29Pharmacy HR DashboardGoogle Sheets · $29Gym & Fitness HR DashboardGoogle Sheets · $29Salon & Spa HR DashboardGoogle Sheets · $29Coaching Institute HR DashboardGoogle Sheets · $29School HR DashboardGoogle Sheets · $29University HR DashboardGoogle Sheets · $29Marketing Agency HR DashboardGoogle Sheets · $29Consulting HR DashboardGoogle Sheets · $29Law Firm HR DashboardGoogle Sheets · $29Accounting Firm HR DashboardGoogle Sheets · $29Insurance HR DashboardGoogle Sheets · $29Banking HR DashboardGoogle Sheets · $29Fintech HR DashboardGoogle Sheets · $29Automotive HR DashboardGoogle Sheets · $29Car Dealership HR DashboardGoogle Sheets · $29Agriculture HR DashboardGoogle Sheets · $29Food Processing HR DashboardGoogle Sheets · $29FMCG Distribution HR DashboardGoogle Sheets · $29Wholesale HR DashboardGoogle Sheets · $29Kirana Store HR DashboardGoogle Sheets · $29Fashion & Apparel HR DashboardGoogle Sheets · $29Jewellery HR DashboardGoogle Sheets · $29Electronics Store HR DashboardGoogle Sheets · $29Furniture HR DashboardGoogle Sheets · $29Pharma HR DashboardGoogle Sheets · $29Telecom HR DashboardGoogle Sheets · $29Solar & Energy HR DashboardGoogle Sheets · $29Non-profit HR DashboardGoogle Sheets · $29Events HR DashboardGoogle Sheets · $29Travel Agency HR DashboardGoogle Sheets · $29Media & Publishing HR DashboardGoogle Sheets · $29Gaming HR DashboardGoogle Sheets · $29Creator Business HR DashboardGoogle Sheets · $29Freelancer HR DashboardGoogle Sheets · $29Startup HR DashboardGoogle Sheets · $29IT Services HR DashboardGoogle Sheets · $29Security Services HR DashboardGoogle Sheets · $29Cleaning Services HR DashboardGoogle Sheets · $29Printing & Packaging HR DashboardGoogle Sheets · $29Pet Care HR DashboardGoogle Sheets · $29
KPIs in every hR dashboard
| KPI | What it tells you | Formula |
|---|---|---|
| Headcount | Number of active employees at period end. | COUNT of employees with status = Active |
| Attrition rate | Share of employees who left in the period. | Leavers ÷ Average headcount |
| Time to hire | Average days from job opening to offer accepted. | AVERAGE of (Offer accepted − Opening date) |
| Open positions | Roles approved but not yet filled. | COUNT of open requisitions |
| Absenteeism | Share of scheduled work time lost to unplanned absence. | Days absent ÷ Scheduled working days |
| Training hours | Total hours of learning completed. | SUM of training hours logged |
| eNPS | How likely employees are to recommend you as a workplace. | % Promoters − % Detractors |
| Avg salary | Average monthly pay per employee. | Total payroll ÷ Headcount |