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. 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. 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. 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 trial14-day free trial. No credit card required.