How to Import Your Entire Org Chart from a Spreadsheet in 5 Minutes
Your employee data already exists in a spreadsheet or HRIS. Your org chart lives in PowerPoint. Every time someone joins, leaves, or changes roles, you update the spreadsheet and then manually redraw the chart. That disconnect is why building an org chart for a 200-person company takes the better part of a day instead of five minutes.
Data and visualization live in separate tools, and the gap between them is where HR hours go to die.
Skip the drawing tool. Import directly from the spreadsheet.
Why Drawing Tools Are the Wrong Starting Point
Your first instinct is probably to open PowerPoint or Lucidchart and start placing boxes. Three problems with this:
It separates data from visualization. The employee data lives in your HRIS or a spreadsheet. The org chart lives in a drawing tool. Every change requires updating both, and they inevitably drift apart.
It doesn’t scale. Drawing boxes is fine for 20 people. At 100, it’s painful. At 200, it’s a full-day project. And at 350, it’s impossible to maintain manually with any accuracy.
It’s also fragile. Move one box and the lines break. Add a person and you have to rearrange an entire branch. Anyone who has wrestled with PowerPoint’s connector arrows at 11pm before a board meeting knows this feeling intimately.
The alternative: treat the org chart as a view of data. If your data is right, the chart draws itself.
Four Columns to a Full Org Chart
You almost certainly already have the data you need. If you use any HRIS (BambooHR, Personio, Deel, Rippling, even a shared Google Sheet) you have a list of employees with IDs, names, titles, and managers.
Four columns. One CSV file.
The minimum viable CSV
A CSV file with these four columns generates a complete org chart:
| external_employee_id | fullName | title | external_manager_id |
|---|---|---|---|
| CEO001 | Sarah Chen | CEO | |
| ENG001 | James Okafor | VP Engineering | CEO001 |
| MKT001 | Maria Lopez | VP Marketing | CEO001 |
| ENG002 | Dev Patel | Senior Engineer | ENG001 |
| ENG003 | Aisha Williams | Engineer | ENG001 |
Manager IDs create the reporting tree. The import tool matches each manager ID to the corresponding employee ID and builds the hierarchy automatically. No boxes, no lines, no arrows.
Columns worth adding
Four columns give you structure. Adding a few more columns gives you a useful org chart:
| Column | Why it matters |
|---|---|
| external_team_id | Assigns employees to teams for filtering and color-coding |
| passions | Captures interests and passions for a searchable team directory |
| description | A short bio or role summary visible on the employee profile |
| picture | URL to a profile photo, so the chart has faces, not just names |
You don’t need all of these on day one. Start with the minimum four, see the chart appear, then enrich over time. If you want a head start, here’s a ready-to-use CSV template with 20 employees showing the right column structure and sample data. Fill in your own team, and you’re ready to import.
Step by Step: Spreadsheet to Org Chart
Here’s how it works:
Step 1: Export from your current system (2 minutes)
If you use an HRIS, look for an “Export Employees” or “Download CSV” option. Most systems have this under Settings or Reports. You want: a unique employee ID, full name, title, and each person’s manager ID.
If your data lives in a Google Sheet or Excel file, save it as a CSV (File > Download > Comma Separated Values).
Tip: Clean up any blank rows or merged cells before exporting. CSV imports expect one row per employee, no exceptions.
Step 2: Verify the manager column (2 minutes)
Column validation is where most imports go wrong. Check that:
- Every employee (except the CEO/top-level person) has a manager ID
- Every manager ID matches an actual employee ID in the same file
- There are no circular references (A reports to B, B reports to A)
A quick way to check: sort by the manager ID column. Every value there should also appear in the employee ID column. If not, you have an orphan, someone whose manager isn’t in the file.
Step 3: Import (30 seconds)
Upload the CSV. The tool reads the headers, maps columns to fields (name, title, manager, etc.), and generates the tree. For a 200-person company, this typically takes less than 30 seconds.
Step 4: Review and adjust (1 minute)
Scan the generated chart for obvious errors:
- Is the CEO at the top with no manager?
- Are departments grouped correctly?
- Do the reporting lines look right for the teams you know well?
If something looks off, it’s almost always a data issue in the CSV. Fix the spreadsheet, re-import, done.
Step 5: Enrich (optional, ongoing)
Once the structure is right, you can add profile details: photos, skills, interests, contact info. Some tools let employees fill in their own profiles, which means HR doesn’t carry the maintenance burden alone.
After the First Import
Your first import saves you a day. The second one is where it gets interesting.
When someone joins, leaves, or changes roles, you don’t redraw anything. You update the spreadsheet (or re-export from your HRIS) and re-import. The tool matches employees by their unique ID, applies the changes, and keeps everything else intact.
That quarterly board update? It goes from a full-day project to a five-minute re-import. The CEO gets a chart that was accurate this morning.
And because the chart is data-driven, you can create multiple views from the same import: one for the board showing leadership structure, one for employees showing their team and neighbors, one for hiring showing open positions. One dataset, many outputs.
Common Pitfalls (and How to Avoid Them)
“My HRIS export has 47 columns.” You only need four to start. Most import tools let you map columns during upload; just ignore the ones you don’t need.
“Some people have two managers.” Matrix structures are tricky. For the import, pick the primary (solid-line) reporting relationship. Dotted-line relationships can be added as a second layer after import.
“We have contractors and part-time employees.” Include them. Add a “type” column (Full-time, Part-time, Contractor) so you can filter views later. Leaving people out creates an incomplete picture.
“Our data is messy.” It always is. Don’t wait for perfect data. Import what you have, see what breaks, and fix it iteratively. A 90%-accurate org chart imported in five minutes beats a 100%-accurate PowerPoint that takes three days and is outdated by Friday.
Checklist
Your five-step plan to get your org chart out of PowerPoint:
- Export your current employee list as a CSV (or create one from your Google Sheet)
- Ensure every row has: a unique employee ID, full name, title, and manager ID
- Clean orphan records: every manager ID must match an employee ID in the file
- Import into a tool that builds the chart from data (HumanMap’s free tier supports up to 2 charts)
- Share the result with your team and ask for corrections; crowdsourcing fixes is faster than auditing alone
Try it with your existing spreadsheet. Five minutes, and you’ll never open PowerPoint for an org chart again.
Questions readers ask most
