✦Template Printable Ideas Insights

Convert Visio Org Chart to Excel Format: Simple Steps

By

Looking to create an organizational chart in Microsoft Excel, but prefer the functionality and visual appeal of Visio? You're not alone. Many professionals choose to create their org charts in Visio due to its robust tools and features, but then face the challenge of integrating this Visio org chart into their Excel documents or presentations. The good news is, it's not only possible but also quite straightforward. Let's delve into how you can format and insert your Visio org chart into Excel.

Before we dive into the process, ensure you have both Visio and Excel installed on your computer. You'll need the professional version of Visio to save your chart as an EMF (Enhanced Metafile) file, which can then be inserted into Excel.

Preparing Your Visio Org Chart

First, you'll need to finalize your org chart in Visio. Once you're satisfied with the design, layout, and content, it's time to save and prepare the file for Excel.

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 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
a flow chart with several different types of language and their corresponding words, including thesauruss
a flow chart with several different types of language and their corresponding words, including thesauruss

Saving Your Visio File as EMF

Microsoft Excel can only read EMF files from Visio. Here's how to save your org chart in this format:

  1. Click on "File" in the Visio ribbon, then select "Save As".
  2. Browse to the location where you want to save your file, name it, then click the dropdown arrow to the right of the "Save as type" field.
  3. Select "Enhanced Metafile (EMF)" from the list, then click "Save".

Inserting Your Visio Org Chart into Excel

Now that you've saved your Visio org chart as an EMF file, let's insert it into your Excel document.

31+ Free Organogram Templates & Organizational Charts
31+ Free Organogram Templates & Organizational Charts
How to Create an Organizational Chart in Word with Free Templates | EdrawMax
How to Create an Organizational Chart in Word with Free Templates | EdrawMax
school-organizational-chart.gif (769×474)
school-organizational-chart.gif (769×474)
  1. Open your Excel document, and navigate to the cell where you want to place the top-left corner of your org chart.
  2. Click the "Insert" tab in the Excel ribbon, then select "Picture" from the "Illustrations" group.
  3. Browse to the location where you saved your EMF file, select it, and click "Insert".

Your Visio org chart should now appear in your Excel document. You can resize, rotate, and position it as needed.

Formatting Your Visio Org Chart in Excel

Once you've inserted your org chart, you can format it directly in Excel to match the rest of your document.

Resizing Your Org Chart

To resize your org chart, simply click and drag one of the corners of the chart. You can also use the "Format" tab in the "Picture Tools" ribbon to precisely adjust the size.

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)
Editable Organizational Chart Template - Excel & Google Sheets - Customize Your Company Structure, Visualize Roles and Hierarchy
Editable Organizational Chart Template - Excel & Google Sheets - Customize Your Company Structure, Visualize Roles and Hierarchy
Org Chart, Organizational Chart, Business Plan, Business Strategy, Company Org Chart, Company Organization Template, Company Structure
Org Chart, Organizational Chart, Business Plan, Business Strategy, Company Org Chart, Company Organization Template, Company Structure
41 Organizational Chart Templates (Word, Excel, PowerPoint, PSD)
41 Organizational Chart Templates (Word, Excel, PowerPoint, PSD)
How to Make an Organizational Chart in Excel - Tutorial
How to Make an Organizational Chart in Excel - Tutorial
25+ FREE Editable Organizational Chart Templates - Besty Templates
25+ FREE Editable Organizational Chart Templates - Besty Templates

Rotating Your Org Chart

To rotate your org chart, click and drag the green rotation handle in the top-middle of the chart. Alternatively, you can use the "Format" tab in the "Picture Tools" ribbon to rotate the chart in precise increments.

With these steps, you can seamlessly integrate your Visio org chart into your Excel documents. Whether you're creating a report, presentation, or dashboard, this method allows you to leverage the best features of both Microsoft Visio and Excel. Happy formatting!

a family tree is shown with many people in the same group, including two men and one woman
a family tree is shown with many people in the same group, including two men and one woman
How to Make an Organizational Chart in Excel - Tutorial
How to Make an Organizational Chart in Excel - Tutorial
an organization chart with the words manager, employee and employee's name on it
an organization chart with the words manager, employee and employee's name on it
Organizational Chart Maker
Organizational Chart Maker