How to Convert Xls to Kmz

Written by emma woodhouse
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Convert Xls to Kmz
XLS files are spreadsheets containing rows and columns of data. (number background image by kuhar from

XLS files are spreadsheet files containing rows and columns, and are made using Microsoft Excel. KMZ files are zipped KML files, where KML stands for Keyhole Markup Language. KML files store information that is displayed by Google Earth. KMZ files are useful as they are smaller than KML files and easier to distribute.

You can store longitude and latitude data in an XLS spreadsheet then convert the file to KMZ to view the data in Google Earth.

Skill level:

Things you need

  • Microsoft Excel
  • Google Earth

Show MoreHide


  1. 1

    Load Microsoft Excel. Click "File," then "Open" and navigate to your XLS file. Click on the file to open it.

  2. 2

    Add a header row to the spreadsheet and the word "longitude" above the column containing the longitude data and the word "latitude" above the column containing the latitude data. Also label any optional information, such as elevation.

  3. 3

    Navigate to the "GPS Visualizer" website (see Resources).

  4. 4

    Click "Choose File." Navigate to your XLS file, then select the file to upload it.

  5. 5

    Set any preferences you wish using the drop-down menus. For example, to change the units from meters and kilometres to feet and miles select U.S. from the "Units" drop-down menu.

  6. 6

    Change the "Output file type" drop down menu to ".kmz (zipped)." This will create a zipped KMZ file rather than an uncompressed KML file.

  7. 7

    Click "Create KML file." A link to the KMZ file will appear on the next page. Click the link to open the KMZ file in Google Earth.

Tips and warnings

  • Latitude and longitude values must be in decimal format.
  • You can upload up to eight XLS files to convert into one KMZ file.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.