Display full version of the post: Getting Coordinates From AutoCAD to Excel

BetweenTheLines
28.08.2012, 16:10
Back in 2009 I wrote a blog post showing one method to get the X and Y coordinates from AutoCAD into Excel using a script. Import X,Y Coordinates from Excel into AutoCAD While this was a workable method, AutoCAD is well known to have several ways to accomplish anything. Between the Lines reader Brian Glackin PE provided a much easier method this week in an email to me. A much shorter option (for one off linework) to create the lines (or plines or 3d polylines) is: Open the excel file with your coordinate pairs (if they are in separate columns, use =CRx&”,”&CRy  in a new cell to create a text line with the pairs) Highlight the coordinate pair dataset and hit ‘Control C’ Move back to AutoCAD Initiate the appropriate command (pline for most of what I do) Once the command is initiated, right click on the command line and select “Paste” Once pasted, either hit <return> or close to end the command Done! If I need to use the line set on multiple drawings, I create a script file like you suggest, but for one offs a quick copy from excel /paste to AutoCAD command line during the active command works best. Thank you Brian! If you have a favorite Autodesk product tip you would like to share with others please Email Me. Cheers, Shaan Go to the original post...