Skip to content

US County Heat Map Generator Excel Templates

4.5 (12 reviews)

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

One-Time Purchase
Business Subscription
One-Time Purchase
Business Subscription
SOMEKA BUSINESS 99 $ /m

Redeem 3 Templates

Download 3 premium templates of your choice for free each month.

Continuous Technical Support

We’ll be your one-stop assistant for all your Excel & Google Sheets questions and needs.

Multi-User Environment

You’ll be entitled to multi-user licensing for your templates.

Cancel Anytime | Growing Catalogue | Continuous Updates

someka-bundle-icon

TEMPLATE DESCRIPTION

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, vote 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 create this kind of chart in a few seconds. The best part is, all in Excel! No installation is necessary. Works in both Windows and Mac.

You can make county choropleth maps for your data.

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.

EASY DATA AND TEXT MANAGEMENT FOR YOUR MAPS

Moreover, in this heat map generator 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

FLEXIBLE SETTINGS TO CONFIGURE YOUR MAPS

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 that 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 county 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.

EDITABLE COUNTY SHAPES

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!

ON-SHEET INSTRUCTIONS

Finally, the 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

US COUNTIES HEAT MAP GENERATORS FEATURES:

  • Unique US Heat Map Excel Template for auto-generation of counties
  • Available for all 50 states of the USA
  • Fully editable county map shapes
  • Works both on Mac and Windows
  • No installation is needed and Ready to use of US county generator
  • 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 a 50% discount! If you have any specific requests on the maps feel free to contact us.

STATES AVAILABLE FOR COUNTY HEAT MAP GENERATORS

PRODUCT VIDEO

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

FREQUENTLY ASKED QUESTIONS

USER REVIEWS & COMMENTS

12 reviews for US County Heat Map Generator Excel Templates

  1. Kris

    This is the beeeeest heat map generator I’ve ever used! It makes me feel like a data visualization proa.

  2. Michele S.

    Someka has been an amazing help with my work. I can now easily make heat maps that look professional in no time. I am so grateful to Someka!

  3. Marjan Tasic

    I wish the template had more colors to choose from, especially ones that are more vibrant and bright.

  4. Bonnie

    I’m disappointed that the US County Heat Map doesan’t come with a tutorial video. I feel like I wasted my money on something I can’t figure out how to use.

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

      US-Counties-Heat-Map-Generators_text-size1

      Hope this helps!

  6. Johnny J

    Text settings is very useful especially text size option

  7. srfwrtohck

    Muchas gracias. ?Como puedo iniciar sesion?

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

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

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

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

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

Only verified users who have downloaded and used the template may leave a review.

RELATED TEMPLATES

Search