How to Make an Org Chart From Excel

To make an org chart from Excel, list one person per row with a unique ID, name, title and their manager's ID, save as CSV, and upload it to an org chart tool that reads reporting lines. Organization Viewer draws the full chart from that file in seconds.

Who Is This For?

The Columns You Need

Required and optional columns
ColumnRequiredExample
Employee IDYesE104
NameYesMaria Lopez
TitleYesOperations Manager
Manager IDYes (blank for the top person)E001
DepartmentOptionalOperations
LocationOptionalDenver
Start dateOptional2023-04-03

Start from the template to get the headers right.

Fixing Common Errors

  • Two people at the top: only one row should have an empty manager ID.
  • Loops: A reports to B and B reports to A. The import flags them.
  • Names instead of IDs: two people with the same name break the link; use IDs.
  • Saved as .xlsx: choose File > Save As > CSV (UTF-8).

Keeping It Current

Re-upload the file when it changes, or sync from your HR system: see org chart from an HRIS.

Questions

Can Excel make an org chart by itself?

Excel's SmartArt can draw a small chart by hand, but it doesn't read reporting lines from your data, so large or changing orgs are hard to keep current.

How many people can I import?

Thousands. Large files load in seconds.

Start Your Org Chart Free →

Free to start. No credit card.