Is there a free org chart template for Excel?

Yes. Every file on this page is free and comes as an Excel workbook (.xlsx) as well as a CSV. The blank one has twelve people in it so you can see how each column is used; replace them with yours and keep the header row.

How do I turn the template into a chart?

Fill in the rows, then import the file: open orgchart.live, start a chart, choose Import and drop the file in. The layout is automatic, and everything the importer decided for you — a manager matched by surname, two rows merged — is listed before it's applied. Building is free at any size. If you'd rather draw it inside Excel, the Excel guide covers SmartArt too.

Does the template work in Google Sheets?

Yes. Open the CSV or the Excel file in Sheets (File, Import), edit it there, and download it again as CSV or Excel when you want the chart. Sheets also has a built-in org chart with its own limits; the Google Sheets guide explains both routes.

Can I add my own columns?

Yes. Columns the importer doesn't recognise are ignored, so a Location or Start date column does no harm. An ID column and a Manager ID column are read, and are the most reliable way to say who reports to whom when names repeat.

Which format should I pick?

Excel if you'll edit it in Excel or share it with someone who will; CSV if it's going into a script, a Google Sheet, or an HR system's import. They hold the same rows, and the importer reads both.

Org chart templates

Most org chart templates are a drawing: boxes you drag around in Excel or PowerPoint until they line up. These are the other kind. Each one is a spreadsheet with one row per person, in Excel and CSV, and the chart is drawn from it, so a change to a row is a change to the chart. Fill in the blank one, or start from the industry closest to yours.

Download the Excel template Download as CSV

The blank template, drawn

Vantage Group · 12 rows · what the template turns into once it's imported. An assistant beside the chief executive, a dotted line from the brand director, a contractor, an intern, and an open role for a VP of Sales, so every column has an example to copy.

What's in the template

Eight columns. Only Name and Reports to are needed; the rest are there when you have them. Headers are matched loosely, so "Manager", "Reports To" and "reports_to" all work, and Spanish headers work too.

Column	Example	What it does
Name	Alexandra Pierce	One person per row. Leave it blank for an open role.
Title	Chief Executive Officer	Shown under the name on the card.
Department	Executive	Gets a colour; groups people in the side panel.
Reports to	Alexandra Pierce	The manager's name as it appears in the Name column. Blank for the top.
Email	alexandra@example.com	Optional. Tells two people with the same name apart.
Employment type	Employee, Contractor, Intern, Open	Contractors and interns get a badge; open roles draw as vacancies.
Dotted line	Alexandra Pierce	A second, non-reporting line, drawn dashed.
Staff	yes	Puts an assistant beside their manager instead of below.

Open roles are rows with a title and no name. Someone whose manager isn't in the file lands at the top rather than being dropped. The spreadsheet guide lists every header the importer accepts and what it fixes without asking.

Templates by structure

The four shapes nearly every company is some mix of, each an invented company with its structure explained on the examples page.

Structure	Company	Excel	CSV
Functional	Halcyon Foods · Grouped by what people do.	.xlsx	.csv
Divisional	Meridian Outdoor · Grouped by market, product or region.	.xlsx	.csv
Matrix	Northgate Robotics · Two lines of reporting: a function and a project.	.xlsx	.csv
Flat	Brightwater Studio · One layer. Everyone reports to the founder.	.xlsx	.csv

Templates by industry

Twenty-four industries drawn the way they really run, with the dotted lines nobody writes down. Each links to a page on how that kind of organisation is structured and where its charts go wrong.

Industry	Company	Excel	CSV
Manufacturing	Ironhurst Fabrication · Two shifts, and quality kept out of production's line.	.xlsx	.csv
Logistics	Keelhaven Freight · Dispatch runs the day; supervisors run the people.	.xlsx	.csv
Construction	Tarrow Brothers Construction · Office and field, meeting on every project.	.xlsx	.csv
Software startup	Nimbrook Software · Squads under a CTO; product managers on a dotted line.	.xlsx	.csv
Nonprofit	Saltmarsh Community Trust · The board on top, programmes beside the money.	.xlsx	.csv
Medical practice	Fennelbrook Medical Group · A clinical line and a business line, crossing at nursing.	.xlsx	.csv
School	Wrenfield Academy · Departments led by teachers who also manage.	.xlsx	.csv
Hotel	The Halloway · Six divisions around one general manager.	.xlsx	.csv
Marketing agency	Foxglove & Tern · Disciplines own people; pods own the work.	.xlsx	.csv
Security & facilities services	Greywatch Facility Services · Sites stacked under supervisors; a 24-hour control room.	.xlsx	.csv
Sales team	Brindle Systems · Regions for closers, a team for openers, RevOps beside them.	.xlsx	.csv
Accounting firm	Harlow & Finch · A partner pyramid, three service lines.	.xlsx	.csv
Law firm	Ashgrove Wilkes LLP · Practice groups, and the business side that runs the firm.	.xlsx	.csv
Church	Cedar Hollow Church · A board that governs, a pastor who leads, ministries below.	.xlsx	.csv
Restaurant	The Copper Vine · Front of house and back of house, meeting at the pass.	.xlsx	.csv
IT department	Calder Group — IT department · Run, build and secure, under one director.	.xlsx	.csv
HR department	Lindmere Group — People team · Partners, specialists and operations: the three legs.	.xlsx	.csv
Local government	City of Kessler Falls · Elected above appointed, and two officers who answer to the council.	.xlsx	.csv
Utility company	Ridgeway Power & Water · Field crews, a 24-hour control centre, and a regulator in the room.	.xlsx	.csv
Bank	Northlake Community Bank · Three lines of defence, drawn as lines.	.xlsx	.csv
Staffing agency	Brightpath Staffing · Sales desks, recruiting desks, and a back office that pays two thousand people.	.xlsx	.csv
Hospital	Mercy Ridge Community Hospital · Two hierarchies that meet at the bedside.	.xlsx	.csv
Retail chain	Larkspur Home & Garden · Head office, the field, and a store drawn once.	.xlsx	.csv
Small business	Harlow Plumbing & Heating · One owner, two managers, and the jobs the owner still does.	.xlsx	.csv

Templates for a job

The charts from the guides: each built to show what a particular job looks like when it's done properly.

Chart	Guide	Excel	CSV
An executive's team	Read the guide	.xlsx	.csv
A reorg, proposed structure	Read the guide	.xlsx	.csv
A merger, Day 1	Read the guide	.xlsx	.csv
A client's current state	Read the guide	.xlsx	.csv

The reorg and merger files carry two extra columns, ID and Manager ID, because both have an open role with people reporting to it, and an open role has no name for its reports to point at.

Why a template should be data

A drawing is right on the day it's made. Then someone joins, a manager changes, a team splits, and the drawing is a job: open the file, find the box, drag six others to make room, fix the lines. After the third change nobody has the twenty minutes, and the chart quietly becomes a picture of the company as it was.

A list doesn't have that problem. One row per person, one column for who they report to, and the drawing is somebody else's job — the layout engine's. Change the row and the chart changes. It's also the shape every HR system exports, so the template is what you'd get from the system anyway, with the columns named plainly.

Using it in Excel, Sheets or PowerPoint

The Excel file opens in Excel, Numbers and LibreOffice; the CSV opens anywhere, including Google Sheets. Edit it where you like and import it when you want the chart. If the deliverable has to be a slide, export the chart to PowerPoint, where every card arrives as an editable shape.

If you'd rather stay inside the tool you have, the guides for Excel, Google Sheets and Visio give the honest steps for each, and where each one stops.

Questions people ask

Is there a free org chart template for Excel?: Yes. Every file on this page is free and comes as an Excel workbook (.xlsx) as well as a CSV. The blank one has twelve people in it so you can see how each column is used; replace them with yours and keep the header row.
How do I turn the template into a chart?: Fill in the rows, then import the file: open orgchart.live, start a chart, choose Import and drop the file in. The layout is automatic, and everything the importer decided for you — a manager matched by surname, two rows merged — is listed before it's applied. Building is free at any size. If you'd rather draw it inside Excel, the Excel guide covers SmartArt too.
Does the template work in Google Sheets?: Yes. Open the CSV or the Excel file in Sheets (File, Import), edit it there, and download it again as CSV or Excel when you want the chart. Sheets also has a built-in org chart with its own limits; the Google Sheets guide explains both routes.
Can I add my own columns?: Yes. Columns the importer doesn't recognise are ignored, so a Location or Start date column does no harm. An ID column and a Manager ID column are read, and are the most reliable way to say who reports to whom when names repeat.
Which format should I pick?: Excel if you'll edit it in Excel or share it with someone who will; CSV if it's going into a script, a Google Sheet, or an HR system's import. They hold the same rows, and the importer reads both.

A template that stays a template

Because the chart is drawn from the rows, the spreadsheet never goes stale the way a drawing does: change a row, re-import, and the chart is right again. Building is free at any size; you pay only for a clean export.

Start a chart, free Every column the importer reads