Sales Territory Heat Map From a ZIP Column

Territory reviews are usually a spreadsheet with a ZIP column and a couple of numbers next to it. This page turns that sheet into a heat map you can paste into a deck, and keeps the same numbers on the CSV you export back out.

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

From spreadsheet to map

  1. Export the sheet as CSV, or just copy the cells

    Select the ZIP column and every numeric column in Excel or Google Sheets and copy. A tab-separated paste is detected automatically; a saved .csv works through the file picker or by dropping it on the box. Keep the header row — it becomes the value-column names in the tool.

  2. Decide whether to sum, average or take the maximum

    One ZIP can appear on several rep rows. Sum answers "how much is booked in this ZIP"; mean answers "what is the average attainment here"; max answers "what is the best result anyone posted here". Duplicate handling is a control, not a hidden default.

  3. Class the values the way the review will read them

    Quantile classes put the same number of ZIPs in each colour, which is what you want when comparing territories of similar size. Equal-interval classes keep the numbers round. Natural breaks (Jenks) find the gaps in the distribution. Custom breaks are for a fixed scale such as 0–50–100% quota.

  4. Export once, use everywhere

    The SVG keeps its legend and vector edges for slides and Figma; the 2× PNG drops into Slack; the GeoJSON carries the value and the class number per ZCTA so it opens in any GIS tool; the CSV adds the class and colour back onto the ZIP list for the next review.

The sample below is a random 25-ZIP territory sheet — accounts and attainment are generated in your browser, not real sales data. Replace it with your own paste.

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.

Sales Territory Heat Map From a ZIP Column — questions

Can two reps own the same ZIP?

Yes, and the tool expects it. Each extra row for a ZIP is merged with the duplicate rule you pick. If you need to see the split rather than the total, export the CSV, which keeps one row per ZIP with the chosen class and colour so you can join it back to the original sheet.

Do quota percentages need to be entered as 0.61 or 61?

Either, as long as the column is consistent. A trailing percent sign is stripped and the printed magnitude is kept, so "61%" becomes 61 — not 0.61. Mixing both forms in one column will produce a misleading map, so pick one before you paste.

Which classing method should a territory review use?

Quantile if the question is "who is ahead of whom", because every colour holds the same number of ZIPs. Equal interval if the numbers themselves matter, such as attainment against a fixed target. Natural breaks when the distribution is lopsided and you want the map to show the few outliers rather than flatten them.

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.