Archives for

# Coupons

## View Google Earth coordinates in Excel - and convert them to UTM

I have data in Google Earth, and I want to visualize the coordinates in Excel. As you can see, it is a land with 7 vertices and a house with four vertices. Save the Google Earth data. To download this data, right click on "My places", and select "Save place as ..." Because it is a file ...

## Draw a polygon in Microstation from Excel

Using this template, you can draw a polygonal in Microstation, from a list of bearings and distances in Excel, or a list of x, y, z coordinates. Case 1: List of Directions and Distances Suppose we have this table of data from the field: In the first columns we have the stations, ...

## Template to create dxf file from list of points in Excel

Juan Manuel Anguita recently handed me the new version of this application that we had previously promoted, but that time had left some problems with the new version of Excel. Its use is very simple, but highly functional. You have to enter a number of the point, coordinate x, y, z; I have placed ...

## Convert decimal geographic coordinates to degrees, to UTM and draw in AutoCAD

This Excel template is initially made to convert geographic coordinates into UTM, from decimal format to degrees, minutes and seconds. Just the opposite of the template that we had made before, as seen in the example: Additionally: It concatenates them in a string It converts them to UTM coordinates, with the option to choose a ...

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

This is an example of how Excel 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 the code of the point of interest to be displayed there, a text in bold, a descriptive text, a photograph of the ...

## Excel to Google Earth, from UTM coordinates

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 view it in Google Earth, including a couple of photos that I have taken The genius of the template is that it only takes one shot: It converts the Geographic UTMa coordinates in decimal format, as it is ...

## Draw a polygon with bearings and distances from Excel to Microstation

A few years ago I published an article in which I showed how to concatenate data in Excel to build a traverse with AutoCAD, without having to do all the protocol: @distancia

## Convert degrees / minutes / seconds to decimals

Some time ago I have been asked this, and since the friend seems a bit rushed and that today is a day to celebrate many things, here is a tool that allows you to convert geographic coordinates, degrees to decimals. Why the conversion table It is common, to find coordinates that are in the format degrees, minutes, seconds, ...

## Build Polygon based on directions and distances in an Excel table

Let's see what the point is: I have the data of a traverse with bearings and distances, and I want to build it in AutoCAD or Microstation. Previously we saw that AutoCAD has its way of feeding this type of data under the format @dist <while in Microstation it is done through AccuDraw. Well, in response to our ...

## Create a box of bearings and distances from UTM coordinates

This post is in response to Diego, from Paraguay, who asks us the following question: a pleasure to greet you ... a while ago for a search that I had accidentally arrived at your website and I found it very interesting, both for the content and for the fun way of communicating your science. I would like to ask you, if you know any ...

## Convert UTM to Geographic Coordinates with Excel

In the previous post we had shown an Excel sheet to convert Geographic coordinates to UTM from a sheet that Gabriel Ortiz had popularized. Let's now see this tool that does the same process in reverse, that is, having coordinates in UTM (Universal Traverso de Mercator) format and knowing the area, transforming them to latitudes ...

## Excel template to convert from Geographic Coordinates to UTM

This template makes it easy to convert geographic coordinates in degrees, minutes, and seconds to UTM coordinates. 1. How to enter the data The data must be processed in an excel sheet, in such a way that they come in the required format. Of course, the normal restrictions regarding the ranges of accepted values ​​must be respected ...