Heat Map Generation From Excel Location Data

Use ShowMyMap to import location data from Excel and generate a personalized 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

Creating a heat map involves two things: making a basic map and creating the heat map itself using our built in heat map tool. Here are 5 easy steps to make your own heat map that you can use on any site, presentation, or anywhere else:

  1. Simply copy the data from your Excel sheet and paste on ShowMyMap’s map-making tool or you can also easily drag and drop the file/s containing your data set. Check out our comprehensive guide on How to Create A Basic Map.
  2. Once your map is set up, head to the view page. When you’re viewing your full map, it will be in 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.
  3. Simply click on “Heat Map.”

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

View Map in a full screen map 

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.

Once your heat map is set up, you can display it on your own website, or simply link to your custom show my map URL. 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

AddressCityStateZipcodeNamePhone NumberGroupURLEmail
12032 SE Sunnyside rdClackamasOR97015Safeway Clackamas(503) 698-1121Group Bhttps://local.safeway.com/safeway/or/clackamas/12032-se-sunnyside-rd.html[email protected]
4715 SE Cesar Estrada Chavez BlvdPortlandOR97202Trader Joe's Portland SE(503) 777-1601Group Chttps://locations.traderjoes.com/or/portland/143/[email protected]
3380 Lancaster Dr NESalemOR 97305Safeway Salem(503) 399-1502Group Bhttps://local.safeway.com/safeway/or/salem/3380-lancaster-dr-ne.html[email protected]
12220 SW Scholls Ferry RdTigardOR97223Whole Foods Market Greenway(971) 371-7000Group Ahttps://www.wholefoodsmarket.com/stores/greenway[email protected]
8145 SW Barbur BlvdPortlandOR97219Safeway Barbur(503) 452-6068Group Bhttps://local.safeway.com/safeway/or/portland/8145-sw-barbur-blvd.html[email protected]
1550 NW 9th St Ste 100CorvallisOR97330Trader Joe's Corvallis(541) 753-0048Group Chttps://locations.traderjoes.com/or/corvallis/154/[email protected]
1210 NW Couch StPortlandOR97209Whole Foods Market Pearl(503) 525-4343Group Ahttps://www.wholefoodsmarket.com/stores/pearl[email protected]
353 E Broadway EugeneOR97401Whole Foods Market Eugene(541) 434-8820Group Ahttps://www.wholefoodsmarket.com/stores/eugene[email protected]
3527 SE 122nd AvePortlandOR97236Safeway 122nd(503) 760-5448Group Bhttps://local.safeway.com/safeway/or/portland/3527-se-122nd-ave.html[email protected]
9940 NE Cornell RdHillsboro OR97124Whole Foods Market Tanasbourne(503) 645-9200Group Ahttps://www.wholefoodsmarket.com/stores/tanasbourne[email protected]
15391 Bangy RdLake OswegoOR97035Trader Joe's Oswego(503) 639-3238Group Chttps://locations.traderjoes.com/or/lake-oswego/142/[email protected]
2490 OR-99WMcMinnivilleOR97128Safeway McMinniville(503) 435-3120Group Bhttps://local.safeway.com/safeway/or/mcminnville/2490-n-hwy-99-w.html[email protected]
4121 NE Halsey StPortlandOR97232Trader Joe's Portland Hollywood(503) 284-4232Group Chttps://locations.traderjoes.com/or/portland/144/[email protected]
Drag and drop your file here

- OR -

Copy + paste your data include column files

AddressCityStateZipcodeNamePhone NumberGroupURLEmail
12032 SE Sunnyside rdClackamasOR97015Safeway Clackamas(503) 698-1121Group Bhttps://local.safeway.com/safeway/or/clackamas/12032-se-sunnyside-rd.html[email protected]
4715 SE Cesar Estrada Chavez BlvdPortlandOR97202Trader Joe's Portland SE(503) 777-1601Group Chttps://locations.traderjoes.com/or/portland/143/[email protected]
3380 Lancaster Dr NESalemOR 97305Safeway Salem(503) 399-1502Group Bhttps://local.safeway.com/safeway/or/salem/3380-lancaster-dr-ne.html[email protected]
12220 SW Scholls Ferry RdTigardOR97223Whole Foods Market Greenway(971) 371-7000Group Ahttps://www.wholefoodsmarket.com/stores/greenway[email protected]
8145 SW Barbur BlvdPortlandOR97219Safeway Barbur(503) 452-6068Group Bhttps://local.safeway.com/safeway/or/portland/8145-sw-barbur-blvd.html[email protected]
1550 NW 9th St Ste 100CorvallisOR97330Trader Joe's Corvallis(541) 753-0048Group Chttps://locations.traderjoes.com/or/corvallis/154/[email protected]
1210 NW Couch StPortlandOR97209Whole Foods Market Pearl(503) 525-4343Group Ahttps://www.wholefoodsmarket.com/stores/pearl[email protected]
353 E Broadway EugeneOR97401Whole Foods Market Eugene(541) 434-8820Group Ahttps://www.wholefoodsmarket.com/stores/eugene[email protected]
3527 SE 122nd AvePortlandOR97236Safeway 122nd(503) 760-5448Group Bhttps://local.safeway.com/safeway/or/portland/3527-se-122nd-ave.html[email protected]
9940 NE Cornell RdHillsboro OR97124Whole Foods Market Tanasbourne(503) 645-9200Group Ahttps://www.wholefoodsmarket.com/stores/tanasbourne[email protected]
15391 Bangy RdLake OswegoOR97035Trader Joe's Oswego(503) 639-3238Group Chttps://locations.traderjoes.com/or/lake-oswego/142/[email protected]
2490 OR-99WMcMinnivilleOR97128Safeway McMinniville(503) 435-3120Group Bhttps://local.safeway.com/safeway/or/mcminnville/2490-n-hwy-99-w.html[email protected]
4121 NE Halsey StPortlandOR97232Trader Joe's Portland Hollywood(503) 284-4232Group Chttps://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