Convert KML to CSV Online — Free & Instant
Extracting data from KML files into CSV lets you analyse Google Earth placemark data in Excel, Google Sheets, or Python. This is common when receiving KML exports from field teams or government portals and needing to work with the coordinates and attributes in a spreadsheet. Maparz outputs X (longitude) and Y (latitude) columns alongside all KML placemark properties.
File converter
When to convert KML to CSV
- Extracting Google Earth placemark coordinates into an Excel spreadsheet
- Loading KML survey data into pandas for data analysis
- Converting KML point data for use in Tableau or Power BI dashboards
- Sharing KML location data with stakeholders who only use spreadsheets
How to convert KML to CSV
- 1
Upload your KML or KMZ
Drop a .kml or .kmz file on the upload zone.
- 2
Select CSV
Click CSV in the format panel.
- 3
Open in Excel
The CSV includes X (longitude), Y (latitude), and all placemark attribute columns.
About KML
Keyhole Markup Language (KML) is an XML-based format developed for Google Earth and now maintained by the OGC. It is widely used in Google Maps, Google Earth, and many consumer-facing mapping applications. KML supports styled geometry, network links, folders, and time-based animations. It always uses geographic coordinates (WGS 84) and is stored as plain XML text. KMZ is simply a ZIP-compressed KML file, which can also include embedded images and other resources.
Strengths
- +Native in Google Earth and Google Maps
- +Supports rich styling and labels
- +Human-readable XML
About CSV
CSV (Comma-Separated Values) files containing geometry data typically include latitude and longitude columns (or X/Y columns for projected data). Many data providers distribute point datasets as CSV because they are easy to open in Excel, Python, and R. When converting from a vector format to CSV, Maparz outputs an X (longitude) and Y (latitude) column along with all attribute data. To convert CSV to GeoJSON, your file must have columns identifiable as longitude (x, lon, lng, longitude) and latitude (y, lat, latitude).
Strengths
- +Opens in Excel, Google Sheets, any spreadsheet
- +Human-readable and editable
- +Lightweight for point data
Frequently asked questions
Q.Will KML placemark names and descriptions be included?
Yes. KML placemark names and description attributes are included as columns in the CSV output.
Q.Can I convert a KMZ file?
Yes. Both .kml and .kmz files are accepted. KMZ is decompressed automatically before conversion.
Q.Does CSV work well for KML polygon data?
CSV is best suited for point data. For KML containing polygons or lines, GeoJSON or Shapefile will better preserve the full geometry.