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

  • Geophysical March, 2019 at

    The link is at the finish of post

  • Carlos Antonio da Silva March, 2019 at

    How faço to buy this planilha?

  • Geophysical September, 2018 at

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

    regards

  • Geophysical September, 2018 at

    Check your email, there is the link.

  • benjamin fernandez September, 2018 at

    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 September, 2018 at

    Hola!

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

    Thank you

  • ALEXIS May, 2017 at

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

  • CRISTOBAL May, 2017 at

    Thank you I was very helpful (Y)

  • Tomas Garcia November, 2013 at

    An excellent tool. Thank you!

  • Artur Castillo July, 2013 at

    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 July, 2013 at

    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 July, 2013 at

    Thanks, my friend, I'll prove it.

  • Pedro June, 2013 at

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

  • g! June, 2013 at

    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 June, 2013 at

    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