How to import a KML into QLIK Sense?

How to import a KML into QLIK Sense?


Did you just download a KML file? Or did you just order a KML file from the Spotzi DataShop and do you want to import this KML into QLIK Sense Desktop? Read the following instructions:

  1. After you bought your data set, you can export your data to a KML file. Please make sure that the column that contains the ZIP code has the title “name”.
  2. Create a new app.
  3. Name your app and click CREATE.
  4. Click OPEN APP.
  5. Drag you KML file into your app or go to data manager in the upper left corner and select the KML from your computer.
  6. Now you will see the columns from your KML file. Select the name and area column and click ADD DATA.
  7. After your import is done, click the particular data set and click LOAD DATA in the upper right corner.
  8. After your data was loaded successfully, click on EDIT THE SHEET to open your visualization where you can add your map.
  9. Drag a map chart to your sheet.
  10. Now drag the field item with the geometry to your map. This is in most cases the field that ends with “.Area”.
  11. Click ADD A NEW LAYER > ADD AS AREA LAYER.
  12. Remember that QLIK Sense will limit the number of areas. If you want to change this, go to the particular area layer and click OPTIONS > GENERAL and set the number of max. visible objects to a number more than 1000.
  13. Show labels by clicking the switch. Select the field that ends with “.Name” to visualize the postal codes.
  14. You have successfully created a QLIK Sense visualization with Spotzi data.
QLIK Sense Boundary Map
Spotzi 4-digit Boundaries of the Netherlands in QLIK Sense
QLIK Sense Boundary Map
Real estate data in QLIK Sense

Database with 100+ KML Files

Spotzi has a large Datashop with a lot of KML (.kml) datasets with demographics, consumer spending, ZIP code boundaries, real estate data, addresses, business listings and many more. Our Datashop offers a one-stop-shop solution where you can browse through all our datasets and order them directly from our shop.