● SALE  60% off every template in the Etsy shop, for a limited time Pinterest Instagram Threads Facebook TikTok Tumblr
Shop on Etsy
Home›Payroll & HR›Employee Directory Tracker
Employee Directory Tracker hero view showing the employee directory tracker spreadsheet and its headline features
PAYROLL & HR

Employee Directory Tracker

When a team is small, people admin hides in your head, in old email threads and in a notebook that vanishes when you need it. This employee directory tracker gives all of it a single proper home: who everyone is, how to reach them in a hurry, and whether their paperwork is truly complete.

$1.00$2.5060% OFF

Sale price in our Etsy shop right now. Checkout, payment and instant delivery are handled by Etsy.

Instant DownloadExcel + Google SheetsPDF Guide Included

Tidy team records, calmer Mondays

Small teams rarely have an HR department, so the people details end up scattered: a phone number in a chat thread, a start date in an old email, a signed contract in a drawer somewhere. This tracker gathers all of it into one workbook, so the answer to a simple question never takes twenty minutes of digging.

The Employee Directory holds each person's name, role, department, start date, email, phone and status, for up to 30 people, with years on the team calculated from their start date. The Emergency Contacts tab pulls names straight from the directory, so you type them once, and anything missing flags itself before it matters in a real emergency.

A Documents Checklist tracks the essentials per person, contract signed, ID copy, tax form and policy sign-off, with a plain Yes or No that makes gaps easy to spot. The dashboard totals your staff, shows who is active and who is on leave, breaks headcount down by department and counts how many files still miss a document.

Inside the workbook: 5 tabs

What you receive

  • Google Sheets Access PDF with a one-click copy link for your own Sheets copy
  • BLANK Excel workbook, your clean fresh start
  • EXAMPLE Excel workbook filled with a sample team of ten
  • Quick Start Guide PDF with the setup steps on one page
  • Four separate files, no ZIP to unpack

Good to know

  • Runs in Microsoft Excel 2021 or Microsoft 365
  • Google Sheets version needs a free Google account
  • Works on computer, tablet and phone
  • For record keeping only, not a substitute for professional HR advice
  • Questions? Message us on Etsy and we will help you get set up

Questions about this template

The things buyers ask us most.

How many employees can it hold?

The directory is built for up to 30 people, which suits most small businesses and growing teams. Each person gets their contact details, role, department and start date recorded once, and the emergency contacts and documents checklist follow the same list, so nobody needs entering twice anywhere in the workbook.

Which documents does the checklist track?

Four essentials per person: contract signed, ID copy, tax form and policy sign-off, each marked with a simple Yes or No. The dashboard counts how many files still miss a document, so you can chase the gaps in one pass instead of opening every person's record to check.

Do I have to type names on every tab?

No. The Emergency Contacts tab pulls names in from the Employee Directory automatically, so each person is typed once and reused. That also keeps spelling consistent across the workbook. If someone joins or leaves, update the directory and the connected tabs follow, with missing contact details flagging themselves.

Do I need Excel, or can I use Google Sheets?

Both are included in the download. The BLANK and EXAMPLE files are Excel workbooks for Excel 2021 or Microsoft 365, and the access PDF carries a one-click link that copies the tracker into Google Sheets with a free account. It works on computer, tablet and phone for quick lookups.

More in Payroll & HR

All templates in this category →

Three more workbooks from the same shelf.

Payroll Tracker Spreadsheet

Hours in, gross pay, tax and net pay calculated, pay stubs ready.

$7.50 $3.00
View on Etsy
Employee Attendance Tracker Spreadsheet

Mark one code per person per day and get monthly totals, alerts and report cards free.

$7.50 $3.00
View on Etsy
Hiring Tracker Spreadsheet

Roles, candidates, interview scorecards and offers in one tracker, with stalled flags built in.

$7.50 $3.00
View on Etsy
View on Etsy · $1.00