Heatmap Maker: Create a Heatmap Online From CSV Data
Need to make a heatmap online without opening Excel or writing Python first? Paste a CSV, map the X axis, Y axis, and value column, then export the chart directly from the page.
- Best for score grids, activity by hour, cohort tables, survey matrices, and other two-dimensional comparisons
- Works with tidy CSV or TSV data where each row describes one heatmap cell
- Exports to PNG or SVG after you finish styling the chart
What a heatmap is and why it matters
A heatmap is a chart that uses color intensity to show how values change across a two-dimensional grid.
It helps when a plain table is too dense to scan quickly. Instead of reading every cell one by one, you can spot clusters, gaps, and outliers by looking for darker or lighter blocks.
That makes heatmaps useful for:
- website activity by day and hour
- student scores by subject and class
- sales by region and month
- product usage by segment and feature
- gene expression or laboratory measurement grids
If you need a more guided walkthrough, see our heatmap guide in Graphic Walker.
Format your data the right way
Before you paste data into the tool, make sure the table is tidy.
| Column | What it should contain | Example |
|---|---|---|
| X axis column | The horizontal grouping | day, month, feature |
| Y axis column | The vertical grouping | hour, region, class |
| Value column | The numeric measure that controls the color | visits, score, revenue |
Example:
day,hour,visits
Monday,09:00,18
Monday,10:00,31
Tuesday,09:00,22
Tuesday,10:00,39If your source file starts as raw event data rather than an already aggregated table, convert it into a grouped table first. For adjacent workflows, see CSV to Chart, Scatter Plot Maker, and Histogram Maker.
Common heatmap mistakes
This page is meant to be usable, not just indexable, so the quickest wins are also the most practical.
- Do not feed the chart raw text into the value field. The color field should be numeric.
- Do not use one giant free-form category axis when the order matters. Clean category names first.
- Do not expect a heatmap to bin continuous values automatically. Aggregate your data into buckets before pasting it in.
- Do not use too many nearly identical shades if you need readers to compare exact differences quickly.
If your data is already a dense matrix and you want to explore more chart types around it, the gallery example Monitor Students' Performance in Reading and Writing shows the same idea in a finished visualization page.
When to use a heatmap instead of another chart
Use a heatmap when the question is about pattern density across two dimensions.
- Use a heatmap when you want to compare intensity across rows and columns.
- Use a bar chart maker when exact category totals matter more than pattern shape.
- Use a line chart maker when the main story is change over time.
- Use a dot plot maker when precise comparisons matter more than a colored grid.
FAQ
What data format works best in this heatmap maker?
The best format is a tidy CSV or TSV with one row per cell, one column for the horizontal category, one column for the vertical category, and one numeric column for color intensity.
Can I upload a CSV file instead of pasting data?
Yes. The tool supports both pasted text and uploaded CSV or TSV files, then lets you map columns before rendering the chart.
Why is my heatmap blank or misleading?
The most common causes are a non-numeric value field, mismatched columns in the CSV header, or data that should be aggregated into buckets before being visualized as a heatmap.
What should I use if I need more than a simple heatmap builder?
If you need drag-and-drop exploration, multiple chart types, or deeper dataset inspection, start with Graphic Walker or review the heatmap documentation.