Blog
Charts from data

CSV to pie chart online

A pie chart says one thing well: this whole is made of these parts. It says everything else badly. Use it when the message really is composition, the parts really do sum to a meaningful total, and there are only a few of them.

Your data never leaves this device

Your data

Paste a table straight from Excel or Google Sheets, or drop a CSV file. Nothing is uploaded anywhere — the whole calculation runs inside this browser tab.

CSV, TSV or plain text. Files saved in windows-1251 are detected and re-read automatically, so Cyrillic headers do not turn into garbage.

Parsing options

Columns

Result

The drawing library is downloaded only when you press the button, and only on this page.

This page has no server side at all. The table you paste is parsed by JavaScript inside your own browser, the chart is drawn on a canvas element on your machine, and the export file is assembled locally. Nothing is uploaded, stored or written to any log. You can disconnect from the network after the page has loaded and everything will still work — which is the simplest way to verify the claim yourself.

Facts and limits of this method

Best for One total split into a handful of parts, shown once
Slice limit Twelve; anything beyond is folded into an "Other" slice automatically
Ideal count 2 to 6 slices
Negative values Ignored — a share of a whole cannot be negative
Centre Solid; the full disc is used for the slices
Sorting Slices are sorted largest first, which is the only order a reader can follow
Output PNG at 2× scale, plus CSV and JSON with values and percentages

When it misleads you

How it is calculated

Every row becomes one slice: the label column supplies the caption, the value column the size. Values are taken as absolute magnitudes and zero or missing rows are dropped entirely, because a slice of zero size is invisible but still consumes a legend entry.

Slices are sorted from largest to smallest before drawing. Unsorted pies are notoriously hard to read — sorting gives the eye a starting point and lets a reader follow the sequence around the circle.

If there are more than twelve categories, the smallest ones are merged into a single “Other” slice and a note tells you how many were folded in. This is a judgement the tool makes deliberately: past a dozen slices the chart carries less information than the table it came from.

The total is displayed above the chart, and the exported file contains both the raw values and their percentages rounded to two decimals, so the numbers behind the picture are always recoverable.

Questions and answers

When is a pie chart the right choice?

When you have between two and six parts, they sum to a meaningful whole, and the reader needs the impression of composition rather than precise comparison. Outside that, a bar chart communicates the same data more accurately.

Why were some of my categories merged into "Other"?

Because there were more than twelve. A pie with twenty slices is a colour wheel, not a chart. The note under the result tells you exactly how many categories were folded in, and the exported CSV still contains every original row.

Can I show two periods as two pies?

You can produce two images, but readers cannot reliably compare angles between separate pictures. A stacked bar chart or a 100% stacked chart answers that question far better.

My total does not match the sum in my spreadsheet.

Check for negative or empty values. Negatives are dropped because a negative share of a whole is meaningless, and empty cells are skipped rather than counted as zero.

Is my data uploaded?

No. The whole chart is computed and drawn inside your browser, with no server involved.

The opposite tool

Need it the other way round? CSV to donut chart A pie with the middle removed and the total put back in

Related tools

All tools