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?
- HR with an employee list in ExcelYou’ll use it to skip drawing and get the chart from data you already have.
The Columns You Need
| Column | Required | Example |
|---|---|---|
| Employee ID | Yes | E104 |
| Name | Yes | Maria Lopez |
| Title | Yes | Operations Manager |
| Manager ID | Yes (blank for the top person) | E001 |
| Department | Optional | Operations |
| Location | Optional | Denver |
| Start date | Optional | 2023-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.
Free to start. No credit card.
