Template to create dxf file from list of points in Excel

Recently Juan Manuel Anguita has passed the new version of this application that before Had promoted, But that time had left with some problems with the new version of Excel.

Its use is very simple, but highly functional. You have to enter a point number, coordinate x, y, z; I have placed using UTM coordinates, but it can still be local (non-geographic) coordinates.

Then you can add a code that could be detail used in the total station and that will be reflected as a label. And finally you can add the layer name where it will be stored.

Xyz2dxf

Among the improvements that come in this version is that the creation of the file dxf is accelerated, before you could stay hung the machine if they were many points.

Also, the number of coordinates can be up to 10,000 and it is possible to choose whether the file is created in 2D or 3D.

Xyz2dxf

And finally, the best: It is compatible with Windows 7 and Excel 2007.

You no longer have the preview, previous. And now when the dxf button is pressed it raises a message indicating where it is stored.

As a result, you can see that for the infrastructure layer (infra) you have separately created codes, dimensions, points and text. Same for the lifting layer (lev).

I have changed color to the layers to visibilizar, but by default they go in white color.

It is also possible that you do not see the points, but for that you have to change the format using the DDPTYPE command.

Another possible error is that the configuration of commas and points in decimals and separators of thousands is wrong.

That is arranged in File / options / advanced. There you can define "use system separators" or change them to particular criteria.

From here you can download the file in v17.1 version. It requires a symbolic value with Credit card or Paypal.

Since it is an Excel file with an embedded macro, it has an xlsm extension, but Excel does this normally.

15 Replies to "Template to create a dxf file from a list of points in Excel"

  1. Hello! I paid with paypal, but when I returned to the merchant I see the same web page ¿? How do I download the template?

    The transaction is:
    Transaction ID: xxxxxxxxxx800223W

    Thank you.
    Bf

  2. Hello!

    After paying I go back to the same page and again the offer to pay (?). How do I download?

    Thank you

  3. Hi friend, how do you change the path where the dxf file is saved? Thank you

  4. How about I apologize, my friend! Will it be that you can change the path where the file is saved since it saves it to me in a programmed route can you change the path where you want to save the file? .. thanks and pending your response

  5. How about excuse me friend g! Will it be that you can change the path where the file is saved since it saves it to me in a programmed route can you change the path where you want to save the file? .. thanks and pending your response

  6. Excellent contribution, many thanks and congratulations for all the achievements so far, success !!!

  7. Thank you my dear.
    You are always reminded, there are coordinate grid files in Geographics that you made that are still using over there.
    Greetings.

  8. Excellent friend G !, always leaving important contributions to those in need of space geo smoke, it is always a pleasure to greet him and realize that he continues in the activity, a strong hug.

Leave an answer

Your email address will not be published.

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