How to Convert XML to KML
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.
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.
Double-click the file to open it. Click "Yes" when the Excel security alert appears to enable the macro.
Click on the "Data" tab.
Type the latitude and longitude within the latitude and longitude columns. Type in any other data you feel is necessary.
Click "Generate KML File." Enter a name for your file and click "Save." Your XML file will be saved as a KML file.