Keyhole Markup Language is similar to the XML format and is used by Google to provide longitude and latitude data for location points consolidated on Google Earth. You can convert your XML file to KML with a map conversion application that is free to download. With this program, you can save your location data as a KML file and submit it to Google or other geography applications.
Step
Launch your Web browser and navigate to http://processtrends.com/Files/MapExcelData.zip. Download the file to your desktop. This file is a VBA macro that imports your Excel data and converts it to a KML file.
Step
Double-click the file to open it. Click "Yes" when the Excel security alert appears to enable the macro.
Step
Click on the "Data" tab.
Video of the Day
Step
Type the latitude and longitude within the latitude and longitude columns. Type in any other data you feel is necessary.
Step
Click "Generate KML File." Enter a name for your file and click "Save." Your XML file will be saved as a KML file.
