Add your KML
Drop a KML file anywhere on this page
.kml · it never leaves the browser
Options
Your CSV
Add a KML file and the CSV appears here, with its feature counts and anything this pair cannot carry.
What comes across, and what cannot
Preserved
- Geometry — points come across coordinate for coordinate; nothing is reprojected, because both sides are WGS84 longitude/latitude.
- Every attribute becomes a column. The header is the union of all property keys across the file, so features with different fields still line up.
- Row order matches feature order, so you can join the result back onto the original file.
Dropped
- Styling. KML carries Style and StyleMap elements — icon, colour, line width, fill — and CSV has nowhere to put them, so they are dropped. Style the data on the map instead.
- Lines and polygons, but only if you ask for it. The default WKT geometry column keeps every geometry type intact; switching to separate longitude and latitude columns can only describe a point, and anything else comes out with empty coordinate cells.
- Time as a dimension. KML's TimeStamp and TimeSpan elements are read as ordinary attributes, which is as close as CSV gets to a clock.
- Elevation. A flat CSV has no third ordinate; keep the WKT geometry column if you need the Z value, because WKT encodes it.
Keyhole Markup Language (KML)
The XML format Google Earth popularised. Placemarks carry a name, a description balloon, a geometry and — unlike GeoJSON — presentation: styles, icons, colours, altitude modes and time stamps.
.kml · application/vnd.google-earth.kml+xml
CSV (comma-separated values)
A spreadsheet, not a spatial format. It becomes spatial when two columns hold longitude and latitude, or when one column holds a WKT geometry — which is how anything other than a point survives the round trip.
.csv · .tsv · text/csv
Convert KML to CSV, step by step
- Step 1
Add your KML
Drop a KML file anywhere on the page, paste it, point at a URL, or press Sample to start from real data. Several files at once are fine.
- Step 2
Set what matters
Coordinate precision and simplification on every pair, plus the handful of settings this one needs — a WKT column or longitude/latitude columns.
- Step 3
Take the CSV
Read the feature counts and the warning list, then download, copy, or open the result in the Spatly studio to style and publish it.
Your data never leaves the page
Every conversion, measurement and export happens client-side. Nothing is uploaded, logged or stored — you can even use this offline once the page has loaded. Only “Open in Studio” sends data, and only after you sign in.
Good to know
- What is preserved when converting KML to CSV?
- Geometry — points come across coordinate for coordinate; nothing is reprojected, because both sides are WGS84 longitude/latitude. Every attribute becomes a column. The header is the union of all property keys across the file, so features with different fields still line up. Row order matches feature order, so you can join the result back onto the original file.
- What is lost converting KML to CSV?
- Styling. KML carries Style and StyleMap elements — icon, colour, line width, fill — and CSV has nowhere to put them, so they are dropped. Style the data on the map instead. Lines and polygons, but only if you ask for it. The default WKT geometry column keeps every geometry type intact; switching to separate longitude and latitude columns can only describe a point, and anything else comes out with empty coordinate cells. Time as a dimension. KML's TimeStamp and TimeSpan elements are read as ordinary attributes, which is as close as CSV gets to a clock. Elevation. A flat CSV has no third ordinate; keep the WKT geometry column if you need the Z value, because WKT encodes it.
- What happens to my folders?
- Placemarks inside folders are flattened into one collection; the folder name is not carried through as a grouping. If you need the grouping, add a property for it before converting, or convert each folder separately.
- Are ground overlays and network links converted?
- No. Only placemark geometry and its data come through. GroundOverlay, ScreenOverlay and NetworkLink are references to other resources rather than features, so there is nothing to convert them into.
- How is the geometry written into a flat table?
- Two ways, and you pick. A single WKT column keeps every geometry type exactly — that is the default, and the one to use if you have lines or polygons. Separate longitude and latitude columns are friendlier to Excel and Google Sheets but can only describe a point.
- What are the columns?
- The union of every attribute key in the file, in first-seen order, plus the geometry column(s). Features missing a key get an empty cell rather than being dropped, so the row count always equals the feature count.
- Is my file uploaded anywhere?
- No. The KML is read, converted and written entirely inside this page — there is no upload, no queue, no server-side copy and no size limit imposed by a plan. Large files are parsed in a background worker so the page stays responsive. The only action that transmits anything is Open in Studio, and that happens after you sign in and press it.
- Is there a limit on file size or number of files?
- There is no imposed limit; the practical ceiling is your browser's memory. Files over about 5 MB are handed to a web worker so the interface keeps responding, and you can drop several files at once — each is converted separately and the set can be downloaded as one zip.