×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

co-ords from autocad to excell?

co-ords from autocad to excell?

co-ords from autocad to excell?

(OP)
Hi m new to the forum but I have ben blundering my way around autocad for a few years. I am trying to gather the easting and northing co-ordinates of several items from autocad drawings and transfer them to excell where i can save them as a csv file for converting to my total station software. at present I can only using the I command pick the point then I have to hand write al the co-ords down and then re-enter them into excell. I do not know anything about the autolisp commands I have been reading about. Is there any way that I can do this quicker than at present

 regards
 Goaliehammy

RE: co-ords from autocad to excell?

You can put all the points on a new layer, isolate that layer, type LIST in command, select all points.  You will get a text file, which you can Select, Copy and Paste.  You will still have to edit, to remove all the other text.  The X is E the Y is N, so you might (or might not, check how your data collector reads) have to reverse them or your data collector will read them 90d rotated.  This part is best done with Excel.  If you have elevations, they will appear as Z, and your data collector can also read them.  I use Word, so I can Replace All with a comma.  The comma is what the total station will need to differentiate N and E, a hard return will let it differntiate each point.  See below, you probably want to end up with 3.3747,8.1001,0.0000.


Command: POINT
Current point modes:  PDMODE=0  PDSIZE=0.0000
Specify a point:
Command: list

Select objects: Specify opposite corner: 1 found

Select objects:

                  POINT     Layer: "0"
                            Space: Model space
                   Handle = 2f
                at point, X=   8.1001  Y=   3.3747  Z=   0.0000

Engineering is the practice of the art of science - Steve

RE: co-ords from autocad to excell?

(OP)
Thanks LHA. This is a new command to me and I will play with it for a while to see if it is what im looking for. it sounds appropriate but ease of use for me will determine its value.

Once again thanks


once I was blind but now the forum lets me see  

RE: co-ords from autocad to excell?

Check to see if your version of AutoCAD supports the type of units you are needing.  Then LIST may show you exactly what you are looking for.

RE: co-ords from autocad to excell?

Anbother thing that you can do is turn off all layers except the points which you need the coordinates; do a LIST command of all the points; then paste and copy to wordpad or excel the history of all the points that you did a listings; and then modify the content of wordpad or excel into a tabular format.   

RE: co-ords from autocad to excell?

Is there a way of doing the opposite excel to autoCAD, i have recently been asked to produce drawings from my survey data, and at present, i input them one by one, this was ok for small details, however i am required to survey a large bund, and this will lead to a large number of points!

RE: co-ords from autocad to excell?

You can copy data from Excel & paste into AutoCAD's command line.  So start a command (say "multiple" "point") then paste a set of coordinates & they'll all be drawn in AutoCAD.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources