Ignoring the civil 3d answer for the moment I have posted many times you need a stringing program to read a pt,x,y,z,code file and do just that join the relevant codes. It would also insert the correct blocks to match a point code. Theres heaps of stuff you can do if you start using the 'code' as well. There are programs out there but they have a cost. One day if I can find the time I will have a go at a stringing program to use with plain Autocad. F1 Challenge 99 02 Setups Are Not Set.

I'm having trouble getting the coordinates from excel into AutoCAD Civil 3D 2013 version. I'm VERY new to this sort of stuff as a trainee site engineer the most I do is simply take coordinates from a drawing to set out on site. I'm importing the points from file using Civil 3D. I've simply saved the coordinate on.

Possibly in excel. From a programing point of view buy the $60 option it will pay for its self in one job. Please stay in your seat and try to remain calm. Did you check out the responses in the link I posted?

Sorry to sound frustrated, I did forget that typing in capitals was considered yelling and rude. I have read all the responses and followed all links, thank you. In C3D, it takes 1 command: 'import points', and voila, the points show up in model space. I am just surprised the solutions, which I am sure work great, but include either scrips, lisps, macros, zip files and even paid external programs just to bring in point data. Autodesk has done a superb job writing software to handle topographic survey data, which commands its own stand-alone product: Civil 3D, not AutoCAD 20XX. Regards, OA OA.

Look at it another way, suppose you work in an architect firm and want to insert a door or window in a wall, with plain Autocad you need to trim the wall with the trim command and rotate the window/door block to aling with the wall or use lisp or something to do it in one command, but with the correct AutoCAD Arch version it's a one button command. Or how about changinging the size of a bearing for an idle gear in a mechincal project and have the shaft and gear update with one button? Now if you took all the code to run all those one button commands and put them in one product how many DVDs or TB of info are you willing to download and install when you may only use 1/8th of them? Use the right tool for the job or right software for the job.

Important: The highest point number allowed in Civil 3D is 4,294,967,295. You can use point names or User Defined Properties to reference numbers greater than 4,294,967,295.

For more information, see. You can add the imported points to a point group, make adjustments to the data as it is imported, including elevation adjustments, coordinate transformation, or coordinate data expansion, encounter how the imported points are numbered as they are created. • Specify the Point Identity settings, which control the point numbers of the created points. For more information, see. • Click Home tab Create Ground Data panel Points menu Point Creation Tools Find. • On the toolbar, click the Import Points button. • In the dialog box, click, and select the point data files you want to import.

After you have specified a point file, the Specify Point File Format list is filtered by the file types that are potential matches for the file that you selected. Note: To toggle off or on the file format filter, click. Based on the specified point file format, the selected point file is parsed and a preview is displayed in the Preview area. • Select the appropriate point file format. The display of the Preview area changes to reflect the currently selected point file format and the contents of the selected point file. • Optionally, specify a point group to which the imported points are added.

• Optionally, specify advanced options for elevation adjustment, coordinate transformation, or coordinate data expansion. • Click OK to import the points.