How to import Excel data into Visio

A worked example, stage by stage

1. Shapes carrying data, nothing joining them

   This is the state a successful Link Data to Shapes import leaves you in: shapes on the page, each bound to a row — "Refresh the churn-risk dataset", the scoring step, and a decision diamond — with not one arrow between them. Nothing has gone wrong; connectors are simply not part of what the feature does.

2. The next-step column draws the arrows

   Filling in which row each step leads to is what turns a field of shapes into a process. "Keep the account on the watchlist" points back at the scoring step, so the loop appears, and "Publish the at-risk queue with its risk drivers" carries the flow out of the signal phase. In Visio this column has no equivalent — it is the hand-drawing you would still be doing.

3. Labelled branches, so a diamond can be read

   "Is the leading driver commercial or product-related?" splits towards "Prepare the renewal and pricing position" and "Confirm the blocked feature in the usage data", and each exit now says which case it carries. A decision with two unlabelled exits is the most common unreadable thing in a process diagram, whatever tool drew it.

4. Owners, and the loop nobody remembers to draw

   The lane columns place every step with the team that performs it, so the handoffs from data and analytics to customer success to the account manager become visible rather than implied. The full chart also exposes the escalation route: "Is the account recoverable before renewal?" sends a second attempt back to "Contact the customer and agree an action plan" instead of quietly ending.

How it works

1. Start in the Visio desktop app

   Data linking has no web equivalent — "Data linking is only available through the Visio desktop app, but in Visio for the web you can view data-linked diagrams." Among the subscriptions the desktop app comes with Visio Plan 2, and the linking and data-graphics rows in Microsoft's comparison are Plan 2 rows. There is no Visio desktop app for macOS, so a Mac is a viewer here. Microsoft's docs conflict over whether perpetual Visio Standard exposes the Data tab, so confirm on the machine in front of you rather than on a spec sheet.

2. Prepare the workbook around one unique column

   Microsoft's prep rule is the whole ballgame: "To make the import process go smoothly, make sure that one column of your data contains unique values for each row, and that the values match the text on the shapes." So flatten the sheet to one header row and one record per row, no merged cells and no blank separators, and add or nominate a column of stable identifiers — an account number, a step ID, an employee number. Anything you intend to bind to existing shapes has to match the text on those shapes.

3. Import from the Data tab

   On the Data tab, Quick Import is the Excel fast path: choose the workbook, then choose the sheet. Custom Import opens the Data Selector wizard, whose documented sources are a Microsoft Excel workbook, a Microsoft Access database, a Microsoft Windows SharePoint Services list, a Microsoft SQL Server database, another OLEDB or ODBC data source, or a previously created connection. Microsoft's own pages describe the surrounding ribbon group three different ways, so navigate to the Data tab and read what is on it rather than hunting for a promised button label.

4. Choose the identifier a refresh will match on

   The wizard has a page called "Configure Refresh Unique Identifier", and it is the step people click past. The column you nominate there is how Visio later works out which row belongs to which shape, so a wrong or non-unique choice is not a cosmetic mistake — it makes refreshing unreliable from the start, and it is decided here rather than fixable later. Choose a value that will not be edited: an account number rather than an account name, a step ID rather than a step description. What happens when a refresh cannot match a row is /guides/how-to-update-visio-flowchart-from-excel's subject.

5. Put the rows on the page, or bind them to shapes already there

   Two directions. To create shapes from data, "Drag a row or set of rows from the External Data window onto a blank space in your drawing" — "One instance of the shape that you click appears for each row that you drag onto the drawing." To attach data to shapes you have already drawn, select them and use Link to Selected Shapes from the row's right-click menu, or run the Automatically Link wizard to match rows to shapes in bulk. The cardinality is asymmetric: one row can feed many shapes, but each shape links to only one row.

6. Apply data graphics, then draw the connectors yourself

   With shapes linked, go to the Data tab, Display Data group, and open the Data Graphics gallery. The "Displayed as" dropdown offers exactly four kinds — Text, Data Bar, Icon Set and Color by Value — and No Data Graphic removes one again. Then wire the diagram by hand: hover over the first shape and select the small arrow pointing at the shape you want to reach, or switch to the Connector tool on the Home tab (Ctrl+3) and drag between shapes, returning to the Pointer Tool with Ctrl+1 or Esc.

Frequently asked questions

Is Link Data to Shapes the same thing as Data Visualizer?

No, and confusing them is the usual reason an import disappoints. Data Visualizer is a set of Visio desktop templates that generate a flowchart from an Excel table — shapes, connectors, branch labels and swimlanes — and it syncs both ways, with Refresh Diagram and Update Source Data on the Data Tools Design tab. Link Data to Shapes works on the Data tab, attaches rows to shapes, draws no connectors, and moves data in one direction only, from source to drawing. Microsoft documents both as Plan 2 among the subscriptions. See /guides/how-to-use-visio-data-visualizer for the other one.

Does importing Excel data into Visio create the shapes automatically?

It can, which contradicts a lot of what is written about it. Microsoft's own instruction is to "Drag a row or set of rows from the External Data window onto a blank space in your drawing", and "One instance of the shape that you click appears for each row that you drag onto the drawing" — so the shape you have selected in the stencil is stamped once per row. What is never created is a connector. You get a field of shapes carrying data, positioned where you dropped them, and the flow between them is still a drawing job. Binding data to shapes you have already placed is the other direction, via Link to Selected Shapes or the Automatically Link wizard.

Can I edit the Excel file from inside Visio after linking?

Not with linked data. Microsoft states it twice and flatly: "You cannot update the data source to which a Visio diagram is linked by making changes in the Visio diagram," and "You cannot refresh your data source by changing the data in your drawing." The workbook is the master; the drawing reads from it. The one exception in Visio is a Data Visualizer diagram, which does write back through Update Source Data — and there the caution is that formulas do not survive it, because after you choose Overwrite "Visio converts the formula to the formula result". Refresh behaviour in both mechanisms is covered at /guides/how-to-update-visio-flowchart-from-excel.

What if my team works in a browser, or on a Mac?

Then data linking is largely closed to you: there is no Visio desktop app for macOS and none planned for Microsoft 365, linking is desktop only, and a data-connected diagram can be viewed but not edited in Visio for the web. Be clear about what that costs you, because linking's real strength is data graphics — Text, Data Bar, Icon Set and Color by Value applied per shape — and a shape that renders its own numbers as a bar or a traffic light is something a flow-oriented tool does not replace. If what you need is the flow rather than the instrumentation, QueryChart takes the opposite approach: the rows are the chart, so editing the data is editing the diagram, in any modern browser, and the connections are a column of row numbers rather than something you draw. The churn-risk example on this page is /templates/data-driven-flowchart, and it is editable in place.