Excel to Kml "goole earth file"

[usef]

Hello,

I am trying to map excel data to google earth kml file. i did this online with http://www.earthpoint.us/ExcelToKml.aspx
and it works very good! i was using the bellow headers:

Latitude
Longitude
Name Description
Icon
Snippet
IconScale
IconAltitude
IconLineColor
HideNameUntilMouseOver

but they have limitations of row counts. and i found http://processtrends.com/Files/MapExcelData.zip

which they have an excel sheet that works fine but dont give the nice output file as earthpoint does.

i hope some one can help me edit the file from processtrends.com to make it create kml files such as earthpoint.

Sample kml files:

Earthpoint:

[code:]
<?xml version="1.0" encoding="UTF-8"?>
<kml xmlns="http://www.opengis.net/kml/2.2" xmlns:gx="http://www.google.com/kml/ext/2.2" xmlns:kml="http://www.opengis.net/kml/2.2" xmlns:atom="http://www.w3.org/2005/Atom">
<Document>
<name>Advanced Features.kml</name>
<StyleMap id="Sheet1Map1">
<Pair>
<key>normal</key>
<styleUrl>#NormalSheet1Map1</styleUrl>
</Pair>
<Pair>
<key>highlight</key>
<styleUrl>#HighlightSheet1Map1</styleUrl>
</Pair>
</StyleMap>
<Style id="NormalSheet1Map1">
<IconStyle>
<scale>0.8</scale>
<Icon>
<href>http://www.earthpoint.us/Dots/GoogleEarth/pal4/icon62.png</href>
</Icon>
</IconStyle>
<LabelStyle>
<color>01000000</color>
</LabelStyle>
<BalloonStyle>
<text>$[description]</text>
</BalloonStyle>
<LineStyle>
<color>ff00ff00</color>
<width>2</width>
</LineStyle>
<PolyStyle>
<color>0100ff00</color>
<fill>0</fill>
</PolyStyle>
</Style>
<Style id="HighlightSheet1Map1">
<IconStyle>
<scale>0.8</scale>
<Icon>
<href>http://www.earthpoint.us/Dots/GoogleEarth/pal4/icon54.png</href>
</Icon>
</IconStyle>
<LabelStyle>
</LabelStyle>
<BalloonStyle>
<text>$[description]</text>
</BalloonStyle>
<LineStyle>
<color>ff00ff00</color>
<width>3</width>
</LineStyle>
<PolyStyle>
<color>7000ff00</color>
<fill>0</fill>
</PolyStyle>
</Style>
<Folder>
<name>Advanced Features</name>
<Placemark>
<name>M32</name>
<Snippet maxLines="1">Mouse Over Effect</Snippet>
<description>TEST1</description>
<LookAt>
<longitude>54.684021</longitude>
<latitude>24.5347862</latitude>
<altitude>0</altitude>
<heading>0</heading>
<tilt>0</tilt>
<range>1200</range>
<altitudeMode>relativeToGround</altitudeMode>
</LookAt>
<styleUrl>#Sheet1Map1</styleUrl>
<ExtendedData>
</ExtendedData>
<Point>
<extrude>1</extrude>
<altitudeMode>relativeToGround</altitudeMode>
<coordinates>54.684021,24.5347862,200</coordinates>
</Point>
</Placemark>
<Placemark>
<name>M10</name>
<Snippet maxLines="1">Mouse Over Effect</Snippet>
<description>TEST2</description>
<LookAt>
<longitude>54.5126572</longitude>
<latitude>24.3810883</latitude>
<altitude>0</altitude>
<heading>0</heading>
<tilt>0</tilt>
<range>1200</range>
<altitudeMode>relativeToGround</altitudeMode>
</LookAt>
<styleUrl>#Sheet1Map1</styleUrl>
<ExtendedData>
</ExtendedData>
<Point>
<extrude>1</extrude>
<altitudeMode>relativeToGround</altitudeMode>
<coordinates>54.51265719999999,24.3810883,200</coordinates>
</Point>
</Placemark>
<Placemark>
<name>A11</name>
<Snippet maxLines="1">Mouse Over Effect</Snippet>
<description>TEST3</description>
<LookAt>
<longitude>54.4542503</longitude>
<latitude>24.4121399</latitude>
<altitude>0</altitude>
<heading>0</heading>
<tilt>0</tilt>
<range>1200</range>
<altitudeMode>relativeToGround</altitudeMode>
</LookAt>
<styleUrl>#Sheet1Map1</styleUrl>
<ExtendedData>
</ExtendedData>
<Point>
<extrude>1</extrude>
<altitudeMode>relativeToGround</altitudeMode>
<coordinates>54.4542503,24.4121399,200</coordinates>
</Point>
</Placemark>
</Folder>
</Document>
</kml>

/[code:]


Processtrends:

[code:]
<?xml version="1.0" encoding="UTF-8"?>
<kml xmlns="http://www.opengis.net/kml/2.2" xmlns:gx="http://www.google.com/kml/ext/2.2" xmlns:kml="http://www.opengis.net/kml/2.2" xmlns:atom="http://www.w3.org/2005/Atom">
<Document>
<name>Normal</name>
<Style id="a">
<IconStyle>
<Icon>
<href>http://maps.google.com/mapfiles/kml/shapes/cabs.png</href>
</Icon>
</IconStyle>
</Style>
<Placemark>
<name>M32</name>
<description>TEST1</description>
<styleUrl>#a</styleUrl>
<Point>
<coordinates>54.684021,24.5347862,0</coordinates>
</Point>
</Placemark>
<Placemark>
<name>M10</name>
<description>TEST2</description>
<styleUrl>#a</styleUrl>
<Point>
<coordinates>54.51265719999999,24.3810883,0</coordinates>
</Point>
</Placemark>
<Placemark>
<name>A11</name>
<description>TEST3</description>
<styleUrl>#a</styleUrl>
<Point>
<coordinates>54.4542503,24.4121399,0</coordinates>
</Point>
</Placemark>
</Document>
</kml>
/[code:]



Thanks!!