ZIP Code Heat Map Maker — Paste Data, Get a Choropleth
Paste a ZIP column and any numeric columns — from Excel, CSV or a saved file — and get a real choropleth of U.S. Census ZIP Code Tabulation Areas. Class the values four ways, pick a colour-blind-safe palette, normalise by land area, then export SVG, 2× PNG, GeoJSON or CSV. No sign-up, no row limit, no upload.
ZIP code heat map maker
Paste cells from Excel (tab separated) or CSV. A header row is detected, ZIP+4 is truncated, leading zeros are kept, and $, thousands separators and % are stripped.
Nothing loaded yet. Paste rows, drop a file on the map, or press “Load sample”.
Hover or tap a ZIP for its city, county and value. Every colour comes from your own numbers.
Roll-up by county
Draw a map to see county totals.
Roll-up by state
Draw a map to see state totals.
Unmatched ZIPs
ZIPs with no Census ZCTA are listed here with the reason.
How the choropleth is built
A ZIP code is not a shape. The U.S. Census Bureau publishes ZIP Code Tabulation Areas (ZCTAs), which approximate USPS delivery areas, and this site ships all 33,791 of the 2020 layer as static JSON. Your ZIPs are matched to those polygons in the browser: no map library, no tile server, no request that carries your rows.
Four classing methods are offered because they answer different questions. Quantile puts the same number of ZIPs in every colour, which is the right choice for comparing territories. Equal interval keeps the legend numbers round. Natural breaks (Fisher–Jenks) minimises variance inside each class and finds the gaps in a lopsided distribution. Custom breaks pin the scale to numbers you chose, such as 0, 50, 100.
Normalise by land area divides each value by the ZCTA's Census land area in square miles. A count map is dominated by big rural ZIPs; a density map answers where customers actually concentrate. Every palette here — viridis, cividis, Blues and two diverging ramps — stays readable with common colour-vision deficiencies.
All 50 states and DC, each with its own ZCTA map
40,977 ZIP codes, 33,642 ZCTAs with a polygon and 3,147 counties across 50 states and DC. Each page has its own build-time choropleth by Census land area and the tool scoped to that state.
- Alabama
- Alaska
- Arizona
- Arkansas
- California
- Colorado
- Connecticut
- Delaware
- District of Columbia
- Florida
- Georgia
- Hawaii
- Idaho
- Illinois
- Indiana
- Iowa
- Kansas
- Kentucky
- Louisiana
- Maine
- Maryland
- Massachusetts
- Michigan
- Minnesota
- Mississippi
- Missouri
- Montana
- Nebraska
- Nevada
- New Hampshire
- New Jersey
- New Mexico
- New York
- North Carolina
- North Dakota
- Ohio
- Oklahoma
- Oregon
- Pennsylvania
- Rhode Island
- South Carolina
- South Dakota
- Tennessee
- Texas
- Utah
- Vermont
- Virginia
- Washington
- West Virginia
- Wisconsin
- Wyoming
Workflows
- Sales territory heat map Reps, quota attainment and duplicate ZIP rows.
- Customer density by ZIP Counts versus customers per square mile.
- Excel ZIP code heat map Leading zeros, ZIP+4, currency and duplicate repairs.
Data, licences and what is not shown
Boundaries, land area and water area come from the U.S. Census Bureau's
2020 ZCTA layer (cb_2020_us_zcta520_500k), which is a U.S. Government work in
the public domain. ZIP to city, county and state comes from
GeoNames' US postal code export
(CC BY 4.0). ZCTAs approximate USPS delivery areas; they are not official USPS boundaries
and this site is not affiliated with USPS or the Census Bureau.
PO-box, military and single-building ZIPs have no ZCTA at all. They are never given an invented polygon: they appear in the unmatched report with the reason, and they are excluded from the map, the legend counts and the classing. Sample data is generated in your browser and labelled as random wherever it appears — it is never presented as a statistic.
ZIP code heat map FAQ
Is this ZIP code heat map maker free?
Yes. Parsing, classing, the map and every export are free, with no account, no trial and no row limit. The only network requests are for the static public-domain boundary files, which never carry your data.
Can I paste straight from Excel?
Yes. Excel and Google Sheets copy cells as tab-separated text, which is detected automatically. A saved .csv can be opened with the file picker or dragged onto the map panel. Quoted cells containing commas or newlines stay in one piece.
What happens to ZIP+4 codes and leading zeros?
ZIP codes are handled as text, never as numbers. 90210-1234 becomes 90210, 02138 keeps its zero, and a 4-digit 2138 left behind by Excel is padded back to 02138 — each repair is counted in the notes under the box so you can see what changed.
Which classing method should I use?
Quantile when you care about rank and want equal-size colours; equal interval when the numbers themselves should stay round; natural breaks (Jenks) when the distribution is lopsided and the gaps matter; custom breaks when the scale is fixed by a target or a policy. The legend always shows the range and the count for every class.
What does normalising by land area do?
It divides each value by the ZCTA's Census land area in square miles, turning counts into densities. Large rural ZCTAs stop dominating the map and dense urban ones rise. The legend unit changes to “per sq mi” and the exported CSV keeps both the value you pasted and the land area, so the conversion is reproducible.
Why is a ZIP missing from the map?
Some ZIPs serve only PO boxes, military mail or a single building, so the Census Bureau never draws a ZCTA for them. They are listed in the unmatched report with that reason. The tool does not invent a polygon or quietly move the value to a neighbour.
Can I share a map with a link?
Datasets of up to 200 rows are encoded into the URL hash, so a refresh or a pasted link restores the rows, the value column, the classing and the palette. Larger datasets are not encoded — the page says so instead of silently truncating the link.
What can I export?
A self-contained SVG with the legend, a 2× PNG for slides and chat, an RFC 7946 GeoJSON FeatureCollection carrying the value and class on every ZCTA, and a CSV that adds class, colour, city, county and land area to your ZIP list.