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.
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.
"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.
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.
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.
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.