Postcode Heat Map in Excel: Data, Setup and Limits

How-to basics · Updated November 21, 2026

Yes—Excel for Microsoft 365 can make a postcode heat map using a Filled Map chart: put postcode areas and their values in a table, select it, then choose Insert > Charts > Maps > Filled Map. It works only when Excel can identify the locations, and full postcodes are not reliably supported everywhere; for precise postcode boundaries, you may need a dedicated boundary map instead.

What a postcode heat map in Excel shows

An Excel Filled Map is a choropleth: it colors geographic regions according to a value, such as sales, customer counts, service requests or average delivery time. A darker shade can mean a higher value, for example. The chart is useful for spotting broad geographic patterns, but it is not the same as a heat map of individual addresses or a density surface showing where points cluster.

The word postcode can refer to different levels of geography. A postcode district or area may cover a sizeable region, while a full postcode can identify a much smaller group of addresses. Excel’s map chart needs a geographic region it can match to its map service. It may recognize some postal codes or districts, but support and geographic detail vary by country and by code type. It does not let you upload arbitrary postcode boundary polygons and use them as the chart’s regions.

That distinction matters: if your goal is to compare performance across broad postcode districts, a Filled Map may be adequate. If you need each full postcode represented by its official boundary, or need to plot customer locations as points, a different mapping tool is usually more suitable.

Prepare postcode and value data

Use a simple table with one row per geographic unit and one numeric measure. For example, a UK table might have columns headed Country, Postcode district and Orders, with rows such as England, AB10 and 42. Including the country helps distinguish codes that could otherwise be ambiguous. For data from another country, use the relevant country or region column and the postal-code format appropriate to that place.

Before building the chart, check the following:

  • Keep postal codes as text. Codes can contain letters, spaces or leading zeroes. If a code such as 02108 is treated as a number, Excel may change it to 2108. Format the column as Text before entering or importing the codes, or check the imported values carefully.
  • Use one consistent format. Extra spaces, inconsistent capitalization and mixed code levels can prevent matching. Standardize spacing and spelling, but do not remove meaningful characters from a postal code.
  • Aggregate repeated locations. If there are many transactions for one postcode, summarize them first. A PivotTable can group the records and calculate a total or average. Select the source data and choose Insert > PivotTable, then place the geographic field in Rows and the measure in Values.
  • Choose the right measure. Totals can make high-volume areas look important simply because they have more customers. For fair comparisons, a rate or average may be more informative, provided its denominator and calculation are appropriate.

For a quick test, start with a handful of well-known locations rather than thousands of rows. Confirm that Excel maps them as intended before cleaning and summarizing a larger dataset.

Create the Filled Map chart

  1. Put the location information and the numeric measure in adjacent columns, with a clear header in each column. If needed, include a country or state column to make the geography less ambiguous.
  2. Select the table, including its headers.
  3. On the Windows desktop version of Excel for Microsoft 365, choose Insert > Charts > Maps > Filled Map. Excel will send the geographic information to its mapping service to identify the regions.
  4. Review the plotted regions before using the chart. If Excel misidentifies a code or leaves it unmapped, correct the source data or add clearer geographic context.
  5. Add a descriptive chart title and make the legend clear about what the colors represent, including units where relevant.

On Excel for Mac, the map-chart option and formatting controls can differ by version, but look under Insert for Maps or Map charts. Excel for the web may have different creation and editing support; use the desktop app if the map option is unavailable or the chart cannot be configured there. The chart relies on an online map service, so internet access may be needed to create or refresh its geographic display.

Make the map easier to read

A map can look polished while communicating very little if its colors and scale are poorly chosen. Use a restrained sequence of light-to-dark shades for values that increase, and avoid a rainbow palette that suggests categories when the data is continuous. Keep the legend visible and label the measure, such as Orders per district or Average response time in days.

Look at how the data is distributed before deciding what the colors mean. A few very large values can compress most regions into nearly the same pale shade. If this happens, consider whether a different measure, a carefully chosen scale or a separate chart would communicate the pattern more fairly. Do not change the data merely to produce a more dramatic-looking map.

Check the geographic coverage as well as the colors. A large region can dominate the visual area even when it has relatively few records, while many small regions can be difficult to distinguish. A map is strongest when it answers a clear question, such as which districts have the highest order totals, and is paired with a table or chart when readers need exact values.

