Excel ZIP Code Heat Map Without Cleaning Your Sheet
Most ZIP columns in Excel are broken before they reach a mapping tool: 02138 became 2138, 90210-1234 lost its hyphen, $12,480 became text. This tool repairs all of that on paste and tells you what it repaired.
From spreadsheet to map
Copy the cells and paste — tabs are detected for you
Excel and Google Sheets put a tab between cells and a newline between rows; this tool scores the delimiters and picks the tab. Quoted cells that contain a comma, such as "$12,480", stay in one piece, and quoted newlines inside a cell do not split the row.
Leading zeros and ZIP+4 are repaired, not misread
ZIP codes are stored as text, never as numbers. "02138" stays 02138, "2138" is padded back to 02138 and counted in the notes as a repair, "90210-1234" is truncated to 90210, and "2138.0" — what Excel leaves behind after a numeric conversion — is handled too.
Money, thousands separators and percentages parse
"$12,480.00" becomes 12480, "1,234" becomes 1234, "61%" becomes 61, and "(500)" becomes −500. A cell that still cannot be read is treated as "no value" and counted in the notes instead of being turned into a zero.
Duplicates and blank rows are reported, not hidden
Blank rows disappear. Two rows for the same ZIP merge with the rule you choose and the count of merged rows appears in the notes. If you need to keep them apart, export the CSV and join it back to the original sheet.
The sample below is a deliberately messy sheet: ZIP+4, a leading zero, currency, percentages, duplicate ZIPs, a blank row and a PO-box ZIP with no ZCTA. Every value is random sample data.
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.
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.
Excel ZIP Code Heat Map Without Cleaning Your Sheet — questions
Do I need to format the ZIP column as text in Excel first?
No. Pasting is enough: a 4-digit value is padded to five digits and the repair is reported. Formatting the column as text before you copy is still the cleanest habit, because it stops Excel from dropping the zero in the source file.
Does the file get uploaded anywhere?
No. The file reader, the parser, the classing and every export run in this page. The only network requests are for the static public-domain boundary files, and they never carry your rows.
What about a ZIP that will not appear on the map?
PO-box, military and single-building ZIPs have no Census ZCTA, so there is no polygon to draw. They are listed in the unmatched report with that reason, and can still be totalled from your own sheet — they are just not painted on the map.
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.