Yes. In Microsoft Excel for Microsoft 365 on Windows, you can shade ZIP-code regions with a filled map: arrange ZIP codes and one numeric measure in columns, select the data, then choose Insert > Charts > Maps > Filled Map. Excel may not recognize every ZIP code or draw it at the level you expect, so keep ZIP codes as text, add location context when needed, and test a few records before relying on the map.
What an Excel ZIP-code heat map shows
Excel’s filled map is a choropleth: it colors geographic areas according to the values in your data. For example, a sales table could shade ZIP-code regions from lighter to darker based on sales totals. That is useful for spotting broad geographic patterns, comparing areas, or communicating where a measure is relatively high or low.
A filled map is not the same as a point-density heat map. It colors recognized regions rather than plotting individual addresses or calculating how tightly clustered points are. The visual result depends on the geographic boundaries Excel can identify and the scale it applies to your values. A ZIP code is also a postal identifier, not necessarily a neatly bounded neighborhood or a measure of population density. Treat the shaded area as a way to compare records, not proof that every resident or location in that region has the same value.
For a basic chart, use one location field and one numeric measure. A small source table might have columns named ZIP Code and Orders, with entries such as 02139 and 18, or 10001 and 42. Those numbers are illustrative. If there are multiple records for a ZIP code, decide how they should be combined before mapping them.
Prepare ZIP codes and values before mapping
ZIP codes are identifiers, not numbers to calculate with. A code such as 02139 begins with a zero; if Excel interprets it as a number, it may become 2139. Set the ZIP-code column to Text before entering or importing the codes. For a CSV, review the import settings and assign the location column a text type rather than assuming Excel will preserve its contents. Applying a display format after a zero has already been discarded does not always repair the underlying source cleanly.
Check the data for consistent, meaningful locations and measures:
- Use one standard format for the geography. For a map intended to compare five-digit ZIP areas, avoid mixing five-digit ZIP codes, ZIP+4 codes, and other postal formats in the same location column.
- Add context when it may help identify a location. A separate State or Country column can help distinguish locations or support recognition, especially when a list contains codes from different countries.
- Remove blank location cells and investigate spelling, extra spaces, and accidental punctuation. One malformed entry can be left unmapped even when the rest of the chart works.
- Choose a measure that makes sense to compare, such as order count, revenue, or a rate. A total count and a per-person rate tell different stories.
- Aggregate repeated ZIP codes deliberately. A PivotTable can summarize repeated records by ZIP; choose Sum, Count, or Average based on what the metric means rather than accepting a default without checking.
Keep a copy of the original detailed data. The map’s input can be a clean summary table, while the source records remain available for audits and later analysis.
Create the filled map in Excel
- Put descriptive headers above the location and measure columns. For example, use ZIP Code and Orders rather than an unexplained abbreviation.
- Select the two columns, including their headers. If you have added State or Country context, include the relevant location fields too, while keeping the table organized so Excel can identify the geographic information and the measure.
- On the Windows ribbon, select Insert > Charts > Maps > Filled Map. Excel uses online geographic mapping services to resolve and display locations, so the result can depend on connectivity and service availability.
- Review the chart as soon as it appears. Check whether the intended ZIP areas are shaded and whether the legend reflects the values you supplied. A chart appearing does not guarantee every location was resolved correctly.
- Give the chart a specific title and keep the source table nearby. A title such as Orders by ZIP Code explains the measure and geography better than Map Chart.
In current Microsoft 365 builds for Mac, look under Insert for Maps; ribbon grouping and availability can vary by build. Excel for the web may provide different chart-editing controls from desktop Excel. If the map command or a formatting option is missing, check that Excel is updated and use the current desktop app for the full set of controls.
Format the map so it is easy to read
Use a simple color progression and make the legend understandable. A sequential light-to-dark scale usually communicates that larger values are higher, but a dramatic palette can exaggerate small differences. The chart’s default range may be influenced by the minimum and maximum values, so inspect the legend rather than assuming a particular shade represents a fixed threshold.
Select the chart to see the chart-design and formatting controls. Available map options depend on the data and Excel build; right-clicking the map and choosing Format Data Series opens relevant series settings when they are available. Chart styles can change the look of the map, while the legend, title, and surrounding labels should explain what the colors mean. If the audience needs exact values, include the summary table or a clearly labeled companion table instead of expecting a reader to infer precise numbers from color alone.
Keep the display focused. A useful chart generally has a descriptive title, a readable legend, and enough surrounding context to identify the country or state. Avoid adding a long list of unrelated categories or decorative elements. If a few very large values flatten the visual differences among most ZIP codes, consider whether a rate, a different summary, or a separate view would be more informative; do not quietly change the scale in a way that misleads readers.
Common problems and how to diagnose them
If some ZIP codes do not appear, first inspect the source values rather than rebuilding the chart. Confirm that leading zeros remain, there are no blank or malformed codes, and all rows use the same intended postal format. Then add state or country context if appropriate and recreate the chart from a small test table containing a few known locations. Excel’s geographic recognition may not resolve every postal code, and a successful chart does not certify that every boundary assignment is correct.
- ZIP codes lose leading zeros: Set the column to Text before importing or pasting. Recheck the displayed values and the source file if the zeros were lost earlier.
- Areas are missing or ambiguous: Add location context, standardize the code format, and test a short sample. If a code still cannot be mapped, use a different geographic level or a mapping method that supports your required boundaries.
- Repeated ZIP codes produce confusing results: Summarize records first and confirm that the chosen aggregation matches the measure. A total is not interchangeable with an average or a rate.
- The map appears blank or does not load: Check the network connection and whether online connected experiences are available under your organization’s settings. An administrator’s policy or a temporary service issue can affect online map features.
- The shading seems misleading: Read the legend, check the measure and its units, and look for outliers. A map colors regions; it does not automatically adjust a count for population, customers, or area size.
Interpret ZIP maps with care
ZIP codes are designed for mail delivery, and their boundaries do not necessarily correspond to stable or uniform statistical areas. The United States Census Bureau’s ZIP Code Tabulation Areas, or ZCTAs, are approximations created for statistical reporting; they are not identical to USPS ZIP-code delivery routes. This matters when a reader assumes that a colored shape is an official neighborhood boundary or that every place within it belongs to a single community.
Counts can also mislead when ZIP codes differ greatly in population or in the number of customers represented. If one ZIP has 100 orders and another has 40, the first has more orders in the data, but that alone does not show a higher ordering rate. When the question concerns comparison of likelihood or prevalence, consider a suitable denominator and explain how the rate was calculated. For a map used in a report, state the period, measure, and geography definition so readers know what is being compared.
Use Excel’s map as an exploratory or presentation view, then verify important conclusions against the underlying records and an authoritative geographic source. A filled map is a visualization, not a substitute for checking data quality or choosing the right statistical unit.
When to use another mapping method
Excel is convenient when you have a modest summary table and Excel can resolve the geographic areas you need. It may be the wrong tool when you need exact postal boundaries, address-level points, custom boundary files, advanced spatial calculations, or reliable control over how geography is matched.
- For a quick comparison in a worksheet: A conditional-formatting heat map in the ZIP-code table can show high and low values without a geographic map. Select the numeric cells and use Home > Conditional Formatting > Color Scales. This colors cells, not ZIP-code regions.
- For exact boundaries or custom geography: Use a geographic information system or a mapping platform that accepts appropriate boundary data. Confirm the data’s license, update date, and geographic definition.
- For simple location pins: A point map may be more suitable if you have coordinates or addresses and want to show locations rather than shade postal areas.
- For a state or county overview: Map the broader geography if ZIP-level recognition is unreliable or more detail would distract from the question.
Excel map charts rely on online mapping capabilities, so consider your organization’s data-handling requirements before using sensitive location data. Follow applicable company policy and use an approved tool when the data is confidential.
Frequently Asked Questions
Can Excel map ZIP codes?
Excel filled maps can recognize some postal-code geographies, including ZIP codes, but recognition and detail are not guaranteed for every code or dataset. Add context such as state or country, preserve the code as text, and verify the mapped result.
Why does Excel remove the first zero from a ZIP code?
Excel treats an all-digit ZIP code as a number unless it is stored as text or otherwise handled as an identifier. Set the column to Text before importing or entering codes so that values such as 02139 remain intact.
Can I map ZIP+4 codes instead of five-digit ZIP codes?
You can try, but ZIP+4 is more specific than a five-digit ZIP and may not correspond to a shaded area Excel can display. If your goal is to compare standard ZIP areas, use a consistent five-digit geography; retain the full ZIP+4 separately when it matters to your analysis.
How do I show several rows for the same ZIP code?
Summarize the records to one row per ZIP before creating the map. Use a PivotTable or another suitable summary and choose the correct operation, such as sum for total orders or average for a per-record average.
Can I make an Excel heat map without a geographic chart?
Yes. Use Home > Conditional Formatting > Color Scales on a range of numeric cells to create a cell-based heat map. It highlights values in a table but does not draw or shade ZIP-code boundaries.
Related
- Excel: Consolidate Text Into One Cell
- Excel Consolidate Tool: How to Combine Data
- Excel Consolidate Tabs: Methods for Combining Worksheets
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Page Breaks: How to Set, Move, and Remove ThemTo set a page break in Excel for Microsoft 365 on Windows, select the cell where the next…
- Google Sheets IF Function: Syntax and ExamplesIn Google Sheets, the IF function checks whether a condition is true and returns one value if it…
- How to Change the Outlook View to Show a Message PreviewTo show a message preview in Outlook, turn on the Reading Pane: in new Outlook for Windows, select…
- Subtotal Excel Shortcut: Open the Subtotal DialogIn Excel for Microsoft 365 on Windows, press Alt+A, B in sequence to open the Subtotal dialog. It…
- How to Make Columns in Word on One Page Only: A GuideTo put columns on just one page in Microsoft Word, isolate that page in its own section, then…
- Google Sheets Dropdown Multiple Selection ExplainedYes. Google Sheets supports multiple selections in a dropdown chip in the same cell: select the dropdown, open…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.