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
Load Microsoft Excel. Click "File," then "Open" and navigate to your XLS file. Click on the file to open it.
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.
Navigate to the "GPS Visualizer" website (see Resources).
Click "Choose File." Navigate to your XLS file, then select the file to upload it.
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.
Change the "Output file type" drop down menu to ".kmz (zipped)." This will create a zipped KMZ file rather than an uncompressed KML file.
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.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for