Excel KML creator

So. I created an Excel KML creator. For those not in the know, KML files are used by Google Maps as the basis for automatically uploading icons.

The KML creator allows you to create your data in a familiar setting, the associated KML generating itself in the background. This version allows for up to 1,000 points to be created.

Here’s what you do to create the KML:

To create the associated map:
  • Go to Google Maps,  logged in with a Google account
  • Hit My places
  • Hit Create map
  • Give it a name and description and hit Import
  • Choose the txt file you just created.
If you need help creating latitude and longitude coordinates from postcodes or zip codes, read this post. It describes how this can be done in Google Docs, albeit 50 locations at a time.

By Dan on 3 September, 2011 · Posted in Spreadsheets

2 Comments | Post Comment

Nick Robinson says:

Excellent! I’ve an idea for doing something fun with google map locations that this might be very helpful with.

And a useful resource for finding lat & longitude and postcode references in one go is the UK Grid Reference Finder here: http://gridreferencefinder.com/

Posted on September 5th, 2011

Brad Weil says:

Your formulas in the spreadsheet are incorrect. The KML generated does not work past the first two lines

Posted on January 11th, 2013