Excel ZIP Code Heat Maps: How to Build and Read Them

How-to basics · Updated November 21, 2026

Yes. In Excel for Microsoft 365 on Windows, select a table of ZIP codes and values, then choose Insert > Maps > Filled Map to color geographic areas by value. For a point-density display, use Insert > 3D Map > Open 3D Maps and choose its Heat Map layer; ZIP-level results depend on how well Excel can locate the codes.

What a ZIP code heat map shows

A heat map uses color to communicate where measurements are higher or lower. On a ZIP-code map, the measurement might be the number of customers, orders, survey responses, service calls, or another quantity associated with each area. Darker or more saturated colors generally indicate larger values, but the legend determines what a shade actually means.

Excel offers two different map approaches that are often both called heat maps. A Filled Map colors geographic regions according to values in a data table. A 3D Maps Heat Map layer emphasizes concentrations of mapped locations. They answer related but not identical questions: a filled map is useful for comparing a value assigned to each ZIP area, while a density layer is useful for seeing where many mapped records cluster.

Neither is the same as Excel’s cell-based heat map made with Home > Conditional Formatting > Color Scales. Conditional formatting colors cells in a worksheet; it does not create geographic boundaries. A map is more intuitive for location patterns, but it also introduces geocoding and boundary limitations that a cell color scale does not have.

Choose the right Excel map

Start with the question you need the visual to answer. If you have one summarized value for every ZIP code and want to compare areas, try a Filled Map. It shades regions, making broad patterns easy to spot. Excel uses geographic recognition to match entries to places, so clear, consistently formatted location fields matter.

If your table contains individual addresses or many records located within ZIP codes, 3D Maps can plot those locations and display a Heat Map layer. This is a density-style view: areas with more mapped points appear more concentrated. If you need to compare a numeric total by ZIP rather than simply show where records occur, summarize the values by ZIP first and use a Filled Map or a suitable 3D Maps region view.

  • Use a Filled Map to compare summarized values assigned to geographic areas.
  • Use a 3D Maps Heat Map layer to explore the concentration of location records.
  • Use a regular chart or a worksheet color scale if the geographic pattern is not important or Excel cannot resolve the ZIP codes reliably.

Do not assume that every Excel map has the same level of detail. A map may recognize a country or state while failing to identify a particular ZIP code. The correct choice also depends on your Excel version, platform, and the location data available to Excel’s mapping service.

Prepare ZIP code data before mapping

Good results begin with a tidy table. Give each column a single, clearly named field, with one row per ZIP code for a Filled Map. Include the ZIP code, the numeric value to display, and—especially for U.S. codes—separate State and Country fields. A location described as ZIP 12345 can be ambiguous; combining it with a state and United States gives Excel more context.

Keep U.S. ZIP codes as text. Codes in states such as Massachusetts can begin with zero, and Excel may remove that zero if it treats the entry as a number. Set the column to Text before entering or importing the data. Applying a display format afterward may make a missing zero appear, but it does not change the underlying value into a text ZIP code. When importing a CSV, check the import options and the resulting column rather than assuming Excel preserved the codes.

For a map with one value per ZIP, aggregate repeat records first. For example, if a sales table has several transactions for ZIP 02139, sum the sales by ZIP in a PivotTable or another summary. That produces a clear value to map and avoids relying on Excel to decide how repeated locations should be combined. Check that the summary has no blank ZIP codes, that the values are numeric, and that the ZIP and state combinations are valid.

  • Use consistent five-digit ZIP codes where the analysis is at ZIP level; ZIP+4 codes represent more specific delivery segments and may not map as areas.
  • Use a separate state column instead of combining state abbreviations inconsistently into ZIP cells.
  • Remove totals and notes from the source range, and convert the data into an Excel table with Insert > Table if the dataset will be updated.

Create a Filled Map in Excel

  1. Arrange the summarized data in columns such as ZIP Code, State, Country, and Customers. Make sure the value column contains numbers and the geographic fields are identifiable.
  2. Select the data range or a cell in the table. Choose Insert > Maps > Filled Map. If Excel does not recognize the ZIP codes, revise the location fields—for example, add the state and country—and try again.
  3. Review the result rather than assuming every row was plotted correctly. Check the chart for missing areas or unexpected shading and compare a few ZIP codes with a trusted reference.
  4. Use the chart formatting options to adjust its appearance and legend. Keep a meaningful legend visible so readers can tell what the colors represent and what value range each color covers.

Map charts rely on online geographic data, so an internet connection and the availability of connected experiences can matter. If the Maps command is absent or the chart cannot render, check the Excel edition and update status, confirm that connected services are available, and try a less detailed location such as state or county to isolate the problem. Menu availability can differ by platform and release; Excel for the web may not offer the same map-authoring features as desktop Excel.

A Filled Map is most useful when the map itself is legible at the chosen level. If ZIP boundaries are crowded or the values vary widely, adjust the scale or consider a table beside the map. Avoid adding too many data labels: a dense label layer can obscure the shape and color patterns the chart is meant to reveal.

