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.

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.

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.