Org Chart Template Excel Free: Find and Use the Right One

Charts & pivot tables · Updated November 20, 2026

Yes. You can get a free org chart template for Excel from Microsoft’s template resources or create a chart in Excel with Insert > SmartArt > Hierarchy. A downloadable template is quickest when you want a ready-made layout; SmartArt is useful when you want to build and format the hierarchy directly in a workbook.

Where to Find a Free Excel Org Chart Template

Start with Microsoft Create or the template options available in Excel. Search for terms such as organization chart, org chart, or hierarchy. The exact templates shown can change over time and may depend on your version of Excel or how you access Microsoft’s template catalog. Check that the file is actually an Excel workbook before downloading it; a preview image or a template designed for PowerPoint may not be editable in Excel in the way you expect.

There are also third-party sites that offer free spreadsheet templates. Before using one, check the file type, the author or publisher, and any license or usage terms. A template described as free to download may still have restrictions on redistribution or commercial use. Avoid downloading files from unfamiliar sources, especially if the site asks you to enable macros for a basic organization chart. A simple chart normally does not need macro code.

When you open a downloaded workbook, inspect its sheets before entering employee information. Some templates include a separate data table, sample names, formulas, or instructions; others are only preformatted shapes. Remove sample information, check for hidden sheets or unexpected content, and save a working copy with a clear name. These checks help you understand how the template works before it contains real organizational data.

Two Ways to Make an Org Chart in Excel

Excel offers two practical approaches, and they solve slightly different problems. SmartArt creates a visual hierarchy from a text outline. It is a good choice for a compact chart that you want to edit and format within Excel. A downloadable template may instead provide a prebuilt diagram, a table for entering names and reporting relationships, or both. Read its instructions because not all templates update the diagram automatically when you change a table.

A simple table is another option when the main purpose is sorting, filtering, or checking reporting information rather than displaying a polished diagram. For example, a table with columns for employee, job title, manager, department, and location is easier to filter than a crowded chart. You can keep that table as the source of truth and maintain a separate visual chart for presentations. Excel does not automatically turn every ordinary employee list into a fully connected org chart just because the list has manager names.

SmartArt is available in desktop Excel for Microsoft 365 on Windows. Its layout and editing controls can differ across Excel for Mac and Excel for the web, so use desktop Excel if you need the most predictable chart editing experience. A file made with SmartArt may also look different when opened in another spreadsheet program.

Build a Chart with SmartArt

To create a chart from scratch in Excel for Microsoft 365 on Windows, choose Insert > SmartArt, select Hierarchy, choose an organization-chart layout, and click OK. Select the chart to open the contextual SmartArt Design and Format tabs. You can enter labels in the Text Pane or click a shape and type directly into it. Each entry in the text outline corresponds to a shape in the diagram.

  1. Enter the top position first, such as Executive Director or General Manager.
  2. Enter direct reports underneath it. Use Tab in the Text Pane to indent an entry into a subordinate level, and Shift+Tab to move it back up a level.
  3. Use SmartArt Design > Add Shape to insert a position. The available commands include options for adding a shape before, after, above, or below the selected one; the command names can depend on the selected layout.
  4. Choose a suitable layout from the Hierarchy options, then use SmartArt Design styles or the Format tab to adjust the appearance.

Think of the diagram as a map of reporting relationships, not a complete directory of every fact about a person. Short labels usually fit best: name on one line and title on another, for example. If you need department, email, location, or employment status, keep those details in a companion table instead of shrinking every shape until the chart is hard to read.

On Mac, the SmartArt feature is also available in Excel, but ribbon placement and some editing controls can vary by release. Excel for the web may offer a different set of editing capabilities than the desktop app. If a control named in a Windows instruction is not present, open the workbook in the current desktop version rather than assuming the file is damaged.

Prepare the Information Before You Start

A little planning prevents most chart rework. Decide what the chart is meant to show: the full organization, one department, a project team, or a particular reporting chain. Then agree on what counts as a reporting relationship. A solid-line manager relationship is usually the main hierarchy; dotted-line collaboration, temporary assignments, and project leadership can make a chart confusing if they are all shown with identical connectors.

Before typing names into shapes, verify the source information with an appropriate internal directory or the people responsible for the organization. Confirm spelling, current job titles, manager assignments, and which positions should appear. If you are charting vacancies, decide whether to label an open role as vacant, leave it out, or show it in a distinct style. Consistency matters more than a particular convention.

For a larger organization, maintain a structured source list with one person or position per row. Useful fields include a unique employee or position identifier, display name, title, manager identifier, department, and effective date. A unique identifier helps distinguish two people with the same name. Even if you use a visual template, a clean source table makes review and future updates easier.

How to Choose the Right Template

