Bill Clark, the author of the useful Google Earth Public Land Survey System (PLSS) tool, has a new online app for converting spreadsheet data into point KML files, and opening them directly in Google Earth. Spreadsheet files can be in XLS (Office 2003 or earlier for now, Office 2007 support coming), CSV, or TXT (tab-delimited format); the minimum data required includes only latitude and longitude (either decimal or degree-minute-second formats are acceptable). Optional additional data accepted includes:
- Name for each point
- Description (text for pop-up balloon)
- Icon (use the table on the web app page to select a number corresponding to the desired icon graphic)
- Formatting tags (size and color of icon, altitude, connecting lines)
Make sure the column headings are included, exactly as specified on the web page’s instructions; there’s an option on the web page to review the spreadsheet data online to make sure it’s correct. The data is formatted into KML at the server, then sent back to your computer to be opened in Google Earth; the original data is then deleted at the server end for security. If you want to save the data displayed in Google Earth, make sure you right-click on the data item in the Places window on the left, and save it in either KML or KMZ format.
Other posts in the Google Earth Data Tools series
- KML Editors
- Diagramming In Google Maps And Google Earth With Smoot
- Plotting Data In Google Earth Using GE-Graph
- Drawing Grids, Paths And Polygons In Google Earth Using GE-Path
- Online Google Earth Utilities For Buffering And Area Calculations
- Easy Display Of Thematic Data In Google Maps And Google Earth
- Using GIF/PNG Transparency In Displaying Raster Graphics In Google Earth
- Adding Vector Graphic Objects To Google Earth
- Animated GIFs In Google Earth
- Creating A Network KML Link To A Google Spreadsheet
- LIDAR Tools
- EarthPlot Software Tools For Google Earth
- Geographic Time Animations
- Convert TIGER Polygons To KML Files
- Putting Time Data Into A KML File
- Using The KML Time Embedder To Stamp Time Data Into A Google Earth File
- Using The KML Time Embedder, Concluded
- KML Time Embedder Improved With Hour-Minute-Second Ability
- Grid Creation And Path/Polygon Measurements: Two New Online KML Tools
- Google Earth PhotoOverlay Tool
- KML Random Placemark Generator
- Update For Online Google Earth Utilities
- KML Time Code Utility
- Screen Overlays In Google Earth
- The KML Screen Overlay Maker Utility
- KML Screen Overlay Maker Utility, Concluded
- KML Circle Generator
- Creating Google Earth Screen Overlays With EarthPaint
- Text Editor With KML Validation
- Online Spreadsheet To KML Converter
- Version 2.0 Of Google’s Online KML Spreadsheet Mapper Tool Released
- Creating Google Earth Ground Overlays From Georeferenced Images
- Google Earth Ground Overlays With GIF Transparency
- Creating "Transparent" Topo Map Overlays For Google Earth
- Using Google Earth Ground Overlays To Display Shapefile Data
- Converting 3D Objects Into Google Earth Format
- Thematic Mapping In Google Earth
- An Online KML Validator
- Modify A KML Polygon File With Excel Data


0 Responses to “Online Spreadsheet To KML Converter”