Geographic heat map – India (Excel template)

Posted on
Geographic Heat Map - India
I was looking for a way to present/visualize state level data on an Indian map. I was not able to get that from the Bing maps application for Excel. I am sure there are paid applications that might provide this functionality.  I think this is a very basic need and I decided to prepare a simple template that can help create geographic heat maps for India.


If you would like to create heat maps like the one above, download the template (Telangana added in June 2014).

Please see below, a quick 5 minute demo of this template.

Geographic_Heat_Map_India_screenshot_2How to use this template?

  • Enter your (numeric) data in the data column and the map image on the right gets updated. 
  • Please make sure that the state (or union territory) names you enter in column A are spelled the same way as they are
    • They are currently ordered alphabetically. However, you may choose to enter them in any order. 
  • You can print the sheet if needed
  • You can copy the image and paste it in other applications such as Microsoft Word or PowerPoint
You can also use this template to showcase the position of one specific state. For the illustration above, I entered a positive number (1) for Madhya Pradesh and deleted the data for all other States/UTs. 
How is the heat map generated?

The template has a hidden worksheet where the outline of India and States/Union territories were drawn with the cells pointing to corresponding data. Conditional formatting has been used to create the heat map. If you would like to change the colour gradient, read this article.

If you know of better ways to do this or if you use any application to create such heat maps for India, please share your thoughts.

116 thoughts on “Geographic heat map – India (Excel template)

  1. Requre more uses Indian map in excel format

    1. Thanks for your message.

      We are in a process of releasing heat maps for Indian states.

      Best wishes

  2. Is there any way to showcase the numeric values as well within the map?

    1. We would have to add the text boxes and display the numeric values from the input cells.
      Best wishes.

  3. we are trying to develop some heat maps all india level using our sales and other parameters, can you help us in this case .
    please contact me if so .

    1. Thanks for your message.

      Due to high workload, we are not accepting any customized projects.

      Best wishes

  4. Excellent work Bro

  5. Can we change the colour gradient from Green to Red?

    1. Thanks for your message.

      Please visit the following link for a tutorial on how to change the gradient color.

      Best wishes

  6. Hi! Is a world heat map by countries available?


    1. Hello

      The distribution by countries is not yet available.


  7. Hi. Is it available for Districts of India ?

    1. Hello

      We are planning to launch heat maps for all the states first. Then we might have the same for districts as well. However, it would take some time.

      Best wishes

  8. Hi. Using this template, but i do not want the graded color scale. I just want three colors – for above average (green), average (yellow) and below average (red). How do i do it?

  9. Hello,

    I came across your blogpost on Heat Map for India.

    I will like to create a Heat Map for Nigeria. Please how do I go about it? How do I insert the image for map of Nigeria prior to inputting my data?

    Thank you.

    1. Thanks for your interest.

      You can unhide a few tabs and make changes as per your requirements. We have used data on the internet extensively.

      Best wishes

  10. once i put all the data in for each state it corrupted the visual so that the colours and the outlines of the states just got all scrambled up. i’m using mac for excel.
    when i opened up the original file the map was uncorrupted, but sometime after it just changed to look like a surrealist melted clock.
    i look forward to being able to use this heat map at a district and even tehsil level 🙂

    1. Thanks for using the template.

      Please ensure that you are using Excel 2013 or later versions on Mac. Also, sometimes if the formatting is altered, the file is not useable. Check the details and in case you are still not able to use the file, sent it to with a list of issues faced.

      Best wishes

Leave a Reply

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