Transfering XYZ Points From Excel into AutoCAD Civil 3D

[bharthts01]

I've just finished up a ground level survey. I've jotted the coordinate and levels down in my notebook and typed them up on Excel. 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 excel as, for example:

 

430245.454 434264.654 62.321

 

I get this error "No point file format match found" when I try and import them. I've had a look at some Youtube videos and I'm not sure what I'm doing wrong. Maybe it's the file type I'm saving it under.

 

Any help would be greatly appreciated.

[Tyke]

It depends on what type of points you need in your drawing, plain and simple AutoCAD points or Civil 3D points. Going the Civil 3D way you have a lot to learn. If its just AutoCAD points you can do it quite easily using a script. Check out Lee Mac's LISP routine "Point Manager" and see if that will do the job for you: http://www.lee-mac.com/ptmanager.html

 

Either way you need to save your Excel as a text or a CSV file, that's a text file with each of your coordinates seperated by a comma.

 

If you are doing it over C3D when you click the import button make sure you pick the point file format RHZ (comma delimited), it should be at the top of the list

[BIGAL]

Civil 3d use Points menu option (or ribbon) its a good idea to have a point group.