Org chart in Excel feature image in ClickUp blog

How to Create an Org Chart in Excel 2022

You can tell us: Creating an organizational chart soaks up hours of your day. 

Not only are you chasing information from all 47 team members to fill the org chart (Is it Senior or Sr? Do you go by your middle name?), but you also struggle with formatting every box and line in Excel

The org chart is an invaluable resource for every employee, especially for cross-collaboration projects and managing communication. Fast-tracking the org chart build process in Excel leaves more time and energy to make fast and efficient decisions to move the workforce closer to organizational goals. 

This article will cover the differences between a traditional and modern org chart, how to make an org chart in Excel, and Excel tips to avoid duplicate work! 

What is an Organizational Chart?

An organizational chart or org chart is a diagram showing a business’s internal reporting and relationship structure. Traditional org charts have a top-down structure shaped like a pyramid. 

The company’s chief management positions are listed at the top level. The rest of the organization’s employees are at the second, third, and following levels. Lines on the org chart show the reporting path by connecting employees.

Suppose you’re looking for a deeper understanding of team interdependencies or need to evaluate functions of different positions. In these cases, a traditional org chart in Excel falls short in its design and capabilities. 

Using modern org chart software gives far more benefits, empowering businesses to stay agile and proactive during organizational restructures, leadership changes, and staff expansions.

build an organization chart with a clickup mind map
Create an org chart template inside a ClickUp Mind Map

In what ways do modern org charts outperform traditional org charts? Beyond providing an at-a-glance visual, modern org charts help teams: 

  • Evaluate specific responsibilities of employees and departments
  • Demonstrate the need for new positions to fill resource gaps
  • Access direct contact information
  • Plan cross-functional projects
  • Clarify project stakeholders

How to Make an Organizational Chart in Excel

In this tutorial, we use Microsoft Word for Mac Version 16.54. The steps and features may look different if you’re on another platform or version. 

Step 1: Create an employee directory

The org chart should include the employee’s first and last name, role, and department, depending on your use case. Organize this data into the spreadsheet with other details as necessary.

In our example, a team leader wants to see the creative division’s full-time and part-time status to make a case for increasing the department headcount. 

Tip: Bold every manager’s name and list their direct reports underneath so when you’re editing the org chart, you won’t have to recall from memory! Alternatively, you can add a symbol before their name, such as *, and delete later using the Find and Replace function. 

import org chart data or create an organizational chart template directory in excel
Created in Microsoft Excel

Step 2: Select the right SmartArt graphic

What you’ll use the org chart for will influence the type of diagram. Excel has a standard Organization chart, Circle Picture chart, Hierarchy chart, and more. Whichever SmartArt graphic you choose, you can easily switch to another anytime!

To add a Smart Art graphic, go to the Insert tab > SmartArt icon> choose Hierarchy from the drop-down menu > select Organization Chart.

use org chart shapes from the insert tab in excel
Created in Microsoft Excel

Step 3: Add employee data to the org chart 

First, highlight and copy all employee information, then paste the text into the SmartArt window. The org chart will look small and hard to read, but we’ll fix this when we organize the employees into their appropriate reporting structure. 

Use the text pane in excel to begin building the organization chart layout
Created in Microsoft Excel

Tip: If you don’t see the Text Pane window, make sure you’ve selected the org chart, and from the Menu Toolbar, open the SmartArt Design tab and click Text Pane

open the text pane to edit the organization chart or use the smartart tools design tab
Created in Microsoft Excel

Step 4: Arrange and customize the org chart

Now let’s arrange the reporting structure from the Text Pane window! The symbols at the top of the pane help perform specific actions: 

  • Plus sign: Add a new box (employee)
  • Minus sign: Remove a box (employee)
  • Left, Right, Down, and Up arrows: Move a box (employee)
create the organizational structure to form the reporting relationships in org charts
Created in Microsoft Excel

Tip: The tab and delete keys on your keyboard will also move boxes left or right (and save you clicks)! 

Go through every employee’s name to position them within the hierarchy. As you move the boxes, you’ll see your org chart begin to form. 

org chart in excel example from a smartart style
Created in Microsoft Excel

Then, click on the org chart and use Enter on your keyboard to give each detail (Name, Role, Department, and Status) its own line.

create an org chart in excel to resemble a family tree or pyramid structure
Created in Microsoft Excel

