Customer Density by ZIP Code

A count map rewards big rural ZIPs. A density map answers the question people actually ask — where are customers concentrated — and this tool can switch between the two with one checkbox, because it ships the real Census land area for every ZCTA.

No upload SVG · PNG · GeoJSON · CSV Census ZCTA polygons Per-square-mile toggle

From spreadsheet to map

  1. Paste counts, not rates

    Paste the ZIP and the number of customers (or orders, or revenue). Keep the raw count: the per-square-mile conversion is done on Census land area inside the tool, so you can flip between count and density without editing the sheet.

  2. Turn on "normalise by land area"

    The toggle divides each value by the ZCTA land area in square miles (Census ALAND20, the same figure the boundary pages quote). Large rural ZIPs drop down the scale and dense urban ZIPs rise, which is the honest picture for expansion planning.

  3. Read the county and state roll-ups

    Below the map, two tables aggregate the same values by county and by state with a count, a sum and a mean. Use the sum for "how much business is in this county" and the mean for "how strong is the average ZIP here".

  4. Check the unmatched list before you trust the total

    PO-box, military and single-building ZIPs have no Census polygon, so they cannot be drawn. They are listed separately with the reason, and they are excluded from the map rather than being invented or silently dropped.

The sample below is a random customer sheet — counts and revenue per customer are generated locally and are not real statistics.

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”.

No data yet
Your map appears here. Paste ZIP + value rows, drop a CSV, or load the sample data.

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.

What the map does with your rows

Each ZIP in your paste is matched to its Census ZCTA polygon. Values are classed with the method you pick — quantile, equal interval, natural breaks, or your own break list — and painted with a colour-blind-safe palette. The legend always shows the range of each class and how many ZIPs fell into it, and the unmatched report lists every ZIP that could not be drawn, with the reason.

The same values drive four exports: an SVG with the legend baked in, a 2× PNG, an RFC 7946 GeoJSON with the value and class on every feature, and a CSV that adds class, colour, city and county to your ZIP list. Nothing is uploaded; the polygons are static public-domain files fetched by your browser.

Customer Density by ZIP Code — questions

Which land area does the density toggle use?

Census ALAND20 for the 2020 ZIP Code Tabulation Area, converted from square kilometres to square miles. It is land only: water is a separate field, so a coastal ZIP with a large bay is not diluted by it.

Why does my count map look so different from the density map?

Because a count is dominated by area at this scale. A rural ZIP of 400 square miles with 40 customers and an urban ZIP of 2 square miles with 40 customers are the same colour on a count map and 200 times apart on a density map. That is the whole point of normalising.

Can I use my own area figures instead?

Yes — divide the value yourself before pasting and leave the toggle off. The exported CSV always carries both the value you pasted and the Census land area in square miles, so the conversion is reproducible either way.

Related pages

State pages carry a build-time choropleth of that state's ZCTAs by Census land area, plus the tool scoped to the state.