See the top rated post in this thread. Click here

Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Import points into drawing file from Excel

  1. #1
    Member
    Join Date
    2005-04
    Posts
    45
    Login to Give a bone
    0

    Unhappy Import points into drawing file from Excel

    I'm going to try and ask this as simple as I can. I'm starting to design retaining walls. The engineer gives me the x and y of the ground lines and also the x and y for the wall block outline. It starts at 0. example would be: 0, 2014.575 ; .75, 2014.575. This takes forever to enter all of this data into cad by drawing a polyline using these elevations and stations. Is there an easier way of maybe importing this data from say an Excel file?
    I have Autodesk Civil 3D 2006. Thanks so much for any input.
    Last edited by msanders.85217; 2006-01-20 at 02:47 PM. Reason: wanted to change notification. wanted to receive email

  2. #2
    The Silent Type Mike.Perry's Avatar
    Join Date
    2000-11
    Posts
    13,656
    Login to Give a bone
    0

    Default Re: Import points into drawing file from Excel

    Quote Originally Posted by msanders.85217
    I have Autodesk Civil 3D 2006.
    Hi

    Please note I have *moved* this thread from the AutoCAD 2006 General forum to this one...

    Why? - I believe Civil 3D has tools built-in that allow direct import of Point data.

    Thanks, Mike

    Forum Moderator

  3. #3
    The Silent Type Mike.Perry's Avatar
    Join Date
    2000-11
    Posts
    13,656
    Login to Give a bone
    0

    Default Re: Import points into drawing file from Excel

    Hi

    In case I have the above totally wrong ( fair chance of that being the case ), the following threads contains some information that should prove useful...

    Inputting numerous co-ordinates from excel files

    Plus, hopefully "MHultgren" will be along soon to correct the mess I have caused.

    Have a good one, Mike

  4. #4
    Geospatial Moderator Jmurphy's Avatar
    Join Date
    2000-11
    Location
    TN/KY Area
    Posts
    1,640
    Login to Give a bone
    1

    Smile Re: Import points into drawing file from Excel

    Quote Originally Posted by Mike.Perry
    Hi

    In case I have the above totally wrong ( fair chance of that being the case ), the following threads contains some information that should prove useful...

    Inputting numerous co-ordinates from excel files

    Plus, hopefully "MHultgren" will be along soon to correct the mess I have caused.

    Have a good one, Mike
    Darn Brits, point you to a thread that points to another thread that points you to another thread.........

    http://usa.autodesk.com/adsk/servlet...linkID=2475323

  5. #5
    Member
    Join Date
    2005-04
    Posts
    45
    Login to Give a bone
    0

    Default Re: Import points into drawing file from Excel

    Yes, I was just thinking that myself! ha ha ha! I'm going from one thread to another and can't keep track of where I'm at!!! Thanks!

  6. #6
    Civil Engineering Moderator MHultgren's Avatar
    Join Date
    2000-12
    Location
    Central Iowa
    Posts
    1,444
    Login to Give a bone
    0

    Default Re: Import points into drawing file from Excel

    Thanks for picking that up J,
    Friday was hectic around here and I didn't make it in to check on the threads before I left work. Gotta love those 5:00 changes for a Monday morning submittal

  7. #7
    Member Chris Matira's Avatar
    Join Date
    2005-08
    Location
    Philippines
    Posts
    41
    Login to Give a bone
    0

    Default Re: Import points into drawing file from Excel

    if you already have your point data on an excel file.. save it on a csv format, then open the csv format file of the point data using notepad..

    once you have opened it, copy the data.

    on the autocad command line, enter the pline command then paste the point data you copied from notepad. every coordinate (x,y) will be recognized now by autocad as one single point. i guess that should do it.

  8. #8
    Member
    Join Date
    2001-01
    Location
    Utah
    Posts
    11
    Login to Give a bone
    0

    Default Re: Import points into drawing file from Excel

    Can one do this too with placing points in the drawing? creating the x, y, and z coordinates of those points?



    Quote Originally Posted by Chris Matira
    if you already have your point data on an excel file.. save it on a csv format, then open the csv format file of the point data using notepad..

    once you have opened it, copy the data.

    on the autocad command line, enter the pline command then paste the point data you copied from notepad. every coordinate (x,y) will be recognized now by autocad as one single point. i guess that should do it.

  9. #9
    Administrator rkmcswain's Avatar
    Join Date
    2004-09
    Location
    Earth
    Posts
    9,803
    Login to Give a bone
    0

    Default Re: Import points into drawing file from Excel

    Quote Originally Posted by msanders.85217
    Is there an easier way of maybe importing this data from say an Excel file?
    I have Autodesk Civil 3D 2006. Thanks so much for any input.
    You might take a look at [ http://www.dotsoft.com/procedures.htm#ExcelScripting ]
    R.K. McSwain | CAD Panacea |

  10. #10
    Civil Engineering Moderator MHultgren's Avatar
    Join Date
    2000-12
    Location
    Central Iowa
    Posts
    1,444
    Login to Give a bone
    0

    Default Re: Import points into drawing file from Excel

    You can import points using the ASCII format, PNEZD would be for Point Number (P), Northing(N or y), Easting(E or x), Elevation (E or z) and Description. So if you saved your Excel file as CSV and then imported it using a ENZ format it would automatically insert the point numbers based on your settings. The description would be blank unless you added it to the Excel file before saving it to a CSV. You could also add the point numbers in the first column rather quickly by inserting a column, typing a 1 in the first cell and then hilite the first cell. You can then click the little white cross that will show up at the bottom right corner of the cell and while you hold the mouse button down, drag your mouse all the way to the bottom.

Page 1 of 2 12 LastLast

Similar Threads

  1. 2012: Import an Excel file into AutoCAD
    By rbhazie in forum AutoCAD General
    Replies: 5
    Last Post: 2014-10-06, 05:09 PM
  2. Civil 3D question - import points from excel, coordinates and attributes
    By Hotrod50 in forum AutoCAD Civil 3D - General
    Replies: 1
    Last Post: 2012-03-02, 05:09 PM
  3. How to Import EXCEL file into Revit?
    By tsong in forum Revit Architecture - General
    Replies: 4
    Last Post: 2007-10-02, 08:57 PM
  4. Import data from MS Excel into a drawing
    By Jack Cheong in forum AutoCAD General
    Replies: 6
    Last Post: 2006-10-18, 04:58 PM
  5. Replies: 3
    Last Post: 2006-03-08, 05:45 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •