Office Settings & Configuration

How to Use the Visio Organization Chart Wizard in Microsoft 365

Nimra Malik Oct 8, 2026 869 views

Question details

The user wants to use the Organization Chart Wizard to import data from Excel into a Visio diagram, and needs solutions for when the wizard is unavailable or missing.

How to Use the Visio Organization Chart Wizard in Microsoft 365

Product: Microsoft Visio
Device & OS: not provided
Scenario: Creating an organizational chart in Visio using templates and importing external data from Excel.
Observed behavior: The user needs to locate the import tool, but the Organization Chart Wizard is sometimes missing due to incorrect editions, subscription limitations, or outdated application versions.

Before you start

Ensure you have your organizational data prepared in an Excel spreadsheet and verify that you have an active Microsoft 365 subscription that includes desktop Visio support.

Solution 1Recommended

Import Excel Data using the Organization Chart Wizard

Use this method when you have your employee data ready in an Excel file and want to automatically generate a Visio org chart.

The Organization Chart Wizard allows you to automatically generate a structured diagram based on your Excel data. This saves time compared to manually drawing and linking shapes.

Open an Organization Chart Template

Launch Visio and choose to open or create a new diagram based specifically on an organization chart template.

Access the Import Tool

Navigate to the Organization Chart tab on the top ribbon.

Import Your Data

Click the Import button and follow the on-screen prompts to select and load your Excel data file into the diagram.

Import Excel Data using the Organization Chart Wizard

Formatting Tip: Ensure your Excel spreadsheet has clear column headers like 'Name', 'Title', and 'Manager' to help the wizard accurately link the organizational hierarchy.

Solution 2

Troubleshoot a Missing Organization Chart Wizard

Follow these steps if you cannot find the Organization Chart tab or the Import button in your Visio application.

Free Microsoft Office alternative

Create Professional Diagrams with WPS Office

If your Microsoft 365 subscription doesn't support the Visio wizard, you can easily create professional organization charts using WPS Presentation. WPS Office is a free, lightweight suite that offers built-in SmartArt features and excellent compatibility with Microsoft Office formats.

1. Open WPS Presentation: Launch WPS Office and create a new blank presentation slide.
2. Insert SmartArt: Navigate to the Insert tab on the ribbon and click on SmartArt.
3. Select Hierarchy Layout: Choose the Hierarchy category, select an Organization Chart layout, and easily type in your structural data.

Free and lightweight Microsoft Office alternativeEasily create organizational charts using built-in SmartArt toolsFully compatible with Microsoft Word, Excel, and PowerPoint formatsFamiliar interface for seamless migration and quick learning

microsoft office alternative - wps office

Frequently Asked Questions

Why is the Organization Chart Wizard missing in my Visio?

The wizard may be unavailable if your specific Visio edition or Microsoft 365 subscription does not include advanced data features, if you are not using an organization chart template, or if your application requires an update.

What file formats can I use to import data into the Visio Org Chart Wizard?

You can typically import data from Microsoft Excel (.xlsx or .xls) spreadsheets, text files (.csv or .txt), or directly from an Exchange Server directory.

How do I check my current Visio version?

Open Visio, click on the File tab, and select Account. Your subscription details, edition, and exact version number will be displayed on the right side under Product Information.

Office App Problems