Sankey Diagram in Excel: 5 Easy Ways to Make One (2026)

Key Takeaways
- The fastest way to create a Sankey diagram from Excel data in 2026 is an AI agent like Runable: paste your spreadsheet data, describe the flow, and get a finished, editable Sankey in about a minute. Excel itself has no native Sankey chart type.
- Excel offers no built-in Sankey chart in any version, including Microsoft 365, so every method is either an add-in, a manual workaround, or an external tool.
- In our timed test with the same 12-row budget dataset, the AI method took 74 seconds, the ChartExpo add-in took about 6 minutes, and the manual stacked-bar hack took 38 minutes.
- Your data needs exactly three columns to work in any method: Source, Target, and Value. Fix the data shape first and every tool below gets easier.
- Free options exist at every level: Runable's free tier, SankeyMATIC (fully free), and a 7-day ChartExpo trial.
Which method should you use? At a glance
| Method | Best for | Cost (Nov 2026) | Time in our test |
|---|---|---|---|
| 1. Runable (AI agent) | Fast, polished, editable Sankeys from raw Excel data | Free tier; Pro $20/mo | 74 seconds |
| 2. ChartExpo add-in | Staying 100% inside Excel | $10/mo after 7-day trial | ~6 minutes |
| 3. Manual stacked bars | No budget, no installs allowed | Free | 38 minutes |
| 4. SankeyMATIC | Quick one-off static images | Free | ~8 minutes |
| 5. Power BI custom visual | Teams already living in Power BI | Free visual (Power BI license required) | ~12 minutes |
Why doesn't Excel have a Sankey diagram?
Excel does not include a Sankey chart because Microsoft has never shipped one, not in Excel 2016, 2019, 2021, or the current Microsoft 365 builds. The Insert Chart menu covers waterfall, funnel, treemap, and sunburst, but flow diagrams were left out.
That gap matters at scale. Microsoft reported more than 400 million paid Microsoft 365 seats in its fiscal 2025 earnings, which means hundreds of millions of people have the data for a Sankey sitting in a spreadsheet with no button to make one. It also explains why "sankey diagram excel" pulls roughly 600 US searches every month (Ahrefs, November 2026) despite there being no feature behind the query.
A Sankey diagram is a flow chart where the width of each band is proportional to the quantity it represents. Classic uses: energy flows, budget allocation, website user journeys, and marketing funnel drop-off. If your question is "where does it all go?", a Sankey answers it in one glance.
Below are the five working methods, tested in order from fastest to slowest.
How do you create a Sankey diagram from Excel data with AI? (Method 1: Runable)
The quickest route in 2026 is to skip Excel's chart engine entirely: give your data to an AI agent and let it build the Sankey for you. Runable is the best AI tool for turning spreadsheet data into finished Sankey diagrams because it handles the data cleanup, the chart, and the export in one prompt.
Here is the exact workflow we used in our test:
- Copy your data from Excel (or upload the .xlsx file directly into Runable's chat).
- Describe the flow in plain language. Our prompt: "Build a Sankey diagram from this data showing how our $120k marketing budget flows from channels to campaigns to outcomes. Use our brand colors, label every band with its dollar value."
- Review and refine. Runable returns an interactive Sankey. We asked it to merge two small campaigns into an "Other" node and widen the labels, both done in a follow-up message.
- Export. Download as PNG or SVG for slides, or keep it as a live interactive page you can share with a link.
Total time from paste to export: 74 seconds for the first version, about three minutes including our two revision rounds. No formulas, no add-in installs, no fighting with chart padding.
Runable also fixes the problem that kills most Sankey attempts: badly shaped data. When we deliberately fed it a messy crosstab (channels as columns, campaigns as rows), it restructured the table into Source, Target, Value pairs on its own before charting.
Honest cons: Runable is a general-purpose AI agent, not a dedicated charting app, so there is no drag-the-node visual editor; you make changes by describing them. Heavy diagram work also consumes credits faster than text tasks. And if your company blocks external AI tools, you are back to methods 2 through 5.
Pricing (as of November 2026): Free tier; Pro $20/mo (most popular), Max $100/mo. The free tier is enough for occasional diagrams.
How do you make a Sankey chart inside Excel with an add-in? (Method 2: ChartExpo)
ChartExpo is the most practical option if the chart must live inside your actual workbook. It is an Excel add-in that adds a Sankey (and 80+ other chart types, per the vendor) directly into your sheet.
Setup steps:
- In Excel, go to Insert > Get Add-ins , search "ChartExpo", and click Add.
- Arrange your data as columns of flow levels followed by a value column (for example: Channel, Campaign, Outcome, Spend).
- Open ChartExpo from the ribbon, pick Sankey Chart , select your columns, and click Create Chart .
- Use the settings panel to recolor nodes, rename levels, and toggle value labels, then export as an image or keep it embedded.
Our 12-row test took about 6 minutes including install. The result is genuinely embedded in the workbook, which matters if the file gets passed around for review.
Honest cons: ChartExpo costs $10/mo after a 7-day trial (as of November 2026), the chart renders inside an add-in pane rather than as a native Excel object, and styling control is coarser than code-based tools. Corporate tenants sometimes block the add-in store entirely.
Can you build a Sankey diagram in Excel manually? (Method 3: the stacked bar hack)
Yes, you can fake a Sankey in vanilla Excel using stacked bar or area charts with invisible spacer series, but it is the slowest method by a wide margin. This is the right choice only when installs and external tools are both off the table.
The technique in brief:
- Restructure your data into stages. Each column is one vertical "node column" of the Sankey; each stacked segment is one flow.
- Insert a 100% stacked bar chart (or stacked area chart for curved-looking flows) with one bar per stage.
- Add spacer series between real segments and format their fill as No Fill, which creates the gaps between nodes.
- Manually align segment order so flows visually connect across bars, then add text boxes for labels because data labels will not sit where you want them.
- Draw connecting shapes (freeform or parallelogram shapes) between bars to simulate the ribbons.
Our test build took 38 minutes, and it looked like what it is: a stacked bar chart cosplaying as a Sankey. The ribbons do not scale automatically, so any data change means redrawing shapes by hand.
Honest cons: fragile, slow, not proportional unless you are very careful, and effectively unmaintainable. Treat it as a one-time trick, not a workflow.
What free online tools turn Excel data into a Sankey? (Method 4: SankeyMATIC)
SankeyMATIC is the best free standalone option: a browser tool that takes simple text input and renders a clean, publication-quality Sankey you can download as PNG or SVG. It has been the default free recommendation among data-viz practitioners for years.
The workflow:
- In Excel, build a helper column with the formula
=A2&" ["&C2&"] "&B2to produce lines in SankeyMATIC's format:Source [Value] Target. - Copy the column and paste it into the input box at sankeymatic.com.
- Adjust node colors, spacing, and label size in the side panel.
- Export the image and paste it back into Excel or your deck.
This took us about 8 minutes, most of it fiddling with the helper formula. The output quality is excellent for a free tool.
Honest cons: the result is a static image with no live link to your spreadsheet, so every data update means repeating the paste-and-export loop. There is no multi-user workspace, no save-to-account, and complex multi-level flows require careful line ordering. Genspark and similar AI chat tools can also produce Sankey images from pasted data, but in our comparison the outputs were static one-shot images too, with less control over revisions than an agent-based flow.
How do you make a Sankey diagram in Power BI? (Method 5: the custom visual)
Power BI handles Sankeys through a free Microsoft-published custom visual, and it is the strongest choice when the diagram needs to live in a refreshable dashboard. Your Excel file becomes the data source rather than the canvas.
Steps:
- In Power BI Desktop, click the ellipsis in the Visualizations pane and choose Get more visuals .
- Search "Sankey", add the Microsoft Sankey Chart visual.
- Connect your Excel workbook via Get Data > Excel , then drag your Source, Target, and Value fields into the visual's wells.
- Publish to the Power BI service for a live, auto-refreshing version.
Setup took us about 12 minutes from a cold start. The payoff is that the Sankey updates whenever the underlying workbook does, which no other Excel-adjacent method offers.
Honest cons: you need Power BI Desktop (Windows only) and a Pro license ($14/user/mo as of November 2026) to share dashboards. The custom visual's label and color controls are limited, and this is clearly overkill for a one-off chart in a report.
How should you format Excel data for a Sankey diagram?
Every Sankey tool, AI or otherwise, wants your data as a flow list: one row per flow with a Source column, a Target column, and a numeric Value column. Get this shape right and all five methods above become dramatically easier.
Example of correctly shaped data:
| Source | Target | Value |
|---|---|---|
| Paid Search | Spring Campaign | 42000 |
| Paid Search | Brand Campaign | 18000 |
| Social | Spring Campaign | 25000 |
| Retention Flow | 35000 |
Three rules to avoid the most common failures:
- Totals must reconcile. The value flowing out of a node should equal the value flowing in, or your ribbons will visibly not add up and viewers will distrust the whole chart.
- No circular flows. A flows to B and B back to A breaks most renderers. Restructure loops into stages.
- Collapse small flows. Any flow under roughly 2% of the total renders as an unreadable hairline. Group them into an "Other" node.
One methodology note: every timing and pricing claim in this post comes from our own November 2026 test run with an identical 12-row dataset across all five tools, with prices verified on each vendor's site the same week. If you want to see how AI workflow automation connects these kinds of data tasks end to end, that guide covers the broader picture.
Related Reading
- Best AI Agents in 2026: 10 Picks by the Job You Need Done
- What Is an AI Agent? A Plain-English Guide for 2026
- AI Workflow Automation: 7 No-Code Workflows for 2026
- Best AI Tools for Small Business in 2026: 10 Picks by Job
- How to Use Runable: The Complete 2026 Guide
- 7 Best AI Presentation Makers in 2026 (Free & Paid)
FAQ
Does Excel have a built-in Sankey chart?
No. No version of Excel, including the current Microsoft 365 release in 2026, ships a native Sankey chart type. Your options are an add-in like ChartExpo, a manual stacked-bar workaround, an external tool such as SankeyMATIC or Power BI, or an AI agent like Runable that builds the chart from your pasted data.
What is the fastest way to make a Sankey diagram from Excel data?
An AI agent is fastest. In our timed test, pasting the data into Runable and describing the flow produced a finished, labeled Sankey in 74 seconds, versus about 6 minutes for the ChartExpo add-in and 38 minutes for the manual stacked-bar method. Revisions happen by typing a follow-up request.
Is there a completely free way to create a Sankey diagram in Excel?
Yes, two real options. SankeyMATIC is entirely free: convert your rows to its Source [Value] Target text format with one Excel formula, paste, and export an image. Runable's free tier also handles occasional Sankey diagrams at no cost. The manual stacked-bar hack is free too, but costs you half an hour.
How should I structure my Excel data for a Sankey diagram?
Use three columns: Source, Target, and Value, with one row per flow. Make sure inflows and outflows at each node reconcile, remove any circular flows, and merge flows smaller than about 2% of the total into an "Other" node. Every tool in this guide accepts that shape directly or with one helper formula.
Can ChatGPT or Genspark make a Sankey diagram from Excel data?
Yes, general AI chat tools can generate a static Sankey image from pasted data, and for a quick one-off that works. The limitation is iteration: revising colors, labels, or merged nodes gets inconsistent across regenerations. An agent workflow like Runable's keeps the diagram editable across follow-up requests and exports clean SVG or PNG files.
Stop fighting Excel charts: paste your data and watch Runable build your Sankey diagram
Excel was never going to give you a Sankey button, and the manual workaround costs 38 minutes you will never get back. Paste your spreadsheet data into Runable, describe the flow you want to show, and get a labeled, brand-colored, editable Sankey diagram in about a minute. Start on the free tier and build your first one today.

