Indzara
Shop
Support
Login

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)

Geographic Heat Map India Excel Template v4

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

183 Comments

    • Thank you for your interest in our templates.

      At the moment, we do not have a heat map template specifically for Gujarat state. We will be sure to update you once we develop and release a template for Gujarat.

      We appreciate your patience and interest.

      Best wishes.

      Reply

  • Can I get the India Heat Map withy Colours for number range as you have in US heat map?

    Reply

    • Thank you for showing interest in our template.

      Currently, we do not have India Heat Map with the requested feature. We can take it as a customization project as mentioned in our Email communication.

      Best wishes.

      Reply

    • In India map, i want to remove the state name from the map, so suggest me how to remove.

      Regards

      Reply

      • Thank you for showing interest in our template.

        To remove the state name from the map, you need to unhide Data sheet and select each text box containing the state name and delete the text box or the names inside from the map.

        Best wishes.

        Reply

  • i want to merge few states , like all north east state into one called north east , chandigarh and punjab into punjab and similarly few other mergers . how can i do same

    Reply

    • Thank you for showing interest in our template.

      You will need to unhide hidden Data sheet and hidden columns in it and modify the map and the cell formulas.

      We take customization projects for a fee, please write to us at the below link for estimation:
      https://support.indzara.com/support/tickets/new

      Best wishes.

      Reply

  • how can we remove names of the states in the heat map of India

    Reply

    • Thank you for showing interest in our template.

      You need to unhide the calculation sheet and select the text box containing the state name and delete the same.

      Best wishes.

      Reply

  • I want to show 3 numbers for a particular state. How can I do that

    Reply

    • Thank you for showing interest in our template.

      You can add a text box inside the required state from the Insert ribbon and select the text box without the cursor inside the textbox and type = to get the referred cell value inside the text box.

      We take customization projects for a fee, please write to us at the below link for estimation if the above steps has to be processed from our end:
      https://support.indzara.com/support/tickets/new

      Best wishes.

      Reply

    • Thank you for showing interest in our template.

      We take customization projects for a fee as mentioned in the sent email. Currently, colors on the map are adjusted according to the value on the cell. Please share your requirement in the email whether you want the entered text in plain white map or along with the color. If you want along with the color, we need to add a column before the value for each state to get the text.

      Best wishes.

      Reply

    • Thank you for showing interest in our template.

      Currently, we do not have a heat map for Maharashtra. We can take it as a customization project for a fee. Please write to support@indzara.com with district wise Maharashtra’s map image for estimation.

      Best wishes.

      Reply

    • Thank you for showing interest in our template.

      Currently, we do not have a heat map for Chennai with region wise split-up. We can take it as a customization project for a fee. Please share your requirement to support@indzara.com with a image of Chennai map with its region split-ups for estimation.

      Best wishes.

      Reply

  • Great Work. Excellent job. This will surely help the community in visualizing data as they say picture speaks louder than the numbers. Keep up the good work. Can I request for Telangana district-wise heat map. Appreciate your team.

    Reply

    • Thank you for sharing your valuable feedback.

      Currently, we do not have the heat map for the Telangana. We will update you after we build the heat map for Telangana.

      Best wishes.

      Reply

  • Wonderful initiative, do you know anybody who has heat map at district level?

    Reply

    • Thank you for sharing your valuable feedback.

      Currently, we do not have the requested information.

      Best wishes.

      Reply

  • Dear team . excellent tool . can you help me with karnataka Heat Map

    Reply

    • Thank you for showing interest in our template.

      Currently, we do not have a district wise heat for Karnataka. We will update you once the same is available in our website. If you wish to prioritise this development for a fee, request to contact support@indzara.com for an estimation.

      Best wishes.

      Reply

    • Thank you for using our template.

      Yes, you can add data labels by unhiding the hidden Data tab and add your requirement to reflect inside the map. Requesting to contact support@indzara.com for more support.

      Best wishes.

      Reply

  • Hello,
    Is it possible to reverse the color gradient? Red for highest and green for lowest? Or use different color scheme all together?

    Reply

    • Thank you for using our template.

      Yes, you can change the color scheme through the following steps.
      1. Unhide hidden Data tab by right clicking the tab name.
      2. Click any cell inside India.
      3. Click Home ribbon.
      4. Select Conditional formatting.
      5. Select manage rule.
      6. Click edit rule and change the color according to your requirement.

      Best wishes.

      Reply

  • Hi,
    Thank you for this heat map file. I use it very often. However, I would like to know how i can edit or modify “www.indzara.com” from the top of the map.

    Regards

    Reply

  • Dear Sir,

    Thanks for the Heat Map.

    I would like to change the font colour of the state’s name as when i select the gradient which appears to be darket that time the font colour being black doesn’t reflect properly.

    Request your support.

    Reply

    • You are welcome.

      You can unhide the hidden sheet and select the particular text box to change the color of the text. If you are unable to change the color, requesting to contact our support team at support@indzara.com to help further.

      Best wishes.

      Reply

    • Hello

      We are in the process of developing heat maps for different states like Karnataka, Maharashtra etc.,. We will release them soon. But currently we are not in plan of developing a heat mat of a city with its territory like
      Bangalore, Chennai etc.,. However we do take customization project for a fee, so if you provide a city image with its territory to support@indzara.com, we can provide an estimate of work.

      Thanks

      Reply

  • The colour gradient is not available in the downloaded file ..only text is there ……from lowest to highest

    Reply

    • We regret the inconvenience caused but we are unable to replicate from our end. Hence, requesting to share the downloaded sheet to support@indzara.com along with your System OS (Mac/Windows) and Excel version used.

      Reply

  • Hi
    The borders and actual map get messed up and disproportional as soon as I open the downloaded file. The same happens if I open as xls, xlsx or csv. Any suggestions on how to solve this?

    Reply

    • Thanks for your message.

      The wait will not be long. We will release them soon.

      Best wishes

      Reply

    • Hello

      We are in the process of developing heat maps for different states. We will release them soon.

      Thanks

      Reply

    • Thanks for using our template.

      You can insert a column in the template. Please ensure that none of the formulas or links are broken.

      Best wishes

      Reply

  • Hi
    Thanks for making this avaiable, It is too good
    Can I have only 03 colors i.e. If I want to restrict the colors to be highlighted for a range ( Red up to 6, Orange upto 8 and Green upto 10)

    Reply

  • Dear Guru,

    I salute you for the good work. This is perfectly good work. Can you please release a Geographic heat map template for Tanzania (with all regions included)? Or it is only for India.

    Thank you

    Reply

    • Thanks for sharing your positive experience.

      We are yet to release heat maps for all countries.

      Best wishes

      Reply

  • Ladakh is not mentioned in the template. How can I include the union territory ladakh in the heat map?

    Reply

    • Thanks for your message.

      We will try to update the map in the next release.

      Best wishes

      Reply

    • Hello

      We are in the process of developing the heat maps for all Indian states.

      Best wishes

      Reply

    • Hello

      The name of the states is mentioned on the map. Hence, data labels are not required as we are not generating a chart.

      Thanks

      Reply

  • Hi,
    Its a fantastic tool for presentation,
    I just want to know how to change the colour gradient in the map.

    Reply

  • Hi,
    This is really a great work. Can you please release the Karnataka map at district level for plotting in excel.

    Thanks!

    Reply

    • Thanks for your message.

      We are in the process of releasing heat maps for different states of India.

      Best wishes

      Reply

    • Thanks for your message.

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

      Best wishes

      Reply

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

      Reply

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

    Reply

    • Thanks for your message.

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

      Best wishes

      Reply

    • 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

      Reply

  • 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?

    Reply

    • 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

      Reply

  • 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 🙂
    thanks.

    Reply

    • 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 contact@indzara.com with a list of issues faced.

      Best wishes

      Reply

    • Hello

      The heat maps are available for Kerala and Tamil Nadu. We are working some states now.

      Best wishes

      Reply

  • Dear Sir , great piece of information sir…. u guys are the saviour of us…it had been a while i was in search of such excel…thanku v much.

    Reply

        • Hello

          Thank you for your interest in our template.
          We are yet to release the Heat Map for Mumbai. Keep watching this space.

          Best wishes

          Reply

    • Hello

      Please unhide the tab called “Map”. You have to insert the details of that respective state and it should work.

      Best wishes & regards

      Reply

    • You are correct. It required a lot of patience and attention to detail. Thanks for the feedback.
      Best wishes.

      Reply

  • Hey,
    I found yor map quite useful. I was hoping to create a similar one districtwise instead of state. If you could share something like a tuturial on how to create this template it will be really helpful. Thanks.

    Reply

    • Thanks. I will try to do that. Which state are you looking for?
      Best wishes.

      Reply

  • How do we add numbers below the name of the states in the heat map?

    Reply

    • Please insert text box (or Shape) for each state in the hidden ‘Data’ sheet and in the formula bar point to the corresponding cells (numbers) in the Geographic_Heat_Map sheet. These text boxes with numbers will automatically appear on the map in the Geographic_Heat_Map sheet.
      Best wishes.

      Reply

  • thanks.. I want to change the border colour blue to black.(telling about India map)

    Reply

    • Please unhide the hidden sheet where you can change the border color (color of the line shapes used to create the border).
      Best wishes.

      Reply

  • 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

  • I want to generate a district level map for India, can it be done through Indzara tools? If this cannot be done through Indzara, kindly guide me with a proper source (in case available). Thanks

    Reply

    • Thanks for your interest. I don’t have the district level maps. Unfortunately, I don’t know of any other source for it as well. Best wishes.

      Reply

  • Hi,
    I downloaded your latest template. However, the picture quality is not as depicted in this post. Also, the legend of the color gradient is also not appearing. Please let me know how can I correct this.

    Thanks

    Reply

    • Thanks for your comment. The picture quality should be the same. The file posted was updated in June of 2014 (while the post was originally made in April 2013) when the new state of Telangana was added. At that time, I removed the color gradient legend image and just had the text indicating the gradient. This is because if you change the color by using the conditional formatting gradient rules(explained https://indzara.com/2013/08/changing-the-colour-gradient-in-the-heat-map/) , then you need to update that gradient legend image too which becomes more work.
      If you need the legend image, you can take a screenshot of the gradient scale from Excel’s conditional formatting menu and paste. If you need any further assistance, please email me at indzara at gmail. Thanks.

      Reply

  • Thank you so much for your work here. The latest download file does not show the map heat legend – the colour gradient key is missing. Thanks Kev. London

    Reply

    • You are welcome.
      I had removed the heat gradient legend. If the user changes the color gradient by following the method explained in https://indzara.com/2013/08/changing-the-colour-gradient-in-the-heat-map/ , then the default gradient legend is not applicable. I don’t know of a way to dynamically update that. So, I removed it from the default template.

      You can definitely take a screen capture of gradient and paste the image on the map. Please let me know if there is any help needed. Thanks & Best wishes.

      Reply

  • Hello and good job, How did you bring that image from the data sheet to be shown with the Geographic heat map sheet?

    Reply

  • Did manage to create unified Andhra on the map. One just had to delete aline. Thanks again.

    Reply

    • I am glad that it worked for you. After you remove the line, please make sure that the values entered for Telangana and Andhra are the same. Best wishes.

      Reply

  • It its not too much of a trouble will it be possible to share the older map with shows Unified Andhra. No I don’t have anything against Telangana and its bifurcation, its just that I am using a older dataset from the first decade of this century. I tried changing the borders but my online drawing skills are atrocious .

    Reply

  • This map is extremely useful. And thank you so much for allowing users to edit stuff on the map. Cheers to Indzara and its commitment to keep knowledge open access.

    Reply

  • Is there any way we can get the districts heat map in India or postal code maps of the Indian cities?

    Reply

    • I am sorry I don’t have districts level or postal code level maps. Best wishes.

      Reply

    • I am not sure I understand what your specific scenario is. The image of the map can be copied (just select the image and copy in Excel) and pasted in any Office application (PowerPoint, Excel, Word). It will just be an image.
      If you want to use different data to create a new map, you can enter that data (overwrite) in this sheet and the map image will be updated with your data. Hope this helps. If this doesn’t answer your question, please explain your specific scenario. Thanks.

      Reply

  • Hai, your heat map of india is very very excellent, as you know Andhra Pradesh is bifurcated to two states as Andhra Pradesh and Telangana, please provide us the india map which includes Telangana state as well.

    Thanks in advance

    Best Wishes
    Kamalesh

    Reply

    • The template has been updated now with the new state. Please download the file again in this blog post.

      Thanks for your feedback,

      Reply

  • thanks for providing us such a wonderful apps of creating indian state map. from last few weeks I was searching and also downloaded some s/w but nt working. however this apps is very simple and very much useful. anyway, I have some ueries about it:
    (1) how can we add title/sub title of map when we like to use only map for copy-paste in another document;
    (2) if I like to use only 4 or 5 different colors with range of data. Then how can we define color for particular ranges which we seen in commonly;

    Reply

  • I came across this post while I was searching for a way to draw district level heatmaps in India. Excellent article.

    Additionally you could also use the gvis API from google and the open source R package to create similar diagrams. More interactive and useful if you are faimiliar with R.

    Reply

  • That’s a very informative post, there are many things i did not know ! Anyhow I appreciate your willing to share your knowledge about heat map !

    Reply

  • Hello !
    first of all , I want to tell u Congratulations to your hard work and beutifull
    How to choose a another country, and also i want to know the password , because when i try edit he ask me a password. Thank you

    Reply

    • Thank you for your kind words.

      To unlock, the word is indzara.

      Currently, I have the map only for India. In the future, I plan to create them for more countries.

      Reply

  • Interesting…this heat map issue … Looks like the predictions in the 1981 book by Joel Garreau “Nine Nations of North America” came true. You should read it (If you haven’t) it’s a great book.

    Reply

  • thanks for your reply will wait for district level maps,but surely it will help lot of people.
    Already we are using your state level heat maps
    I wanted to thank you for your effort Thanks 🙂 🙂

    Reply

    • Hello Sri,

      Thanks. I am glad that the map is useful. Please e-mail me at indzara at gmail, if you don’t mind, and let me know how the map is being used. It will be good to know.

      Reply

  • Hi
    your template helped me lot.How to add districts with in State.
    can u guide me plz
    Thanks and regards

    Reply

    • Hello bhai,

      Thanks. I have not created the district level maps yet. I plan to create them in the future. I will post them. Please subscribe to my blog to be notified.

      Reply

      • Hello ind zara,

        I need it for Mumbai Region, Pincode wise.

        Will be greatly helpful

        Regards,
        Anand Saboo

        Reply

  • Congratulations. It’s pretty good. How does this the hidden ‘Data’ sheet? It is macro? Never seen anyone do that. The net has.

    Reply

    • Thanks. 🙂

      You can unhide the ‘Data’ sheet and see how I built it. It has a lot of cells with simple formulas. There is no macro.

      It’s not difficult, but it takes a lot of patience and time. When I find a better method, I will post a video on it.

      Reply

    • According to Google translate, you are saying
      “Congratulations Indzara. Your map okay show. How do I create my own map here in Brazil?”

      Thank you. It was a manual effort for me to draw the outline of the country map and then have Excel cells with formula that points to the numbers in the data. I applied conditional formatting after that. I need to find a better method to create the map so that I can create for other countries too.

      Reply

  • Dear Indzara,

    Greetings, Your map is excellent, how can we change colours as green lowest and Red highest.

    Please help.

    Thanks
    Kamalesh

    Reply

    • Hello Nisha Sachan,
      It’s done using conditional formatting on the hidden ‘Data’ sheet. If you are familiar with Excel, you can unhide the ‘Data’ sheet and change conditional formatting. If you are not familiar with condistional formatting, I can either change the colours (Green lowest and Red highest)and e-mail a new template to you. Or I can provide instructions/video to explain how to change colours. Please let me know what you prefer.
      Thanks for using the template. I hope it’s useful.

      Reply

    • Thanks for the revert was able to reverse the gradient,can we be able to mention numbers as well on the states along with the colors.

      Reply

    • Yes, we can insert text box (or Shape) for each state in the hidden ‘Data’ sheet and in the formula bar point to the corresponding cells (numbers) in the Geographic_Heat_Map sheet. These text boxes with numbers will automatically appear on the map in the Geographic_Heat_Map sheet. If you would like a copy of the template with the numbers, please e-mail at indzara at gmail.

      Reply

      • Hi Indzara
        can you share the templete with the heat map showing numbers along with the state name.

        Reply

        • I have emailed the file to you. It is for the older map where Andhra Pradesh was unified as one state. Thanks. Best wishes.

          Reply

    • Ind Zara Just Now I have seen you map. It was excellent. I also wanted to generate districts map to prepare a report card for advocacy of Government of India. I want to fill the colours as per our WBTi scoring. Can I generate colour map for districts also as per my colour requirement?

      Reply

Leave a Reply

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