Geofumed – GIS – CAD – BIM resources

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 number of the point, coordinate x, y, z; I have placed using UTM coordinates, but it can still be local coordinates (not geographic).

Then you can add a code that could be a detail used in the total station and that will be reflected as a label. And finally you can add the name of the layer 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, prev. 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 created codes, dimensions, points, and text separately. The 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 fixed in File / options / advanced. There you can define “use system separators” or change them at your own discretion.

From here you can download the file in version v17.1. 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 comments

  • Carlos Antonio da Silva

    How faço to buy this planilha?

  • Hello Benjamin, I have sent you the email with the download link.

    regards

  • Check your email, there is the link.

  • benjamin fernandez

    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

  • Benjamin Fernandez

    Hi!

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

    Thank you

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

  • CRISTOBAL

    Thank you I was very helpful (Y)

  • Tomas Garcia

    An excellent tool. Thank you!

  • Artur Castillo

    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

  • Artur Castillo

    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

  • Anonymous

    Thanks, my friend, I'll prove it.

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

  • 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.

  • Roberto posas

    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 a comment