Print Page | Close Window

Copy multiple coordinates from Excell into CAD

Printed From: CAD Forum
Category: EN
Forum Name: AutoCAD
Forum Description: Discussion about AutoCAD and AutoCAD LT, viewers, DWG and DWF formats, Design Review, AutoCAD 360, add-ons
URL: https://www.cadforum.cz/forum_en/forum_posts.asp?TID=2593
Printed Date: 24.May.2026 at 08:28


Topic: Copy multiple coordinates from Excell into CAD
Posted By: Peadaregan
Subject: Copy multiple coordinates from Excell into CAD
Date Posted: 23.Oct.2009 at 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?


Replies:
Posted By: miki1
Date Posted: 23.Oct.2009 at 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!


-------------
Milan Tesanovic

Posted By: CarlB
Date Posted: 23.Oct.2009 at 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!

Posted By: miki1
Date Posted: 24.Oct.2009 at 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.



-------------
Milan Tesanovic

Posted By: CarlB
Date Posted: 24.Oct.2009 at 21:13
For copying data, yes x & y data should be in columns, all adjacent,as in:

x1  y1
x2 y2
x3 y3
etc...

this method comes in handy for drawing lines & polylines from Excel coordinates

And for someone using LT version, they wouldn't be able to use the lisp option.

Posted By: bmshutts
Date Posted: 12.Nov.2009 at 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.

Posted By: miki1
Date Posted: 13.Nov.2009 at 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? 

-------------
Milan Tesanovic

Posted By: bmshutts
Date Posted: 13.Nov.2009 at 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

Posted By: miki1
Date Posted: 14.Nov.2009 at 10:53
Thanks a lot ! I`ll never use ImportXYZ.lsp anymore.
Best regards!


-------------
Milan Tesanovic


Print Page | Close Window