Does anyone have experience taking a kmz file from Google Earth and converting it to an Excel spreadsheet for lat/long positions in DMS?
This little piece of free software will do that for you.
http://www.dnr.state.mn.us/mis/gis/tools/arcview/extensions/DNRGarmin/DNRGarmin.html
I overran its capabilities with an SHP file that was more than 30,000 records, but it will handle reasonably sized files.
I don't know of a slick way, but I could do it with this laborious process:
-Copy whatever.kmz to whatever.zip
-Unzip the file and find the .kml within it.
-Rename from whatever.kml to whatever.csv
-Edit the .csv file with a text editor to remove everything extraneous. Keep and data. Put the name and coordinates for each point on one line, separated by commas.
-Open with the spreadsheet program.
-convert decimal degrees to dms using spreadsheet formulas.
Edit: I'm glad someone had an easier way.
http://sourceforge.net/projects/kmlcsv/
I use this alot, works great.
It will get you to a CSV (ASCII) file that you can use in Excel.
That's really a neat way to do it. In the past, I've opened KML files in a text editor, used search and delete to strip away the unwanted stuff, saved and opened in Excel.
Necessity is the mother of invention!
GPSBabel will work also. www.gpsbabel.org
Edit: and ArcGIS is another option
My personal favorite (with all kinds of output formatting options (tab delimiting, AutoCAD format, etc.):
If you can resave the .kmz file as a .kml file, you should be able to open it right in Excel. You have to click through a couple of boxes that pop up about unknown format and that Excel will have to make its own schema for the file, but it works. I do it this way all the time.
