skip to Main Content

US County Heat Map Generator Excel Templates

4.63 (8 reviews)

Excel Template to generate heat maps for US Counties. Visualize your data in an editable spreadsheet. Copy paste shapes into Powerpoint.

Learn more about License Types

Someka refunds icon


Someka one time payment icon


Someka direct download icon



Geographic Heat Maps are great when you want to visualize your data distribution over regional mediums (such as US counties).Also, 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 a density map from scratch is not as easy as it sounds. Then, 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 is 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 the 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! Basically, when you click the button, all your values will be reflected on the map automatically.


Moreover, 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

In addition, you can also show values on counties if you want:

US Counties Heat Map Generator - Excel Template - Someka 3


The United States of America Counties Heat Map Generators come with several options, so that let you customize the output easily.

US-Map-Settings - Excel Template - Someka 4

1. Color Palette: Upon our research, we have selected the five most used color palettes for these kinds of charts. However, you can easily change these default palettes with your own colors. To clarify, 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 the corresponding color on the left. Please make sure that the first value is always zero and the last value is something very high so that all your values stay within limits. Any county in the heat map which doesn’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 in the data section and select “Display Text” in this section.
Here you can also change the font size of texts to be displayed on the map. This is pretty useful especially when you need to fit texts over the counties.

4. Background and Border Colors: In 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 it to PDF by clicking this button. Besides exporting to PDF, you can anytime just copy the map area and paste it into your Powerpoint presentation as well.


Sometimes you may want to make some changes specific only to a few counties in the heat map. With this template, you receive all editable map shapes of the purchased state. This is very useful, especially if you want to make individual changes and copy-paste them 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 purple. Just unlock the template and select the county shapes as you would normally do in Excel:

Editable-Map-Shapes - Excel Template - Someka 5

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


Finally, template comes with instructions about how to use the tool. Further, 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 and 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
You can purchase each state heat map individually or in a bundle pack with 50% discount! If you have any specific request on the maps feel free to contact us.



Watch the video below to see the template in action! Presentation also includes usage notes, explanations and tips & tricks about the template.



8 reviews for US County Heat Map Generator Excel Templates

  1. Preston

    Really nice product. But I want to see text with bigger size.but actually default is working thanks

    • Someka

      Hello Preston,

      The template has a text setting feature.
      “Text size” lets you change the font size of texts displayed on map
      Please see the image below


      Hope this helps!

  2. Johnny J

    Text settings is very useful especially text size option

  3. srfwrtohck

    Muchas gracias. ?Como puedo iniciar sesion?

  4. Nora Schultz

    Good Afternoon.
    This morning I purchased a Heat Map Generator for the state of Iowa. I have been working with it for a number of hours now and I can’t get it to generate anything. It seems quite easy but I guess I am missing sth. Can you help me?

    • Someka

      Hi Nora,

      We will be happy to help you!

      Did you watch our US Counties Heat Map Generators product video? We have prepared it to show all of the features of the template. Besides that, you will see how can you input the data and generate the heat map.

      If you still can not figure out how to do it, please do not hesitate to contact us!

    • Someka

      Hi, thanks for the video. Your support team was quite fast and helped me a lot!

  5. Von Derau

    Hi, I purchased your heat map generator several years ago and have never found a problem with it. However, I have always had large numbers in my dataset (my 5 ranges might have 100-500 or more between them). This map I was working on had very small numbers and the map is not accurate. Can you help?

    • Someka

      Hi Von,

      Thanks for your interest!

      The issue is probably related to specifying the min and max values of each data range. You need to start the one data range with the previous one’s endpoint (which is the max one).

      heat map comment pic1

      We are sure that you will understand once you have a look at once more the data range we entered as a dummy. Then, those with a zero value will be colored grey. The max values are not included in that data range, it will be included when it is the min value box.

      Hope our explanation is clear!

    • Von Derau

      Thank you!!!

      I appreciate the help.

  6. Wynne Barnes

    I purchased this template last month. This template is easy to use and presents well. Also excellent price! It fit my needs perfectly!

    • Someka

      Hi Wynne,

      First of all, thanks a lot for your time to spend writing a review. We are glad that you find our template is useful. Appreciated!
      You can always get in contact with us when you have any issues or further questions regarding the template.

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

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