skip to Main Content

US Counties Heat Map Generators

5.0 (2 reviews)

Excel Template to generate heat maps for US Counties. Editable county shapes. Copy paste into Powerpoint.

Works on: Windows / Mac (min. Excel 2007)

Watch Video:

Geographic Heat Maps are great when you want visualize your data distribution over regional mediums (such as US counties). They are being used in many areas like sales dashboards for companies, votes distribution during elections, statistical maps in meteorology and many more.

For example, you may want to create a heat map showing Population Distribution per California County which will look like this:

California Population Heat Map - Someka 1

This looks cool! However, making it from scratch is not as easy as it sounds. That’s why we have prepared Dynamic Heat Map Generators which will let you to create these kind of charts in a few seconds. The best part is, all in Excel! No installation necessary. Works in both Windows and Mac.

How to prepare a US county Heat Map with this template in less than a minute:

  1. Put your own values into data section (you can just copy-paste from another source)
  2. Choose your limits for painting
  3. Choose your color palette (or make your own)

That’s it! When you click the button, all your values will be reflected onto the map automatically.


In the template, you can put your own data and texts which you want to be displayed per county on the map:

New Jersey County Data - Excel Template - Someka 2

You can also show values on counties if you want:

US Counties Heat Map Generator - Excel Template - Someka 3


US Counties Heat Map Generators come with several options which lets you customize the output easily.

US-Map-Settings - Excel Template - Someka 4

1. Color Palette: Upon our research, we have selected five most used color palette for these kind of charts. However, you can easily change these default palettes with your own colors. Just select the cell and paint it as you normally do in Excel. Click “Select” and press the Paint button to apply changes.

2. Data Limits: This is your legend. You can define which values should fall into corresponding color on the left. Please make sure that first value is always zero and last value is something very high so that all your values stay in limits. Any county which don’t fall into limits will be painted gray.

3. Text Settings: In this section, you can select what to show on the counties map. You have three different quick text selections. Besides no text and county names, you can display whatever you want on the counties. Just put your own text in the Text column at data section and select “Display Text” at this section.
Here you can also change the font size of texts to be displayed on map. This is pretty useful especially when you need to fit texts over the counties.

4. Background and Border Colors: At this section you can change the map background color and county border color.

5. Export to PDF: When you finish creating your heat map, you can easily export to PDF by clicking this button. Besides exporting to PDF, you can anytime just copy the map area and paste into your Powerpoint presentation as well.


Sometimes you may want to make some changes specific only to few counties. With this template, you receive all editable map shapes of the purchased state. This is very useful especially you want to make individual changes and copy-paste into your Powerpoint slides or anywhere you wish.

For example, after completing your Texas map you wanted to select some individual counties and paint them in purple. Just unlock the template and select the county shapes as you would normally do in Excel:

Editable-Map-Shapes - Excel Template - Someka 5

You can change the size, color, shape and even make your own custom map!


Template comes with the instructions about how to use the tool. If you want a clear view and don’t want to be distracted, you can turn off these guidance texts anytime you want:

NewYork-Counties-Data-Section- Excel Template - Someka 6


  • Unique US Heat Map Excel Template for auto generation of counties.
  • Available for all 50 states of USA
  • Fully editable county map shapes
  • Works both on Mac and Windows
  • No installation needed. Ready to use.
  • Export to PDF feature
  • Full Print Ready
  • White Label
  • Flexible customization options
  • On Sheet Instructions
  • Compatible with Excel 2007 and later versions

Please note that, each state heat map is sold individually. If you want to buy all of them or have a specific request on the maps you can contact us via [email protected]

If you want states heat map instead of counties, check our USA Heat Map generator:


2 reviews for US Counties Heat Map Generators

  1. Katie

    I purchased the WASHINGTON COUNTIES GEOGRAPHIC HEAT MAP for a project and it’s really good. I am working on and discovered there are gaps between some of the borders of the counties. Is there a way to correct this?

    • Someka

      Thanks for feedback Katie!
      The placement can change depending on the operating system (most probably you use a Mac, right?)
      But you can easily move them to fit better. Just follow:
      – Unlock the sheet with password “someka”
      – Click on the shape and select it. Then move it with arrow keys.
      Hope that helps!

    • Katie

      Thank you, I finally figured that out yesterday. And actually, I use a PC. Despite it taking me a couple of hours to get things exactly the way I wanted it to look and fixing the colors and the fonts to be those that I wanted, this was much faster than doing heat mapping the way I’ve done it in the past. Now that the initial setup is done, it will be a piece of cake to fill in the data and print my maps. Thank you very much for the product!

  2. Matt Cavalli

    I purchased the MI template. The program provides a quick and easy way to visualize data with enough flexibility to be used for a variety of situations. When I had suggestions for a modification to improve user-friendliness, Someka was very responsive and created a modified version of the template to fit my needs. The Someka heat maps are a very cost-effective alternative and the customer/technical support will help you get what you need out of the program.

    • Someka

      Thank you Matt! Glad it has been helpful.

Leave a customer review

Your email address will not be published. Required fields are marked *