skip to Main Content

World Countries Geographic Heat Map Generator

4.63 (8 reviews)

World Heat Map Excel Template will visualize the grouped of data on the map of world. Put your data and heat map will be ready automatically.

Learn more about License Types

Someka refunds icon


Someka one time payment icon


Someka direct download icon



We use heat maps in order to visualise values of individual data points within a data set. While illustrating those data points from the lowest to the highest, we use colour sets. Geographic heat map is probably the most popular type, since it’s used in variable areas like, meteorology, sociology, politics, economics, medicine, etc. For example you can create a world heat map which would look like this:

However, creating it from scratch isn’t as easy as it sounds. That’s why we have built this Excel tool. With 3 easy steps, heat map of world will be ready:

1. Step: Paste/Type your data from your own spreadsheet
2. Step: Choose your limits for data ranges
3. Step: Choose your color set and click the button!

Now you can create a Country Heat Map in a few minutes!

World Heat Map Generator Features:

  • Fully editable World Map Generator with 170 countries
  • Easy to use and nice density map
  • 5 Premade color sets to choose from (you can even modify as you wish)
  • Export to PDF feature
  • Clear on sheet instructions (with turn on/off function)
  • Print Ready
  • Includes VBA code and macros
  • Works both on Windows and Mac
  • Compatible with Excel 2007 and later
  • No installation needed. Ready to use.

This excel template is prepared with VBA macros. Don’t forget to enable macros after you get it. If you need customization on your charts or in need of more complex schemes, just contact us via

On-sheet instructions will guide you about the usage of template:


Since it’s print-ready, you can easily print it. Or you can easily export to PDF if you like.

You can pick one of 5 different colour set options or change the colours as you wish:


Finally, we would like to remind you other continent and country heat map generators which are available at:
Someka Heat Maps Collection


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



8 reviews for World Countries Geographic Heat Map Generator

  1. Juan

    hello my name is juan. I bought the program, but I have a couple of queries
    a) when generating the pdf it creates an error -2147024864 (execution time)
    b) is it possible to add more countries?

    Best regards

    • Someka

      Hi Juan,

      First of all, thanks a lot for your interest!

      To figure out what is the reason that you are getting this error message please let us ask some questions. Are you using this template on Mac or Windows? Can we learn the Excel version that you are using? Are you using Microsoft Excel for desktop or online?

      Unfortunately, you can not add new countries to the existing map. All the shapes are already matched with the countries on the Country Names column, so you should use the existing ones.

      Hope that helps!

    • Juan

      Hi, thanks a lot for your quick response. The pdf button is working now, it was my fault that it didn’t work because I tried to change something. But I didn’t think it would have an effect on the pdf create button.

      thanks again.

  2. Andrez_pie

    It used to work good when I first downloaded. Now I want to make some modifications but see “unlock sheet” warnings. It is getting complicated.

    • Someka

      Thanks for your feedback Andrez! Don’t worry about it. Just download the fresh template from the link you’ve been provided after download.

  3. Castro Gaetano

    I bought the full version and surprisingly I have noticed that I cannot modify the file, not only this, but the logo of someka appears everywhere I am wrong or I paid the licence? Not really friendly.

  4. rubina54

    really appreciate for new version. Its more managable and i can paste my data alphabetically with a few touches.

  5. Sylvi

    I used the world map version of Someka. The tool is really helpful. It’s easy to use and it’s modifiable, too. The price is also worth it. I also asked questions to the Someka team via webchat and email, and their response was very good, helpful, and most importantly fast. I do really appreciate their help.

    • Someka

      Thank you Sylvi for the feedback. And good luck with your academic paper!

  6. Jill Philips

    This heat map maker is a very useful tool and presents well in our reports and presentations!

  7. Ubalda

    Dear Someka team,
    I bought World Geo Heat map. It works well but would like to know if below is possible:
    – Currently there are only 5 color options available in each individual color palette.
    – We have data that we are trying to feed in to world heat map represents 8 different values so we want to know if its possible to get 8 color options added to the color palette so that we can represent 8 types of data on the world geo map.

    • Someka

      Hi Ubalda. Thanks for the feedback.
      Yes we can develop the 8 color options but as this will be a custom development, please send us an email with your detailed request so that we can elaborate an offer for you.

  8. Kai Goncalves

    I was a bit reluctant as there were no reviews of this tool. But it is really good!
    Easy to use and does what it says. Well done!

Leave a customer review

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