blankblank blank




Excel Spreadsheet Data To Google Earth Thematic Map



After yesterday’s post on thematic mapping in Google Maps, John Stewart  of the University of North Carolina’s MEASURE program wrote to tell me about their own thematic mapping tool, the E2G Thematic Mapper. This Microsoft Excel macro spreadsheet data and links it with polygon data for countries and their administrative units to create thematic maps for Google Earth:

Excel data to Google Earth thematic map

Image is from the excellent PDF manual included with the distribution. I can’t try it out because I don’t currently have a computer with Excel (2003 or 2007), and it doesn’t seem to run on Open Office Calc.

It also currently only has polygon data for sixteen countries:

  • Botswana
  • Côte d’Ivoire
  • Democratic Republic of the Congo
  • Ethiopia
  • Guyana
  • Haiti
  • Kenya
  • Mozambique
  • Namibia
  • Nigeria
  • Rwanda
  • Tanzania
  • Uganda
  • Vietnam
  • South Africa
  • Zambia

But John says that an update coming this summer will add polygon data for more countries, along with more macro features.

If you’re interested in field data acquisition, the entire Monitoring and Evaluation Systems section of the MEASURE site is worth a look.


Looking for something else? Enter some keywords below, then click "Search".
"This site" searches Free Geography Tools; "Web" searches the Internet using Google.



0 Responses to “Excel Spreadsheet Data To Google Earth Thematic Map”


  1. No Comments

Leave a Reply


I welcome all legitimate comments. But spammers should know that my spam filters are currently blocking almost 100% of comment spam, and any that gets through the filters is immediately deleted. Don't believe me? Try posting a spam comment, and see what happens.

Powered by WP Hashcash