Free Employee Directory Template (Excel and Google Sheets)

When your team grows past a handful of people, “who do I call in Finance?” becomes a daily question. A simple employee directory answers it: names, roles, departments, phone numbers and emails in one place that everyone can search.

Download the free employee directory template (.xlsx)

Employee Directory template preview with sample data
Preview of the Employee Directory template with sample data. Download it above and replace the examples with your own.

What is inside

Feature How it works
Directory sheet Room for 200 employees: ID, name, job title, department, mobile, email, extension, location, start date
Drop-downs Department, location and status, editable on the Lists sheet
Years of service Calculates automatically from the start date
Status colors “On leave” turns amber and “Left” turns grey, so you keep history without deleting rows
Summary sheet Active and on-leave headcount for each department
Filters and frozen header Find anyone in seconds, even with a long list

How to use it

  1. Download the file and open the Lists sheet. Change the departments and locations to match your company.
  2. Replace the sample employees on the Directory sheet with your team.
  3. Pick a status for each person: Active, On leave or Left.
  4. Use the filter arrows to show one department or location.
  5. Check the Summary sheet for headcount by department.

Use it in Google Sheets

Open Google Drive → New → File upload, then open the file with Google Sheets. Drop-downs, formulas and colors keep working. To let the team view it without editing, share it as Viewer. See how to share files in Google Drive safely.

Tips for a useful directory

  • Keep it to work contact details. Don’t add salaries, ID numbers or home addresses to a file many people can see.
  • Name one owner (HR or the office manager) who updates it when people join or leave.
  • Add it to onboarding: new joiners get added on day 1. See our onboarding checklist template.
  • Link it from Teams or your intranet so people always open the latest version.

Who uses a company directory template?

  • Small businesses that need one up-to-date list of who does what, with phone numbers and extensions.
  • HR and admin teams that want headcount per department without counting by hand (the Summary sheet does it).
  • Receptionists who need to find the right person and extension in seconds using the filters.
  • Managers onboarding new staff: add the person on day one alongside the onboarding checklist.

Keep personal data safe

A staff directory holds personal details, so share it carefully. Share work contact details widely, but keep private information such as home addresses or ID numbers out of the shared file. In Google Sheets, give edit access only to HR, and view access to everyone else.

FAQ

Is this employee directory template free?
Yes, for personal and business use. Please do not resell it.

How many employees can it hold?
The Directory sheet has room for 200 employees. Insert rows inside the table if you need more.

Does it work in Google Sheets?
Yes. Upload it to Google Drive and open it with Google Sheets. Drop-downs, colours and the summary keep working.

Should I delete employees who leave?
No. Set their status to “Left”. The row turns grey and drops out of the active headcount, so you keep the history.

Related templates

Leave a Comment