You have all the relevant map data you need but no easy way to analyze them. You can use any of the hundreds of functions of a spreadsheet software, such as Excel, to make sense of your data and convert them into visual representations, such as graphs and pie charts. If you have at least an intermediate knowledge of Excel functions, you may be able to formulate your own sub-routines to suit your purposes; or you can use custom functions created by others and made available online. 


Need to create a heat map? You’ll most likely find a lot of Excel how-tos online, but there’s an easier solution. You don’t need to figure out how spreadsheet functions work to derive insight from your data when a simple copy-and-paste process would do the trick! ShowMyMap allows you to do just that!

Create a Heat Map with ShowMyMap

A heat map is a graphic representation of value densities within any given data. Different colors represent different values and make it easier to distinguish the varying levels of density based on markers on the map. 

With ShowMyMap’s Heat Map function, creating a heat map from your Excel data only requires a few clicks of your mouse. Here’s how to do it. 


Create a basic marker map

  1. Select all the data on your spreadsheet, including the header/s, by pressing Ctrl + A on Windows, or Cmd + A on Mac. 
  2. On ShowMyMap’s home page, simply paste the data into the allocated box by pressing Ctrl + V on Windows, or Cmd + V on Mac. 
  3. Click “ Create Map.” You will be taken to the Geocoding section; select all the appropriate fields that apply to your map. You may also configure the Map Preview and Customize Map sections. 
  4. Click “Make Map,” wait for the geocoder to generate your map, and then click “Save Map & Continue.” Choose how to save your map (public, private, or password protected), input your map’s title and your email address.
  5. Click “Save Map.” You will be shown a preview of your map and provided with your map’s URL. Go directly to your full map by clicking “View Saved Map.” It will look like this:

*Your map is interactive. You can click on any of the markers on it to browse and get more information. Overlapping markers or marker clusters will give you an idea of the density groups on your map. But the overlaps can make the data too confusing to analyze. This is where you’ll need a heat map.  


Create a heat map

  1. When you’re viewing your full map, it will be on Default mode. The Heat Map mode is available on ShowMyMap Pro, and you’ll find it beside the Default mode option on the upper right corner of your map.  
  2. Simply click on “Heat Map.” 
  3. The markers on your map will be replaced by heat map colors, as shown below. Red signifies the highest density and the colors radiating outward represent decreasing density levels.

*Your heat map is interactive, just like any Google map. You can zoom in and out, or scroll/pan in any direction. A heat map can give you invaluable insights into page traffic and visitor behaviors by revealing “hot spots,” for example, or areas of your page that receive the most clicks; the prevalence of crimes in a specific location; how the same type of businesses, such as bookstores, is scattered throughout the map; and so much more. 

You can use data from your heat map to choose the best location for your business; to do research for a journalistic report; to find potential leads; or to attract more visitors to your page.   

ShowMyMap’s heat map mode offers the following features:

  • The colors’ radius decreases or increases as you zoom in or out.
  • There are four default colors used; red signifies the highest density, followed by orange, yellow, and then green. 
  • The color intensity is fixed, i.e., the concentration of the red color does not change based on the density of clustering. ShowMyMap uses the number of markers within a cluster to assign colors depending on density. 
  • The opacity of the heat map layer is fixed.
  • When the heat map is enabled, the markers/pins disappear.


Try us out for free and create your first map.