Choose based on the number of reporting levels and the way people will use the chart, not simply on the template’s appearance. A small team may fit on one page with names and titles. A department with many branches may be clearer as one overview chart plus separate charts for each team. A single diagram that tries to show every employee can become too wide, too small, or difficult to print.

  • Layout: Check whether the template supports the hierarchy depth and branch structure you need.
  • Editing: Determine whether labels are ordinary cells, text boxes, SmartArt shapes, or linked to a data table. This affects how quickly you can update it.
  • Readability: Look for adequate text size, contrast, and space for long titles. A chart that looks clear on screen may be unreadable when printed.
  • Compatibility: Check that it opens in your intended Excel version and does not rely on add-ins or macros you cannot use.
  • Purpose: Consider whether the chart is for internal reference, a presentation, onboarding, or a printed directory. Each use may need a different level of detail.

For example, a 12-person team with three management levels can often use a single SmartArt diagram. A 200-person business might be better served by a high-level chart with department leads and separate team-level charts. The second approach gives readers a useful overview without forcing every name into tiny shapes.

Common Problems and Practical Fixes

One frequent problem is text that overflows or becomes too small. Shorten labels, widen the chart, split the chart into smaller units, or move nonessential details into a table. Changing font size alone can solve a small fit issue, but it is not a good fix if readers can no longer comfortably read the names.

Another problem is a chart that stops matching the current organization. A visual diagram is a snapshot, and changing a manager in a source list may not change a manually arranged set of shapes. Decide who owns updates and when the chart should be reviewed. For example, a department might check it after staffing changes and perform a broader review on a regular schedule. Add an as-of date so readers know when the information was last confirmed.

Connectors can also become confusing when someone tries to represent several kinds of relationship in one hierarchy. Keep the main reporting structure visually consistent. If dotted-line assignments matter, explain the line styles in a small legend or show those relationships in a separate table. Do not rely on color alone to distinguish meaning, since the chart may be printed in grayscale or viewed by someone with color-vision differences.

Finally, avoid treating decorative formatting as evidence that the underlying information is correct. A polished chart can still contain an incorrect manager, a departed employee, or a missing role. Review the reporting relationships and date as carefully as the design.

Sharing, Privacy, and File Safety

An org chart can contain personal and operational information, including names, job titles, team structures, and sometimes contact details. Include only what the audience needs. A public-facing chart may need fewer details than an internal staff directory, and a chart for a specific project may not need to expose the whole company structure.

Store and share the workbook through an approved location with access controls appropriate to its contents. Before sending a copy outside the intended group, check for hidden worksheets, comments, old sample data, and extra details in the workbook. If you export or print the chart, check page breaks and margins so that names or branches are not cut off. Save a separate distribution copy if you need to remove sensitive fields while preserving the internal source workbook.

For downloaded templates, use ordinary file-safety care: obtain files from a source you trust, keep Office security protections in place, and do not enable macros simply because a template asks. A basic diagram can be created with standard Excel features. If a workbook behaves unexpectedly, do not enter confidential information until you understand what its sheets and controls do.

Excel Templates Compared with Other Options

Excel is convenient when the chart belongs alongside schedules, headcount lists, or other spreadsheet information, or when colleagues already work in Excel. It is not always the best tool for a very large or frequently changing hierarchy. SmartArt is easy to arrange, but a manually maintained diagram can take time to update and may not provide specialized org-chart data management.

PowerPoint can be a better fit when the primary goal is a presentation slide. Dedicated diagramming applications may provide more controls for large charts, cross-functional links, or data-driven updates, though access and licensing depend on the product and organization. A shared employee directory or HR system may be the authoritative source for reporting relationships; the spreadsheet chart can then be treated as a presentation copy rather than the official record.

There is no universal rule that one format is best. Use Excel when the chart is modest in size, familiar to its editors, and easy to maintain there. Consider another tool when the chart becomes difficult to read, the reporting data changes often, or multiple relationship types must be shown clearly.

Frequently Asked Questions

Does Excel have a free org chart template?
Excel may offer organization-chart templates through Microsoft’s template resources, and you can create a hierarchy with SmartArt without downloading a separate template. Availability of specific downloadable designs can change, so search the current template catalog and confirm the file format.

How do I make an org chart in Excel without a template?
In desktop Excel, select Insert > SmartArt > Hierarchy, choose an organization-chart layout, and add names and positions through the Text Pane or shapes. Use indentation in the Text Pane to show which positions report to others.

Can Excel automatically create an org chart from an employee list?
A plain employee table does not automatically become a connected org chart just because it contains names and managers. Some specialized templates or other Microsoft tools may support data-based diagrams, but check their requirements and compatibility rather than assuming a generic Excel file will do it.

Can I edit an Excel org chart in the browser?
Excel for the web can handle many workbook tasks, but SmartArt editing features may not match desktop Excel in every release. If you cannot make a needed change in the browser, open the workbook in the desktop app and confirm the result after saving.

What is the best way to keep an org chart current?
Assign an owner, use a reliable source for reporting relationships, and put an as-of date on the chart. Review changes after relevant staffing updates, and make clear whether the chart shows formal reporting lines or other working relationships as well.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.