If you use the Google Earth mapping program, you will want to convert your Microsoft Excel files containing your map data into KML and KMZ files. KML files are the specific files that Google Earth uses to read map data. KMZ files are the zipped version of the KML files. You will need to download a file-zipping program in order to convert KML to KMZ files.
- Skill level:
Open a new Microsoft Excel spreadsheet. You cursor will appear in the first cell of column A, which is where you will input your first category name. Type "Name." Press "Tab." Type "Latitude" in B1. Press "Tab." Type "Longitude" in C1. Press "Tab." Type "Icon #" in D1.
Input the specific data in the cells under each category. For example, in the cells of column A, you might write the following:
In the cells of B and C, you will type the latitudinal and longitudinal coordinates of each city. In the cells of D, you will type the code number for a specific icon that will identify your city on the map.
Save your file and open Google Earth. Find "Places." Right-click the folder labelled "Earth Point Excel To KML." Save the file as a KML file.
Convert your KML file to a KMZ file by opening a file-zipping program that you have downloaded. Examples of file-zipping programs are WinRar and WinZip.
Open your file in the file-zipping program.
Save the file as a KMZ file. The program will automatically zip your file and convert it with a KMZ file extension.
- 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