✦Template Printable Ideas Insights

Convert Excel Data to Visio Org Chart: Step-by-Step Tutorial

By

Ever found yourself drowning in a sea of Excel data, dreaming of a visual org chart to make sense of it all? Visio, the powerful diagramming tool from Microsoft, can turn those spreadsheets into structured and navigable organizational charts. But can you create an org chart from Excel data in Visio? Absolutely, and it's easier than you think!

Before we dive in, ensure you're using compatible versions of Excel and Visio. Microsoft recommends using Visio 2019 or Visio Online Plan 2 (or higher) with Excel 2016 or later. Now, let's roll up our sleeves and get to work.

Preparing Your Excel Data

Imagine your Excel sheet as a picnic basket. You want everything to fit neatly when closed, just like you want your org chart to look. So, start by cleaning and organizing your data:

How to Make an Org Chart in Excel (+ video tutorial)
How to Make an Org Chart in Excel (+ video tutorial)
a computer screen with an arrow pointing to the text boss how did you make this org chart?
a computer screen with an arrow pointing to the text boss how did you make this org chart?
How to Make an Organizational Chart in Excel - Tutorial
How to Make an Organizational Chart in Excel - Tutorial
  • Headers: Ensure the first row contains headers for each column of data (e.g., Name, Title, Department, etc.).
  • Format: Convert all text to the same case (e.g., Capitalize or lowercase) and use bullet points sparingly.
  • Structure: Data should be hierarchical, with managers and their direct reports in separate rows.

Once your data is clean and structured, it's time to bring it into Visio.

Exporting Excel Data to Visio

Visio can import data from Excel directly. Here's how:

How to Create the Organizational Chart You Know Your Business Needs | Process Street | Compliance Operations Platform
How to Create the Organizational Chart You Know Your Business Needs | Process Street | Compliance Operations Platform
an excel chart with two smiley faces and the word excel in green on top of it
an excel chart with two smiley faces and the word excel in green on top of it
How to Create an Organizational Chart Linked to Data in Excel (Easy & Dynamic)
How to Create an Organizational Chart Linked to Data in Excel (Easy & Dynamic)
  1. Launch Visio and choose "Organizational Chart" under the "Recently used" or "Business" templates.
  2. Click on "Data" in the "Insert" tab, then select "From Excel".
  3. Choose the Excel file, select the sheet containing your data, and click "Import".

Ta-da! Your Excel data is now in Visio, ready to become an org chart.

Creating the Org Chart

Once your data is imported, Visio automatically creates an org chart layout. However, you may want to tweak it to fit your needs. Here's how:

  1. Layout: Go to "Design" in the "Home" tab, then choose a layout you like.
  2. Colors & Style: Click on "Colors" in the "Home" tab to change the look and feel of your org chart.
  3. Refine: Use Visio's(shape tools in the "Home" tab) to add, remove, or edit shapes and text boxes.

With a bit of finesse, your org chart will look polished and professional.

How to Create an Organizational Chart in Word with Free Templates | EdrawMax
How to Create an Organizational Chart in Word with Free Templates | EdrawMax
How to Make an Organizational Chart in Excel - Tutorial
How to Make an Organizational Chart in Excel - Tutorial
7 Types of organizational structures
7 Types of organizational structures
How to Create an Organizational Chart in Word with Free Templates | EdrawMax
How to Create an Organizational Chart in Word with Free Templates | EdrawMax
Create Organization Chart in Excel
Create Organization Chart in Excel
How to Create Relationships Between Multiple Tables Using Data Model in Excel
How to Create Relationships Between Multiple Tables Using Data Model in Excel

Refining Your Org Chart

Now that your org chart is visually appealing, let's make sure it's functional too:

Cross-Functional Relationships

Some employees may report to multiple managers (e.g., project-based or shared service roles). You can show these relationships in Visio:

  1. Click on "Shape" in the "Home" tab, then select "Cross-Functional Relationship".
  2. Connect the shapes of the employees and their managers.

Instantly, your org chart becomes a more accurate reflection of your organization.

the most useful excel chart info sheet
the most useful excel chart info sheet
the organizational chart for an organization
the organizational chart for an organization
Organizational Charts in Excel | MyExcelOnline
Organizational Charts in Excel | MyExcelOnline

Adding Photos and URLs

Personalize your org chart by adding photos and direct contact information:

  1. Photos: Right-click on a shape, select "Add Shape", then "Pictures".
  2. URLs: Right-click on a shape, select "Action", then "Hyperlink...". Enter the desired URL.

Now, employees can click on their colleagues' shapes to learn more or reach out.

And there you have it! From Excel data to a live, dynamic org chart in Visio.