Common mapping problems and fixes

  • No map chart appears. Check that the selected data contains a location field and a numeric value, and that you are using a desktop version with map charts available. If the command is disabled, test a small table with recognized geographic names.
  • Some postcode rows are missing. Excel may not recognize that code type or geographic level. Add a country or state column, check for typos and spaces, and try a broader postcode district. If it still cannot match the region, the chart cannot reliably plot it as supplied.
  • A code is mapped to the wrong place. Postal-code formats can overlap or be ambiguous when the country is omitted. Include the country and, where helpful, a broader region. Validate a sample against a trusted reference rather than assuming every match is correct.
  • Several rows seem to collapse into one area. Duplicate locations may represent separate source records, but a region-based map needs a meaningful summary for each area. Aggregate the records first and decide whether the value should be a sum, average, count or rate.
  • Small areas are hard to see. A country-scale map can make district-level details difficult to inspect. Zooming is not a substitute for suitable boundaries; use a more detailed map source or show a ranked table alongside the chart.

Also check whether the source codes refer to current or historical geography. Postal areas can change over time, and a map made with a current boundary may not accurately represent older records. Keep the period and geographic definition with the data so that comparisons can be interpreted correctly.

Choose a useful measure and interpret it carefully

Map colors show the values supplied to Excel; they do not explain why those values differ. A district with more orders may simply have more residents or customers. Where the question is about relative performance, a measure such as orders per customer or complaints per 1,000 deliveries may be more informative than a raw total. State the denominator and time period, and avoid comparing rates based on very small counts without appropriate context.

Geographic size can also mislead readers. A lightly populated rural district may occupy much more map area than a dense city district, even if the city contains more people or activity. The visual area of a region is not a measure of its importance. For decisions that need exact comparisons, include a sorted table or a bar chart with the map.

Finally, a postcode map is not automatically evidence of a local cause or trend. Differences can reflect the mix of customers, reporting practices, missing records or the way boundaries are drawn. Treat the map as a way to explore and communicate geographic variation, then examine the underlying data before drawing conclusions.

When Excel is not enough

Excel’s Filled Map is a convenient starting point when its built-in geography matches your postcode level and a shaded regional summary answers the question. It is less suitable when you require custom boundaries, highly detailed UK postcode sectors or full postcodes, point locations, route analysis, or fine control over labels and map projections.

For those needs, use a geographic information system or another mapping product that can load a suitable postcode-boundary file and join it to your summarized data. Boundary data may come with licensing, attribution, update and permitted-use conditions; check those terms before distributing a map. A boundary file must also use the same geographic codes and vintage as the spreadsheet, or the join can omit or misplace records.

Another practical option is to keep Excel as the data-preparation tool and move the finished summary to mapping software. This avoids forcing a detailed boundary problem into a chart designed for recognized geographic regions. If you only need to compare areas rather than display their shapes, a PivotTable and a sorted bar chart may be simpler and easier to read.

Frequently Asked Questions

Can Excel make a map by postcode?
Yes, Excel for Microsoft 365 can create a Filled Map when its map service recognizes the postcode geography. Results depend on country and code level, so test a few rows. Excel may not support the exact boundary detail needed for full postcodes.

How do I make a postcode heat map in Excel?
Prepare a table with one location per row and a numeric measure, select it, then choose Insert > Charts > Maps > Filled Map in Excel for Microsoft 365 on Windows. Check that every intended region is correctly matched and that the legend explains the colors.

Why does Excel not recognize my postcodes?
The code may be ambiguous, incorrectly formatted, or too detailed for the map service to match. Keep it as text, check spelling and spacing, and add a country or broader region. Some postcode types simply are not available as Filled Map regions.

Can I map full UK postcodes in Excel?
Do not assume that Excel’s built-in map will display every full UK postcode as an exact area. Its supported geographic detail can be limited, and full postcodes may not correspond to regions the chart can draw. For exact postcode boundaries, use a suitable boundary dataset and mapping software that supports custom polygons.

Is an Excel Filled Map a true density heat map?
No. A Filled Map colors geographic regions using a value, so it is a choropleth. A density heat map usually represents the concentration of point locations across space. The two visuals answer different questions and should not be treated as interchangeable.

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.