HR data in Excel

How to create an org chart from Excel employee data

The boxes are the easy part. The real work is building a clean reporting hierarchy—one employee, one stable ID, and one unambiguous manager relationship per row—then choosing a layout that stays readable when the team gets real.

Written by Joshua Cottrell-Schloemer, 2× Microsoft Excel MVP and designer of the Big Excel Energy Org Chart Generator. Updated July 16, 2026.

To create an org chart from Excel employee data, start with one row per employee and connect each row to a manager using stable IDs—not names. Validate the relationships, choose which fields belong on each card, select a layout, then draw the hierarchy manually with SmartArt, generate it through Visio, or use an automated Excel workbook.

The structure

A flat list can describe a complete hierarchy

An organization chart looks like a tree, but the source data should not. Keep the employee data flat: one person per row. The hierarchy comes from the relationship between two fields—Employee ID and Manager ID.

If employee E008 reports to employee E004, the Manager ID on E008's row is simply E004. Repeat that pattern through the table and you have enough information to reconstruct every branch. This is cleaner than storing “levels” because levels change whenever someone moves. The manager relationship is the durable fact.

Flat employee table

One row per person with Employee ID, Manager ID, name, role, department, and optional display fields.

Generated hierarchy

Cards and connectors are positioned from the reporting relationships, then styled for the final audience.

Your employee table

Three required fields, then only what earns its space

Every additional field makes the employee card larger. Add information because it helps someone read the organization—not because it exists in HRIS.

Employee IDA unique, stable identifier. This is how other rows point to the employee.

Employee nameThe display name that appears on the card.

Manager IDThe Employee ID of the person's manager. Leave blank only for a deliberate root.

Job titleUsually the most useful second line on a card.

DepartmentUseful for grouping, filters, and restrained color coding.

LocationUseful for distributed organizations, but not automatically necessary on every chart.

StatusCan distinguish active employees, vacancies, contractors, or planned roles.

Photo file / URLSupports headshots. Standardize filenames, dimensions, and missing-photo behavior.

Download a clean employee-list example

This fictional CSV includes stable employee IDs, manager IDs, departments, status, and photo filenames. Open it in Excel and use it to test a hierarchy before connecting real employee data.

Download sample CSV ↓

Do this before drawing

Validate the hierarchy

Most “org-chart errors” are employee-data errors wearing a visual costume.

Find duplicate IDs

Every Employee ID must identify exactly one row. Duplicate names are normal; duplicate IDs are not.

Find missing managers

Every nonblank Manager ID must exist in the Employee ID column. Otherwise the branch has nowhere to attach.

Find self-references

An employee cannot report to their own ID. It sounds obvious until one copied row produces an impossible loop.

Decide how many roots exist

A company chart normally has one top row. Multiple blanks may be legitimate for separate entities, or they may be missing data.

Check for circular chains

A reports to B, B reports to C, and C reports to A can never become a tree. The generator should stop and explain the cycle.

Standardize photos

Mixed aspect ratios and broken paths make an automated result look broken even when the hierarchy is correct.

Two simple table checks catch a surprising amount:

Duplicate ID: =COUNTIF(Employees[Employee ID],[@[Employee ID]])>1

Missing manager: =AND([@[Manager ID]]<>"",COUNTIF(Employees[Employee ID],[@[Manager ID]])=0)

Choose the method

SmartArt, Visio, or automation inside Excel

Method	Best for	Tradeoff
Excel SmartArt	A small, mostly static chart you are comfortable arranging and updating manually.	Easy to start, but it is not a true employee-list-to-chart workflow. Reorganizations mean more manual editing.
Microsoft Visio	Organizations that already use Visio and want its Organization Chart Wizard to import an Excel data source.	Automatic and capable, but the workflow and output live in a separate application.
Automated Excel workbook	Recurring charts that should stay in Excel with custom cards, themes, fields, and layouts.	Automatic generation generally requires VBA macros and desktop Excel. Your organization must allow the file to run.

