October 17th is Spreadsheet Day! Get a $50 credit if you sign up for a paid plan between now and the 17th.

Employee Directory Template

FEATURES
Employee Directory
Overview

An Employee Directory is used to store information about staff in a single location for shared access throughout the organization, so no one at your company ever has to ask, "Does anyone know how I can reach that guy from Finance?" With an employee directory, they'll know.

This template can be used to track and manage a wide variety of information about employees such as: names, job titles, contact information, location, job skills, current projects, work hours, vacation schedule, personal interests, favorite pokemon, and more.

By
Spreadsheet.com
Spreadsheet.com
2
Worksheets
What is an employee directory template?

An employee directory template is a way for you to store all of the important information about your employees. This simple spreadsheet offers a way to easily record employee information in order to have an organized directory of everyone who works for you. If you're going to be paying them money, you probably want to know who they are and how to contact them.

Because it's a basic template, you can modify it and use it however you like. You can use it as a simple employee contact list to find everyone's email address, or a more comprehensive employee directory to look up everyone's department and location. Either way, it's a spreadsheet that stores all of your employee information to have at your fingertips.

Did you know?

"Employee Directory Template" is an anagram of "Pirate Temple Decoy Remotely", "Eye, Prattle Me Melodic Poetry", and "Yep, Partly Mediocre Omelette". So if you ever see your employees hoisting a jolly roger while rhyming about their breakfast, that's why. (It's also technically an anagram of "Employee Directory Met Plate", but that's a lot less interesting.)

Employee Directories are much more useful than Employee Indirectories, which tell you how to contact someone whose brother's best friend's cousin is on your payroll. That doesn't seem useful at all.

How does it work?

This basic employee directory template has two worksheets.

The Employees worksheet lists each employee's Name, along with their Title and Email address. Attach a Photo right in the spreadsheet so you can recognize your employees on sight or recall who you spoke to in the hall. Selectable columns for Department and Location make it easy to sort or filter when necessary—see the Department view in the drop-down in the upper left. Additional columns may be added at will for any other relevant information.

The Locations worksheet lists the location of each of your offices, with City, State, Country, and Postal Code, in addition to the Street Address. Images of each office can be attached in the appropriate column, to help when visiting other offices. And most importantly, a list of the Employees at each location lets you track who is where.

Employees and Locations are linked together using a Related row column, so when you view a location, you’ll see a list of all the employees that work there.

Why do I need an employee directory?

Once your company grows beyond the number of employees you can count on your fingers, it becomes a lot more difficult for your staff to keep a mental directory of who everyone is, what they do, and where they are. Luckily, they don't have to, because you can keep a digital directory instead, freeing up all of that mental energy for more useful work.

Maintaining an organized employee directory ensures that people in your organization can find the person they need to talk to and contact them directly. No more wondering who was that person with the great idea in yesterday's meeting, or how to contact the Sales department. Photos and departments are all in the directory.

Sorting and filtering by Department allows you to quickly address staffing gaps, or reach key employees in a crisis. And additional columns allow you to make notes on anything else relevant. If someone's buying a cake to have in the office for Michelle's birthday (and you should; she totally deserves it), it might be worth knowing that she has a gluten allergy.

Who uses employee directory templates?

Large Teams

If you can't list all of your employees from memory in under a minute, you probably should have an easily accessible directory. That's why employee contact sheets were invented, so you don't have to memorize 200 names, departments, and email addresses.

Remote Teams

If your staff is split among multiple locations, it's useful to have a directory telling you who is where. Especially comes in handy if you want to know who is going to be affected by that massive power outage in Austin.

More templates like this one
Team Objectives and Tasks
The Team Objectives and Tasks template helps you track tasks and their status for one or multiple teams and relate them to short-term and long-term objectives.
Team Objectives and Tasks
The Team Objectives and Tasks template helps you track tasks and their status for one or multiple teams and relate them to short-term and long-term objectives.
Simple Applicant Tracking
This Simple Applicant Tracking template serves as a database for candidates and their resumes, as well as details about each job opening. Candidates are linked with jobs and hiring managers can easily collaborate with recruiters and HR on candidate status, feedback, etc. Kanban views make it easy to manage moving candidates and job openings through the interview and job opening lifecycle.
Simple Applicant Tracking
This Simple Applicant Tracking template serves as a database for candidates and their resumes, as well as details about each job opening. Candidates are linked with jobs and hiring managers can easily collaborate with recruiters and HR on candidate status, feedback, etc. Kanban views make it easy to manage moving candidates and job openings through the interview and job opening lifecycle.
Meeting Agenda and Attendees
The Meeting Agenda and Attendees template makes it easy to define meeting goals, lay out a detailed agenda, outline action items, and keep track of attendees.
Meeting Agenda and Attendees
The Meeting Agenda and Attendees template makes it easy to define meeting goals, lay out a detailed agenda, outline action items, and keep track of attendees.
Employee Training Management
This spreadsheet is designed to help companies keep track of employee training courses and individual employee requirements. Within this workbook there are separate worksheets for tracking employee information, courses and certifications, scheduled class dates, and course feedback.
Employee Training Management
This spreadsheet is designed to help companies keep track of employee training courses and individual employee requirements. Within this workbook there are separate worksheets for tracking employee information, courses and certifications, scheduled class dates, and course feedback.
Employee Engagement Survey
The Employee Engagement Survey template lets you collect, aggregate, and analyze employee feedback.
Employee Engagement Survey
The Employee Engagement Survey template lets you collect, aggregate, and analyze employee feedback.
Printable Performance Review Form
The Printable Performance Review Form template makes it easy to record employee performance evaluations and distribute them when needed.
Printable Performance Review Form
The Printable Performance Review Form template makes it easy to record employee performance evaluations and distribute them when needed.