DISCOVER
×

How to Convert XML to KML

Updated April 17, 2017

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.

Cite this Article A tool to create a citation to reference this article Cite this Article

About the Author

Katrina Matterhorn is experienced in technology consulting for two of the largest technology companies in the world. Since 2009 she has specialized in technology, business and home and garden articles. She has a double major in English and political science from Austin College in addition to Microsoft and IBM certifications.