Convert KML to CSV
Free, private and fast: everything runs in your browser and your KML file is never uploaded.
KML to CSV: why convert
A KML from Google Earth or Google My Maps is perfect for looking at places on a map, but not for counting, sorting or mail-merging them. This converter turns the placemarks into a CSV table you can open in Excel or Google Sheets: one row per placemark with its name and description, and the longitude and latitude as two plain columns. Paths and areas are written as WKT text, which GIS tools can read back. Each KML folder becomes its own CSV, so a My Maps file with several layers gives you one table per layer in a zip. Choose the standard CSV, or an Excel style that shows letters such as æ and é correctly and, for countries with a decimal comma, uses semicolons and decimal commas.
How to convert KML to CSV
- Drop your .kml file in the box, or click to choose it. For a .kmz, use the KMZ to KML converter first.
- Choose the CSV style that suits the program you will open the file in.
- Click Convert to CSV and open the table in Excel, Google Sheets or your GIS.
What changes when you convert
Only name and description
The converter reads each placemark's name and description. Extra fields stored as KML ExtendedData, which My Maps uses for imported table columns, are not read. If you need those columns, export the layer from My Maps as CSV directly, or open the KML in QGIS.
Points become X and Y
When a folder holds only points, the CSV starts with an X column (longitude) and a Y column (latitude). Points with a real altitude also get a Z column; the zero altitude Google Earth writes for points on the ground is left out.
Paths and areas become WKT
A folder with lines or polygons gets a WKT column instead, for example LINESTRING (12.56 55.67, …). Excel shows that as text; QGIS and other GIS programs can turn it back into geometry.
Descriptions with HTML
Descriptions written in Google Earth often contain HTML such as line breaks and links. They are copied as they are, so you may see tags like <br> in the cells.
About the formats
KML
KML (Keyhole Markup Language) is the XML format behind Google Earth and Google My Maps, and an OGC standard since 2008. Besides geometry it can hold styles, icons, folders and descriptions in HTML.
- Always WGS84 longitude, latitude and optional altitude.
- Folders group placemarks; each folder can become its own layer when converting.
- Styles (colors, line widths, icons) are specific to KML and Google Earth.
CSV
CSV (comma-separated values) is a plain-text table that opens in Excel, Google Sheets and every database. It has no geometry type of its own: locations are stored either as two coordinate columns, such as latitude and longitude, or as a column of WKT text.
- Points fit in two columns (X and Y, or longitude and latitude); lines and polygons need a WKT column.
- The coordinate system is not stored in the file, so note it separately.
- There is no standard for the separator: Excel uses a comma or a semicolon depending on the language settings.
- Every value is text; whether 0800 is a number or a postcode is up to the program reading it.
Frequently asked questions
Is my KML uploaded?
No. The file is read and converted by your browser on your device.
Why did I get a zip?
Your KML has several folders or layers. Each becomes its own CSV, named after the folder, so the tables do not get mixed up.
Which CSV style should I choose?
Standard for GIS programs, databases and Google Sheets. "Excel" for Excel in English-speaking countries, and "Excel in Europe" if your Excel uses a comma as the decimal mark.
Can I turn the CSV back into a KML?
Yes. Convert it to GeoJSON with the CSV converter, and then to KML.