Exporting points from Excel to AutoCAD with point labels.

[Anonymous]

I have an excel file with x y z coordinates. I want to import those points to AutoCAD as x and y coordinates and the 'z' value as a label. How do I do this? Any help greatly appreciated.

[pendean]

Z-point as a label? Is that a text or block or...? With or without a leader?
Can you show an example and explain?
Are you using plain AutoCAD or a variant like MAP or Civil?

[tboehler]

This is very simple with the right lisp file.   We had a block with a donut or point symbol and an attribute for the elevation label.  The lisp file would do all the work with a csv file from excel.  I'm sorry - I can not find those lsp files we used to use.  I have used Civil 3D as of late and it has built in commands to do this.

You may want to try the custom forum for help with the lisp file. 

I have attached a simple block with an attribute as an example.  (FYI - it's an older file and not annotative but it works).

[ChicagoLooper]

How many points? Over 25? 50? 100? If you are planning on using plain vanilla AutoCad, you can insert the points without labels. 

If you want points and corresponding labels then you can’t do it with vanilla AutoCad. You can, however, do it with Civil 3D or Map 3D.

Either way, the ribbon and command line is all you need. No lisp required. 

[leeminardi]

See this post and replace the label D2 with the z coordinate in C2 then fill down.

[Anonymous]

Hi, thanks for responding, i want it to look something like the picture attached

[ChicagoLooper]

You want ‘z’ to be used as a label? Looks like column A would be a better choice. Why would you want to use column D?

Hypothetically speaking, a small area could have a bunch of points with the same label indicating a ‘flat’ area. 

What you have isn’t  an xyz file,  it’s PNEZ or PENZ. 

P=point number

N=northing

E=easting

Z=elevation

[leeminardi]

Assuming that the x,y,z values are in columns B,C,D and that the data starts at line 2, and that you would like 

the text label to be the z coordinate rounded to 2 decimal places with a text height of 0.4

  you could put the following statement in cell E2 and fill down.  You can then copy and paste column E2 down to AutoCAD.

=CONCATENATE("point ",B2,",",C2,",",D2," ","text ",B2,",",C2,",",D2," ",0.4," ",0," ",round(D2,2)," ")