Convert KML to CSV and Excel

Open a KML or KMZ file and download a spreadsheet with one row per pin, line or area: its name, folder, position, size and data fields. It opens in Excel and Google Sheets. No signup and nothing to install.

Drop a KML or KMZ file here

or choose one from your computer or phone

KML · KMZ · GPX · GeoJSON · Shapefile. A copy is sent to us to improve the viewer and is deleted after one day.

How to convert KML to CSV

  1. 1. Open the KML or KMZ file

    Drop it on the box above or choose it from your computer. GPX, GeoJSON and shapefiles work too.

  2. 2. Pick US or metric

    Lengths and areas in the spreadsheet use the units shown above the map: feet and acres, or meters and hectares.

  3. 3. Download CSV

    Click Download CSV and open the file in Excel, Google Sheets or Numbers. Accented letters show correctly in Excel too.

From a map file to a spreadsheet

A KML file is good for looking at places on a map, but not for counting, sorting or adding them up. A spreadsheet is. Converting to CSV gives you a table you can filter by folder, sort by size or total up for a quote.

CSV is a plain text table that every spreadsheet program opens. Excel and Google Sheets can then save it as an .xlsx workbook if you need one.

What is in the spreadsheet

One row for each pin, line and area in the file.

Name, type and folder

Each row starts with the item name, whether it is a pin, line or area, and the folder it sits in.

Position

Latitude and longitude of each pin, or of the middle of each line or area, ready for sorting or for another map program.

Sizes

Length for lines, area and perimeter for areas, in feet and acres or meters and hectares.

Data fields and the full shape

Every data field from the file gets its own column, and a last column holds each full shape as text that GIS programs can read back.

Other ways to convert KML to CSV

QGIS

Open the KML in the free QGIS program, right-click the layer, choose Export, then Save Features As, and pick Comma Separated Value. It works one layer at a time.

Google My Maps

Import the KML into a map in Google My Maps, then open the data table of the layer to copy names and fields into a sheet by hand.

What happens to your file

The viewer opens the file inside your browser, so it shows up right away. A copy is also sent to us, so we can find and fix files the viewer gets wrong. It is scheduled to be deleted automatically after one day, and until then our team may look at it to improve the viewer. Nothing is added to an account.

Questions

Need a tool we have not built yet?

Tell us what would save you time. We read every request.

From a site outline to a finished job

DroneBundle turns a KML or KMZ site outline into a project, shows the FAA airspace around it, and keeps flights, pilots and aircraft for the whole team in one place.

Start free trial

14-day free trial. No credit card required.