[gdal-dev] Re: converting csv to kml: locations displaced in Google Earth

[Tim Michelsen]

Hello!

> Maybe someone else can comment on how to property format your CSV to be 
> read by ogr2ogr, or you could try GPSBABEL as a download:
> http://www.gpsbabel.org/htmldoc-development/fmt_csv.html
> 
> or online:
> http://www.gpsvisualizer.com/gpsbabel/
I found out (by trial & error) that CSv files are read well if the have 
the following attributes:
* use comma ( , ) as separator
* if the fields have text with comma wrap it in "": "Singapur, Asia"

If exporting from Office I found the OpenOffice Calc export dialog to 
better that Excel: it allows to specify the charset which is useful for 
non-english texts.

Kind regards,
Timmie