Let's see the case:
I have gone to the field to build a property, as shown in the following table and I want to visualize it in Google Earth, including a couple of photos that I have taken
The genius of the template is that of only one:
- Converts the UTM coordinatesTo Geographic in decimal format, as it is what Google requires
- Allows you to set the name of the destination file
- Lets name the layer of kml
- Rewrite existing file, even if it is already generated
- It allows to use html tags in the description, such as images, hyperlinks, etc.
The template is ready for the spheroid to be selected, we know that for Google Earth we must choose WGS84.
- In the first column we enter the data that Google will show as Label.
- In the next two the UTM coordinates, taking care that our system is configured to use the comma and the point as the decimal separator as a thousands separator. So a coordinate like 599.157,90 is not allowed it should be written as 599157.90
- In the next column we enter the zone. Just by placing it on the first line, the others will be changed. Although they can be changed manually in case the data were in the limit of two zones. Likewise the hemisphere; in this case I am using data from Bogotá, so I use Zone 18 and the Northern Hemisphere.
- And finally the description, which is what we would see when we click on the point in Google Earth.
Convert coordinates to kml file using an Excel macro
Once the tabular data has been filled in, the name of the kml file and the address where it will be stored appear on the right. in this case it appears as C: \ Race 25 X.kml
- In the lower row we write the name that the layer will have in the kml file, in this case: 25 X Race Survey
- The result is this: by touching a point you can display the description of the last Excel column.
- Finally, once we are ready we press the green button, and the file should have been generated.
The result, when opening it in Google Earth is the following. Look at the name of the layer, as we call it, and then there are the points with its description; touching them raises a display of detail. If the objects or labels They are very large, they can be customized in Google Earth by right clicking on the layer and choosing properties.
How to add the photo to kml
This is simple, suppose that in the detail of the level bank I want to put the image of the cadastre plate, then in the cell corresponding to the description I write:
Property limit, Cadastre level Bank
Similarly, if at the point I have called Photo, I want to place a photo of the facade of the house, the procedure is similar.
- If you need to insert more rows, make copies of the existing ones so that they go with formula.
- You do not have to add columns, if you do it can stop working.
- Requires that you accept the execution of macros when opening the Excel file
- If it sends you an error message, it could be that the C: directory does not have write permission, you can try another folder like C: \ users \ downloads \ as long as the folder exists.
From here they can download The kml file As it should be.
Downloading the template in Excel requires a symbolic contribution, which you can do with Paypal or credit card.
In case what you have is Geographic coordinates of type Latitude, Longitude, and you want to send to Google Earth, the template is this.
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, you should put a path on disk D, which has fewer restrictions than 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. It always indicates the version of windows you are using.