Bookmark and Share

Wednesday, June 22, 2011

How to generate KML file from excel data (or csv!)

The marketing department gives you an excel file and says : “it would be nice to have this data available on gGogle Earth (and also on Google Maps! ”…. can you do this today?

Instead of running out of the room with your hands in your hair simply download the excel file located at 

Follow the instructions and in 10 minutes you will have the data geolocated and a beautiful kml file.

This is the excel file:


The generated KML file:


And the kml file in viewed in Google Earth:


Many thanks to and to simon_a !