How to Create an Org Chart from Excel (+ Free Template)

You have 50 names in a spreadsheet. Someone wants an org chart by tomorrow.

The fastest path: upload the spreadsheet to a dedicated tool to build your org chart from Excel: imports generate the hierarchy in 5 minutes. No typing names twice, no manual box alignment, and no connector lines. That method is covered first.

If you need the diagram to live inside the workbook itself as an embedded SmartArt graphic, that method is covered second. It works for teams under 20, but there is a wall you will hit as your roster grows.

Key Takeaways:

• Upload your Excel file to Org Chart Studio: five minutes from spreadsheet to finished chart, no retyping.
• SmartArt is the right call only when the chart needs to stay inside an Excel file.
• SmartArt doesn't read your spreadsheet data, every update means editing the chart manually.
• Excel SmartArt hits practical limits around 100 nodes and 6 levels; text becomes illegible past 30 people.
• Org Chart Studio's free tier handles up to 250 people per chart with auto-layout and drag-to-reparent.

---

The faster way: generate an org chart from Excel automatically

If you have employee data in Excel, there's a better path than SmartArt. Upload it to a dedicated org chart tool and let the software build the hierarchy automatically.

This is what Org Chart Studio was designed for.

Step 1: Prepare your Excel data

You need three columns minimum:

Name	Title	Manager
Sarah Chen	CEO
Marcus Johnson	VP Engineering	Sarah Chen
Priya Patel	VP Operations	Sarah Chen
David Kim	Senior Developer	Marcus Johnson
Ana Rodriguez	Developer	Marcus Johnson
James Wilson	Operations Manager	Priya Patel

The Manager column does all the work. It tells the software who reports to whom. Sarah Chen has no manager, so she sits at the top. Everyone else points to exactly one person who exists in the Name column.

You can add a Department column too. It imports as a field displayed on each card.

Step 2: Open Org Chart Studio

Go to orgchartstudio.com/studio. No account needed to start.

Open the command palette on the left. Click Import. Select your .xlsx file directly to create a clean org chart from Excel. (If you prefer CSV, File > Save As > CSV in Excel works too. Both formats import the same way.)

Step 3: Pick the right sheet

If your workbook has more than one sheet, Studio asks which one holds the roster. Single-sheet workbooks skip this step.

Step 4: Map your columns

The import dialog asks which column is which:

• Which column contains names?
• Which column contains managers?
• Which column contains titles?

Select from the dropdowns. The tool validates your data and flags issues like circular reporting (someone who reports to their own subordinate) or managers who don't exist in your list.

Step 5: Generate your chart

Click import. Your org chart appears.

Everyone is positioned correctly based on reporting relationships. No dragging boxes. No drawing connector lines. The auto-layout handles it.

From here you can:

• Drag to reorder siblings left to right
• Drag a card onto another person to reparent them
• Double-click to edit names or titles
• Adjust spacing with five layout presets

The whole process takes about five minutes. Most of that is finding the file on your computer.

---

Troubleshooting your org chart from Excel import

Real-world spreadsheets have messy data. Here's how to handle the common problems:

Typos in manager names. If someone's listed manager is "Jon Smith" but the employee record says "John Smith," Org Chart Studio's fuzzy matching catches it. The import flags the mismatch and suggests the closest match (within two character differences).

Missing managers. If a manager name doesn't exist in your employee list, that person is flagged as Needs manager. The tool shows you which records are affected. Fix the spelling in your spreadsheet, or add the missing person, then reimport.

Circular references. If Person A reports to Person B who reports to Person A, the validation catches it. Someone's manager field is wrong. Check your data.

Blank manager fields. If someone has no manager listed, they become a root node at the top of a tree. Most orgs have one CEO with a blank manager. If you have multiple blank entries by accident, you'll get multiple separate trees.

Extra columns. The import ignores columns it doesn't need. Phone numbers, employee IDs, start dates: they won't break anything. Just map the columns you want.

---

How to create an org chart in Excel using SmartArt

