Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesHR & People ManagementEmployee & RecordsOrganizational Chart

SpreadsheetEmployee & RecordsFree

Organizational Chart

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

Colour

Organizational Chart

An org chart in a sheet: who reports to whom, levels, manager names looked up and span of control for every manager.

Headcount (incl. vacancies)
18
People managers
8
Average span of control
2.1
Direct reports per manager
Managers with narrow or wide spans
5
Broken reporting lines
0
Should be zero
Headcount by department
  • Sales5
  • Technology5
  • Operations4
  • Finance2
  • Executive1
  • People1
Direct reports by person
  • Helen Ward5
  • Jordan Lee3
  • Asha Patel3
  • Tom Reyes2
  • Diana Brooks1
  • Frank Novak1
  • Priya Raman1
  • Raj Mehta1

How to use it

  1. 1Give every person a unique Employee ID, and enter their manager’s ID in Reports to (leave it blank for the top of the chart).
  2. 2Check the Manager column: "Not found" means the Reports to ID does not match anyone.
  3. 3Review Span check for managers with very wide or very narrow teams.
  4. 4Export to CSV and import into your diagramming tool, using Employee ID and Reports to as the relationship fields.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

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.

Who it’s for

  • Maintaining a single source of truth for reporting lines
  • Re-organisations and span-of-control reviews
  • Importing into Visio, Lucidchart or HR system org charts

What’s included

  • Employees sheet: One row per person or open role.
  • By department sheet: Headcount, managers and span of control by department.
  • By level sheet: The number of entries for each level.

How to use it

  1. 1Give every person a unique Employee ID, and enter their manager’s ID in Reports to (leave it blank for the top of the chart).
  2. 2Check the Manager column: "Not found" means the Reports to ID does not match anyone.
  3. 3Review Span check for managers with very wide or very narrow teams.
  4. 4Export to CSV and import into your diagramming tool, using Employee ID and Reports to as the relationship fields.

Tips

  • Many organisations aim for 5–8 direct reports for people managers; very narrow spans add layers and cost, very wide ones limit coaching.
  • Include open roles as rows (with "Vacant" as the name) to show the planned structure.
  • Update the sheet as part of every joiner, mover and leaver process.

Questions

What is span of control?

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.

How do I turn this sheet into a visual org chart?

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.

How should I show dotted-line reporting?

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.

Related searchesorg chart template excelorganizational chart spreadsheetreporting structurespan of controlcompany hierarchy templateorg chart data

Details

Format
Spreadsheet
Category
Employee & Records
Sheets
3
Setup
20 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetEmployee & RecordsFree

Organizational Chart

An org chart in a sheet: who reports to whom, levels, manager names looked up and span of control for every manager.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Employee & Records
Sheets
3
Setup
20 min
Level
Beginner
Price
Free

Your copy is private to you.

More employee & records templates

View all
Employee Directory2 sheets

Headcount

10

Average tenure

3.6

Probation reviews due

2

ABCD
1NameJob titleDepartmentManager
2Amara OkaforChief ExecutiveLeadership
3Daniel BrooksHead of SalesSalesAmara Okafor
4Mei TanakaSenior EngineerEngineeringLucas Silva
5Lucas SilvaEngineering ManagerEngineeringAmara Okafor
Employees
SpreadsheetEmployee & Records

Employee Directory

Every employee with role, department, manager and contacts, plus tenure, work anniversaries, probation dates and headcount by department.

10 min setupPreview
Headcount Plan2 sheets

Current headcount

5

Planned hires

3

People cost this year

$776,573

ABCD
1RoleDepartmentStatusStart month
2Head of EngineeringEngineeringFilled1
3Senior DeveloperEngineeringFilled1
4DeveloperEngineeringOpen3
5Account ExecutiveSalesFilled1
Roles
SpreadsheetEmployee & Records

Headcount Plan

Current and planned roles by department with start dates, salary cost and the budget they use.

10 min setupPreview

Company Name Employee Handbook

Version: 1.0 Effective date: 1 January 2027 Owner: Head of People Applies to: All employees in country/state

Welcome

Welcome to Company Name. We are glad you are here.

This handbook explains how we work together: what you can expect from us, what we expect from you, and where to go when you have a question. Please read it during your first week and keep it handy. If anything is unclear

Name, Chief Executive Officer

1. About us

Company Name was founded in year to one-sentence mission. Today we employ number people across locations and serve customers / clients / communities.

DocumentEmployee & Records

Employee Handbook

A complete, plain-English staff handbook covering pay, leave, conduct, safety and leaving, ready to brand and adopt.

90 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