Tip: If you want to change the colors or overall style of the org chart, go to the Menu Toolbar, and under the SmartArt Design tab, choose your preferred customizations. 

open the smartart graphics to use an organizational chart template in excel
Created in Microsoft Excel

Step 5: Save as an org chart template

Satisified with your org chart? Great! Let’s save it as a template for future revisions. Go to the Menu Toolbar > File > Save as Template. 

save an org chart template in excel with employee data
Created in Microsoft Excel

Related Resources:

3 Common Excel Problems (and How to Solve Them)

The biggest downside to using an org chart in Excel is you can’t learn anything else besides the minimal information provided about each department or employee. Names, titles, and faces don’t give them a direct path to contact their team members. 

Earlier, we learned about the benefits of modern org chart software. If you’re looking for a solution to replace Excel as a productivity tool or are curious about ClickUp, here are three reasons to make the switch!

Problem 1: Excel is not designed for collaborative work

Teams separated by time zones need an intuitive org chart to schedule meetings, projects, and work trips at any given time. When everyone’s contact information is in one org chart, they no longer drown in the nonessential back-and-forth emails.

Plan to spend than save more time in an Excel org chart.

Solution: ClickUp Whiteboards and Mind Maps

If you prefer real-time collaboration—and employees responsible for updating their Out of Offices and contact information—use Whiteboards and Mind Maps

ClickUp’s visualization tools empower teams to add more content and media to their org chart, so everyone stays connected to people and resources. Here are a few ways to customize ClickUp Whiteboards:

  • Align your objects to create relationships with Smart Alignment Guidelines
  • Style your org chart with banners, headings, highlights, and buttons
  • Convert shapes, sticky notes, or text into a ClickUp task
  • Change colors, sizes, and connector types
  • @mention people, tasks, and ClickUp Docs

Introduction to Whiteboards template by ClickUp

use clickup whiteboards to create an organization chart template
Build organizational charts with more context and visuals in ClickUp Whiteboards

Problem 2: Organization charts in Excel require hours of preparation time

With Excel, you’re pulling information from multiple resources like emails, Slack, and PDFs. Then, copy, paste, and format every employee box in the org chart. There’s a faster way to simplify the process. And all it begins with a Form!

Solution: Gather the right information with ClickUp Forms 

Here’s how it works: You send a ClickUp Form link with all the questions a person needs to complete for their profile (headshot, title, time zone, preferred communication channel, etc.) After the person completes the Form, their submission routes to the List of your choice.

After you’ve collected all the responses, you can group, sort, and filter the tasks to build a real-time directory List for all employees to interact with at any time and anywhere! 

build organizational charts using clickup forms to collect employee data
Complete a ClickUp Form on a desktop or mobile device

Problem 3: An org chart in Excel only shows formal relationships amongst people and teams

A traditional org chart in Excel misses important context about cross-functional teams working together. For example, an executive assistant reports to the chief creative officer and SVP of marketing on paper. But informally, they also support the design department as a team coordinator.

Or perhaps you’re putting together a cross-functional team for a company-wide employer brand campaign and need contributors from Marketing, Legal, Creative, and Human Resources. This campaign will require people to be located at the office headquarters for on-site filming. A native org chart in collaborative software would be a valuable resource to quickly find and connect with these specific individuals.

Solution: Build a powerful employee directory with ClickUp Lists

Are you in an organization of tens, hundreds, or thousands? Keeping up with personnel updates and transitions is easier with powerful ClickUp Lists. 

ClickUp’s all-in-one employee database template includes pre-built views, Custom Fields, and custom statuses to easily create a staff directory hub and evolve with your organization!

  • Sort employee information at a glance by department, location, and title
  • Log employee working hours, travel plans, birthdays, and more
  • Schedule and assign projects with full visibility

The Employee Directory template by ClickUp

clickup lists replace org charts in excel as an all in one employee directory tool
Create multiple org charts for different departments, regions, and projects in ClickUp

Free resources are available 24/7 with live support, on-demand webinars, and online learning. If operational efficiencies are top of mind at your organization, try ClickUp to bring your workforce closer to productivity goals! 🧑‍💻

Questions? Comments? Visit our Help Center for support.

Sign up for FREE
and start using ClickUp in seconds!
Please enter valid email address