One row per feature
Every Feature becomes one row. When all features are points, the table starts with latitude and longitude columns; otherwise every row gets a wkt column, and a GeometryCollection is written as one GEOMETRYCOLLECTION value. Features with a null geometry keep their row with empty coordinate cells.
Flattening properties
- Nested objects and arrays become JSON text in a single cell.
- A Feature
idthat is not already a property becomes anidcolumn. - simplestyle properties such as
strokeandfillare left out, and the conversion report counts the features that had them. - Z values are removed, and the report mentions them when a height was not zero.
Clean numbers and safe cells
Numbers are written without exponent notation, so 1e-7 becomes 0.0000001. Cells that start with =, +, - or @ get a leading apostrophe so spreadsheets do not run them as formulas; plain negative numbers are untouched. The file is UTF-8 with a byte order mark.