
Open the fusion table and check that it has shapes by looking for a ‘map’ view (normally this has its own tab).

Type what you are searching for and add the word geometry or KML. You can find KML files using Google Tables search (make sure you have ‘Fusion Tables’ secleted on the left). Image of a KML map in Google Fusion Tables Convert a KML file to XML The big advantage of KML files is the users can customize the maps according to their data and without knowing how to code. KML files contain the parameters to add shapes to maps or three-dimensional Earth browsers like Google Earth. KML – Keyhole Markup Language – documents are XML files specific for geographical annotations. XML defines the structure of the information, whereas HTML focuses on other elements too, including their meaning and arrangement (even when it is not supposed to focus on appearance), and the importing of other code and media. XML uses tags like HTML, but there is a big difference between both languages. XML – Extensible Markup Language – is a language designed to describe data and it is used in RSS systems. In this post, you will learn how to convert a KML file into XML and download it as a CSV file. What is the difference between XML and KML? The open source data cleaning tool Open Refine can help you to open, process and convert KML files into other formats in order to, for example, match two datasets ( VLOOKUP) or create a new map with the information of the KML file.

KML (Keyhole Markup Language) is the default format used by Google’s mapping tool Fusion Tables (Google bought the company which created it in 2004), but it is also used by other mapping tools like CartoDB.

In this guest post ( first published on her blog) Carla Pedret explains how you can use the data cleaning tool Open Refine to ‘read’ KML files in order to convert them into other formats (for example to grab the names of places contained in the file). If you are working with map data that uses the shapes of regions or countries, chances are you’ll need to work with KML.
