Is this an automatic Excel org chart generator?

Yes. Add your employee list and reporting relationships, choose the layout and styling, then run the included macro to generate the organization chart in Excel.

Which org chart layouts can it create?

It generates three layouts: a classic tree, a vertical layout, and a horizontal layout.

Can the org chart include employee photos?

Yes. The generator supports uploaded headshots as well as initials-style avatars when a photo is not used.

Can I customize the colors and information shown on each card?

Yes. You can use built-in themes or customize department colors, displayed fields, card layouts, fonts, borders, connector lines, shadows, tints, and other style options.

Do I need to enable Excel macros?

Yes. This is a macro-enabled .xlsm workbook and the generator requires a desktop edition of Excel that can run VBA macros. Do not purchase it if your organization blocks macros.

Does it work in Excel for the web or Google Sheets?

No. Excel for the web and Google Sheets cannot run the VBA generator. Use a desktop edition of Microsoft Excel with macros enabled.

How do I get the file after I buy?

Checkout is handled securely by Kit. After purchase, the macro-enabled Excel file is delivered by email with a download link; no subscription is required.

Excel Org Chart Generator From Employee Data

Automatically build an org chart from your employee list

The Excel Org Chart Generator is a macro-enabled workbook that converts a structured employee list into a complete organization chart inside Excel. Add your people and reporting relationships, choose a layout, and let the workbook generate the employee cards and connector lines.

Unlike a static organizational chart template with boxes you have to position manually, this file generates the hierarchy from your data. It is designed for recurring updates, growing teams, and anyone who wants to keep the entire workflow in Excel.

Macro requirement: this is an .xlsm file and its generator runs with VBA macros. Before purchasing, confirm that your organization allows macro-enabled Excel workbooks. It will not generate charts in Excel for the web or Google Sheets.

Want to prepare the employee data correctly first? Read how to create an org chart from Excel employee data. It covers stable Employee and Manager IDs, missing-manager and duplicate checks, circular relationships, layout choices, photos, and when SmartArt or Visio may be a better fit. You can also browse the HR and People Operations template collection.

What’s included

A macro-enabled Excel org chart generator workbook
Three generated layouts: classic tree, vertical, and horizontal
Support for employee headshots and initials-style avatars
Built-in themes plus detailed color and style customization
Department color coding, optional card fields, and vacant-position styling
Editable card layouts, fonts, borders, connector lines, shadows, and tints

How the Excel organization chart generator works

Enter employees and their reporting relationships in the workbook’s structured list.
Add details such as job title, department, tenure, status, notes, or headshots where useful.
Choose one of the three layouts and select a built-in theme or your own styling.
Run the generator to draw the hierarchy, cards, and connecting lines in Excel.

Three org chart layouts

Classic tree creates a familiar top-down hierarchy. Vertical organizes branches into tall columns for teams with many direct reports. Horizontal spreads the organization across a wide landscape layout that works well for presentations and large-format output.

Headshots, themes, and detailed customization

Use employee photos or clean initials-style avatars. Assign colors by department, decide which fields appear on each card, change the card structure, and tune details such as font, border, connector color, line weight, corner radius, shadow, tint, and vacancy badges. Built-in themes provide a quick starting point, while the custom controls let you match an existing brand or reporting style.

Who it’s for

Built for HR and People Operations teams, chiefs of staff, department leaders, organizational-design consultants, and anyone who regularly turns employee data into a clear reporting hierarchy.

Excel compatibility and security

This download is an Excel macro-enabled workbook (.xlsm). Use a desktop edition of Microsoft Excel capable of running VBA macros. Excel for the web and Google Sheets cannot run the generator. Corporate macro policies vary, so check with your IT or security team before buying if you are unsure.

An Excel-first alternative to drawing every box manually

Microsoft Excel includes SmartArt organization charts, while Microsoft Visio can generate an org chart from employee data. This template is for people who want an automated, customizable workflow that stays inside Excel.