Turn Excel Data Into an Org Chart: Steps and Options

Charts & pivot tables · Updated November 20, 2026

Yes. You can use Excel for Microsoft 365 to turn employee information into an org chart by arranging it as a reporting hierarchy, then building a chart with Insert > SmartArt > Hierarchy > Organization Chart. Excel does not automatically convert a regular employee table into a live, data-linked org chart, so expect to arrange the hierarchy in SmartArt—or use a tool such as Visio when the chart is large or needs frequent updates.

What Excel Can—and Cannot—Do

An org chart shows who reports to whom. A typical Excel roster has one row per employee, with columns for a name, job title and manager. That is a flat list; a chart is a tree of connected positions. To create the tree, the reporting relationships in the roster must be clear and each employee must be placed at the right level.

Excel includes organization-chart layouts as part of SmartArt. They provide a quick way to make a visual hierarchy directly in a workbook. You can add, remove and rearrange boxes, and edit their text. However, SmartArt does not continuously read the rows of an ordinary Excel table. Changing a manager’s name in the source list will not automatically move that person’s box in the chart.

This distinction matters when choosing a method. For a small team or a chart that will be used once, SmartArt is often sufficient. For a large organization, recurring updates, or a chart that must be generated from employee records, consider Visio or a dedicated org-chart application that supports importing spreadsheet data. Availability and features depend on the product and license.

Prepare the Employee Data

Before drawing anything, make the source list consistent. Use one row per person and one column per attribute. A simple structure might be Employee ID, Name, Job Title, Manager ID, and Department. Employee ID is useful because two people can share a name, while an ID can distinguish them. If you do not have IDs, use a combination of name and another unique field, but take care when matching managers.

For example, a small roster could describe Maya Chen as the company head with no manager, Luis Romero as a manager reporting to Maya, and Asha Patel as an analyst reporting to Luis. The chart should place Maya at the top, Luis below her, and Asha below Luis. The source table can be in any row order; the manager relationship, not the row’s position, determines the hierarchy.

Check these details before building the chart:

  • Choose one top-level person or position. The top person normally has a blank manager field or a clearly identified parent such as the board.
  • Use the same spelling and identifier for a manager wherever that manager appears in the roster.
  • Confirm that every employee, except the top-level person, has the intended manager.
  • Look for duplicate people, blank names, misspelled titles and former employees who should no longer appear.
  • Decide whether the chart represents formal reporting lines, departments, locations, or another structure. A chart becomes confusing if it mixes these purposes without explanation.

Format the source as an Excel table if it will be maintained: select a cell in the data and choose Insert > Table, then confirm that the table has headers. A table makes the roster easier to filter and extend, but it does not itself create or refresh the org chart.

Build a Small Org Chart with SmartArt

For a compact hierarchy, create a SmartArt organization chart and enter each person in the appropriate level. In Excel for Microsoft 365 on Windows:

  1. Choose a blank area of the worksheet, then select Insert > SmartArt.
  2. In the SmartArt gallery, choose Hierarchy, select Organization Chart, and select OK.
  3. Open the SmartArt Text Pane if it is not visible. One way is to select the SmartArt and use SmartArt Design > Create Graphic > Text Pane.
  4. Enter the top person first. Add a new line for another person, then use Tab in the text pane to make an entry a subordinate of the preceding level. Use Shift+Tab to promote an entry one level. The exact layout is controlled by the outline levels, so check the chart as you edit.
  5. Enter names and, if useful, titles. You can put a title on a separate line in a box, or include it after the name in a consistent format.

For the example roster, enter Maya at the top level, Luis one level below, and Asha one level below Luis. If Maya also has another direct report, that employee should be at the same level as Luis, not nested beneath Luis. This is a common point of confusion: the order of entries in the text pane matters because each level is interpreted relative to the outline around it.

You can also add boxes using the SmartArt Design controls, including Add Shape, and then set their positions with Promote, Demote, Move Up or Move Down where available. The text-pane outline is often easier to reason about than drawing boxes individually, particularly when several people report to the same manager.

Style, Label and Check the Chart

Once the hierarchy is correct, use the SmartArt Design and Format tabs to change the appearance. SmartArt styles and color options can improve readability, but restrained formatting usually works best: use consistent colors for the same type of role or department, and avoid relying on color alone to communicate meaning. Names and reporting lines should remain understandable when printed in grayscale or viewed by someone with limited color vision.

Keep labels short enough to fit inside the boxes. A name and job title are usually more useful than adding phone numbers, locations, email addresses and other details to every box. If readers need those details, keep them in the roster or provide a separate directory. For a wide organization, consider splitting the chart by department or creating separate views for different levels rather than shrinking everything until the text is unreadable.

