How to create a Visio flowchart from a spreadsheet
Your steps are in Google Sheets, a CSV export or a shared tracker, but every Visio route to a generated diagram wants an Excel workbook. How to convert properly, and how to avoid ending up with two versions of the process.
A worked example, stage by stage
The exported list, labels only
"Send feedback through any channel", "Log the feedback in the tracker", "Categorise the item and set severity" — three rows with shapes and no relationships, which is exactly what a tracker export gives you. Every step is present and the process is still invisible.
The column that makes it a process
Filling in the row number each step leads to draws the arrows, and the fork appears at "Does the customer need an individual reply?". This is the column no exported tracker contains, because a spreadsheet has never needed to say what happens next.
Naming the branches
"Is the cause inside our own process?" now carries "Inside our process" and "Outside our control" on its two exits, and the recurrence test below it separates "Yes" from "One-off, low impact". Unlabelled exits are the commonest reason a generated diagram cannot be read back.
Lanes, the loop and both endings
The lane columns place each step under Customer, Support, Process owner or Quality across the five phases, and "Did the change fix the problem?" routes back to "Agree the action, the owner and the check" when it did not. Two endings: closed with the change confirmed, and closed with no process change and the reason recorded.
How it works
Export the list from wherever it lives
Get the steps out of the Sheet, tracker, Airtable base or Jira view as tabular data, one row per step and one header row. CSV is a perfectly good intermediate format at this stage — it is only unacceptable as the thing you eventually hand to Visio. Strip merged cells, grouped headers and blank separator rows now, while you are still in the tool that produced them.
Open it in Excel and save it as .xlsx
The wizard's Excel page asks you to "Select the Excel workbook", so the file has to be a workbook. Open the CSV in Excel and save it in the .xlsx format. Put the data on one sheet with nothing above the header row, and check that the columns landed in separate cells rather than one comma-filled column, which is what a mismatched delimiter produces.
Convert the data to an Excel table
Do not leave it as a range. Microsoft's guidance is plain — "Use an Excel table and not a custom range if you want to keep your diagram and data synchronized" — and the wizard's second prompt, "Select a table or a custom range in the workbook", is where the choice is made. A range works once and then never refreshes, with no error to tell you why.
Add the columns the wizard maps
The wizard needs a unique, never-blank Process Step ID, a description, the Next Step ID of the following step, connector labels for branching shapes, and a shape type; the function and phase columns matter only for a cross-functional flowchart. Rewriting your existing IDs into that shape is the fiddly part, and /guides/how-to-turn-excel-data-into-visio-flowchart covers the schema cell by cell.
Start the Data Visualizer template in Visio desktop
Open Visio, or select File > New if you are already editing, then select TEMPLATES and Select Flowchart, and choose "Basic Flowchart - Data Visualizer" or "Cross-Functional Flowchart - Data Visualizer". Choose a unit of measurement, select Create, and the Create Diagram from Data wizard opens; point its Excel page at your workbook and at your table. The five wizard pages are walked through in /guides/how-to-create-a-flowchart-from-excel-in-visio.
Decide which copy is the master, then keep them in step
Click in the diagram container to enable the Data Tools Design tab. Refresh Diagram re-reads the workbook; Update Source Data writes the diagram's changes back into it, and the workbook must be saved and closed if it sits on a desktop machine or a network file server. Neither command touches the Sheet or tracker you exported from, so pick one home for the process and tell people which it is.
Frequently asked questions
Can Visio import a Google Sheet directly?
Not by any documented route. The Data Selector Wizard behind Link Data to Shapes offers six sources — an Excel workbook, an Access database, a SharePoint list, a SQL Server database, another OLEDB or ODBC source, and a previously created connection — and Google Sheets is not one of them. The Create Diagram from Data wizard is narrower still: it asks for an Excel workbook and then for a table or a custom range within it. The practical path is to download the Sheet as an .xlsx, convert the data to an Excel table, and treat that workbook as the file Visio is linked to from then on.
Can I create a Visio flowchart from a CSV file?
Not with the Data Visualizer route. Its wizard asks you to select an Excel workbook and then a table or custom range inside it, and a CSV contains neither, so the conversion to .xlsx is unavoidable. Delimited text does go into Visio in one place: the Organization Chart Wizard reads tab-delimited and comma-delimited .txt files alongside Excel workbooks, Org Plus text, Exchange Server directories and ODBC sources. That is an org chart rather than a process flow, and /guides/how-to-create-org-chart-from-excel-in-visio covers it. For a flowchart, open the CSV in Excel and save it properly first.
Which file formats can Visio actually read a process out of?
Narrower than the export menu of whatever tool you are leaving. For a generated flowchart, one: an Excel workbook, with the steps inside a table or a named range. For linking data to shapes you have drawn, the Data Selector Wizard documents six sources — an Excel workbook, an Access database, a SharePoint list, a SQL Server database, another OLEDB or ODBC source, and a previously created connection. The Organization Chart Wizard is the broadest reader of the three, taking .xls, .xlsx, .xlsm and .xlsb alongside tab-delimited, comma-delimited and Org Plus text files, an Exchange Server directory and ODBC sources. Nothing in that list is a Google Sheet, a CSV, or an export from a tracker, so .xlsx is the format to convert to.
How do I keep a diagram in step with a spreadsheet other people are editing?
On the Visio route you cannot, not directly: the diagram is bound to the workbook you selected, so somebody has to re-export and re-refresh, and that person is the single point of failure. Two options remove the hand-off. Make the .xlsx itself the working document, so there is only one copy, and accept that the original tracker is now a dead artefact. Or keep the process in a tool where the rows are the diagram — in QueryChart everyone edits the same rows at the same URL and the chart re-renders, so there is no export step to forget and no copy to compare against.