Yes. You can use an Excel workbook as the source for an organization chart in the Visio desktop app: arrange employee names and reporting relationships in columns, then use Visio’s Organization Chart Wizard to build the diagram. Excel supplies the data; Visio creates and formats the chart.
What Excel and Visio Each Do
An org chart is a visual representation of who reports to whom. Excel is useful for maintaining the underlying roster because rows and columns make it straightforward to enter names, roles, departments, and manager relationships. Visio is designed to turn that structured information into a diagram made of connected shapes.
That distinction matters: typing a roster into Excel does not, by itself, create a native Visio diagram. The usual process is to save the workbook and import it through Visio’s Organization Chart Wizard. You can also create a small chart manually in Excel with SmartArt, but that is an Excel graphic rather than a Visio file, and it may be harder to manage when the reporting structure is large or changes often.
The import option is most useful when you already have employee data in a spreadsheet or need a diagram with many positions. For a quick picture of a small team, building the chart manually may take less time. For a frequently changing organization, keeping the data in a well-maintained source workbook can make revisions less error-prone, even though you should not assume every version of Visio automatically keeps the diagram synchronized with Excel.
Prepare the Excel Workbook
Put one employee or position on each row, with a header row naming each field. The essential information is the person’s name and the name of the person they report to. Optional fields can supply details shown in the Visio shapes, such as job title or department. A simple example might look like this:
- Name: Jordan Lee; Reports To: blank; Title: Chief Executive Officer.
- Name: Casey Morgan; Reports To: Jordan Lee; Title: Director, Operations.
- Name: Sam Patel; Reports To: Casey Morgan; Title: Operations Manager.
In this example, the blank manager field identifies the top position. Casey reports to Jordan, and Sam reports to Casey. The reporting relationship—not the order of rows or the indentation of text—is what lets Visio determine the hierarchy. Arrange rows in a convenient order for people reviewing the workbook, but do not rely on row order to communicate who reports to whom.
Before importing, check the sheet for practical data problems:
- Use consistent, clearly labeled column headings and avoid blank rows within the employee list.
- Make manager names match the corresponding entries in the Name column exactly. A spelling difference or extra space can prevent a relationship from being recognized.
- Make names unambiguous. If two people have the same name, use a distinguishing label, such as a middle initial or a team identifier, in the value used to identify them.
- Check that each person has one intended manager, except for the top position, and that there are no circular reporting relationships.
- Save the file as an Excel workbook, such as an .xlsx file, and note which worksheet contains the roster if the workbook has several sheets.
Keep any extra columns focused on details that help readers understand the chart. A phone number or email address may be useful in an internal directory, while salary, personal contact details, or other confidential information usually does not belong in a broadly shared org chart.
Import the Spreadsheet in Visio
In Visio for Microsoft 365 on Windows, start by opening the desktop application and choosing File > New. Find the Organization Chart template, select it, and choose Create. The Organization Chart Wizard should open. Choose the option for information already stored in a file or database, select the Excel-file option, and browse to your workbook. Wording and screens can vary somewhat by Visio edition.
- Choose the worksheet or range containing the roster when the wizard asks where the data is stored.
- Tell Visio which field identifies each person and which field identifies that person’s manager. In the example above, those are Name and Reports To.
- Map any additional spreadsheet fields—such as Title or Department—to the corresponding information fields offered by the wizard.
- Review any layout or chart options the wizard offers, then finish the import and inspect the resulting diagram.
Visio uses the manager relationship to place people in levels and connect them to their managers. Optional fields can appear as text in the shapes, depending on the field mapping and layout choices. If the result looks wrong, check the source data before rearranging shapes: a misplaced person often indicates an incorrect or unmatched Reports To value rather than a drawing problem.
The Organization Chart Wizard is a desktop Visio feature, and availability depends on the edition and license. If you do not see the template or wizard, check whether your Visio plan includes the desktop application and this feature. Visio for the web has different capabilities and does not provide the same desktop import workflow in every plan. Excel for Mac can prepare and save the workbook, but Visio does not have a native macOS desktop app; use a supported Visio web workflow or a Windows computer with the desktop app for the wizard-based import.
Arrange and Review the Result
The first layout Visio creates is a starting point, not a guarantee that the chart is ready to publish. A large organization may spread across multiple pages, and a long title or unusually deep reporting structure can make shapes crowded. Review the overall hierarchy, page breaks, connector lines, and the text inside representative shapes.
For example, suppose a department has a vice president, four directors, and several managers under each director. Confirm that each director appears under the vice president and that each manager appears under the correct director. Then inspect the chart at a readable zoom level and consider whether a page layout, orientation, or division into department-level charts will make it easier to follow.
Use Visio’s drawing tools to refine spacing, presentation, and labels after the relationships are correct. If a person appears under the wrong manager, fix the source relationship and rebuild or update the diagram as appropriate instead of merely dragging the shape. Otherwise, the visual placement can disagree with the roster and create confusion the next time someone checks the data.
Keeping the Chart Current
An imported chart should be treated as a point-in-time view unless your specific Visio workflow explicitly supports refreshing the source data. A change to the Excel workbook does not necessarily move shapes or update labels in an already-created Visio diagram automatically. Refresh and data-link behavior can depend on the Visio edition, how the diagram was created, and how the workbook is stored.
For a reliable update process, keep the source workbook in a known location, record when the diagram was last generated, and decide who is responsible for updating it. For a small change, it may be practical to edit the diagram directly, but also update the roster so the two records do not diverge. For a substantial reorganization, correct the Excel data and use the supported import or refresh process for your Visio version, then review the whole chart for moved positions and outdated labels.
Before sharing a revised chart, compare a few reporting lines against the current roster and check that former employees or vacant positions are represented intentionally. If the diagram is a formal reference for staff, include a date or version note so viewers can tell whether it reflects the current organization.
Excel Org Chart Versus Visio
Excel has a built-in way to make a simple hierarchy graphic: in Microsoft 365 for Windows, choose Insert > SmartArt > Hierarchy and select a layout. SmartArt is convenient for a small, mostly static chart that you want to place beside spreadsheet data. You add and format the text as a graphic; it is not the same as importing a table of manager relationships into Visio.
Visio is generally a better fit when you need a dedicated diagram, more control over page layout, or a chart generated from an existing roster. The import wizard can save time compared with drawing many boxes and connectors by hand. Excel SmartArt may be quicker when the chart has only a few positions and is unlikely to change. Neither option removes the need to verify the underlying reporting information.
PowerPoint also offers SmartArt hierarchy graphics and can be a convenient choice when the main goal is a presentation slide. A dedicated HR or directory system may be more suitable when the organization needs permissions, frequent changes, and a maintained employee database. The right choice depends on whether the priority is a quick visual, a structured diagram, or ongoing management of employee records.
Common Import Problems
If Visio cannot place an employee correctly, start with the reporting data. A manager value that does not exactly match a name, a missing manager, or a duplicate identifier can disrupt the hierarchy. Check whether the top position has been identified correctly, whether any person accidentally reports to themselves, and whether a chain of managers loops back to an earlier person.
If fields appear in the wrong part of a shape or are missing, revisit the wizard’s field mapping and verify the column headings and cells in Excel. If the chart is too wide or difficult to read, that is often a layout issue rather than a failed import. Try a different page arrangement or create separate charts for divisions when one diagram would be unwieldy.
If the import option is unavailable, confirm that you are using the Visio desktop application and an edition that includes the Organization Chart Wizard. A workbook can still be prepared in Excel on another platform, but the ability to import it depends on Visio, not on Excel alone. Avoid assuming that copying and pasting the worksheet into Visio will create a connected organization chart; it may only place a table or static content on the page.
Sharing, Privacy, and File Management
Org charts can reveal internal structure, staff names, job titles, and contact details. Include only information necessary for the chart’s audience. Before distributing the Visio file or a PDF export, check the visible page and any included data fields, and follow your organization’s rules for storing and sharing employee information.
Keep the Excel source and Visio output clearly named and stored in an approved location. A useful naming convention can include the department and an update date, such as “Operations Org Chart – 2026-11.” If a workbook contains sensitive columns that are not meant for the diagram, omit them from the chart and restrict access to the source file as appropriate. A clean diagram can be widely useful without exposing every detail in the underlying roster.
Frequently Asked Questions
Can Excel create a Visio org chart by itself?
Excel can hold the employee data and can make a basic hierarchy graphic with SmartArt, but it does not create a native Visio diagram by itself. Use the Organization Chart Wizard in a supported Visio desktop edition to import the workbook.
What columns do I need in Excel?
At minimum, provide a field identifying each person and a field stating who that person reports to. Add optional fields such as title or department if they will help readers interpret the chart. The top position normally has no manager listed.
Does the Visio chart update when I edit Excel?
Not necessarily. An imported diagram may represent the data as it existed when it was created. Whether a refresh is available depends on the Visio version and import or linking method, so verify your workflow before relying on automatic updates.
Can I import the Excel org chart on a Mac?
You can prepare the workbook in Excel for Mac, but Visio has no native desktop app for macOS. The desktop Organization Chart Wizard is a Windows workflow; use the Visio web features available to your plan or a Windows device if you need that import method.
Can Visio make an org chart without Excel?
Yes. You can create an organization chart manually in Visio by adding and connecting shapes. That can work well for a small chart, while importing structured data is often more convenient for a larger roster or one that already exists in a spreadsheet.
Related
- Subscript in Excel: Shortcut Key and How to Apply It
- Excel Strikethrough Shortcut: Windows, Mac, and More
- Stop Excel Converting Text to Dates Before It Happens
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Average for Every 5-Unit X-Axis RangeTo find the average Y value in each 5-unit X-axis range in Excel, put the X values in…
- Excel Pivot Table Slicer Greyed Out? How to Fix ItIf Excel’s Insert Slicer command is greyed out, first click a cell inside the PivotTable you want to…
- Manual Sort Pivot Chart in Excel: Control Category OrderTo manually sort a PivotChart in Excel for Microsoft 365 on Windows, reorder the chart’s categories in its…
- Matrix Bubble Chart in Excel: How to Build and Format OneYes. In Excel for Microsoft 365 on Windows, put each item’s numeric X position, numeric Y position, and…
- Excel Dashboard: Build a Useful Interactive ReportYes—you can build an interactive dashboard in Microsoft Excel by organizing data in a table, summarizing it with…
- Excel Graph Legend: How to Add, Format, and Fix ItAn Excel graph legend explains which data series—or, in some chart types, which categories—are represented by the chart’s…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.