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.

Related posts:

  1. Thematic Mapping Engine API For Displaying Your Own Data In Google Earth
  2. Creating A Thematic Map Using Just Excel
  3. Modify A KML Polygon File With Excel Data
  4. Thematic Mapping In Google Earth
  5. Another Excel To KML Converter
  6. Displaying Datasets In The Google Earth Plugin With Earth Atlas
  7. XLS2KML – Another Excel To KML Converter, With A Few Extras
  8. Excel Add-On For Map And Data Visualization
  9. Create KML Range Circles, Arrows And Wedges With An Excel Macro
  10. Plotting Swivel Data In Google Maps

Looking for something else? Enter some keywords below, then click "Search".    




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


  1. 1 BeGraphic

    Easiest solution is http://www.begraphic.com

    the free version of this Excel addin lets you build dynamic maps from your data.

    Business users (with professional email) receive 10 000 maps.

  2. 2 Leszek Pawlowicz
Comments are currently closed; feel free to contact me with questions/issues.