Export KML to Excel: 4 Easy Ways

How-to basics · Updated November 22, 2026

Yes, you can export KML to Excel, and the simplest way is to use a free online converter or Excel’s built-in 3D Maps feature—but the most reliable method is to convert the KML to CSV first, then open that CSV in Excel. Below are the detailed steps, tool comparisons, and troubleshooting tips you need.

What Is a KML File and Why Export It?

KML (Keyhole Markup Language) is an XML-based file format used by Google Earth, Google Maps, and many GIS applications to display geographic data—points, lines, polygons, and associated attributes like names and descriptions. Exporting KML to Excel is useful when you need to analyze coordinates, sort placemarks, edit data in bulk, or combine geographic data with other spreadsheet data. For example, you might have a KML of customer locations and want to calculate distances or create pivot tables.

KML files are essentially text files with nested XML tags. Excel cannot open a KML file directly (it will show a warning about the file format), so you must convert it to a tabular format like CSV or XLSX.

Method 1: Convert KML to CSV Using a Free Online Tool

The fastest way for most users is to use a web-based converter. These tools parse the KML and output a CSV file with columns like Name, Description, Longitude, Latitude, and sometimes Altitude.

  1. Go to a reputable converter site (e.g., MyGeodata or GPS Visualizer).
  2. Upload your .kml file (or paste its URL).
  3. Choose output format as CSV (or Excel).
  4. Click Convert and download the resulting file.
  5. Open the CSV in Excel (File > Open, or double-click if CSV association is set).

Note: Free tools may have file size limits (often 5–10 MB) and may not preserve complex attributes like styles or extended data unless explicitly supported. For sensitive data, avoid uploading to unknown sites.

Method 2: Use Excel’s 3D Maps (Power Map) to Import KML

If you have Excel 2016 or later (Microsoft 365), you can import KML directly using 3D Maps, which converts the geographic data into a table automatically.

  1. In Excel, go to the Insert tab and click 3D Maps (or Map in some versions).
  2. In the 3D Maps window, click Add Layer.
  3. Click the Import icon (or right-click the layer and choose Import Data).
  4. Select your KML file. Excel will parse it and create a new worksheet with the data.
  5. Close 3D Maps; the data is now in your workbook as a table.

This method works best for point data (placemarks). Lines and polygons may import as geometry but not as simple coordinate columns. Also, 3D Maps is not available in Excel for the web or on Mac.

Method 3: Use Google Earth Pro to Save as CSV

If you have Google Earth Pro (free desktop app), you can convert KML to CSV without third-party tools.

  1. Open your KML in Google Earth Pro (File > Open).
  2. In the Places panel, right-click the layer or placemark and choose Save Place As.
  3. In the Save dialog, change the file type to CSV (if available). If CSV is not an option, save as KML again, then use a converter.
  4. Open the CSV in Excel.

Note: Google Earth Pro’s CSV export may only include name, longitude, and latitude, not all extended data. For richer data, use a dedicated converter.

Method 4: Use a GIS Tool Like QGIS (Free) for Complex Data

For KML files with multiple layers, polygons, or extensive attribute data, a GIS tool gives you full control.

  1. Download and install QGIS (free, open-source).
  2. Drag and drop your KML file into QGIS.
  3. Right-click the layer in the Layers panel and select Export > Save Features As.
  4. Choose format as CSV or Excel (if you have the XLSX plugin).
  5. Set the CRS (coordinate reference system) to WGS 84 (EPSG:4326) if you want standard lat/lon.
  6. Click OK and open the exported file in Excel.

QGIS preserves all attributes and handles complex geometries. It’s ideal for professionals but has a learning curve.

Common Problems and How to Fix Them

  • Coordinates appear as one column – Some converters merge lat/lon into a single column like “POINT (lon lat)”. Use Excel’s Text to Columns (Data > Text to Columns) with space as delimiter to split them.
  • Data is in a single row – If the KML uses CDATA or multiline descriptions, converters may flatten everything into one cell. Try a different converter or use QGIS.
  • Special characters garbled – Ensure the converter uses UTF-8 encoding. When opening CSV in Excel, go to Data > From Text/CSV and choose UTF-8 encoding.
  • Polygons not showing coordinates – For polygons, you need to extract the boundary coordinates. Some converters only export the centroid. Use QGIS to export polygon vertices as separate rows.
  • File too large – Online tools often limit file size. Split your KML into smaller files or use a desktop tool like QGIS.

How to Choose the Right Method

Your choice depends on your data and technical comfort:

  • Simple point data, quick task – Use an online converter (Method 1).
  • Already have Excel 3D Maps – Use Method 2 for a no-upload solution.
  • Need to preserve all attributes – Use QGIS (Method 4).
  • Prefer a desktop tool without installing – Google Earth Pro (Method 3) is a middle ground.

If you need to edit the data repeatedly, consider converting to a proper Excel table and using structured references.

Costs and Safety Considerations

All methods described above are free (Excel 3D Maps is included in Microsoft 365 subscriptions, but the feature itself is free). QGIS and Google Earth Pro are free. Online converters may have premium tiers for large files or batch conversions, but basic use is free.

Safety: When using online converters, be cautious with confidential or proprietary data. Uploading to a third-party service means your data is stored on their servers. For sensitive data, use offline tools like QGIS or Excel’s 3D Maps. Also, always verify the converted data for accuracy—check a few coordinates against the original KML.

Frequently Asked Questions

Can Excel open KML files directly?

No, Excel cannot open KML files directly because they are XML-based and not a recognized spreadsheet format. You must convert KML to CSV or XLSX first, or use 3D Maps to import it.

How do I convert KML to Excel without any software?

Use a free online converter like MyGeodata or GPS Visualizer. Upload your KML, select CSV output, download, and open in Excel. No software installation is needed.

Why does my KML show only one column in Excel?

This usually happens when the converter outputs the geometry as a single string (e.g., “POINT (lon lat)”). Use Excel’s Text to Columns feature to split by space or comma, or choose a converter that separates longitude and latitude into distinct columns.

Can I convert KML to Excel on a Mac?

Yes. Online converters work in any browser. Excel for Mac also has 3D Maps? No, 3D Maps is not available on Mac. For Mac, use an online converter or QGIS for Mac.

How do I convert KML to Excel with multiple placemarks?

All methods handle multiple placemarks. Online converters will list each placemark as a row. If you have nested folders, ensure the converter flattens them; QGIS gives you control over how to export.

Is there a way to convert KML to Excel offline?

Yes. Use Google Earth Pro (free desktop) or QGIS (free desktop). Both work offline once installed. Alternatively, use Excel’s 3D Maps if you have Microsoft 365, which is fully offline.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.