Yes. In the Windows desktop version of Visio, the Organization Chart Wizard can turn an Excel employee list into an org chart by matching each person to their manager. Prepare a clean table with one person per row, then use File > New > Organization Chart to start the import.
How the Excel-to-Visio process works
Visio reads the rows in your workbook and uses the employee and manager fields to determine reporting relationships. It then creates a diagram of shapes and connectors, with each person represented by a shape and each manager-to-employee relationship shown as a reporting line. Optional fields, such as job title, department, telephone number, and email address, can be included as shape information or displayed in the chart, depending on the wizard choices and your Visio version.
This is a way to create a diagram from structured data, not a magic conversion of any spreadsheet into an org chart. A payroll workbook with several tabs, subtotals, or unrelated columns will need to be cleaned and mapped first. The source table must make the hierarchy clear: each employee normally has one direct manager, and the top person in the chart has no manager listed.
The import is also distinct from a continuously synchronized report. Treat the resulting diagram as a generated Visio document unless you deliberately set up a separate data-linking workflow. Editing a cell in Excel should not be assumed to rearrange the Visio chart automatically.
Prepare the Excel workbook
Make a simple worksheet with one header row and one row for every person. The essential information is a field identifying each employee and a field identifying that employee’s direct manager. A practical layout might be:
- Name: Jordan Lee
- Reports to: Priya Shah
- Title: Operations Manager
- Department: Operations
- Email: jordan.lee@example.com
For the organization’s top leader, leave Reports to blank. Use the same spelling for a manager in the manager’s own Name field and in each direct report’s Reports to field. If two employees share a name, use a distinctive name format or add an employee identifier if the wizard offers a suitable field mapping; otherwise, the hierarchy can be ambiguous. Avoid using a person’s title as the relationship field: job titles describe roles, while Reports to identifies the actual reporting link.
Keep the source range tidy. Remove merged cells, blank rows within the list, introductory notes above the headers, and totals or footers. Do not rely on cell color, indentation, or visual grouping to express who reports to whom; the wizard uses the data values. Save the workbook as an Excel file, such as .xlsx, and note which worksheet contains the roster.
Import the roster with the Organization Chart Wizard
- Open Visio for Windows and choose File > New > Organization Chart. Select the Organization Chart template and choose Create if that button appears in your version.
- In the wizard, choose the option for information already stored in a file or database. Select the Excel workbook as the data source and browse to the file.
- Choose the worksheet or range containing the roster when prompted. Confirm that the first row contains column headings if the wizard asks.
- Map the column that contains each person’s name and the column that indicates who they report to. Map optional fields such as title or department if you want them available in the diagram.
- Choose which employee details to show on the shapes and how many organization levels to display on each page. Complete the remaining layout choices and let Visio generate the chart.
Labels and wizard screens can vary somewhat across desktop releases. The key choice is to import existing information, then identify the employee and manager fields correctly. If the Organization Chart template or wizard is absent, check that you are using an installed Windows desktop edition that includes it. The browser-based Visio app does not provide the same Excel-import wizard.
Choose what appears on the chart
A chart can become hard to read when every available spreadsheet field is printed inside every shape. For a leadership overview, name and title may be enough; department can be useful when teams are arranged across functional lines. Phone numbers, email addresses, office locations, and employee IDs may be better kept as shape data rather than displayed as visible text.
Consider the intended use before choosing the layout. A chart for a staff directory may need contact details and multiple pages. A chart for a presentation should emphasize structure and remain legible at the size it will be shown. Visio’s organization-chart tools provide layout and formatting options, but a very large company chart may still need to be divided by department, location, or management level. This is a presentation decision, not a change to the underlying reporting data.
Check the result against the source roster before sharing it. Confirm that the top leader appears at the top, the expected managers have the right teams, and no employee has been left out because of a blank or misspelled manager name. A diagram can look orderly even when its underlying links are wrong, so visual polish is not a substitute for checking the data.
Updating the chart after Excel changes
The wizard creates a Visio diagram from the information it reads at import time. If someone changes a manager, adds a new employee, or renames a department in Excel, do not assume that the existing diagram will update or reflow on its own. Depending on how the chart was created, some imported values may be stored with Visio shapes, but that does not mean the whole organizational structure remains synchronized with the workbook.
For a small change, you can edit the Visio diagram directly, but then the workbook and diagram can disagree. For a recurring roster update, keep the Excel file as the authoritative source, document the import settings, and generate or revise the chart from the updated data using a repeatable process. Review the generated chart after each import, especially if you have manually changed shape positions, formatting, or page breaks. A new generation may not preserve every manual adjustment in the way you expect.
Visio has separate features for linking external data to shapes and refreshing linked data. Those features are not the same as automatically rebuilding an organization chart’s hierarchy from an edited Excel roster. If you need scheduled refreshes or a governed employee directory, verify the specific capabilities of your Visio edition and consider whether a dedicated reporting or HR system is more appropriate.
Common import problems and fixes
- People appear at the wrong level: Check the Reports to values for spelling, extra spaces, and inconsistent versions of the manager’s name. Make sure the column is mapped as the reporting relationship, not as a descriptive field.
- The chart has no clear top person: Leave the top person’s manager field empty, and check that other rows do not point to a misspelled or nonexistent manager.
- Duplicate names cause confusing links: Use distinctive full names consistently. If your data and wizard mapping support it, use a unique identifier to make people unambiguous; do not expect a common first name alone to identify a manager reliably.
- Some rows are missing: Check that the selected worksheet or range includes the entire roster and that headers are not being treated as employee data. Remove blank lines or unrelated records that interrupt the list.
- The chart is too crowded: Display fewer fields, limit the number of levels on a page, or create separate charts for appropriate divisions. A single chart is not always the clearest way to show a large or distributed organization.
Also check the source for circular reporting relationships, such as A reporting to B while B reports to A. A hierarchy needs a coherent top-to-bottom structure; contradictory relationships cannot be made clear by changing colors or connector styles.
Visio desktop, Visio for the web, and Excel alternatives
The full Excel-based Organization Chart Wizard is a Windows desktop Visio workflow. Visio Plan 2 includes the desktop application, and certain perpetual desktop editions also provide organization-chart features; exact capabilities depend on the edition and release. Visio for the web is useful for viewing and editing supported diagrams in a browser, but it does not offer the same wizard for building an org chart directly from an Excel roster. A Mac user can access Visio for the web in a browser, but should not expect the Windows desktop import steps to be available there.
If you only need a simple chart and do not have desktop Visio, Excel itself can create a basic hierarchy graphic using Insert > SmartArt > Hierarchy. That approach is convenient for a small, mostly manual diagram, but it is not the same as importing a roster and mapping manager relationships through Visio’s wizard. For a few people, a manually built diagram in a tool already available to you may be faster. For a large roster or repeated updates, using structured employee data and a tool designed for data-driven diagrams is generally easier to maintain.
Licensing and practical planning
Whether you can follow the import steps depends on having a Visio desktop edition that includes the Organization Chart Wizard, not merely an Excel workbook or a browser login. Microsoft changes subscription bundles and regional pricing, so check the current Visio plan comparison and your organization’s license details before buying or assigning a plan. If you already have Visio installed, look for the Organization Chart template before changing licenses.
Before a company-wide import, also consider who is allowed to access the source file and the generated diagram. Employee names, reporting relationships, contact information, and role details can be sensitive organizational information. Store and share the workbook and Visio file under the same access rules your organization applies to staff directories, and remove optional personal details that viewers do not need.
Frequently Asked Questions
Can Visio create an org chart directly from an Excel spreadsheet?
Yes. Use the Organization Chart Wizard in Visio for Windows desktop, select the Excel workbook, and map the employee-name and Reports to columns. The data needs to be arranged as a clean roster.
Does the Visio org chart update automatically when Excel changes?
Do not count on automatic hierarchy updates from the wizard. It generates the chart from the data available during import. Re-import or revise the diagram using a defined update process, and check the result against the latest roster.
Can I create the chart in Visio for the web?
The web app does not include the same Excel-based Organization Chart Wizard found in Windows desktop Visio. You can use a desktop edition with the wizard, or consider a basic SmartArt hierarchy in Excel for a small manual chart.
What columns are required for a Visio org chart?
At minimum, provide a name for each employee and a field identifying that person’s direct manager. Leave the manager field blank for the top person. Title, department, and contact details are optional additions.
Can one employee report to two managers in this chart?
A standard organization chart represents a hierarchy in which each person has one direct reporting link. If the real structure includes matrix relationships, show the primary reporting line in the org chart and represent secondary relationships separately so the diagram does not imply a simple hierarchy that is not accurate.
Related
- Microsoft Excel Format Cells: A Practical Guide for Data
- Microsoft Excel Employee Schedule Template: Setup Tips
- Microsoft Excel Debt Payoff Template: Build a Reliable Plan
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Histogram by Category: Methods, Bins, and ExamplesTo make an Excel histogram by category, first use the same numeric bin boundaries for every category, then…
- How to Save a Graph in Excel as a Picture: PNG or JPGTo save a graph (which Excel calls a chart) as an image in Microsoft Excel for Microsoft 365…
- Create a Pivot Chart in Excel: A Step-by-Step GuideTo create a PivotChart in Microsoft Excel for Microsoft 365 on Windows, select a cell in your data,…
- Excel Bar and Whisker Chart: How to Create and Read OneAn Excel bar and whisker chart, more commonly called a box-and-whisker chart or box plot, summarizes the distribution…
- Balloon Chart in Excel: A Step-by-Step TutorialTo make a balloon chart in Excel for Microsoft 365 on Windows, arrange your data in columns for…
- Google Sheets Gantt Chart Tutorial: Build a Project TimelineTo make a Gantt chart in Google Sheets, put each task and its start and end dates in…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.