Export list of geographic coordinates to Google Earth, from Excel, with image and rich text

This is an example as with Excel you can send content to Google Earth. The case is this:

We have a list of coordinates in decimal geographic format (lat / lon). We want to send to Google Earth, and we want it to show the code of the point of interest, a text in bold, a descriptive text, a photograph of the point and a hyperlink to open a page on the Internet.

Here's the example of what we hope to show by clicking on the dot:

The code is: XL-3458

The length:

-103.377499

Latitude:

20.654443

And this is what we hope to see:


XL-3458

Central plaza

Mr. Joaquín Gómez Father's house, where the National University initially existed and is now restored as a museum protected by the National Institute of Anthropology

View website


Although the template will be uploaded, the spirit of the article is to explain how to do it on your own.

What we do is create the html tags in separate columns to be able to concatenate: The code of this would be:

<p><Strong>Central plaza</ Strong></ P>
<p>Mr. Joaquín Gómez Father's house, where the National University initially existed and is now restored as a museum protected by the National Institute of Anthropology</ P>
<p>

<p><img src = »http://upload.wikimedia.org/wikipedia/commons/thumb/3/3c/Casas_actiopan.jpg/800px-Casas_actiopan.jpg»Width =»144»Height =»168«></ P>

<p>

<p><a href = »http://commons.wikimedia.org/wiki/File:Casas_actiopan.jpg«>View website</a></ P>

All <p> tags are to indicate that it is a separate line, closing with a </ p> that is equivalent to an Enter.

Then the <strong> is a label to indicate that that text is bold, of course closing it with a </ strong>

Im is a tag for the image, which carries properties such as the width (width), height (height) and the address where the image is (src)

Finally there is the label for the hyperlink, which opens with <a href,,Äôs next is the address and text that links the hyperlink, and close with </a>

The marked in purple is content that would change with each image, so we will be interested then to leave it in cells.

Without much turn, you can see then that the concatenate function would be summed up to something like this:

= CONCATENATE(<p><Strong>,CELL,</ Strong></ P>,CELL,<p>,CELL,</ P> <p> <p><img src = »,CELL,»Width =»,CELL,»Height =»,CELL,«></ P><p><p><a href = »,CELL,«>,CELL,</a></ P>)

Which implies, that we will occupy 8 columns to store all the data that we want to show. Although in the case of those with labels that use the symbol = and double quotes, it is difficult for us in Excel, the first one indicates a function and the second one is used to separate a textual content. This is resolved by placing these contents in separate cells as if they were text.

Finally we have this:

Lat lon google earth

And to send to Google Earth I have placed a button that generates the file. Lat lon google earthThere you specify the path where the file is and the name we expect to have the description of the kml when it is displayed in the left panel.

The template has some indications when moving the mouse over the cells to suggest how the data should be entered. In general it usually has problem when the macros are not enabled and when the path where the file is being created is not entitled to write.

There we have it, you can do search by code in the sidebar of Google Earth, and clicking on the point is shown as we expected.

Lat lon google earth

Latlon to google earht DownloadsDownload example kml

It requires a symbolic contribution for the download, which you can do with Paypal or credit card.

It is symbolic if one considers the utility it provides and the ease with which it can be acquired.


Common problems

It may happen that, when using the application, one of the following incidents may appear:


Error 75 - File path.

This happens because the path that has been defined where the kml file is to be saved is not accessible or there are no permissions for this action.

Ideally, it is to place a route on disk D, which has fewer restrictions than what disk C. usually has. Example:

D: \

The points are coming out at the North Pole.

This usually happens, because in our windows, as indicated in the instruction for the template to work, the regional configuration must be established in the regional panel:

  • -Point, for decimals separator
  • -Coma, for thousands separator
  • -Coma, for listings separator

So, a data such as: One thousand seven hundred and eighty meters with twelve centimeters should be seen as 1,780.12

The image shows how this configuration is done.

This is another image that shows the configuration in the control panel.

Once the change is made, the file is generated again and then, the points will appear where it corresponds in Google Earth.

If you have a question, write to the support email editor@geofumadas.com. Always indicate the version of windows you are using.

22 Replies to "Export list of geographic coordinates to Google Earth, from Excel, with image and rich text"

  1. I have already done the download of the template I will study it and any doubt or modification I will write to you Thanks g '

  2. No link appears for payment via bank transfer. I am from El Salvador. Thank you.

  3. I would like to buy a template but I do not have a card like I do

  4. Check, how safe are you placing the plea upside down. This is an example:
    D: obrasalc

  5. Download the Excel file, and I have difficulties uploading photos from my disk D: /works / alc, please can you send me an explanation how I can upload the photos from that address.
    Do the photos have a specific size? Or you can work with photos of 4 mb

  6. It is possible to read images stored locally on PC or using network drives. Thank you

  7. Can this application read images stored locally without using a URL?

  8. Hello, I am interested in buying your templates. I am from Peru, but when I click on the bank account transfer link, I don't get anything like Aug to deposit your money

  9. We regret the incident, but we have already resolved and the payment system is already enabled.

    Greetings.

  10. I would like to pay for many of the plans that are here and I can not

  11. The download includes the power to modify the source file or the main macro of the program in excel.

  12. It is not datum failure, it is that the Google image is displaced

  13. Indeed, the datum I have in Google Earth is the WGS84.
    Have you found the reason for the failure with my data?

  14. Send them to the mail to see them. Send me the table in Excel and the kml file that it generates. Editor@geofumadas.com

    Check if you are using the respective Datum, Google Earth uses UTM WGS84.

  15. Thank you for the speed in the solution that worked. However, when I run the «kml» file with Google Earth, almost none of the coordinate points appear and only a few are seen, almost always the 1º and last of the series, but quite far from what corresponds (100 Kms. Pe ). I got bored of doing tests and nothing. Can I send you the file with the data uploaded to some e-mail? So you would see what happens. Thank you,

  16. That is a known problem, as it is written above.
    Change the path, you are putting the file to be created directly in C: and that is often not allowed by the Windows settings. Use another route and make sure it exists.

  17. The program seems great and I had a hard time finding it.
    I have achieved against payment of 2 $ but it turns out that when I run it does not work and a notice says:
    "The '75' error occurred at runtime.
    Error accessing the route or file »
    I appreciate if you can tell me how to solve it or if you send me another Excel file, as soon as possible, because I have to prepare a work of representation of geographical points and I am quite late.
    Regards,

  18. It depends on the displacement.

    If they are displaced a few meters (10 to 15 meters) it is because the google image is displaced, you can see it changing the image to previous years and you will see that the georeference is quite bad. Although the coordinate is correct.

    If the displacement is greater, it could be that they are coordinates of another Datum. Google uses WGS84.

    If the coordinates fall in another area of ​​the planet, it could be that you are entering latitude and longitude backwards. Or you are not using the sign: In the western hemisphere the longitude is negative, in the southern hemisphere the latitude is negative.

  19. Very good contribution only to note that when I put my coordinates does not show me exactly where it is ... .because you think it will be ??

Leave a comment

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.