Use the free Table Heatmap Generator below: your data never leaves your browser — all work happens on your device, and nothing is uploaded to any server.
A table full of numbers is easy to store and hard to read. Your eye has to compare every cell with its neighbours, and the biggest and smallest values hide in plain sight. A heatmap solves that by shading each number cell by its value, so highs glow in strong colour and lows fade to pale. The pattern jumps out before you read a single digit: a hot row, a cold column, or a corner where everything is high.
The Table Heatmap Generator turns a pasted table into that coloured view. Paste a CSV with a header row, pick a colour scale, and press Colour the table. The tool shades every numeric cell and leaves text cells plain, so labels stay readable. Two scales are offered: white to teal, which is gentle on the eyes, and white to red, which reads as heat and urgency. Everything runs in your browser, and nothing you paste is uploaded or stored.
One detail matters and the tool states it plainly: each numeric column is shaded from its own lowest to highest value. That means the darkest cell in one column is that column’s maximum, not the maximum of the whole table. This per-column scaling is the right choice when columns measure different things, such as temperature in one column and rainfall in another, because a single shared scale would wash out the smaller column entirely. But it also means you must not compare shades across columns as if they were the same scale. Compare shades within a column, and read the numbers for anything across columns.
Good uses are everywhere. A teacher pasting grades by subject can spot a struggling student or a hard exam at a glance. A shop owner pasting sales by branch and month can see seasonal patterns and weak branches without a spreadsheet chart. A sports fan pasting player stats can see who leads each category. In each case the heatmap does not replace the numbers; it guides the eye to the cells worth reading first.
Data preparation is simple but worth doing. Keep one header row, keep numbers plain without currency symbols or thousands separators, and keep the same kind of value in each column. A column that mixes percentages and counts will shade nonsense, because the scale assumes one unit. If a cell stays unshaded, it was read as text, and checking that cell usually reveals a stray symbol or a space.
Colour is an aid, not a verdict. A dark cell is only the highest value in its column, not proof of a problem or a success. A pale cell may be fine if the whole column sits in a healthy range. Use the heatmap to find where to look, then read the actual numbers and the context behind them before you act.
How to generate a table heatmap
- Paste your table as CSV, header row first.
- Choose a colour scale, teal or red.
- Press Colour the table.
- Read patterns within each column, not across columns.
- Check the numbers behind any striking cell before acting.
Frequently asked questions
Why is the same number dark in one column and pale in another? Each column has its own scale, from its own lowest to highest value. Shades are only comparable within a column.
Why is a cell not coloured? It was read as text. Remove currency symbols, commas, or stray spaces and try again.
Which scale should I choose? Teal for calm reports and red when you want highs to feel urgent.
Is my data uploaded? No. All shading happens in your browser.
Paste a table you already work with and colour it once. The patterns you notice in ten seconds are the reason heatmaps exist.