topic Re: Exporting points from Excel to AutoCAD with point labels. in AutoCAD Forum

Exporting points from Excel to AutoCAD with point labels.

Anonymous — Wed, 20 May 2020 16:46:16 GMT

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.

Re: Exporting points from Excel to AutoCAD with point labels.

pendean — Wed, 20 May 2020 18:23:45 GMT

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?

Re: Exporting points from Excel to AutoCAD with point labels.

tboehler — Wed, 20 May 2020 20:15:43 GMT

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

Re: Exporting points from Excel to AutoCAD with point labels.

ChicagoLooper — Thu, 21 May 2020 02:57:46 GMT

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.

Re: Exporting points from Excel to AutoCAD with point labels.

leeminardi — Thu, 21 May 2020 12:36:41 GMT

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

Re: Exporting points from Excel to AutoCAD with point labels.

Anonymous — Fri, 22 May 2020 11:11:38 GMT

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

Re: Exporting points from Excel to AutoCAD with point labels.

ChicagoLooper — Fri, 22 May 2020 12:08:23 GMT

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

Re: Exporting points from Excel to AutoCAD with point labels.

leeminardi — Fri, 22 May 2020 13:13:23 GMT

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)," ")