Yes. ArcGIS for Excel can display mapped point data as a heat map: add your location data to a map, select its point layer, open the layer’s Styles options, and choose Heat Map. The result is a geographic visualization of where points are concentrated; it is not the same as an Excel color scale or a calculated statistical density surface.
That distinction matters. ArcGIS for Excel connects spreadsheet records to places on a map, while Excel’s ordinary conditional formatting colors cells according to their values. Use ArcGIS when the pattern you want to explore is geographic, such as clusters of store visits or service requests across a city.
What an ArcGIS for Excel heat map shows
A heat map represents the concentration of point features using color intensity. Areas where mapped points are close together appear more prominent than areas with fewer nearby points. This can make a large collection of overlapping locations easier to read than a map that draws every point with the same symbol.
For example, imagine a worksheet with one row per customer visit and columns for latitude and longitude. A heat map can reveal neighborhoods with many visits and areas with fewer. It does not, by itself, explain why visits cluster there, prove that a population is at risk, or calculate a rate. Those interpretations require suitable data and analysis beyond simply styling the points.
The display is also different from a heat map of values in a table. In Excel, a color scale can shade cells according to their numbers, but it has no geographic meaning unless the data is separately mapped. ArcGIS for Excel puts the pattern in spatial context, such as roads, boundaries, or other map layers.
Prepare the worksheet data
Each row should represent a feature you want to map, and the worksheet needs a way to identify where that feature is. Latitude and longitude are usually the most direct choice. If you use coordinates, check that latitude and longitude are in separate columns, are numeric, and use the expected coordinate reference system—commonly geographic coordinates in decimal degrees for ordinary GPS-style data. A swapped pair can place records far from their intended locations.
You can also use address fields or place names, depending on the data and the add-in’s available location-matching options. Addresses may need separate street, city, region, and postal-code fields for more reliable matching. Remove blank rows, check inconsistent spellings, and make sure headings are clear. If two records refer to the same address, they will overlap geographically; that may be exactly what the heat map is meant to make visible.
- Coordinates: Best when you already have reliable latitude and longitude values.
- Addresses: Useful for customer or facility lists, but incomplete or ambiguous addresses can match incorrectly or fail to locate.
- Place names: Convenient for well-known locations, but names such as “Springfield” can refer to multiple places unless you include a region or country.
- One row per event: Appropriate when each visit, report, or observation should contribute a point to the display.
Keep an identifying column, such as a record number, if you will need to inspect individual records later. A heat map emphasizes clusters, so it is not a substitute for retaining the underlying rows or showing record-level detail when that detail matters.
Create the map and apply Heat Map styling
In Microsoft Excel for Microsoft 365 on Windows, add ArcGIS for Excel if your organization permits it. A common route is Insert > Get Add-ins, then search for ArcGIS for Excel; availability and the exact add-in controls can depend on your organization’s Microsoft 365 settings. Open the add-in, sign in if prompted, and use its map and data controls to add the worksheet data as a layer.
- Choose the worksheet range or table that contains the records, including its column headings.
- Identify the columns that describe location. Select latitude and longitude when available, or choose the appropriate address or place fields.
- Review the resulting points on the map. Check for unmatched addresses, misplaced records, and unexpected clusters before styling.
- Select the point layer, open its Styles options, and choose Heat Map.
- Adjust the available style settings, then zoom and pan to the area and scale relevant to your question.
Interface labels and the placement of controls can change between add-in releases. If a control is not where expected, look for the selected layer’s styling or layer-options panel rather than assuming the worksheet itself has a Heat Map command. The heat map belongs to the map layer, not to Excel’s cell-formatting ribbon.
ArcGIS for Excel is also offered in environments beyond Windows, but add-in availability and the surrounding Excel interface can differ in Excel for the web or on Mac. If your organization uses one of those environments, check that the add-in is enabled there and follow the controls displayed in that version rather than relying on Windows-only ribbon instructions.
Choose settings and interpret the display carefully
Heat map appearance depends on the map scale, the distribution of points, and the layer’s available styling settings. A cluster that looks like one broad hotspot when zoomed out may separate into smaller groups when you zoom in. Conversely, individual hotspots can merge at a wider extent. Compare maps at similar zoom levels before treating a change in color pattern as a real change in the data.
Where the style offers choices such as color scheme or influence area, choose a ramp with clear contrast and avoid implying a meaning the data does not support. A bright color does not automatically mean danger, high performance, or statistical significance. It simply represents the visual density or intensity defined by the map style. The exact controls available can vary by version and layer, so inspect the options shown in your add-in.
Consider the question before choosing the style. A heat map is useful for answering “Where are observations concentrated?” It is less suited to “Which individual record is this?” or “What is the exact value at this location?” For those questions, use a point style, labels, a table, or a map popup that exposes individual feature information. If the goal is to compare event counts between administrative areas, a choropleth or a table of rates by area may be more appropriate.
Heat map versus Excel color scales and other map styles
Excel’s built-in color scales are intended for cells. Select a range and use Home > Conditional Formatting > Color Scales to shade values from lower to higher. This is useful for a matrix, such as monthly sales by product, but it does not place the values on a map. ArcGIS for Excel instead associates rows with locations and draws a geographic layer.
Within a map, a heat map is only one way to show data. Individual symbols make separate locations easier to identify, but can overlap when there are many points. Graduated colors or symbol sizes can communicate a numeric attribute for each feature, while categories can distinguish types such as store, clinic, and warehouse. A heat map prioritizes the spatial concentration pattern, not the identity of every point.
Do not confuse a heat map renderer with a formal density-analysis result. Styling a point layer changes how it is drawn; it does not necessarily create a new dataset with density values that can be exported, measured, or used as analytical output. If your project needs a defined statistical method, a documented search radius, or a reusable raster or density surface, check the analysis tools available in your ArcGIS environment and choose a workflow designed for that purpose.
Common problems and practical fixes
- No points appear: Confirm that the selected worksheet range includes data rows and that the location columns were identified correctly. Check for blank or text-formatted coordinate values.
- Points appear in the wrong place: Verify that latitude and longitude were not reversed, and check the coordinate system and units. Decimal degrees should not be entered as degrees-minutes-seconds text unless the workflow supports that format.
- Some addresses are missing or misplaced: Add city, state or region, and country where appropriate. Correct typos and inspect unmatched or questionable locations rather than assuming every address was found accurately.
- The heat map looks like one solid patch: Zoom in, review the layer’s available influence or appearance settings, and check whether dense overlapping records are expected. A broad hotspot may reflect map scale rather than a single precise center.
- The map is slow or hard to use: Large worksheets and complex location matching can take time. Start with a manageable sample to verify the workflow, then map the full dataset if performance and organizational limits allow.
- Heat Map is unavailable: Check that you selected a point layer and that the add-in is current and enabled. Some layer types or organizational configurations may not expose the same styling choices.
Accounts, credits, and data handling
ArcGIS for Excel is an add-in, but access to ArcGIS services and capabilities can depend on your account, organization, and configuration. Some workflows may require signing in to an ArcGIS account. Location matching, analysis, or other service use may also be subject to organizational limits or ArcGIS credits; the applicable rules depend on the service and workflow. Check your organization’s ArcGIS settings and current Esri documentation before processing a large dataset or estimating a project’s cost.
Be especially thoughtful with sensitive information. Address matching and mapping can involve sending location data to a service, and a map may make private patterns easier to see even if the workbook was previously shared only with a small group. Follow your organization’s data-classification and sharing rules, avoid uploading information you are not authorized to process, and confirm who can access the map and its layers. A heat map can reduce the visibility of individual points, but it should not be treated as a privacy guarantee: a small or distinctive cluster may still reveal sensitive activity.
When to use an alternative
Use Excel conditional formatting when you want to color values in a table and geography is irrelevant. Use an ArcGIS point layer with individual symbols when people need to find or inspect particular facilities or events. Choose a different ArcGIS map style when the main message is a numeric value per location, a category, or a comparison across defined areas. For a rigorous density calculation, use an analysis workflow that explicitly produces the required analytical output rather than relying on a visual style alone.
A sensible decision process is to state the question in one sentence, identify the geographic unit represented by each row, and decide whether the answer depends on clusters, individual points, categories, or area-level comparisons. Then test the map at the scale where readers will use it. This prevents a visually appealing heat map from being mistaken for an answer to a question it was not designed to address.
Frequently Asked Questions
Can Excel itself make a geographic heat map?
Excel’s built-in conditional formatting creates color scales in worksheet cells, not geographic maps. To map locations and show their concentration, use ArcGIS for Excel or another mapping tool that can link records to places.
Does an ArcGIS for Excel heat map change my worksheet data?
Applying Heat Map styling changes the map’s visual representation, not the values in the worksheet. Location matching or other workflows may use ArcGIS services, so check the add-in’s prompts and your organization’s data rules.
Can I make a heat map from addresses instead of coordinates?
Often, yes, if the add-in can match the address fields to locations in your ArcGIS environment. Complete addresses are more reliable than a street name or place name alone; inspect the mapped results for errors.
Can a heat map show the value of each individual point?
Its main purpose is to show concentration, so exact point-level values may not be easy to read from the color pattern. Use an individual-symbol style or inspect feature details when record-level values matter.
Does the heat map prove that an area has a high rate of incidents?
No. A concentration of mapped records shows where the supplied points are clustered, not the rate relative to population, area, or exposure. To compare risk or incidence fairly, you need an appropriate denominator and a suitable analysis.
Do I need an ArcGIS account to use it?
Account requirements depend on the add-in’s current configuration and the ArcGIS services your organization enables. Sign-in, licensing, and credit requirements can differ by workflow, so check with your ArcGIS administrator or the current Esri product guidance.
Related
- 0 in Excel Conditional Formatting: 10 Practical Rules
- 2-Dimensional Data Table in Excel: 10 Practical Uses
- Why Is Excel Not Letting Me Transpose Data?
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Double Space Each Line in Microsoft Word EasilyTo double-space text in Word, select the text, then choose Home > Line and Paragraph Spacing > 2.0.…
- How to Make a Brochure in Microsoft Word Step by StepTo make a tri-fold brochure in Microsoft Word, set the page to landscape, divide each of two pages…
- Conditional Formatting to Highlight an Entire Row in ExcelYes. In Excel for Microsoft 365, select the data range, create a formula-based conditional-formatting rule, and use a…
- Excel Date Shortcut: Insert Today’s Date with Ctrl+;In Excel for Microsoft 365 on Windows, press Ctrl+; (Ctrl plus the semicolon key) to insert today’s date…
- How to Set Out of Office Dates in Outlook for Any DeviceTo set out-of-office dates in Outlook, open Automatic Replies, turn on replies for a specific time period, enter…
- How to Undo a Sort in Google SheetsTo undo a sort in Google Sheets, press Ctrl+Z on Windows or Chromebook, or Command+Z on Mac, immediately…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.