Just stumbled across another Excel .XLS file with macros that will convert a list of coordinates and descriptions into a Google Earth KML file. Not particularly fancy, but easy to use and works well.
excel2kml uses VBA, so you’ll have to have Excel (i.e. it won’t work with OpenOffice). Open the file in Excel, and enable macros if they’re disabled for security purposes. First page is the data sheet, with a set of sample data already in place: Name, Latitude, Longitude, and Description are the only data fields available. Paste your data into the data sheet (up to 50,000 lines), enter Alt-F8, and run the “Generate KML” macro. A file called “myfile.kml” will be created in the root directory of the C-drive; you can modify the file name and destination in the “File Details” tab. That’s it - tested it with the sample data and a file of my own, and works perfectly. You could probably modify it quite easily to meet any additional requirements you might have.
Other posts in the Google Earth Plus Features For Free series
- Google Earth Plus - Do You Really Need It?
- Importing GPS Data Into Google Earth I - Proprietary software and EasyGPS
- Importing GPS Data Into Google Earth II - GPSBabel and GPSVisualizer
- Exporting Data From Google Earth To A GPS Unit
- Using GPS Utility To Import/Export GPS Data To/From Google Earth
- Importing Spreadsheet Data Into Google Earth
- Another Excel To KML Converter
- US Address Geocoding For Google Earth
- GPS TrackMaker: A Better Solution For GPS Export/Import With Google Earth
- Automatic Caching Of Google Earth Data For Offline Use
- Real-Time GPS Tracking In Google Earth Free - Setup
- Real-Time GPS Tracking For Google Earth - Free Options I
- Real-Time GPS Tracking For Google Earth - Free Options II
- Real-Time GPS Tracking With Google Earth - DonationWare
- Real-Time GPS Tracking With Google Earth - Paid Options
- Update On GooPs - Real-Time GPS Tracking In Google Earth
- A KML To CSV (And CSV To KML) Converter For Spreadsheets And Garmin POI Files
- XLS2KML - Another Excel To KML Converter, With A Few Extras
- Recap Of "Google Earth Plus For Free" Series
If you have OpenOffice, you could consider upgrading to Novell OpenOffice 2.0.2 rc1 to get VBA compatibility.
It is about a 400MB download.
I have not tested this myself.
I couldn’t open the file for some reason…it said there was a Run-time error ‘75′: Path/File access error.
Do you know what that means?
let me know;
jeffrey.m.hamilton@gmail.com
The problem is that a “Run-time error ‘75′: Path/File access error” message could be caused by any number of things:
- A virus
http://www.wilderssecurity.com/showthread.php?t=58589
- Files set to read-only mode
http://www-1.ibm.com/support/docview.wss?uid=swg21136108
- File access issues due to system or network restrictions
http://www.iteris.com/itsarch/html/turbo/faq30details.htm
And so on. Do a Google search for the error message, and a lot of hits will come up.
It’s impossible for me to say what it could be on your system - I’m afraid that you’ll have to figure it out on your own. Sorry.