KML or KMZ To Excel Converter needed

**Moudj** · 2011-10-05, 12:12 AM

Dear All;
is there any converter which can convert KML or KMZ Data to Excel sheet, i have to generate a list of sites (links) with coordinate and comments in Excel Sheet, is it possible?

**Finetopix** · 2011-10-05 12:12 AM

**Dimitris_Z** · 2011-10-05, 12:36 AM

You need to convert the kml/kmz to mapinfo tab format and after from mapifo table to xls

**echomoon** · 2011-10-05, 03:52 AM

As KML is actully just XML, Excel can open it directly. Just type
"*.kml" in the filename in the Open File Dialog, find and open your
file(s).

I guess then once in KML you will copy/paste it into one document, and
convert it into some form of CSV

best regards

**telwind** · 2011-10-05, 09:49 AM

kmlcsv converter can do it very well for you.

**freakturd06** · 2011-10-05, 04:44 PM

How about excel macro converting cell data directly to kml file like the one shared here for RxLev and Qual without using MAPINFO plug-ins.

Please share if you have.

**justdream** · 2011-10-13, 04:47 AM

Originally Posted by telwind

kmlcsv converter can do it very well for you.

Please share KMLCSV converter?
Thanks

**telwind** · 2011-10-13, 07:57 AM

Originally Posted by Moudj

Dear All;
is there any converter which can convert KML or KMZ Data to Excel sheet, i have to generate a list of sites (links) with coordinate and comments in Excel Sheet, is it possible?

KMLCSV converter utility can convert kml to csv then use excel to convert into excel file.

Also simply open kml file by excel to edit and save as your target excel file.

**telwind** · 2011-10-13, 08:07 AM

link to download kmlcsv

JRE 1.5 is required.

**Stantheman** · 2011-10-13, 08:50 AM

it is open source SW, here is the sourceforge link KMLCSV Converter | Free Development software downloads at SourceForge.net

"Converts Google Earth KML file to a CSV file, and vice versa. This enables you to plot all custom POIs with Google Earth first before transferring them into your Garmin GPS using the POI Loader."

From the review page KMLCSV Converter | Reviews for KMLCSV Converter at SourceForge.net "It has a well designed interface very well thought out and very intuitive. But it will choke on large files, and will truncate data in the description block when saving CSV file.."