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
And this is what we hope to see:
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
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><img src = »http://upload.wikimedia.org/wikipedia/commons/thumb/3/3c/Casas_actiopan.jpg/800px-Casas_actiopan.jpg»Width =»144»Height =»168«></ 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:
And to send to Google Earth I have placed a button that generates the file. There 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.
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.
Learn how to make this and other templates in the Excel-CAD-GIS cheat course.
It may happen that, when using the application, one of the following incidents may appear:
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:
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 email@example.com. Always indicate the version of windows you are using.