Excel to Visio Org Chart: Import, Map, and Troubleshoot

Charts & pivot tables · Updated November 19, 2026

Yes. In Visio for Windows, choose File > New > Organization Chart > Create, select employee information stored in an Excel file, and map the columns for each person and their manager. A clean table with one row per employee makes the import easier and helps Visio build the reporting structure correctly.

What happens when you import Excel data into Visio

Visio uses the relationships in your spreadsheet to arrange people in an organization chart. The key information is who each employee is and who they report to. Columns such as job title, department, phone number, and email address can supply additional details for the shapes, but those details do not establish the hierarchy.

For example, a small table might have columns called Employee ID, Name, Reports To ID, Title, and Department. An employee’s Reports To ID points to the Employee ID of their manager. Visio can use that relationship to place the employee below the manager. The highest-level person normally has no manager, so that person’s Reports To ID is blank.

The wizard creates a diagram from the rows it reads; it does not turn the workbook into a continuously synchronized, two-way org chart. Treat the result as an imported version of the data unless you deliberately set up a separate data-linking workflow. Changes made to the chart should not be assumed to update the Excel source.

Prepare the Excel workbook first

Organize the source as a simple rectangular table: one header row followed by one row per person. Keep each value in its own cell, avoid merged cells and blank rows inside the list, and use clear, consistent column headings. A formatted Excel Table can make the range easier to manage, although the important point is that Visio can identify the correct rows and columns.

  • Use a unique identifier where possible. Names are readable, but two employees can share a name. An employee number or other stable ID helps distinguish them. Include a manager ID that refers to the manager’s ID, rather than relying on spelling if your wizard offers those identifier fields.
  • Check every reporting relationship. Each manager reference should match a person in the employee list. The top leader’s manager field should be empty, not filled with a made-up name such as CEO or None.
  • Keep the data consistent. Extra spaces, inconsistent spellings, and different forms of the same name can stop a relationship from matching. If you use names as references, make the manager value exactly match the manager’s name in the name column.
  • Include only useful chart details. Title, department, location, and contact information can make shapes more informative, but unnecessary columns can clutter the diagram or expose information that viewers do not need.

For instance, a department head called Priya Shah might have a blank Reports To ID, while an employee who reports to her would have Priya’s ID in that field. The manager’s title and department can be separate columns. Do not sort or group the rows in a way that suggests hierarchy is determined by row order: the reporting references are what define the structure.

Import the spreadsheet with the Organization Chart Wizard

In the Visio desktop app for Windows, open the File tab and choose File > New > Organization Chart > Create. Template names and availability can vary by Visio edition, but look for the Organization Chart template or wizard. In the wizard, choose the option for information already stored in a file or database, select an Excel spreadsheet as the source, and browse to the workbook.

  1. Choose the source and worksheet. Point Visio to the workbook and select the worksheet or data range containing the employee list. If the workbook has several sheets, confirm that you are using the sheet with the headers and complete records.
  2. Tell Visio how to identify people. Map the column containing each person’s name, and, when available, select a unique identifier column. Then identify the column that says who each person reports to, or the manager-identifier column if the data uses IDs.
  3. Choose optional shape information. Map fields such as title, department, phone, or email if you want them available on the chart shapes. The wizard’s choices determine which spreadsheet details become shape information; they do not replace the reporting relationship.
  4. Review layout and page choices. Follow the remaining wizard prompts for the chart’s layout and how it is divided across pages, if those options are offered. Finish the wizard, then inspect the generated chart rather than assuming every row was interpreted as intended.

Keep the source workbook available while you work, and note its file name and worksheet. If the wizard cannot find the expected data, check that the selected range includes the header row and the employee records, not a title or introductory note above the table.

Arrange and format the resulting chart

After import, check that the senior leader is at the top and that each team appears under the intended manager. Visio’s org-chart shapes and layout tools can help you reposition or format the diagram, but manual dragging is not a substitute for correcting an incorrect reporting relationship in the source data. If an employee is under the wrong manager, fix the relationship and rebuild or update the chart using an appropriate workflow.

Use the chart to show the level of detail its audience needs. A staff directory may benefit from titles and departments, while a high-level leadership chart may need only names and roles. Adding every available field can make the shapes too large to read, particularly when Visio spreads a large organization across pages.

