Headcount
10
Average tenure
3.6
Probation reviews due
2
Employee Directory
Every employee with role, department, manager and contacts, plus tenure, work anniversaries, probation dates and headcount by department.
SpreadsheetEmployee & RecordsFree
An org chart in a sheet: who reports to whom, levels, manager names looked up and span of control for every manager.
Shown with sample data
An org chart in a sheet: who reports to whom, levels, manager names looked up and span of control for every manager.
Keep your reporting structure accurate in a format you can sort, filter and import into org chart tools. Give every employee an ID and their manager’s ID; the sheet looks up manager names, counts direct reports, checks span of control, flags broken reporting lines and summarises headcount, managers and average span by department and level.
The number of direct reports a manager has. It affects how many management layers you need and how much time each manager can spend with each person.
Export it as CSV. Tools such as Visio, Lucidchart, draw.io and most HR systems can build a chart automatically from an employee ID and a manager ID column.
Keep Reports to for the solid line and add the dotted-line manager in Notes; most charting tools handle only one primary manager per person.
Download a copy
Downloads need a free account.