Geographic heat map – India (Excel template)

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.

India Heat Map Excel Template

India Heat Map Excel Template
India Heat Map (by State) – India Heat Map Excel Template

Download

If you would like to create editable map of India in excel free download the India Heat Map Excel Template (Telangana added in June 2014)

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

How to use this India Heat Map Excel 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
India Heat Map Excel Template - Geographic Heat Map India Map India
India Heat Map Excel Template – Geographic Heat Map India Map India

You can also use this template to showcase the position of one specific state.

Showcasing a state - India Heat Map Excel Template
Showcasing a state – India Heat Map Excel Template

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 India Heat Map Excel 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 color gradient, read this article.

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

Related free Templates

179 Comments

  • Very Excellent & Simple to use heat map!!! I want to go at City and Taluka level mapping. How can I recreate this map to suit my need?

    Reply
    • Thanks for the feedback. You have to start from an outline map at city/taluka level and then fill the map with cells and then conditional format.
      Best wishes.

      Reply
  • nice map but if we want to go deeper at district level then what to do

    Reply
  • How can I remove state name from the heat map???
    I want to show the colors only

    Reply
    • Please unhide the hidden sheet ‘Data’. The state names are entered there in text boxes. You can remove them in that sheet.
      Best wishes.

      Reply
  • Can we have multiple tabs with different parameters to work….eg sheet 1 parameter 1, sheet 2 paramter 2???

    Reply
    • The template is set up to display only one map at a time. Sorry. It can be customized to choose any metric to display on that one map. Thanks. Best wishes.

      Reply
  • Hi,

    Can we get a State level with more than one parameter and as we hover the mouse the map shows respective values. Also, how can we add a hyper link state wise to a different sheet.

    Can we get district level map for multiple variables for Gujarat, MP, Karnataka, Rajasthan.
    You can mail me at raizadaster@gmail.com.

    Reply
    • Thanks for the feedback. I am sorry that I don’t have state level maps yet. Best wishes.

      Reply
  • Great maps and tremendous effort. You hv made district wise maps for India. Please let me know .

    Reply

Leave a Reply

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