Sankey diagram from Excel

Visualize flows effortlessly: paste data, get an exportable diagram instantly.

Español
Accepted formats:
Source [100] Target (one flow per line)
source,target,value CSV/TSV (comma, semicolon or tab, optional header)
Coffee:100, Library:50 (shorthand: hangs items from a «Total» root node)
Click a node to change its colour

From spreadsheet to diagram, no add-ins

Excel has no built-in Sankey chart, and the add-ins are often paid or fiddly. Here you only need three columns: source, target and value. Select the cells in Excel or Google Sheets, copy them and paste them into the data box. They paste as tab-separated columns, which the generator reads as is.

The example is a comma-separated CSV with a header row. Product sales and consulting add up to “Revenue”, which then splits into salaries, cloud hosting, marketing, taxes and profit. The header row is detected and skipped automatically, so you can paste an export without cleaning it first.

Tip: if the same source-target pair appears on several rows, for example one row per month, the values are added together. You can paste the detailed data and let the diagram do the totals, instead of building a pivot table first.

How to make a Sankey diagram

A Sankey diagram visualizes flows between stages: the width of each band is proportional to the quantity.

Use it for budgets, energy flows, sales funnels, or any process with inputs and outputs.

In this tool: 1) Paste your data into the text area (one flow per line, CSV, or shorthand). 2) Click «Generate». 3) Customize colors and export to SVG or PNG.

Pro version

One-time payment of 10 €: export without the watermark, with a transparent or dark background, and 4× PNG for slides and print.

Buy for 10 €