blankblank blank




Modify A KML Polygon File With Excel Data



Remy Paternoster writes to announce a new tool he’s created, an Excel app called KMLxl that imports a KML polygon/placemark file created in Google Earth, and lets you both attach data to each polygon and scale the height of the polygon to a variable value:

kmlxl

The process is straightforward, involving creating polygons and associated placemarks in Google Earth, importing the KML file into Excel with the app, adding data, and then exporting the results as a new KML file. You can update the Excel spreadsheet at any time with new data, and create a new KML that reflects the newer data. In addition to the app, Remy has an easy-to-follow step-by-step tutorial of the process in an accompanying PDF file.

Other posts in the Google Earth Data Tools series

  1. KML Editors
  2. Diagramming In Google Maps And Google Earth With Smoot
  3. Plotting Data In Google Earth Using GE-Graph
  4. Drawing Grids, Paths And Polygons In Google Earth Using GE-Path
  5. Online Google Earth Utilities For Buffering And Area Calculations
  6. Easy Display Of Thematic Data In Google Maps And Google Earth
  7. Using GIF/PNG Transparency In Displaying Raster Graphics In Google Earth
  8. Adding Vector Graphic Objects To Google Earth
  9. Animated GIFs In Google Earth
  10. Creating A Network KML Link To A Google Spreadsheet
  11. LIDAR Tools
  12. EarthPlot Software Tools For Google Earth
  13. Geographic Time Animations
  14. Convert TIGER Polygons To KML Files
  15. Putting Time Data Into A KML File
  16. Using The KML Time Embedder To Stamp Time Data Into A Google Earth File
  17. Using The KML Time Embedder, Concluded
  18. KML Time Embedder Improved With Hour-Minute-Second Ability
  19. Grid Creation And Path/Polygon Measurements: Two New Online KML Tools
  20. Google Earth PhotoOverlay Tool
  21. KML Random Placemark Generator
  22. Update For Online Google Earth Utilities
  23. KML Time Code Utility
  24. Screen Overlays In Google Earth
  25. The KML Screen Overlay Maker Utility
  26. KML Screen Overlay Maker Utility, Concluded
  27. KML Circle Generator
  28. Creating Google Earth Screen Overlays With EarthPaint
  29. Text Editor With KML Validation
  30. Online Spreadsheet To KML Converter
  31. Version 2.0 Of Google’s Online KML Spreadsheet Mapper Tool Released
  32. Creating Google Earth Ground Overlays From Georeferenced Images
  33. Google Earth Ground Overlays With GIF Transparency
  34. Creating "Transparent" Topo Map Overlays For Google Earth
  35. Using Google Earth Ground Overlays To Display Shapefile Data
  36. Converting 3D Objects Into Google Earth Format
  37. Thematic Mapping In Google Earth
  38. An Online KML Validator

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



3 Responses to “Modify A KML Polygon File With Excel Data”


  1. 1 josh

    I get nothing after I do the first import step.

  2. 2 Remy Paternoster

    You only should get a message that says the number of polygons you imported. You should see any data added to the sheets, I didn´t want it to interfere with your data, the import process creates a txt file right next to you excel file with the imported data…

    Check the tutorial out to see the next steps and let me know if you have any more problems.

  3. 3 4u2v

    where downloads excel addin?

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