When should I use a heat table?

When exact values AND patterns both matter ● Financial reports with conditional formatting

When should I avoid a heat table?

Pure visualization (use heatmap) ● When color adds no insight

What are common mistakes with heat tables?

Using rainbow colormap ● Too many cells making patterns invisible

Specialized

Heat Table

Data table with cells colored by value - spreadsheet meets heatmap.

Quarterly Sales by Product

Color intensity = sales volume

View data (12 rows)

Chart data table: Quarterly Sales by Product
Product	Quarter	Sales
Widget C	Q1	200
Widget C	Q2	180
Widget C	Q3	195
Widget C	Q4	220
Widget A	Q1	120
Widget A	Q2	145
Widget A	Q3	98
Widget A	Q4	160
Widget B	Q1	85
Widget B	Q2	92
Widget B	Q3	110
Widget B	Q4	88

Make a heat table with your data

Use a heat table when…

When exact values AND patterns both matter
Financial reports with conditional formatting

Avoid when…

Pure visualization (use heatmap)
When color adds no insight

Data it needs

Property	Value
Min Rows	4
Min Columns	3
Column Types	stringstringnumber

Visual anatomy

Marks

rectangletext

Channels

color-luminancetext-value

Axes

table rows/columns

Guiding principles

ColorPerceptually Uniform Colormaps
Use sequential colormap
ContextAbove All Else, Show the Data
Show values directly in cells
PerceptionGestalt Grouping
Sort rows and columns by marginal totals (or a clustering order) so the heat-table's pattern actually pops instead of being scattered across the grid

Consider instead

Heatmap

When exact values aren't needed

Common mistakes

Using rainbow colormap
Too many cells making patterns invisible

History

Evolution of conditional formatting in spreadsheets, formalized as a visualization technique.

Accessibility notes

Values shown in cells make this inherently accessible — but check that in-cell text meets WCAG AA contrast against the darkest cell colors (white text on deep saturated fills sometimes fails). Always include a color legend.

Got data? Let's see what works.

Drop your CSV. You'll get a Heat Table plus four alternatives - ranked by which one actually fits your data best.

Try it free