ToolSphere

Histogram Generator

More tools

Visualize the distribution of numeric columns from CSV datasets as customizable frequency histograms. Adjust bin counts to analyze data skew and spread.

Drag & drop your file here, or browse

Supports single file (.csv,text/csv)

Or paste CSV text directly

Upload or paste a CSV file to begin.

On this browser only

Give feedback

Did this tool help?

Tell us what worked, what didn’t, or what you’d like next.

Opens Google Forms in a new tab with this tool’s name filled in. No sign-in or email required. Feedback is optional.

About Histogram Generator

Histogram Generator

Divides a numeric column's range into equal-width bins and counts how many values fall into each, rendering the result as a bar chart — the standard way to visualize a single variable's distribution shape (skewed, symmetric, multi-modal, etc.).

Bin count is adjustable because it genuinely changes what the histogram reveals: too few bins can hide real structure (like two separate peaks blending into one), while too many can make the shape look noisy and hard to read.

Bin count is an analytical choice, not a setting

A histogram does not show your data — it shows your data grouped, and the grouping changes what you see. Too few bins smooths real structure away: two distinct peaks merge into one broad hump, and you conclude the distribution is unimodal when it is not. Too many bins turns sampling noise into apparent structure, producing a spiky chart where every wobble looks meaningful.

This is why the bin count is adjustable and why you should move it. If a feature survives across a range of bin widths it is probably real; if it appears at 40 bins and vanishes at 20, it was noise.

Starting points that are defensible

Two published rules give a reasonable first bin count, and both are starting points rather than answers.

Sturges' rule, ⌈log₂n⌉ + 1, is simple and works for roughly normal data of moderate size. It under-bins large datasets badly.

The Freedman–Diaconis rule sets bin width to 2·IQR/∛n. Because it uses the interquartile range it adapts to spread and resists outliers, which makes it the better default for skewed real-world data.

What the shape is telling you

Right-skewed — a peak on the left with a tail to the right — is the most common shape in practice: durations, incomes, file sizes, counts. The mean sits above the median, so report the median.

Two peaks almost always mean two populations mixed together. Find the variable that separates them and plot each group; the combined histogram is describing something that does not exist as a single thing.

A spike at one value, often zero, usually means a sentinel: a default, a "not measured", or a floor effect. Treat it as a data-quality finding rather than a feature of the distribution.

Gaps in an otherwise continuous range suggest rounding, a measurement limit, or values that were filtered out upstream.

Guides and tutorials

Frequently asked questions

Why does changing the number of bins change what the histogram looks like?

Bin count controls the resolution of the distribution view — too few bins can merge distinct patterns (like two separate peaks) into what looks like one broad hump, while too many bins can fragment the data into a noisy-looking shape with no clear structure.

Is there a 'correct' number of bins?

There are common rules of thumb (like the square root of the sample size), but the right number ultimately depends on what you're trying to see — adjusting interactively and looking at the result is often more useful than a fixed formula.

How many bins should I use?

Start with the Freedman–Diaconis rule — bin width 2·IQR/∛n — because it adapts to spread and resists outliers, then adjust. Sturges' rule is simpler but under-bins large datasets.

How do I know whether a feature in my histogram is real?

Change the bin count. Structure that persists across a range of bin widths is usually real; a peak that appears at one setting and disappears at another was sampling noise.

What does a tall spike at a single value mean?

Usually a sentinel rather than a measurement — a default value, a 'not recorded' placeholder, or a floor effect. It is a data-quality finding, not a property of the distribution.

Have a suggestion for Histogram Generator?Share your feedback ↗