Display full version of the post: Copy multiple coordinates from Excell into CAD

Peadaregan
23.10.2009, 13:11
Hello,
 
I would like to copy approx. 200 Easting and Northing Coordinates that are in Excell (in two columns) into CAD.
 
I was hoping these Coordinates would appear as points.
 
Don't fancy copy and pasting individually!
 
Any ideas?

miki1
23.10.2009, 17:20
find IMPORTXYZ.lsp on web.after, tools>load application>find lsp>browse for excel file, choose type of inserted points (node, block, circle) and THIS IT!

CarlB
23.10.2009, 19:40
A quick way to do it, to just create unlabeled points, is to use the AutoCAD "point" command, then paste in the coordinates.
 
Point coordinates should have x & y values in separate columns in Excel, adjacent rows.
Type MULTIPLE then POINT on the command line.
When prompted for point location, copy & paste range of values from Excel.
Voila!

miki1
24.10.2009, 12:33
Maybe, you think adjacent columns?I try your solution but don`t work on my AutoCAD 2010.For now, better solution is IMPORTXYZ lisp.

CarlB
24.10.2009, 21:13

For copying data, yes x & y data should be in columns, all adjacent,as in:x1  y1x2 y2x3 y3etc...this method comes in handy for drawing lines & polylines from Excel coordinatesAnd for someone using LT version, they wouldn't be able to use the lisp option.
CarlB2009-10-24 21:14:51

bmshutts
12.11.2009, 15:13
in the third collum of EXEL type this =CONCATENATE(A1,",",B1)    Then hit enter.  Copy down that collum.  In CAD hit the point command and copy the new list of points COMMA FORMAT to the command line in CAD.  Zoom to extents and you got em.

miki1
13.11.2009, 15:36
CONCATENATE command in Excel is a solution!Just that column from Excel taked with Ctrl+C and pasted in AutoCAD 2010 (MULTIPLE>POINT>Ctrl+V).Well done!!Question is, is that work with Z koordinate? 

bmshutts
13.11.2009, 16:38
for the z coordinate to be added   =CONCATENATE(A1,",",B1,",",C1)
drag down copy values to another collum.  copy these values into the COMMAND LINE after Point enter

miki1
14.11.2009, 10:53
Thanks a lot ! I`ll never use ImportXYZ.lsp anymore.Best regards!