Explore location density with 3D Maps

In Excel for Microsoft 365 on Windows, select the location data and choose Insert > 3D Map > Open 3D Maps. In the 3D Maps window, assign the appropriate location field or fields—such as ZIP code, state, and country—so Excel can geocode the records. Then select the Heat Map visualization in the layer options. The interface may vary slightly with updates, and the result depends on how accurately the locations are resolved.

3D Maps is particularly useful when the source has many individual location records rather than a single summarized row per ZIP. Inspect the plotted points or another view first to confirm that locations landed in the expected country and region. A density surface built from incorrectly located records can look convincing while communicating the wrong pattern. 3D Maps is a Windows desktop feature; it is not available in the same way in Excel for Mac or Excel for the web. On those platforms, try a supported Filled Map chart or use an external mapping tool.

Understand ZIP boundary and interpretation limits

A ZIP code is a U.S. Postal Service mail-delivery identifier, not a promise of a neat, permanent geographic polygon. ZIP codes can describe delivery routes or facilities, and their boundaries are not equivalent to municipal boundaries. Some ZIP codes do not correspond to ordinary residential areas. The geographic shapes used by mapping products are constructed representations, and vendors may use different boundary datasets or update schedules.

That matters because a Filled Map colors an area, which can suggest that the measured value applies evenly throughout the shaded shape. It does not. If a ZIP code has 200 customers, that total is attached to the mapped ZIP area; the chart does not show where within the area those customers live. A ZIP centroid, when used to place summarized data, is a representative point, not the location of every customer.

Color choice can also affect interpretation. A sequential light-to-dark scale usually communicates increasing amounts more clearly than unrelated colors. Skewed data may leave most areas looking almost identical if a few ZIP codes have very large values. Consider whether to show raw counts, rates, or another normalized measure. For example, a ZIP with more residents may naturally have more customers; customers per 1,000 residents may answer a different and more useful question. Explain the denominator and time period, and do not compare rates when their underlying population figures are not comparable.

Common problems and practical fixes

  • ZIP codes lose leading zeros: import or store the field as Text, then verify the actual cell contents. A custom number format is not a dependable substitute for text in a location field.
  • Excel maps a code to the wrong place: add separate State and Country columns, check for typos, and make sure ZIP codes have the intended length. Ambiguous codes need context.
  • Some ZIP areas are missing: test the affected entries individually and verify that Excel recognizes the geography. Some codes may not have a usable mapped boundary. Consider a different geographic level or a mapping source with an appropriate boundary dataset.
  • The chart shows an unexpected total or pattern: check for duplicate rows, blank locations, text values in the measure column, and accidental inclusion of a grand-total row. Compare the map with a PivotTable summary.
  • The map looks blank or will not load: check the connection, Excel updates, and access to connected mapping services. Try a small sample with well-known ZIP codes to separate a data issue from a service or version issue.

For quality control, keep the source table and the summary used to make the map. Record the measure, date range, geographic level, and any exclusions. A map is easier to review when someone can trace a color back to a value instead of treating the visual as the only record of the analysis.

Alternatives when Excel is not enough

If Excel cannot map the ZIP boundaries you need, consider a mapping product or a geographic information system that accepts a ZIP boundary file and a matching data table. Check the boundary provider’s coverage, update date, license, and definition before using it; not all ZIP boundary products represent the same geography. You may need to join the data to the boundary file using a consistent ZIP field.

A PivotTable with a sorted bar chart is often a better alternative when the main task is ranking ZIP codes rather than seeing their spatial relationship. It is easier to label precisely and does not imply that a ZIP boundary is exact. A worksheet color scale can also help compare a compact list, but it should not be described as a geographic map.

Frequently Asked Questions

Can Excel make a heat map from ZIP codes?
Yes. A Filled Map can shade recognized geographic areas using a value column, and 3D Maps offers a Heat Map layer for location density. The level of ZIP-code support depends on the data and mapping service.

Why does Excel not recognize my ZIP codes?
Common causes include missing leading zeros, ambiguous locations, extra spaces, or absent state and country context. Store codes as text, check the entries, and add separate state and country fields. Some ZIP codes may not have a usable mapped area.

Should I use a Filled Map or 3D Maps?
Use a Filled Map to compare a summarized value for each ZIP area. Use 3D Maps when you want to explore the concentration of many mapped records. Confirm that the displayed result matches the question you are asking.

Can I make a ZIP-code heat map in Excel for Mac?
Excel for Mac does not provide 3D Maps in the same way as Windows. Map chart support and available commands can vary by version, so check for Insert > Maps > Filled Map. If it is unavailable or cannot resolve ZIP codes, use a different mapping tool or a non-map chart.

Are ZIP code map boundaries exact?
No. ZIP codes are postal identifiers, and ZIP boundary shapes are representations rather than definitive USPS neighborhood polygons. Treat the map as an analytical visualization, verify important results against an appropriate geographic source, and explain the limitation when sharing it.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.