Importing Station and Elevation pts from excel into CAD

[anoelle311]

I am trying to read from an Excel spreadsheet points at a certain station and elevation and import them as points into AutoCAD automatically, and then have a line drawn from point to point. Can anyone help?

 

[CarlAK]

Here's my suggestion;

First get the data in Excel into one column, representing points in "x1,y1" format. If it's really "station" information, you may have to convert to coordinates first. A formula in Excel to combine data into column "A" would be:

=B1&","&C1

(you could also use the "concatenate" function)

Then in AutoCAD, start the "line" or "polyline" command. Then when it prompts for first point, copy the data from column A, and paste (ctrl+v) that into AutoCAd's command line, and a line will be drawn between all points.

HTH!