blankblank blank




Another Excel To KML Converter



Just stumbled across another Excel .XLS file with macros that will convert a list of coordinates and descriptions into a Google Earth KML file. Not particularly fancy, but easy to use and works well.

excel2kml uses VBA, so you’ll have to have Excel (i.e. it won’t work with OpenOffice). Open the file in Excel, and enable macros if they’re disabled for security purposes. First page is the data sheet, with a set of sample data already in place: Name, Latitude, Longitude, and Description are the only data fields available. Paste your data into the data sheet (up to 50,000 lines), enter Alt-F8, and run the “Generate KML” macro. A file called “myfile.kml” will be created in the root directory of the C-drive; you can modify the file name and destination in the “File Details” tab. That’s it – tested it with the sample data and a file of my own, and works perfectly. You could probably modify it quite easily to meet any additional requirements you might have.


Looking for something else? Enter some keywords below, then click "Search".    




5 Responses to “Another Excel To KML Converter”


  1. 1 Anonymous

    If you have OpenOffice, you could consider upgrading to Novell OpenOffice 2.0.2 rc1 to get VBA compatibility.
    It is about a 400MB download.
    I have not tested this myself.

  2. 2 Anonymous

    I couldn’t open the file for some reason…it said there was a Run-time error ’75′: Path/File access error.

    Do you know what that means?

    let me know;
    jeffrey.m.hamilton@gmail.com

  3. 3 Leszek Pawlowicz

    The problem is that a “Run-time error ’75′: Path/File access error” message could be caused by any number of things:

    - A virus
    http://www.wilderssecurity.com/showthread.php?t=58589
    - Files set to read-only mode
    http://www-1.ibm.com/support/docview.wss?uid=swg21136108
    - File access issues due to system or network restrictions
    http://www.iteris.com/itsarch/html/turbo/faq30details.htm

    And so on. Do a Google search for the error message, and a lot of hits will come up.

    It’s impossible for me to say what it could be on your system – I’m afraid that you’ll have to figure it out on your own. Sorry.

  4. 4 Alex

    For this concern i usually use this tool-Excel impossible read file,it advised me friends some times ago,it is free as is known,program save important information,such as graphics,statistic and mathematics,program will help you to recover valuable information and avoid its losses,tool scans your broken worksheet,then gets the data from this document,will help you to repair damaged files in Microsoft Excel sheet recognizable format,repair file Excel this file is not in a recognizable format, Excel showing this file does not in a recognizable format, or Microsoft Excel worksheet this file is not in a recognizeable format, it is an Excel file error: data may have been lost: Microsoft Excel impossible read file,tool performs a scan of your corrupt excel files not recognizable format and attempts to recover all available data.

  5. 5 access repair

    you can try Stellar Phoenix Excel Recovery Software from here: http://www.repair-excel-file.com/

    I have used this software to repair my excel database when I faced same situation. you can try demo version first of this excel repair software, to check whether your database is recoverable or not. If you are able to view your database then go for full version and save your data.

Comments are currently closed; feel free to contact me with questions/issues.