Microsoft documents how to draw an organization chart with SmartArt and how Visio can create one automatically from employee data. The right choice is less about which tool is most powerful and more about where the chart needs to be maintained.

Build the output

Six steps to a readable organization chart

Prepare one employee table

Use stable IDs and one row per person. Keep the source flat even though the result is a tree.

Validate the relationships

Resolve missing managers, duplicates, self-references, unintended roots, and circular chains before touching the design.

Choose the card fields

Name and title are the usual core. Add department, location, status, tenure, or notes only for a specific audience.

Choose a layout

Classic tree for familiarity, vertical for branches with many direct reports, or horizontal for wide presentation and print output.

Set the visual system first

Define card size, type hierarchy, department colors, photo treatment, connectors, and vacant-position styling before generating hundreds of objects.

Generate, then inspect

Automation gets the structure onto the page. A person still needs to check clipping, spacing, branches, stale data, and whether the chart answers the intended question.

Layout is a data decision

Three layouts solve three different problems

Classic tree

The familiar top-down hierarchy. It is the easiest to explain, but wide management spans can make it grow sideways fast.

Vertical

Useful when managers have many direct reports. Tall branches trade width for height and can keep a dense team on the page.

Horizontal

Useful for landscape presentations and large-format output. It gives deep hierarchies more room to travel across the page.

Design the cards

Show the organization, not the database

An HR file may have fifty fields per employee. An org-chart card does not need fifty fields. The chart exists to communicate reporting structure, so name, title, and one useful secondary signal are often enough.

Use department color lightly—an edge, label, avatar, or small fill area is usually enough. If every department becomes a fully saturated card, the chart turns into a patchwork and the hierarchy disappears. Connectors should be quieter than the cards; photos should use one crop and size; vacancies should look intentional instead of broken.

The larger the organization, the more important it is to generate audience-specific views rather than force everyone onto one poster. A leadership chart, department chart, and People Ops working chart can all come from the same employee table while showing different depth and detail.

What breaks it

Common employee-data and org-chart mistakes

Using manager names as keysNames repeat, change, and get typed inconsistently. Stable IDs make the relationship unambiguous.

Drawing before validatingA missing manager or circular chain cannot be fixed with better spacing. Repair the data first.

Putting every HR field on the cardThe chart becomes a directory and stops communicating the reporting structure.

Building one chart for every audienceThe board, HR, and an individual department rarely need the same depth and information.

Ignoring macro policy until purchaseIf the chosen generator uses VBA, confirm that desktop Excel and the organization's security policy allow it before relying on the workflow.

Automatic and Excel-first

The generator I built

Horizontal organization chart generated from employee data inside Excel

Macro-enabled Excel template · $39

Excel Org Chart Generator

Add the employee list, choose a layout and style, then generate the full chart inside Excel. It handles classic tree, vertical, and horizontal layouts, headshots or initials, built-in themes, department colors, card fields, connectors, vacancies, and detailed styling.

Please do not buy it unless you know your organization allows macros. This is an .xlsm workbook and needs desktop Excel with VBA enabled.

See the generator →

FAQ

Excel org charts, answered

Can Excel automatically create an org chart from employee data?

Excel can store and validate the employee hierarchy, but SmartArt is mainly a manual drawing tool. Automatic generation inside Excel generally requires VBA or another automation layer. Microsoft Visio can also generate an org chart from an Excel data source.

What columns are required?

The safest minimum is a unique Employee ID, Employee Name, and Manager ID. Job title, department, location, status, notes, and a photo filename or URL are optional display fields.

Should I use manager names or manager IDs?

Use manager IDs. Names can be duplicated, misspelled, or changed. A stable ID makes each reporting relationship unambiguous.

Can the chart include headshots?

Yes. An automated workbook can place a photo or initials avatar on each employee card, but image paths, filenames, crop proportions, and missing-photo behavior should be standardized first.

Does the automatic generator work in Excel for the web?

No. The Big Excel Energy generator uses VBA in a macro-enabled .xlsm workbook. It requires a desktop version of Excel with macros enabled and does not generate charts in Excel for the web or Google Sheets.

Keep going