Convert an Excel List to an Org Chart in Microsoft 365

Charts & pivot tables · Updated November 19, 2026

To convert an Excel list to an org chart, arrange the people in a reporting hierarchy, then use Insert > SmartArt > Hierarchy > Organization Chart and enter the hierarchy in SmartArt’s text pane. Excel does not automatically turn an ordinary employee-and-manager table into a linked org chart with one click, so you must either build the hierarchy in SmartArt or use a tool that can map manager relationships from your data.

What your Excel list needs

A useful org chart shows who reports to whom, not just a set of names. The simplest source table has one row per person and separate columns for the person’s name, job title, and manager. For example:

  • Name: Priya Shah; Title: Director; Manager: blank
  • Name: Luis Romero; Title: Sales Manager; Manager: Priya Shah
  • Name: Mei Chen; Title: Account Executive; Manager: Luis Romero

The blank manager identifies the top person in this example. In a larger organization, there may be multiple top-level people or a designated position above them that is not included in the file. Decide how to represent that before you draw the chart. SmartArt needs a nested outline, so a manager column alone is not enough: the information must be translated into parent-and-child levels.

Include the fields that will help readers understand the structure, but avoid adding sensitive details such as personal phone numbers or compensation unless they are genuinely needed and the chart will be appropriately protected. Department, location, or job title may be useful; employee ID is usually better kept in the source table than displayed in every shape.

Choose the right conversion method

For a small team or a chart that changes infrequently, SmartArt is usually the quickest Excel-only option. You create the chart and arrange people manually in an outline. It is convenient for a presentation or a simple reference, but the chart is not automatically linked to the manager column in your table. Changing the source list later does not reliably update the reporting structure in SmartArt.

For a large organization or a chart that must be refreshed regularly, use a diagramming tool with an organizational-chart import feature, such as Microsoft Visio where that feature is available in your edition. Such tools can use fields like employee name and reports-to name to build relationships. Check the current product edition and licensing before planning around an import wizard; availability and exact steps can vary. You can also use a suitable third-party org-chart tool, subject to your organization’s privacy and security rules.

Choose based on the job the chart must do: a one-time visual, a reusable reporting document, or a maintained representation of live personnel data. A neat-looking SmartArt diagram is not the same thing as a chart that stays synchronized with a table.

Prepare and check the reporting data

Before building anything, make the source list consistent. Use one row per person, a single spelling for each name, and a consistent title format. Check that every manager value identifies a person in the list, except for intentionally blank top-level entries. If two employees share a name, use a unique identifier in your working data to distinguish them, even if you choose not to display that identifier in the final chart.

  • Confirm that each person has the correct direct manager. An org chart normally shows direct reporting lines, not every higher-level manager.
  • Look for missing managers, misspelled names, duplicate records, and employees who appear to report to themselves.
  • Check for loops, such as A reporting to B while B reports to A. A reporting hierarchy must have a valid top level and no circular chain.
  • Decide how to handle vacancies, contractors, temporary roles, and shared or dotted-line reporting before they become shape-layout problems.

Sorting the rows alphabetically can make a table easier to scan, but it does not create a hierarchy. Likewise, placing a manager above a person in the worksheet does not, by itself, establish a reporting relationship. The parent-child levels in the outline are what determine the SmartArt structure.

Build an org chart with SmartArt

In Excel for Microsoft 365 on Windows, click a blank cell where you want the graphic, then choose Insert > SmartArt > Hierarchy and select Organization Chart. Click OK. If the SmartArt text pane is not visible, use the small arrow on the left edge of the graphic to open it. The pane is an outline: each entry becomes a shape, and indentation indicates reporting level.

  1. Enter the top person on the first line. Add the person’s title after the name if you want both to appear in the shape.
  2. Press Enter to add another entry. Keep entries at the same outline level when they report to the same manager.
  3. To make an entry a direct report, place the cursor at the start of its line and press Tab to demote it one level. Use Shift+Tab to promote it back. Alternatively, create the entries and adjust their levels in the text pane.
  4. Repeat the pattern down the organization. Put a manager before their direct reports, then indent those reports one level beneath that manager.
  5. Review the outline against the source table before formatting the chart. A misplaced indent changes the reporting relationship, not just the visual spacing.

For example, the outline might have the director at the first level, two managers at the next level, and each manager’s employees one level below that manager. The result is a branching structure. Do not indent every new line: that would make each person appear to report to the person immediately above them.