Before sharing, compare every box and connection with the source roster. Check the top-level position, direct reports, vacant roles, and any employees who have moved teams. Also decide whether the chart should show people or positions. A position-based chart can preserve a vacancy as an empty role; a people-based chart may omit it. Label the distinction if readers might otherwise mistake an unfilled box for a data error.

What to Do with a Large or Changing Roster

SmartArt is practical for a modest chart, but manual entry becomes tedious when there are many employees or reporting lines change often. The chart and roster are separate objects, so a process that depends on editing both can lead to mismatches. Keep one source of truth, record who is responsible for updates, and set a review date if the chart is used for operational decisions.

For a larger hierarchy, look at Microsoft Visio’s organization-chart tools or another diagramming product that can create a chart from spreadsheet data. Depending on the Visio edition and setup, its organization-chart workflow can use data stored in an Excel file. Review the product’s current import requirements before preparing the workbook: it may expect specific fields for employee identity, position and reporting relationship. Importing does not remove the need to clean the source data or verify the resulting diagram.

Another option is to create the diagram in a system that already manages employee records, if your organization has one and it supports org-chart views. This can reduce duplicate maintenance, but access controls, update timing and the system’s definition of a reporting relationship still matter. A chart exported from any source should be checked before distribution, especially if people rely on it to find decision-makers or escalation contacts.

Common Problems and How to Avoid Them

  • Every person appears at the same level. The text pane may contain entries at one outline level. Demote direct reports beneath their manager, then confirm that sibling employees remain at the same level.
  • The manager is missing. A manager named in the roster may not have a corresponding employee or position entry. Add the missing role if appropriate, or correct the manager reference.
  • Several people seem to be at the top. A traditional org chart is a single-root hierarchy. If the organization has multiple independent reporting trees, create separate charts or make the shared governing structure explicit.
  • The chart is too crowded. Reduce optional text, split the chart into sections, or use a tool designed for larger diagrams. Enlarging the worksheet alone may not make a chart legible when printed or viewed on a small screen.
  • Changes in the roster do not change the chart. This is expected with a manually built SmartArt diagram. Update the chart separately, or switch to a workflow that imports or synchronizes data and verify how refreshes are handled.
  • A person reports to more than one manager. A basic hierarchy normally gives each box one parent. If the organization uses matrix reporting, decide which relationship the chart is meant to show and explain other reporting lines separately.

SmartArt, Visio or a Spreadsheet-Based Workflow?

Choose based on the chart’s size, update frequency and audience—not just on which tool is already open. SmartArt is a convenient choice for a small, mostly static diagram that needs to remain in an Excel workbook. It is easy to edit visually, but manually maintaining it beside a roster is a weakness.

Visio or a specialized charting tool is worth considering when the hierarchy is extensive, needs repeated regeneration, or requires diagram features beyond a basic reporting tree. Check licensing, import limits, refresh behavior and export options before committing. A tool that can import a workbook may still need the spreadsheet reorganized to match its expected columns.

A plain Excel roster is preferable when the main need is sorting, filtering or searching employee details rather than seeing reporting lines. A chart is not automatically a better representation: a long list of boxes can be harder to navigate than a well-labeled table. Some organizations use both, with the roster as the authoritative data and a chart as a readable summary.

Frequently Asked Questions

Can Excel automatically make an org chart from a table?
Not from a standard employee table using SmartArt alone. SmartArt provides an organization-chart layout, but you must arrange the hierarchy in the diagram. A separate tool or add-in may support importing spreadsheet rows, subject to its requirements.

How should I show who reports to whom in Excel?
Use a clear manager field in the roster, ideally with a unique Manager ID that matches an Employee ID. The top-level person can have a blank manager field. This makes relationships easier to validate before you create the visual chart.

Will my SmartArt org chart update when I change the Excel table?
No. A SmartArt chart is not automatically linked row by row to a regular Excel table. If names or reporting lines change, update the SmartArt too, or use a data-import workflow designed to rebuild or refresh the diagram.

Can I include job titles in an Excel org chart?
Yes. Add titles as a second line in each SmartArt box or include them in a consistent label alongside each name. Keep labels concise, since long titles can make boxes crowded and the overall chart difficult to read.

Can one employee report to two managers in a basic org chart?
A conventional hierarchy gives each box one parent, so it does not clearly represent two equal reporting lines. Choose the primary relationship for that chart and document the secondary relationship separately, or use a diagramming method intended for matrix structures.

Keep the Chart Useful

An org chart is only as dependable as its reporting data and update routine. Start with a clean roster, build the hierarchy carefully, and check the finished diagram against the source. Use SmartArt for a straightforward chart that can be maintained manually; move to a data-driven diagramming workflow when size or frequent changes make that approach impractical. Keep the roster as the definitive record unless a dedicated system is explicitly responsible for maintaining the relationships.

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.