SmartArt is Excel's built-in diagram tool. It handles the layout automatically, which is both its strength and its limit. Use this method when the org chart Excel file needs to stay inside an Excel workbook.

Step 1: Insert the SmartArt graphic

Open your Excel file. Go to Insert > SmartArt (or Insert > Illustrations > SmartArt depending on your version).

In the dialog box, click Hierarchy on the left. You'll see about 15 templates. Most are decorative variations on the same concept.

Choose Organization Chart (the first option). Click OK.

A starter diagram appears with placeholder boxes.

Step 2: Use the Text Pane for faster entry

Here's where most tutorials fail you. They tell you to click each box and type. That's slow.

Instead, look for the small arrow on the left edge of the SmartArt graphic. Click it to open the Text Pane. This is your outline view.

Type names here like a bulleted list:

• Each bullet becomes a box
• Press Tab to demote someone (make them report to the person above)
• Press Shift+Tab to promote them back up
• Press Enter to add a new person at the same level

If you already have names listed somewhere, you can copy and paste them into the Text Pane. Excel interprets indentation as hierarchy. This is as close as SmartArt gets to importing data.

Step 3: Add names and titles

For each person, you can add multiple lines within a single box. In the Text Pane, type the name, press Shift+Enter (soft return), then type the title.

Example:

Sarah Chen
Chief Executive Officer

The text auto-sizes to fit the box. If it shrinks too small to read, that's a sign your chart is getting too big for SmartArt.

Step 4: Delete the assistant box

SmartArt inserts a default "assistant" position off to the side of the top role. If you don't have an executive assistant to map, click that box and press Delete. It throws off the symmetry otherwise.

Step 5: Fix the layout

By default, SmartArt uses a "hanging" layout that stacks direct reports vertically. This saves horizontal space but makes charts harder to read.

To fix it:

1. Click the manager's box (the one above the vertically stacked people)
2. Go to SmartArt Design tab (or SmartArt Tools > Design in older versions)
3. Click Layout and choose Standard for horizontal arrangement

Now direct reports appear in a row instead of a column.

Step 6: Style the chart

Under the SmartArt Design tab (labeled "SmartArt Tools > Design" in some versions), you'll find color schemes and 3D effects. The Change Colors button offers preset palettes. The SmartArt Styles gallery adds gradients and shadows.

Keep it simple. A clean org chart communicates structure. A chart with 3D bevels and rainbow gradients communicates that someone discovered the formatting menu.

---

Keyboard shortcuts for Excel org charts

Working in the Text Pane is faster than clicking boxes. These shortcuts help:

Action	Shortcut
Demote (make subordinate)	Tab
Promote (move up a level)	Shift+Tab
Add person at same level	Enter
New line within same box	Shift+Enter
Delete selected box	Delete
Open SmartArt dialog	Alt, N, M

Build your entire structure with Tab and Enter first. Style it after.

---

Where Excel SmartArt works well

To be fair, SmartArt handles certain situations fine:

Small teams. Under 20 people, the chart stays readable and updates are manageable.

Two or three levels. CEO, managers, individual contributors. Classic pyramid. SmartArt does this well.

One-time use. A slide for tomorrow's board meeting. A diagram for a proposal. Something you'll build once and archive.

Charts embedded in Excel. If the org chart lives inside a larger Excel report, keeping it in SmartArt avoids format conversion headaches.

For a 15-person startup creating an investor deck, SmartArt gets the job done.

---

Where Excel org charts get painful

The problems compound as your organization grows:

No data connection. This is the big one. Your employee data is right there in Excel, but SmartArt can't read it. You have a spreadsheet with 80 names, titles, and managers. SmartArt's response: type them again, one box at a time. Every time someone joins, leaves, or moves teams, you update the chart manually. Miss one, and the chart lies. The bypass: skip SmartArt entirely to build a dynamic org chart Excel sheet automatically from your spreadsheet. (If your data is in Google Sheets, BambooHR, ADP Workforce Now, or Workday, we have dedicated guides for each.)

