Skip to content
The title slide and first slides of the Employee Directory template

Employee Directory

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
3
Style
Minimal
Difficulty
Beginner
Updated
November 6, 2026

Every slide (3)

Overview

The Employee Directory is a single list of everyone on your team, with department, job title, manager, location and start date. Years with us is worked out from the start date, so it stays current without editing. The Dashboard shows headcount, average length of service and charts of headcount by department and by location.

The file comes with sample data for twelve people, so you can see how it works. Make a copy, replace the sample rows with your own staff, and the counts, averages and charts update on their own.

Useful for

  • Finding who to contact in each department
  • Showing a new starter who their manager is and where the team sits
  • Reporting headcount by department or location to leadership

What's included

  • 3 tabs: Dashboard, Directory, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Directory: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Directory tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

Is this Employee Directory template free?

Yes. The Employee Directory template is free to download, copy and use for your own organisation.

Does it work in Excel?

Yes. Download the .xlsx file and open it in Microsoft Excel. The formulas, dropdowns, filters and charts work in Excel as well as in Google Sheets.

Should I store personal details in the directory?

Keep the directory to work details such as name, job title, manager, location and start date. Store personal data such as home address, bank details or health records in your HR system, with proper access controls.

  • #employee-records
  • #employee-directory
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Human resources

All human resources templates
Get this template

Preparing your template…