[gdal-dev] .kml to .xlsx or .xls ( with Geometry Column Included)

[Jeff McKenna]

Another option is to convert from KML to CSV, which can be opened by 
LibreOffice/Word etc. using the "GEOMETRY=AS_XY" switch, which generates 
your X and Y columns magically:

   ogr2ogr -f CSV -lco GEOMETRY=AS_XY output.csv input.kml


-jeff



-- 
Jeff McKenna
MapServer Consulting and Training Services
https://gatewaygeomatics.com/


On 2019-11-27 8:45 AM, Wuyyuru Ravi Teja Krishna wrote:
> Hello GDAL team,
> 
>           We are trying to use ogr2ogr util for conversion of .kml to 
> .xlsx. But the converted .xlsx file is missing geometry column. In 
> documentation it says of using ogr vrt capabilities for this purpose but 
> its not clear on procedure need to be followed. Can someone please 
> direct us with solution to our problem?
> 
> Thanks in advance
>