Google Earth Community: Excel to KML converter

Google

Official Google Earth Download Site

Google Earth Community

System Reliability: Possible Very Short Interruptions Between 1100 and 1130 PST

You are not logged in. [Login]

Entrance · Main Index · Search · Active Topics
New user · Who's Online · FAQ · KML Reference · GE Guide · Help Group

Support and Answers >> KML Discussions (read only)

simon_a
Master Guide

Reged: 08/21/05
Posts: 1773
Loc: London, UK

Excel to KML converter

09/26/06 01:32 PM

View in Google Earth View in Google Maps (12894 downloads)

Hello,

Attached is a simple MS Excel spreadsheet and macro. This tool will turn a list of names, co-ordinates, and descriptions into a KML file.

This should overcome some of the limitations of the default spreadsheet import - no limitation on number of placemarks (within reason), for example - but is still a very basic tool (you will need to enhance the VBA code to create more complex KML files).

There is an 'Instructions' tab but, basically, you simply populate the 'Data' worksheet and then run the 'generateKML' macro (hit [ALT] + F8 then 'Run').

I've included a few lines of sample data to play with...

[Edit: updated to change the default maximum number of placemarks from 5000 to 50000 (editable)]

See also Open GE from MS Excel, which allows you to click on a link in a spreadsheet to open that row's co-ordinate directly in GE:
http://bbs.keyhole.com/ubb/showthreaded.php/Cat/0/Number/774351

Disclaimer: This is provided 'as is' with no support or guarantees etc. Care should be taken opening any file including a macro - I've no reason to suspect that it contains a virus (I should hope not - that means my PC is infected!) but I still suggest scanning with an anti-virus tool just in case.

Simon.

Edited by simon_a (01/28/07 02:52 PM)

Post Extras

Print Post

Remind Me!

Report this Post

Entire topic
Subject	Posted by	Posted on
Excel to KML converter	simon_a	09/26/06 01:32 PM
Re: Excel to KML converter	RemKou	10/25/06 02:59 AM
Re: Excel to KML converter	simon_a	10/25/06 03:32 AM
Re: Excel to KML converter	RemKou	10/25/06 04:25 AM
Re: Excel to KML converter	simon_a	10/25/06 04:41 AM
Re: Excel to KML converter - Addresses	simon_a	10/16/06 02:01 PM
Re: Excel to KML converter - Addresses	BusterDAN	01/09/07 02:07 AM
Re: Excel to KML converter	Valery35	09/28/06 11:12 AM
Re: Excel to KML converter	tekgergedan	09/27/06 09:08 AM
Re: Excel to KML converter	simon_a	09/27/06 11:26 AM

Extra information

0 registered and 9 anonymous users are browsing this forum.

Moderator: Hill, Jumble, jrohlf, Kempster, mcshea98, jeffryv, dulce, esterrett, regionator, NormB, Frank_McVey, geus, ZeroDeeFeX, LaBelleTerre, vagabondsailor, SupersonicBuddha, DWebb, BeadieJay, TheLedge, Cyclonic, no_stranger, LuciaM, tekgergedan, ManoM, cantarell, toponym2006, Noisette, danescombe, Michal_Drewniak, mutex, marinerfan, Delta102, bebop, MarkAubin

Forum Permissions
      You cannot start new topics
      You cannot reply to topics
      HTML is disabled
      UBBCode is enabled

Rating:

Thread views: 58060

Jump to

earth.google.com bbs.keyhole.com

UBB.threads™ 6.5.1.1