Yes. In the Visio desktop app for Windows, prepare an Excel worksheet with each person’s name and the name of their manager, then use Visio’s Organization Chart Wizard to import the workbook and generate the chart. Excel supplies the hierarchy and optional employee details; Visio turns those rows into editable shapes and connectors.
What the Excel-to-Visio process does
An Excel org-chart worksheet is a data source, not a finished diagram. Each row represents one person, and a reporting field identifies that person’s manager. Visio reads those relationships to place people in a hierarchy, then creates boxes and reporting lines. You can adjust the appearance and layout in Visio after the import.
This is different from copying a table or pasting an Excel range into a Visio page. Copying produces a table-like object; it does not automatically infer who reports to whom. The wizard builds a structure from the relationships in the worksheet, so the quality of the result depends on accurate, consistent source data.
The instructions below are for Visio desktop on Windows, such as Visio Plan 2. Visio for the web and different licenses may not offer the desktop Organization Chart Wizard. Excel can be used to prepare the workbook on Windows or Mac, but Visio does not have a native macOS desktop app. If you only have Visio for the web, check its current features and your organization’s license before planning to create the chart there.
Prepare the Excel worksheet
Keep the source data in a simple rectangular range: one header row, one employee per row, and no merged cells or blank rows within the list. A small example might have columns named Name, Reports to, Title, Department, and E-mail. Name and Reports to provide the core hierarchy; other columns can supply information displayed on the employee shapes, depending on the wizard’s field-mapping options.
For example, the rows might identify Priya Shah as the Chief Executive Officer with no manager, Luis Moreno as a Finance Director reporting to Priya Shah, and Dana Kim as an Accountant reporting to Luis Moreno. The Reports to value must match the manager’s name as it appears in the Name column. In this example, entering Luis M. in Dana’s row when the manager’s Name value is Luis Moreno can prevent Visio from recognizing the intended relationship.
- Use a single, consistent name format. If two employees have identical names, distinguish them consistently, such as by adding a department to each name, and use that exact wording in the Reports to column.
- Give the top person in the chart a blank Reports to cell. Do not list the top person as reporting to themself.
- Check for spelling differences, trailing spaces, duplicate entries, and managers who are missing from the employee list.
- Keep titles and departments in separate columns if you want to map them separately in Visio.
- Remove unrelated notes, totals, and decorative rows from the import range.
It is helpful to convert the data range into an Excel table using Insert > Table, with the option indicating that the table has headers selected. A table makes the source easier to maintain as rows are added, although it does not by itself keep a generated Visio diagram synchronized. Save the workbook in a location you can access from Visio.
Import the workbook with Visio’s wizard
Open Visio for Windows and choose File > New. Search for Organization Chart, select the organization chart template, and choose Create. Depending on the Visio build and how templates are displayed, the template may appear directly under File > New rather than in search results. The Organization Chart Wizard should guide you through the source and layout choices.
- On the wizard’s source choice, select the option to create the chart from information already stored in a file or database.
- Choose the Excel workbook as the source, browse to the saved file, and select the worksheet or range containing the employee list.
- Identify the fields that contain the person’s name and the person they report to. If Visio does not recognize the column headings automatically, select the appropriate source columns in the field-mapping step.
- Choose which additional information, such as title, department, telephone number, or e-mail address, should appear on the shapes. The available fields depend on the source columns and wizard options.
- Review the diagram and page options offered by the wizard, then complete the steps to create the chart.
Labels in the wizard can vary somewhat between releases, but the key decisions remain the same: select the Excel source, identify the name and reporting fields, and choose any extra details to show. If the chart looks incomplete, do not assume Visio has randomly omitted people. First confirm that the selected worksheet or range includes every employee row and that each manager reference matches a name in the source.
Arrange and format the finished chart
The wizard creates an initial layout; it does not know which people or teams deserve visual emphasis. Review the reporting lines and page breaks, especially in a large organization. In Visio, you can move or format shapes, adjust the chart’s layout, and edit the text shown in a box. Keep a clear distinction between changing the diagram’s presentation and changing the underlying employee information: editing one does not necessarily update the other.
Decide how much information belongs inside each box. A name and title are often enough for a readable overview. Adding a long list of contact details can make boxes crowded and force the diagram across more pages. For a chart intended for printing, use a test print or print preview to check that names are legible, reporting lines are easy to trace, and page breaks do not split teams awkwardly.
For a large chart, consider whether the audience needs the whole organization at once or a focused view of one department. A single enormous page may be technically complete but difficult to read. Visio’s layout and page options can help distribute content, while a carefully scoped chart can be easier for staff to navigate. Preserve a copy of the source workbook and the original generated diagram before making extensive manual layout changes.
Keeping the chart current
Importing an Excel workbook creates a diagram from the information provided at that time. Do not assume that editing a cell later will automatically rearrange the Visio chart. The Organization Chart Wizard’s import should be treated as a generated chart unless your specific workflow explicitly establishes and verifies data links. A diagram may contain shape data without being a live, automatically updating view of the workbook.
When the organization changes, update the source data carefully and regenerate or revise the chart using the method supported by your Visio version. If you choose to use Visio’s separate data-linking features, check that the shapes are actually linked to the intended workbook and that a refresh updates the fields and relationships you care about. A refresh of linked shape data should not be assumed to rebuild every hierarchy or layout decision. Test the update process on a copy before relying on it for an important chart.
For a recurring monthly or quarterly update, establish a simple owner and process: maintain one authoritative workbook, record which worksheet or table is the source, and document how the Visio file is regenerated or refreshed. This avoids the common problem of one department editing an old workbook while another publishes a chart from a newer version.
Common import problems and fixes
- People appear under the wrong manager: Compare each Reports to value with the exact manager name in the Name column. Look for inconsistent abbreviations and duplicate names.
- The top person is missing or treated as a subordinate: Check that the top person has a row and a blank Reports to value. Confirm the wizard is using the correct name field.
- Only some employees appear: Recheck the selected worksheet, table, or cell range. Data placed below a gap or outside the selected range may not be included.
- Boxes show the wrong details: Return to the field mapping choices or edit the shape text. A column called Department cannot reliably populate a title field if the columns were mapped incorrectly.
- The chart is hard to read: Reduce the information shown in each box, adjust the layout, or make a focused chart for a specific team rather than squeezing every detail onto one page.
- The workbook changed but the chart did not: Check whether the diagram is linked to the workbook. If it is a generated import without an active data link, update or regenerate the chart instead of expecting an automatic refresh.
Before publishing, verify a few reporting paths from the top of the organization down to individual employees. This catches errors that may be less obvious than a missing shape, such as a person appearing under a similarly named manager.
When Excel and Visio are a good fit
Excel is useful when employee information already exists in a spreadsheet, when several people need to review the source list, or when the chart must be recreated after changes. Visio is useful when the result needs polished diagram layout, editable shapes, connectors, or print-ready pages. Together, the programs separate the structured employee list from the visual presentation.
For a very small team with a stable structure, drawing the chart directly in Visio may be faster than preparing a workbook. For a complex hierarchy, using Excel can reduce repetitive shape creation, but it does not remove the need to validate data or arrange the final result. If the organization needs a continuously maintained directory rather than a periodically published diagram, a directory or HR system may be a more suitable authoritative source; the chart can then be treated as a presentation of selected information.
Access, licensing, and employee data
Visio availability depends on the product and license assigned to the user. The desktop wizard described here requires an edition that includes the Visio desktop app; a web-only entitlement may not provide the same creation workflow. License names and included features can change, so check the current Microsoft plan details or ask your organization’s administrator rather than relying on an old price or feature comparison.
An org chart can expose personal or business-sensitive information, including names, job roles, phone numbers, and reporting relationships. Include only details the audience needs, store the workbook and Visio file in an approved location, and apply the appropriate sharing permissions. Before sending a chart outside the organization, review both visible labels and any employee information retained in shape data, then remove details that should not be shared.
Frequently Asked Questions
Can Excel automatically create an org chart in Visio?
Excel does not create a Visio diagram by itself. Prepare the employee rows in Excel, then use the Organization Chart Wizard in Visio desktop for Windows to import the workbook and generate the chart.
What columns does the Excel file need?
At minimum, provide a person’s name and a Reports to value that matches the manager’s name in the list. A top-level person normally has a blank manager field. Columns such as title, department, phone, and e-mail are optional.
Can I make the chart in Visio for the web?
The workflow described here uses the Windows desktop Organization Chart Wizard. Visio for the web has different capabilities, so check the current web app and your license before expecting it to import Excel data in the same way.
Will a change in Excel update the Visio org chart automatically?
Not necessarily. A generated chart should be treated as a point-in-time result unless you have explicitly created and tested a data-linking workflow. Updating the workbook may require you to regenerate or revise the diagram.
Can I create an org chart from Excel on a Mac?
You can prepare and save the Excel workbook on a Mac. Visio does not offer a native macOS desktop app, however, so use the Windows desktop wizard on a suitable computer or check whether the available Visio web features meet your needs.
Related
- Resource List Excel Template: Set Up, Track, and Share
- Replace in Excel: Find and Replace Text, Values, and More
- Resize Columns in Excel: Keyboard Shortcuts and Tips
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Pivot Table Charts in Excel: Create, Format, and UseYes. In Microsoft Excel for Microsoft 365 on Windows, click inside a PivotTable, choose PivotTable Analyze > PivotChart,…
- EBITDA Waterfall Chart in Excel: Build It Step by StepTo make an EBITDA waterfall chart in Excel, list opening EBITDA, each positive or negative driver, and closing…
- Excel Power Pivot Incremental Load: What WorksExcel Power Pivot does not have a built-in incremental refresh policy that keeps old rows and imports only…
- Excel Dashboard vs Power BI: Which Should You Choose?Excel is usually the better choice for a small, flexible dashboard built around spreadsheets; Power BI is usually…
- Excel Pivot Table Not Updating? Fix Refresh IssuesIf your Excel pivot table is not updating when you refresh, the most common cause is that new…
- Power Pivot Many-to-Many Relationships ExplainedPower Pivot does not model a many-to-many relationship as a direct link between two tables when both sides…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.