• Around The HomeToggle Menu

    • Entertainment
    • Productivity
    • Smart Home
  • FamilyToggle Menu

    • Parenting
    • Toys
    • Pets
    • Travel
  • ReviewsToggle Menu

    • Phones
    • Tablets
    • Laptops
    • Desktops
    • Wearables
    • Audio
    • Cameras
    • Headphones
    • Printers
    • Smart Home
    • TVs
    • Gaming and Video
  • One Cool ThingToggle Menu

    • Frugal Tech
    • Kickstarters
    • Videos
  1. Home
  2. Around The Home
  3. Productivity
  4. How to Convert XML to KML

How to Convert XML to KML

By: Katrina Matterhorn
  • Share
  • Share on Facebook

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.

Show Comments

Related Articles

How to Clear Google Chrome Cache

How to Clear Google Chrome Cache

Around The Home
Productivity
By: Jackie Bailey
How to Convert Xls to Kmz

How to Convert Xls to Kmz

Around The Home
Productivity
By: Emma Woodhouse
How to Convert CSV to TSV

How to Convert CSV to TSV

Around The Home
Productivity
By: Tammy Clevenger
How to Graph a CSV File in Excel

How to Graph a CSV File in Excel

Around The Home
Productivity
By: Kiva Bottero
How to Convert a BAK File to Excel

How to Convert a BAK File to Excel

Around The Home
Productivity
By: Tammy Clevenger
How to Create a Vacation Leave Spreadsheet

How to Create a Vacation Leave Spreadsheet

Around The Home
Productivity
By: Kathryn Hatashita-Lee
  • HOW WE SCORE
  • ABOUT US
  • CONTACT US
  • TERMS
  • PRIVACY POLICY
  • COPYRIGHT POLICY
  • Advertise

An error occurred. Try again later.

Thanks for signing up!
© 2019 Leaf Group Ltd. Leaf Group Media

Get great tech advice delivered to your inbox.

Keep your family productive, connected, entertained, and safe.

Please enter a valid email.