Google Sheets to flowchart: convert Google Sheets to audit-ready process maps

Use a worked spreadsheet flowchart to plan rows, connections and owner lanes. Paste or import the prepared steps into QueryChart, then pull linked Google Sheets values into chart columns when needed.

The CSV that produces this diagram

One row per step. The numbers in Line to are row numbers — that is what draws the connectors, and it is the column most files are missing.

#ShapeBox textLine toLine textHorizontal laneVertical lane
1StartSend feedback through any channel2CaptureCustomer
2RegistryLog the feedback in the tracker3CaptureSupport
3ProcessCategorise the item and set severity4TriageSupport
4DecisionDoes the customer need an individual reply?5, 6Yes, NoTriageSupport
5ProcessReply and record what was promised6TriageSupport
6ProcessInvestigate the cause with the people doing the work7TriageProcess owner
7DecisionIs the cause inside our own process?9, 8Inside our process, Outside our controlTriageProcess owner
8ProcessFeed the cause back to the third party16TriageProcess owner
9DecisionDoes it recur or breach a service target?10, 16Yes, One-off, low impactTriageQuality
10ProcessAgree the action, the owner and the check11ActionProcess owner
11ProcessMake the change and update the procedure12ActionProcess owner
12ProcessMeasure the agreed check after the change13VerifyQuality
13DecisionDid the change fix the problem?14, 10Yes, No, still recurringVerifyQuality
14ProcessTell the customer what changed15CloseSupport
15SuccessClosed with the change confirmedCloseQuality
16EndClosed with no process change, reason recordedCloseProcess owner
#,Shape,Box text,Line to,Line text,Horizontal lane,Vertical lane
1,Start,Send feedback through any channel,2,,Capture,Customer
2,Registry,Log the feedback in the tracker,3,,Capture,Support
3,Process,Categorise the item and set severity,4,,Triage,Support
4,Decision,Does the customer need an individual reply?,"5, 6","Yes, No",Triage,Support
5,Process,Reply and record what was promised,6,,Triage,Support
6,Process,Investigate the cause with the people doing the work,7,,Triage,Process owner
7,Decision,Is the cause inside our own process?,"9, 8","Inside our process, Outside our control",Triage,Process owner
8,Process,Feed the cause back to the third party,16,,Triage,Process owner
9,Decision,Does it recur or breach a service target?,"10, 16","Yes, One-off, low impact",Triage,Quality
10,Process,"Agree the action, the owner and the check",11,,Action,Process owner
11,Process,Make the change and update the procedure,12,,Action,Process owner
12,Process,Measure the agreed check after the change,13,,Verify,Quality
13,Decision,Did the change fix the problem?,"14, 10","Yes, No, still recurring",Verify,Quality
14,Process,Tell the customer what changed,15,,Close,Support
15,Success,Closed with the change confirmed,,,Close,Quality
16,End,"Closed with no process change, reason recorded",,,Close,Process owner

The diagram those rows produce

Rendered from the rows above, unchanged. Edit a cell and the diagram follows; move a box and the rows follow.

How it works

  1. Prepare the process rows in Google Sheets

    Write one step per row. Include a shape, box text, the row numbers each step leads to, and optional lane names. Review decision branches before copying the rows into QueryChart.

  2. Copy the prepared rows into QueryChart

    Paste the rows into the chart spreadsheet, or export the Sheet as CSV and import that file. QueryChart uses the prepared row and connection columns to draw the chart.

  3. Check the generated flowchart

    Verify every connection and owner lane against the Sheet. A decision needs a destination for each outcome; a source column alone cannot supply those routes.

  4. Link values that need later updates

    For selected chart columns, QueryChart can pull values from Google Sheets with read-only access. Pulling a column does not rebuild the flowchart or automatically change its approval state; review structural changes separately.

Frequently asked questions

Does Visio Data Visualizer support Google Sheets?

No. Visio Data Visualizer is an Excel add-in and depends on the Microsoft 365 / Visio Plan 2 ecosystem; Google Sheets ingestion is not supported. QueryChart is the spreadsheet-native option for Google Workspace teams.

How is QueryChart different from Lucidchart for Google Sheets?

QueryChart draws a chart from prepared process rows and can pull selected values into chart columns from Google Sheets. Map the sheet's fields to QueryChart's row and connection columns before import; a general purpose Sheet is not converted automatically.

Is the conversion deterministic?

Yes — the same sheet always produces the same diagram.

Open the spreadsheet flowchart example

The template behind this guide

Spreadsheet to flowchart template (customer feedback) — Turn a spreadsheet of steps into a flowchart, using a customer feedback tracker: capture, triage, cause analysis, a recurrence threshold that decides which items become improvement actions, and verification before closure.

More in Spreadsheet to flowchart