Convert KMZ to Excel: 4 Ways That Actually Work

How-to basics · Updated November 22, 2026

Yes, you can convert a KMZ file to Excel, but there is no one-click button—you must first extract the placemark data from the KMZ, then import it as a table. The most reliable method is to change the KMZ extension to ZIP, extract the KML file, open it in Excel (which parses KML as XML), and then clean the data. Below are the full steps plus alternative tools, common pitfalls, and answers to frequent questions.

What a KMZ File Actually Is

KMZ is the compressed format used by Google Earth. It is simply a ZIP archive that contains one or more KML (Keyhole Markup Language) files, along with optional images, icons, and 3D models. KML is an XML-based markup language that stores geographic features like points, lines, polygons, and their associated attributes (name, description, coordinates, etc.). Because KMZ is just a ZIP, you can rename it to .zip and open it with any unzip tool—no special software required.

Method 1: Rename, Unzip, and Import into Excel (No Extra Software)

  1. Copy the KMZ file to a folder you can find easily (e.g., Desktop).
  2. Rename the file from yourfile.kmz to yourfile.zip. Windows will ask for confirmation—click Yes.
  3. Right-click the ZIP and choose Extract All (Windows) or double-click to open it on Mac.
  4. Find the .kml file inside (usually doc.kml).
  5. Open Excel (Microsoft 365 or Excel 2021/2024).
  6. Go to Data > Get Data > From File > From XML (or in older Excel: Data > From Other Sources > From XML Data Import).
  7. Select the KML file. Excel will show a navigator—choose the table that contains your placemark fields (often named Placemark or Folder).
  8. Click Load. Excel will import the XML as a table, but you will likely see columns like name, description, and a Point.coordinates column that holds the coordinates as a long string.
  9. Split the coordinates using Data > Text to Columns (delimited by comma) to get longitude, latitude, and altitude in separate columns.

This method works on Windows and Mac with Excel for Microsoft 365. On Mac, the ribbon path is the same: Data > Get Data > From File > From XML.

Method 2: Use Google Earth Pro to Export as CSV

If you prefer not to deal with XML, Google Earth Pro (free desktop app) can export your KMZ placemarks directly to a CSV file that Excel can open.

  1. Download and install Google Earth Pro (available for Windows, Mac, and Linux).
  2. Open your KMZ file via File > Open.
  3. In the Places panel, right-click the placemark or folder you want to export.
  4. Choose Save Place As….
  5. In the “Save as type” dropdown, select CSV (comma delimited).
  6. Click Save. The CSV will contain columns like Name, Description, and Longitude/Latitude (depending on the version).
  7. Open the CSV in Excel with File > Open—it will appear as a normal spreadsheet.

Note: Google Earth Pro’s CSV export includes only the first coordinate of a path or polygon, not all vertices. For full geometry, use the XML method or a dedicated converter.

Method 3: Online Converters and Third-Party Tools

Several free websites convert KMZ to Excel or CSV directly, but they come with privacy and accuracy caveats. Popular options include:

  • MyGeodata Cloud – allows KMZ to CSV/XLSX conversion with a free tier (limited file size).
  • Convertio – supports KMZ to XLSX, but only for files under 100 MB on the free plan.
  • GIS Converter (gisconverter.com) – converts KMZ to CSV, GeoJSON, or Shapefile.

To use them, you upload your KMZ, select output format (Excel or CSV), and download the result. The main risk is that your geographic data may be stored on the converter’s servers—avoid uploading sensitive or proprietary location data. Also, these tools often flatten nested folders and may lose formatting or attributes.

Common Problems and How to Fix Them

  • Coordinates appear as one long string – Use Data > Text to Columns with comma delimiter. After splitting, you’ll have Longitude, Latitude, and Altitude (if present).
  • Excel says “XML import error” – This happens when the KML has multiple namespaces. Try opening the KML in a text editor and removing the xmlns attributes from the root element, then save and import again. Or use Google Earth Pro’s CSV export instead.
  • Only the first coordinate of a polygon or path is exported – The CSV method from Google Earth Pro only gives the first point. To get all vertices, you must parse the KML manually or use a GIS tool like QGIS.
  • Description field contains HTML tags – KML descriptions often include HTML. In Excel, you can strip tags using a formula like =TRIM(SUBSTITUTE(SUBSTITUTE(A2,"
    "," "),"&","&"))
    (adjust cell reference).
  • File is too large for an online converter – Use the ZIP method; it handles any size because Excel processes the XML locally.

Comparing the Methods: Which Should You Choose?

Method Pros Cons
ZIP + Excel XML Import Free, offline, preserves all attributes, works with large files Requires cleaning data; can be tricky for beginners
Google Earth Pro CSV Simple, no XML knowledge needed, free Only first coordinate for lines/polygons; may lose some attributes
Online converters Fast, no software install Privacy risk, file size limits, often flatten data

For most users, the ZIP method is the most reliable and gives you full control. If you only need point coordinates (like a list of landmarks), Google Earth Pro’s CSV export is faster.

What About Converting Excel to KMZ?

Sometimes the need is the reverse: you have an Excel spreadsheet of coordinates and want to create a KMZ for Google Earth. That’s also possible using Google Earth Pro’s File > Import to bring in a CSV or XLSX, then saving as KMZ. Or you can use a tool like GPS Visualizer (free online) to upload CSV and download a KMZ. This is useful for mapping survey points, store locations, or GPS tracks.

Frequently Asked Questions

Can I open a KMZ directly in Excel?

No. Excel cannot read KMZ directly because it’s a compressed archive. You must first unzip it to get the KML file, then import that KML as XML. Alternatively, use Google Earth Pro to export as CSV.

Why do my coordinates look like “-122.084,37.422,0”?

That’s the standard KML coordinate format: longitude, latitude, and altitude (in that order). After importing, you can split them into separate columns using Text to Columns with a comma delimiter. Remember that longitude comes first, which is opposite of the common “lat, lon” order.

Will an online converter steal my data?

Most reputable converters have privacy policies, but there’s always a risk when uploading files to a third-party server. If your KMZ contains sensitive locations (e.g., home addresses, archaeological sites), use the offline ZIP method instead.

How do I keep the formatting of my Excel file after conversion?

When importing KML as XML, Excel will not preserve any styling from Google Earth (like icon colors or line widths). The XML import only brings the data fields. If you need styling, you’ll have to recreate it in Excel manually.

Can I convert a KMZ with multiple layers or folders?

Yes. The XML import in Excel will show each folder as a separate table in the Navigator pane. You can load multiple tables and then combine them with Power Query (Data > Get Data > Combine Queries) or by copying and pasting.

Is there a way to automate this conversion for many files?

You can use a VBA macro in Excel to loop through multiple KMZ files, unzip them, and import the KML. However, macros cannot be undone with Ctrl+Z, so always save a copy of your workbook before running one. A simpler approach is to use a batch unzip tool and then import each KML manually.

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.