Employee Directory Template: Fields to Keep and Skip

A new hire needs someone in accounts payable. The company directory is a spreadsheet with 40 columns, half of them blank, and the name under “AP” belongs to someone who left in the spring. That’s the usual way an employee directory template fails: too many fields, so nobody keeps it up.

The template below has twelve fields. Each one answers a question colleagues actually ask. Who is this? What do they do? Where are they, and how do I reach them? Everything else goes in your HR system, where access is controlled.

You’ll get the copy-ready table, the fields to leave out and why, a shorter staff directory template for schools and shift teams, and the Excel setup that keeps it usable.

The employee directory template (copy this table)

Paste the header row into a spreadsheet and you have a working directory. The “Who fills it in” column matters as much as the field itself, because a field with no owner is the first one to go wrong.

Two choices here are deliberate. The manager column holds an email address, not a name, because two people called Chris Taylor will eventually break a name-based lookup. And the photo is the one field worth chasing. A directory without faces is a phone book. The small-business employee directory guide covers what changes as a team grows.

Nine fields to leave out

Every extra column is personal data you now have to protect and keep accurate. The UK regulator puts it plainly: under the ICO data minimisation principle, personal data must be adequate, relevant, and limited to what is necessary for the purpose. A directory’s purpose is finding and contacting colleagues. Test each field against that.

These fail the test:

• Home address. Nobody needs it to reach a colleague at work.
• Personal email. Work email does the job; personal addresses leak into forwarding chains.
• Date of birth. It’s an identity-verification answer, so don’t publish it to the whole company.
• Salary or pay grade. Belongs in payroll, behind payroll’s access controls.
• Emergency contacts. HR needs these; the sales team doesn’t.
• National insurance or Social Security number. Never in a shared spreadsheet.
• Employee ID. Skip it unless another system looks people up by it.
• Hobbies and fun facts. Charming on day one, wrong by month six, and nobody owns updating them.
• A free-text “skills” column. It turns into a list of tools people used two jobs ago.

This post describes good practice, not legal advice. GDPR and CCPA compliance depends on your specific data-processing context. Consult counsel before relying on these descriptions for compliance decisions.

A staff directory template for schools and shift teams

Not every team sits at a desk with an extension. For a school, a plant floor or a retail site, a shorter staff directory template works better: preferred name, photo, role, area (classroom, line or department), work phone or radio channel, and manager. Six columns.

Photos matter even more here. A supply teacher or a new shift lead has to recognise people in a corridor, not on a screen. If your reception team also signs visitors in, the same staff list tells them who to call when someone arrives, which is why a visitor sign-in sheet template usually has a “host” column that should match this list exactly.

Employee directory template in Excel or Google Sheets

The Excel version of an employee directory template is only as good as five settings. Get these right before anyone starts typing.

1. Format it as a table. In Excel, select the data and use Home > Format as Table. You get filter buttons on every column, and new rows inherit the formatting. Google Sheets gets close with filter views.
2. Freeze the header row so column names stay visible as the list grows.
3. Use dropdowns for Department and Location. Data validation stops “Sales”, “sales” and “Sales team” becoming three departments in the filter.
4. Add a “Last checked” date column. Sort by it once a month and chase the oldest rows.
5. Give one person edit rights. Everyone else gets view access. A directory twenty people can edit has twenty versions of the truth.

One warning. Hiding a column doesn’t protect it. Anyone who can open the file can usually unhide it or download a copy, so sensitive data stays out of the sheet entirely rather than tucked out of sight.

Who keeps it current

Templates don’t go stale. Companies change underneath them. The median worker had been with their current employer for 4.1 years in January 2026, and just 3.0 years for workers aged 25 to 34, according to the Bureau of Labor Statistics employee tenure release. Shorter tenures mean more rows to add and remove every year.

Monthly churn makes the point faster. Total separations ran at 3.2 percent of employment in August 2026, per the BLS Job Openings and Labor Turnover Survey. At that rate a 100-person company loses about three people a month, and each one leaves a row behind unless someone deletes it.

So split ownership by field, the way the template does. HR changes title, department, manager and location as part of the same checklist that handles joiners and leavers. Employees own their photo, mobile, time zone and pronouns. The list also feeds other things: an employee check-in app is only as accurate as the staff list behind it, and so is the roll call in your emergency evacuation plan.

FAQ

What should an employee directory include?

Preferred name, photo, job title, department, manager, location, time zone, work email and work phone cover most lookups. Add an opt-in mobile number, employment type and optional pronouns. Anything a colleague doesn’t need to find or contact someone belongs in your HR system instead.

Should personal mobile numbers go in a company directory?

Only if the employee chooses to add one. Make the column opt-in and leave it blank by default. People who are on call or work away from a desk often want it listed; others don’t.

How often should you update an employee directory?

Change it the day someone joins, leaves, moves team or changes manager, and tie those edits to your onboarding and offboarding checklists. Then do a monthly sweep for rows that haven’t been checked in 90 days.

Is an employee directory the same as an org chart?

No. A directory answers who someone is and how to reach them. An org chart shows the reporting lines between people. If your directory has a manager column, you already hold the data an org chart is built from, which is how most org chart software works too.

When the spreadsheet stops keeping up

A spreadsheet is the right place to start. It stops working when people search on their phones, when photos never get added, or when the person who owned the file leaves.

InstaCheckin People, our employee directory and org chart app, is coming soon. It’s planned as a searchable photo directory with location and department filters (coming soon), with employees updating their own photo, phone, pronouns and bio (coming soon), and sync with Google Workspace and Microsoft Entra ID is coming soon as well. It will also share one employee list with InstaCheckin Visitor (coming soon), so the people in your directory are the same hosts your lobby iPad notifies. Read how InstaCheckin People (coming soon) compares with other employee directory software, then join the waitlist and we’ll email you when it opens.