Depth and size limits. Here's where it gets frustrating: Microsoft's documentation claims org chart layouts have "unlimited" shapes. In practice, users hit walls. One source reports limits of 6 levels deep and 100 entries maximum. Microsoft community threads confirm users hitting caps around 100-300 nodes, with entries beyond the limit marked with a red X and hidden from the chart. Microsoft's own support recommends Visio for larger organizations. For a 75-person company with names and titles displayed, you're already approaching the edge.

Text shrinks to illegible. As you add people, boxes shrink to fit. Past 30-40 people, names become microscopic. SmartArt can't wrap to a new row or page.

No dotted lines. Matrix organizations, dual reporting, cross-functional relationships: SmartArt doesn't understand them. You can manually draw dashed lines using Shapes, but they won't stay attached when you move boxes.

Every change is manual. Promotions, new hires, departures, reorgs. Each requires editing the SmartArt by hand. For organizations with monthly turnover averaging 3-4%, the chart decays constantly.

---

Free org chart Excel templates

We've created two templates depending on your situation:

Template 1: Excel SmartArt template

Download Excel Org Chart Template (.xlsx)

A pre-formatted SmartArt org chart inside an Excel file. Replace the placeholder names with your team. Use the Text Pane for faster editing.

Best for: Quick charts under 20 people that need to stay inside Excel.

Template 2: Spreadsheet import template

Download Excel Import Template (.xlsx) or Download CSV Import Template (.csv)

A structured data template ready for Org Chart Studio:

1. Open the file in Excel
2. Replace the sample data with your team
3. Keep the headers (Name, Title, Manager, Department)
4. Save the file
5. Import at orgchartstudio.com/studio

Best for: Teams with existing employee data who want to generate an org chart from Excel automatically.

---

Org Chart Studio vs. Excel SmartArt

For small teams already in Excel, SmartArt works. For teams with real employee data who update charts regularly, the import workflow saves hours.

---

FAQs: org chart from Excel common questions

How do I create an organizational chart in Excel?

Insert > SmartArt > Hierarchy > Organization Chart. Use the Text Pane (click the arrow on the SmartArt's left edge) rather than clicking individual boxes: it's much faster. Tab demotes, Shift+Tab promotes, Enter adds a peer at the same level. Quick for small teams; for anything larger, upload your .xlsx (or CSV) file to a dedicated tool.

Can I make an org chart in Excel from existing data?

Not directly. SmartArt doesn't connect to spreadsheet cells. You have to type or paste names into the Text Pane manually. For automatic chart generation from data, upload your Excel file (or CSV) to a tool like Org Chart Studio that supports spreadsheet import.

How many people can an Excel org chart handle?

Microsoft's documentation claims "unlimited," but users consistently hit walls in practice. Reports suggest limits around 100-300 nodes and 6 levels of hierarchy. Entries beyond the limit get marked with a red X and hidden. For readability, you'll struggle past 20-30 people anyway. Microsoft recommends Visio for larger organizations. For teams over 50, consider dedicated org chart software or split by department.

Can I add photos to an Excel org chart?

Yes. Choose the "Picture Organization Chart" layout in SmartArt. Each box gets a photo placeholder. Click to insert images. It works, but formatting 30+ photos is tedious.

How do I show dotted-line relationships in Excel?

SmartArt doesn't support them natively. You can draw a dashed line using Insert > Shapes, but it won't stay connected to boxes when you move things. Matrix structures need a dedicated tool.

How do I update an Excel org chart when someone changes roles?

Open the Text Pane (click the arrow on the SmartArt edge), find the person, edit their text or use Tab/Shift+Tab to change their position. For frequent updates, maintaining separate source data and reimporting the spreadsheet is more reliable.

Can I create an org chart from an Excel employee list automatically?

Not within Excel itself. The workaround is to upload your Excel file to a tool designed for this. Org Chart Studio reads .xlsx (and CSV) directly, maps columns to name, title, and manager fields, then generates the chart automatically.