Build Polygon based on directions and distances in an Excel table

Let's see what the point is:

I have the data of a polygonal with directions and distances, and I want to build it in AutoCAD or Microstation. Previously we saw that AutoCAD Has its shape to feed this type of data under the format @dist <while in Microstation is made Through AccuDraw.

Well, in response to our friend James, here is the table:

Autocad excel microstation

1. The input data

These are entered under the yellow zone, here enter the stations, distances and heading as the example.

2. The initial coordinate

This is in the header of the green zone, presuming that we know the coordinate of the first point. In case of not having it, place any value, preferably high so that negative coordinates do not appear, such as 5,000 (five thousand)

3. The output data

This is the area marked in orange, where what you have is the xy coordinates concatenated with a separating comma.

4 How to send it to AutoCAD.

Simple, "copy" is done in the orange area of ​​the excel file, then in AutoCAD the polyline command is activated (pline) and it is "paste" in the command bar. The result is the polygonal drawn only to give the closing point

Autocad excel microstation

Here you can download the template to build polygons based on directions and distances in an Excel table.

Directions to autocad Downloads

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

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

5 How to send it to Microstation

To do it in Microstation I have created a template that does almost the same thing, but in the logic of the Microstation Key-in command.

View template for Microstation.

56 Replies to "Build Polygon based on bearings and distances in an Excel table"

  1. Already make the contribution, How do I download the file?

  2. hello good afternoon I could not make the transfer due to lack of address of the company where to place greetings

  3. hello good night as payment by transfer if I do it directly in bank to which account number I deposit thanks I am interested greetings

  4. Check your mail, sometimes it goes to spam.
    You should get a message with a download url, which expires in 4 days.
    If you have problems please contact us editor (at) geofumadas.com

  5. I made payment by paypal. Where can I download the template?

  6. I would like to warn you to send money by Pay Pal to your name by the templateExcel

  7. Good morning to all and congratulations for this good work.
    I have a question.

    How do I do in MICROSTATION so that I do not just leave the point cloud but also the lines that would make up the polygonal?
    Thank you.

  8. Anyone know how to enter all the data in one go ??
    AYUDAAAAAAAA

  9. True, it could work for any program that accepts coordinates in that format.

    Possibly there are extensions for ArcGIS, but I have never talked about that topic here.

  10. Hello, you just saved my life with this post, I needed to do a traverse in ArcGIS so I used this method and only suited it for ArcMap, I do not know if there was an easier way to do it for this program or if you had already published some Post on this, but good served me a lot, it would be good that they also put the post to pass it to ArcGIS. Thank you very much !!!!!! Congratulations on this page, saludooooos.

  11. Thank you…!!
    For help, now if there is already the polygon ... ^ _ ^

  12. That changes it in Windows

    Start, Control Panel, Regional Settings

    Then there, you choose the country where you are and with this you should have the correct points and commas in the gray area, below where the examples are. First there are the numbers.

    If they appear incorrect there, still choosing your country, then press the "customize" button and there change the format of decimal symbol and thousands separation symbol.

  13. I have a problem to get the drawing in autocad, the problem radiates in the following.
    The problem is in the table of exel of my office I need to know how to change the comma (,) by the Point (.) I have office 2007.
    To me it appears as follows:

    418034 (,) 128,1590646 (,) 877
    418028 (,) 562,1590680 (,) 724
    418034 (,) 064,1590699 (,) 614

    Where there has to be a dot (.) There is a comma (,) help my please. !!

  14. Hello everyone, I have several years of using MicroStation for cadastre and just wanted to add to the excellent contributions of colleagues that if they want to add a polygon in addition to the points, the procedure is very simple. In the header txt sheet we write "place smartline", to each coordinate we add xy = x coordinate, y coordinate. so on to all. In the Key-in entry we write @C: \ name and location of the file.txt That is the theory of the procedure if someone knows another procedure would appreciate the input.

  15. I need to make a plan in autocad .. because I enter coordinates and x and I get the plane shot

  16. Thanks brother for the help, I really saved a lot of work with this table, congratulations on the development of the formulas, very good work ..

  17. How about, I already have the microstation site, I do not know if you can help me with the procedure and try a little but it has several tools.
    It's okay with you.

  18. Good Thanks boy look for the microstation site and boy approve

  19. To make a table of distances and distances occupy Microstation Site, just like you can not do it only with AutoCAD but Civil employees.

    But you can do the reverse process of this post With this excel table

  20. Well I think it's interesting, how do you solve, I have a problem I can not get a construction box (directions and distances) of a polygonal already made in microstation v8 xm or v8i, as it is done in civilcad that you only the polygonal tool and you give it generate construction chart and spades within the drawing or pligonal, they will attack them will help me

  21. I have not seen a lisp that does that, which could help you is this . The code does not have a password, so you modify it so that it gives you the other information, or you leave it in the observations column with the concatenated function.

  22. g

    Thanks, but I think I need to clarify something, I want to avoid doing it manually, to be automated using a lips, to gratify the data by importing the excel file.

  23. Well I understand that if it is just that line, you only do:
    - Command line
    - enter
    - 227935.1665,9111959.809,2618.718896
    - enter
    - 227935.1665,9111959.809,2618.718896
    - enter
    And then you put the data on foot as text.

  24. g

    I CONGRATULATE YOU OR THE CONTRIBUTION Q DAS IN THIS PAGE SO INTERESTING. GOOD WANTED TO KNOW IF YOU CAN HELP ME TO GRAPH AUTOCAD THESE DATA OF EXCEL, THAT I DIVIDED A LINE WITH ALL THE INFORMATION ID, COORDINATES OF START OF THE LINE, LENGTH, AZIMUT AND INCLINATION (INCL) FROM THE XY PLANE.
    I WILL BE GRATEFUL HELP.

    ID EAST NORTH ELEVATION LONG. »« AZIMUT »« INCL. »
    01 227935.1665 9111959.809 2618.718896 150 84.295 -19.22
    02 227935.1665 9111959.809 2618.718896 130.25 84.295 -19.22

  25. I congratulate you, it is an excellent page and above all with much useful information for those who are dedicated to this of the topography and geodesy ...
    I have also been checking the information you have regarding the use of geograficas (or gedesicas) and UTM ... I am struggling a little with the transormation of Geographic to Topographic, that is, I want to convert from geodesics to a flat system, in such a way that The points or vertices that we placed and did a post-process, we can use them with total station or any conventional equipment and distances check or match ... would be of great help your comments ... thanks and greetings from tampico, tamaulipas, mexico ...

  26. good friends I wanted to know if you can help me as I can manually pass a coordinate from a gps to autocad

  27. If that were it, maybe it would check in the control panel, locale, and see if the commas are as thousands separators and the decimal point.

  28. Know I think the problem lies in the configuration of commas and points .... From excel

  29. ok grasias, everything turned out calmly ...
    You were right the fault is to collect the data incorrectly ... thousands of surplus ... ..

  30. Well check the order of what you're doing:

    Command point (or line)
    Select the area in excel
    Copy
    Click on the AutoCAD command line
    Catch

  31. I was not wrong hitting the correct data, something is happening, ah I have another format in excel that is very useful to make alignments in portfolios is very similar to this format but in both cases I get this message »2d point or option keyword requiered» when passing to autodesk land, I don't understand ?.
    If you want to pass the format in excel just write your mail ....
    It is very interesting
    AAA IF YOU FIND THE SOLUTION TO THIS PROBLEM PASS THE VOICE….

  32. I have another format similar to this one to make road alignments and move to autodesk land is very similar to this format, I have already used the format that I have and it turned out well and then I got that message «2d point or option keyword requiered» and My polygon does not appear, and I am not mistaken in copying the data. IF YOU WANT TO PASS THE FILE IN EXCEL WRITE YOUR MAIL …….

    AAA PLEASE IF YOU HAVE FOUND THE SOLUTION PASS THE VOICE, I DO NOT KNOW IF THE PROBLEM IS THE AUTO CAD CONFIGURATION OR SOMETHING FAILS IN THE EXCEL ....

  33. Joshua, I think you're copying the wrong area, you should copy the marked orange

  34. To me also appears 2d point or option keyword requiered and I do not find solution if they know porfa help me it is urgent please ....

  35. Excellent file will serve me a lot and I'm already doing what I asked about how to convert cross-sections of traffic and level to UTM .... I'll test it for an open traverse

    Jcpescotosb@hotmail.com

  36. It is possible that you have the comma and dot format wrong, this should be verified in the control panel, regional settings. It will work if you have the points as separation of decimals and commas as separation of thousands.

  37. I did the test in Autocad 2009 and it worked fine but microstation not
    It will be that I do not do the right thing in some of Microstation V8 xm.

  38. Let's see:
    1. Polyline command
    2. You write 0,0
    3. enter
    4. Copy in the orange area of ​​the excel sheet
    5. Click on the command line
    6. Get ctrl + v
    7. Enable full-view zoom

    If it's not working, something weird is around. Another option that may be affecting is your commas and periods are confused in the separation properties of thousands and decimals.

  39. Good afternoon

    WHAT HAPPENS IS I NEED TO ENTER TOPOGRAPHIC COORDINATES TO AUCTOCAD.

    WHEN I CLICK TO COPY THEN I GO AND SELECT POLILINE WRITE 0,0 AND APPEAR SPECIFY THE FOLLOWING POINT APPEARS THIS [Arc / Halfwidth / Length / Undo / Width
    AND I MAKE CASE OMISO TO THIS AND PEGO BUT IT APPEARS TO THIS (2D point or option keyword required) I DON'T KNOW HOW TO MAKE THE POLYGON STOP I WOULD LIKE TO KNOW IF YOU CAN HELP ME.

  40. René, the coordinates come out because we have assumed an initial coordinate.

  41. I think that from these directions we can not get the utm coordinates because those directions are not geographic coordinates. A great contribution to separate coordinates with a comma

  42. Very good spreadsheet, could it be done from a polygon to make a table with Rumbos, Azimuth, Distance, Azimuths with a known base?

Leave a comment

Your email address will not be published.

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