CSV to KML conversion - invalid coordinates
Brought to you by:
m3t30r1c
Not sure if this post is referring to the same problem in "Invalid KML file when csv file is in UTF8 - ID: 2889445". Anyways, i hope to provide some clarity here ..
while converting the below csv:
UTC-Timestamp Remark Longitude Latitude HorizontalAccuracy VerticalAccuracy Elevation Speed Heading
2009-12-09T10:05:14.120Z my place 75.930531 11.837122 0.839999974 2.5 606 0.6km/h 164.8718262
i get the KML
<Placemark>
<name><![CDATA[75.930531]]></name>
<description><![CDATA[11.837122]]></description>
<Point>
<coordinates>2009-12-09T10:05:14.120Z,my place,0</coordinates>
</Point>
</Placemark>
where the coordinates are wrong.
Please help to correct this; if any clarification is required please contact sandeep.karun@gmail
I believe your csv data is not arranged correctly, it should be like this:-
"-122.347627","47.621248","Experience Music Project","325 5th Ave N<BR>Seattle, WA 98109<BR>(206) 770-2702"
"-122.397187","47.667631","Hiram M Chittenden Locks","3015 Northwest 54th St<BR>Seattle, WA 98107<BR>(206) 783-7059"