
Company Magazine
Docs + Word7 pages
Free
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.
Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.
Start on the Directory tab: replace the sample rows with your own.
Keep the formula columns as they are; they fill in as you type.
Read the How to use tab for tips. For Excel, download the .xlsx file instead.
Yes. The Employee Directory template is free to download, copy and use for your own organisation.
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.
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.

Docs + Word7 pages
Free
Docs + Word21 pages
Free
Slides + PowerPoint16 slides
Free