You can also select a shape and use the SmartArt Design tab’s commands to add a shape or change its level. Ribbon labels and available controls can differ slightly across releases. In Excel for Mac, use Insert > SmartArt, choose a hierarchy layout, and enter the outline in the text pane; the ribbon arrangement and keyboard behavior may differ. Excel for the web may not offer the same full editing experience as the desktop app, so use the Windows or Mac desktop version if a command is unavailable.

Format the chart for readability

Once the structure is correct, select the graphic to open the SmartArt Design and Format tabs. The Design tab offers layout and style choices; the Format tab provides shape-level formatting. Keep the visual hierarchy clear: use a consistent shape style, readable text, and restrained color. If color represents department or location, explain the meaning rather than relying on color alone.

Use the name and title consistently, such as a name on the first line and title on the next, or a concise name-title format. Long titles and large teams can make the graphic crowded. Consider abbreviating only when the abbreviations are familiar to the intended readers. Adjust the worksheet column widths or move the graphic to a dedicated sheet so it has room; resizing a chart to fit a crowded worksheet can make the text too small.

Inspect the chart at the size at which people will read it. A chart that looks clear at full screen may be difficult to read when printed or inserted into a slide. For a very wide or deep organization, a set of department-level charts with a clear link to the overall structure may be more useful than squeezing every employee onto one page.

Common problems and how to avoid them

The most common mistake is confusing a sorted list with a hierarchy. A table can be perfectly organized and still contain no clear visual reporting relationships. Another frequent error is indenting a person one level too far, making them appear to report to a colleague rather than to the intended manager. Compare each branch with the manager column after entering the outline.

Names alone can also cause ambiguity. If a manager and an employee share a name, the chart may look plausible while representing the wrong relationship. Add a team or title for clarity, and use a unique identifier while checking the underlying records. If someone has two reporting relationships, decide whether the chart should show only the solid-line manager or also communicate a secondary relationship. A basic hierarchy layout is designed around parent-child branches; it may not clearly represent complex matrix reporting.

Finally, remember that the chart is a separate graphic. Editing the Excel table will not automatically correct SmartArt. Keep a copy of the source data, date the chart if it is used as a snapshot, and recheck the reporting lines whenever you rebuild it. Treat the chart as out of date if you cannot confirm when its structure was last reviewed.

Alternatives for larger or changing organizations

If the chart is too large to enter as an outline, or if it must be regenerated after staffing changes, consider an org-chart application that imports a spreadsheet and matches each person to a manager using a reports-to field or employee ID. In Visio, for example, an organization-chart creation workflow may be available depending on the product edition. Follow the current instructions for your installed version and check that the import process maps the correct columns before generating the diagram.

Before importing employee data into any external service, check your employer’s approved tools and data-handling requirements. A spreadsheet can contain personal or confidential information, and uploading it may be inappropriate even if the service offers a convenient chart. If your organization has a standard HR or diagramming platform, use its approved process rather than making an unreviewed copy of employee records.

For a compact chart that only needs to be shown once, PowerPoint or a diagramming app can also be a better place to lay out shapes manually. For an ongoing source of truth, keep the employee-manager table authoritative and treat exported diagrams as views of that data. This separation makes it clearer which file should be corrected when a reporting line changes.

Frequently Asked Questions

Can Excel automatically create an org chart from a manager column?
No, not through the standard SmartArt workflow. SmartArt creates a hierarchy from an outline that you provide; it does not automatically read a manager column and connect every employee to the matching manager. Use an import-capable org-chart tool for that kind of mapping.

How do I show that an employee reports to a manager in SmartArt?
Put the manager above the employee in the outline and indent the employee one level beneath them in the SmartArt text pane. People at the same indentation level are peers within the same branch.

Can I make an org chart from just a list of names?
You can create shapes from names, but names alone do not tell Excel who reports to whom. You need reporting relationships or a manually planned hierarchy to produce a meaningful org chart.

Will my SmartArt chart update when I change the Excel table?
Not automatically. SmartArt is a separate graphic, so update the outline or rebuild the chart when reporting data changes, then verify the branches against the current source list.

What should I do if the org chart is too large to read?
Split it into department or team charts, show only the key leadership levels, or use a tool designed to import and navigate larger organizational structures. Avoid shrinking all the text until it becomes illegible.

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.