How To Create A Heat Map

There are a number of how-to’s online showing how to create heat maps but they tend to take a lot of time and require at least an intermediate or advanced knowledge of Excel functions. 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. With ShowMyMaps’ help, creating heat maps is made simpler by just copy-and-pasting your data. 

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.

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 Heat Map
  • Simply copy the data from your excel or google sheet and paste on ShowMyMap’s map-making tool or you can also easily drag and drop the file/s containing your data set. How to Create A Basic Map.
  • Once your map is set up, head to the view page. When you’re viewing your full map, it will be on Default mode. Currently, the Heat Map mode/feature is available to all plans (Free, Pro and Pro+). You’ll find the Heat Map mode beside the Default mode option on the upper right corner of your map.
show my map heat map function
  • Simply click on “Heat Map.”
  • 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.
showmymap heat map function

*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. 

View Map in a full screen map 

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.

Start creating map

Drag and drop your file (xls, xlsx or csv) Use our sample data, by clicking here. Or

Address City State Zipcode Name Phone Number Group URL Email
12032 SE Sunnyside rd Clackamas OR 97015 Safeway Clackamas (503) 698-1121 Group B https://local.safeway.com/safeway/or/clackamas/12032-se-sunnyside-rd.html [email protected]
4715 SE Cesar Estrada Chavez Blvd Portland OR 97202 Trader Joe's Portland SE (503) 777-1601 Group C https://locations.traderjoes.com/or/portland/143/ [email protected]
3380 Lancaster Dr NE Salem OR 97305 Safeway Salem (503) 399-1502 Group B https://local.safeway.com/safeway/or/salem/3380-lancaster-dr-ne.html [email protected]
12220 SW Scholls Ferry Rd Tigard OR 97223 Whole Foods Market Greenway (971) 371-7000 Group A https://www.wholefoodsmarket.com/stores/greenway [email protected]
8145 SW Barbur Blvd Portland OR 97219 Safeway Barbur (503) 452-6068 Group B https://local.safeway.com/safeway/or/portland/8145-sw-barbur-blvd.html [email protected]
1550 NW 9th St Ste 100 Corvallis OR 97330 Trader Joe's Corvallis (541) 753-0048 Group C https://locations.traderjoes.com/or/corvallis/154/ [email protected]
1210 NW Couch St Portland OR 97209 Whole Foods Market Pearl (503) 525-4343 Group A https://www.wholefoodsmarket.com/stores/pearl [email protected]
353 E Broadway Eugene OR 97401 Whole Foods Market Eugene (541) 434-8820 Group A https://www.wholefoodsmarket.com/stores/eugene [email protected]
3527 SE 122nd Ave Portland OR 97236 Safeway 122nd (503) 760-5448 Group B https://local.safeway.com/safeway/or/portland/3527-se-122nd-ave.html [email protected]
9940 NE Cornell Rd Hillsboro OR 97124 Whole Foods Market Tanasbourne (503) 645-9200 Group A https://www.wholefoodsmarket.com/stores/tanasbourne [email protected]
15391 Bangy Rd Lake Oswego OR 97035 Trader Joe's Oswego (503) 639-3238 Group C https://locations.traderjoes.com/or/lake-oswego/142/ [email protected]
2490 OR-99W McMinniville OR 97128 Safeway McMinniville (503) 435-3120 Group B https://local.safeway.com/safeway/or/mcminnville/2490-n-hwy-99-w.html [email protected]
4121 NE Halsey St Portland OR 97232 Trader Joe's Portland Hollywood (503) 284-4232 Group C https://locations.traderjoes.com/or/portland/144/ [email protected]
Drag and drop your file here

- OR -

Copy + paste your data include column files

Address City State Zipcode Name Phone Number Group URL Email
12032 SE Sunnyside rd Clackamas OR 97015 Safeway Clackamas (503) 698-1121 Group B https://local.safeway.com/safeway/or/clackamas/12032-se-sunnyside-rd.html [email protected]
4715 SE Cesar Estrada Chavez Blvd Portland OR 97202 Trader Joe's Portland SE (503) 777-1601 Group C https://locations.traderjoes.com/or/portland/143/ [email protected]
3380 Lancaster Dr NE Salem OR 97305 Safeway Salem (503) 399-1502 Group B https://local.safeway.com/safeway/or/salem/3380-lancaster-dr-ne.html [email protected]
12220 SW Scholls Ferry Rd Tigard OR 97223 Whole Foods Market Greenway (971) 371-7000 Group A https://www.wholefoodsmarket.com/stores/greenway [email protected]
8145 SW Barbur Blvd Portland OR 97219 Safeway Barbur (503) 452-6068 Group B https://local.safeway.com/safeway/or/portland/8145-sw-barbur-blvd.html [email protected]
1550 NW 9th St Ste 100 Corvallis OR 97330 Trader Joe's Corvallis (541) 753-0048 Group C https://locations.traderjoes.com/or/corvallis/154/ [email protected]
1210 NW Couch St Portland OR 97209 Whole Foods Market Pearl (503) 525-4343 Group A https://www.wholefoodsmarket.com/stores/pearl [email protected]
353 E Broadway Eugene OR 97401 Whole Foods Market Eugene (541) 434-8820 Group A https://www.wholefoodsmarket.com/stores/eugene [email protected]
3527 SE 122nd Ave Portland OR 97236 Safeway 122nd (503) 760-5448 Group B https://local.safeway.com/safeway/or/portland/3527-se-122nd-ave.html [email protected]
9940 NE Cornell Rd Hillsboro OR 97124 Whole Foods Market Tanasbourne (503) 645-9200 Group A https://www.wholefoodsmarket.com/stores/tanasbourne [email protected]
15391 Bangy Rd Lake Oswego OR 97035 Trader Joe's Oswego (503) 639-3238 Group C https://locations.traderjoes.com/or/lake-oswego/142/ [email protected]
2490 OR-99W McMinniville OR 97128 Safeway McMinniville (503) 435-3120 Group B https://local.safeway.com/safeway/or/mcminnville/2490-n-hwy-99-w.html [email protected]
4121 NE Halsey St Portland OR 97232 Trader Joe's Portland Hollywood (503) 284-4232 Group C https://locations.traderjoes.com/or/portland/144/ [email protected]
Copy + paste your data
Configuration

Map Fields

+ Add Custom Field
Show More

    Oh no!

    On the free tier you can only map up to 150 locations at one time. Please add a plan if you wish to map more than 150 locations.

    Related Articles

    Reduslim Kaufen