For a large company, decide whether the goal is one overview chart or several focused charts, such as one per division. A very wide layer of direct reports can also create a crowded page. Page breaks and multiple pages can improve readability, but check that the page structure still makes reporting lines understandable when someone prints or shares the file.

Updating the chart when the spreadsheet changes

An import is not the same as editing the Excel workbook and automatically seeing every change appear in Visio. New hires, departures, title changes, and manager changes may require another import or a deliberate data-refresh setup, depending on the method and edition being used. Even where a data link is configured, do not assume it provides two-way editing or rebuilds the org-chart layout exactly as desired.

For a chart that changes often, establish a repeatable process. Keep a controlled source workbook, use consistent column names and identifiers, and record who is responsible for validating changes. Before replacing a published chart, compare the new result with the previous one: a changed ID, missing row, or blank manager field can alter the structure in ways that are easy to overlook.

For occasional updates, importing a clean, current workbook and reviewing the resulting diagram may be simpler than maintaining a more elaborate connection. If you need updates to flow from a data source, check the capabilities and licensing of your specific Visio desktop edition and test the process on a copy before relying on it for a live directory.

Common import problems and how to fix them

  • People appear under the wrong manager. Verify the reports-to values against the manager’s name or unique ID. A manager reference should point to the correct record, not merely to a department name or job title.
  • Some people are missing. Confirm that the selected sheet or range includes every employee row and that there are no blank rows interrupting the data. Check whether filters or an incomplete selection caused records to be excluded.
  • Duplicate names cause confusion. Use unique employee identifiers and manager identifiers if the wizard supports them. If you must match by name, make names unique enough for the chart and verify every relationship carefully.
  • The chart has several disconnected groups. Check for blank or unmatched manager values. Separate groups may be intentional—for example, independent organizations—but if they are meant to report to one leader, correct the missing link.
  • Shapes show the wrong details or none at all. Revisit the field-mapping choices. A column can contain good data yet remain absent from the diagram if it was not selected as a shape field. Also check that the source cells contain the expected values.
  • The layout is too crowded. Reduce unnecessary shape details, use multiple pages where appropriate, or create separate charts for distinct groups. Avoid shrinking text until it becomes unreadable simply to force the whole organization onto one page.

Visio availability and alternatives

The Excel-based Organization Chart Wizard is a desktop Visio workflow for Windows; available features depend on the Visio edition and license. Visio for the web is useful for viewing and editing supported diagrams, but it does not offer the same desktop wizard workflow for building an org chart directly from an Excel employee list. If the menu path is absent, check the installed Visio edition and its available templates before assuming the workbook is the problem.

Excel itself can display employee data and make a useful directory, but it does not automatically create the same connected org-chart diagram from a reporting list. If you do not have a Visio edition with the wizard, alternatives include building a chart manually in a diagramming tool or using a supported organizational-chart feature in another application. Confirm that any alternative accepts your data format and can represent the reporting relationships you need.

Consider privacy before importing or sharing the file. Employee contact details and reporting information may be sensitive within your organization. Include only necessary fields, store the workbook and Visio file in approved locations, and check sharing permissions before distributing the chart beyond its intended audience.

Frequently Asked Questions

Can I make a Visio org chart from an Excel spreadsheet?
Yes. In a compatible Visio desktop edition for Windows, use the Organization Chart Wizard and map the spreadsheet’s employee and manager information. A tidy table with one employee per row is the best starting point.

What columns should my Excel org chart data have?
At minimum, include a person’s name and the person they report to. A unique employee ID and corresponding manager ID help avoid ambiguity. Optional fields can include job title, department, office, or contact details.

Does Visio update the chart automatically when Excel changes?
Do not assume so. The wizard creates a chart from spreadsheet data, but an ordinary import is not automatically a live, two-way sync. Check your edition and any configured data-linking process, and validate updates before publishing.

Can I create an Excel-to-Visio org chart in Visio for the web?
The desktop Organization Chart Wizard workflow is not the same as Visio for the web. If you need to generate the chart directly from an Excel list, use a compatible Visio desktop edition or choose an alternative that supports spreadsheet-based organization charts.

Why does my org chart have employees in the wrong places?
Visio follows the reporting information you mapped, not the order of people in the worksheet. Check that every manager reference matches the right name or unique ID, and confirm that the wizard mapped the intended columns.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.