How to create an org chart from Excel in Visio

A worked example, stage by stage

1. Rows with no relationships

   Three rows — "Refresh the churn-risk dataset", "Score every account against the churn-risk model" and "Is the risk score above the intervention threshold?" — carry shapes and nothing else. An employee sheet with a name column and no reports-to column is in exactly this state: a list of people, and no organisation.

2. One column names another row

   Filling in the row number each step leads to draws the whole structure, which is precisely what Reports_to does in the wizard's starter workbook. Note that "Keep the account on the watchlist" points back to row 2 — a process may loop, whereas an org chart may not, because the wizard's reports-to column has to resolve to a tree.

3. Say which branch is which

   "Is the leading driver commercial or product-related?" now labels its two exits, and so does the re-engagement check at the end. An org chart needs no branch labels, but it does need the same discipline: an identifier that resolves, on every single row, or the shape is orphaned.

4. Change the owner, and the box moves

   The last two columns hold the phase and the owner, so "Prepare the renewal and pricing position" sits in Account manager and "Confirm the blocked feature in the usage data" sits in Product. Reassign a step and the diagram redraws around it — which is the reorganisation case that a Visio org-chart refresh will not absorb, because refreshing adds and removes nothing.

How it works

1. Get the three required things into your Excel file

   One row per person, with a column holding the employee name, a column holding a unique identifier — which may be the name column itself if all names are unique — and a column holding whom each person reports to, containing that manager's unique identifier and left blank for the person at the top. Headings can be anything. If you would rather start from Microsoft's own layout, the wizard can generate a sample workbook whose header row is Name, Reports_to, Title, Department, Telephone; if you use it, note the instruction not to delete the Name and Reports_to columns.

2. Open the wizard from the Organization Chart template

   On the File tab, point to New, select Organization Chart, choose Metric Units or US Units and then select Create. Choosing the template starts the wizard automatically — there is no separate command to hunt for. In Visio 2016 the template sits under File > New > Business > Organization Chart. This is a Windows desktop procedure: Microsoft's article on creating an organization chart automatically from employee data lists the perpetual Professional and Standard editions, 2016 to 2024, in its Applies To banner.

3. Choose your file as the source

   The first page offers "Information that's already stored in a file or database" or "Information that I enter using the wizard". Take the first if you have the spreadsheet, the second if you want Visio to generate the starter workbook for you. The readable sources are a Microsoft Excel worksheet, a text file, a Microsoft Exchange Server directory and an ODBC-compliant data source; Excel formats accepted are .xls, .xlsx, .xlsm and .xlsb, along with tab-delimited, comma-delimited and Org Plus text files. Then browse to the workbook.

4. Point the wizard at your name and reports-to columns

   This is the page that makes the column headings irrelevant: you identify which columns contain the employee name and the reports-to name yourself. Get the reports-to mapping right in particular — if you supplied a separate identifier column, the reports-to values must be manager identifiers, not manager names. Exactly one person, the one at the top, should have that field empty. The next pages let you choose which fields are displayed on the shapes, using Add and Remove and Up and Down to order them, and which fields are carried as shape data.

5. Decide about photographs

   The wizard offers "Don't include pictures in my organization chart" or "Locate the folder that contains your organization pictures". If you point it at a folder, the naming rule is strict and unforgiving: "The pictures all need to be in a single folder, with the file name in the format 'Employee Name.FileType' – for example, Jonathan Foster.jpg (the name has to match the name in the data source exactly)." You can add them later instead from the Org Chart tab > Insert > Multiple Pictures.

6. Set the pagination, then finish

   The final page offers "I want to specify how much of my organization to display on each page" or "I want the wizard to automatically break my organization chart across the pages". Two opt-in checkboxes go with it: "Hyperlink employee shape across the pages", which makes a manager on one page clickable through to their team on another, and "Synchronize employee shape across the pages", which keeps duplicated shapes consistent. Both are worth ticking on any chart big enough to span pages. Then select Finish and Visio draws the shapes and connectors.

Frequently asked questions

What columns does my Excel file need for a Visio org chart?

Three things, under any headings you like: an employee name, a unique identifier, and whom each person reports to. Microsoft is explicit that "it doesn't matter what the column names are in the data source, because in the wizard you manually identify which columns (or field names) contain the employee name and the reports-to name." The identifier can be the name column itself if every name is unique; otherwise add a column that does uniquely identify each person, and put those identifiers in the reports-to column. Leave the reports-to field blank for the one person at the top. Title, department and telephone are optional and can be displayed on the shapes or carried as shape data.

Can I create an org chart from Excel in Visio for the web?

No. The Organization Chart Wizard is a Windows desktop feature, data linking is desktop only, and there is no Visio desktop app for macOS — Mac users work in the browser. But it is wrong to say the web cannot do org charts at all: Visio for the web ships an Organization Chart template with five stencils, and Plan 1 and Plan 2 subscribers get a Format Org Chart pane for styling, photo uploads and employee fields. What the web cannot do is import your spreadsheet, or open a chart the desktop wizard built, because templates carrying solutions and add-ins are not editable there. On the web you draw the hierarchy by hand.

Why doesn't my Visio org chart update when someone joins or leaves?

Because refresh was never designed to restructure it. Data > External Data > Refresh All updates the data held inside shapes that already exist, and Microsoft states plainly that "refreshing the data does not add or remove shapes." A changed job title appears; a new hire does not, a leaver's box stays, and a reporting line that moved leaves the shape where it was. Microsoft adds that "if new data doesn't exactly match the data the chart was built with, you might have to move individuals manually", and offers three remedies: manual moves, Compare, or rebuilding the chart. For a quarterly re-org, rebuilding from the sheet is usually less work than reconciling the old drawing.

Is the Organization Chart Wizard the same as Data Visualizer?

No, they are unrelated mechanisms. The Organization Chart Wizard reads an employee list and generates a hierarchy from a reports-to column, and is reached from the Organization Chart template on the desktop. Data Visualizer means the Create Diagram from Data wizard and its three Plan 2 templates — Basic Flowchart, Cross-Functional Flowchart and Audit Diagram — which map a process table of step IDs and next-step IDs and support two-way sync with the workbook. There is no org-chart template among them. The separate Data Visualizer add-in for Excel could produce org charts, but Microsoft announced its retirement in November 2025 with a service shutdown set for 2 March 2026. One further confusion worth clearing: Org Explorer is not Visio — it visualises Microsoft Entra ID data inside Outlook and Teams, with no Excel file involved.