AutoCAD Civil 3D General Discussion

Distinguished Contributor
Posts: 112
Registered: ‎08-24-2013
Message 1 of 4 (297 Views)

How to copy a Point Table from Excel?

297 Views, 3 Replies
10-22-2013 03:32 PM

This seems like it should be the most stupidly easy thing...but AutoCAD doesn't seem to have a way to do this.


I made a point table from a point group. Quick and sweet.


But now I want to change it a little bit, and it's not something I can just do from the table style. So I want to copy it into Excel...and when I try to, hitting paste in Excel ends up just giving me this block image version of the table in Excel. I tried doing TABLEEXPORT but that's only for regular tables.


Any help here? Thanks!

*Expert Elite*
Posts: 752
Registered: ‎09-29-2008
Message 2 of 4 (269 Views)

Re: How to copy a Point Table from Excel?

10-23-2013 01:29 AM in reply to: pocketmerlin
This can not be done in this way. Civil tables are not the same as excel tables or autocad tables so the data cannot be passed in this way.

You can export the points and achieve the same thing so long as you select the right columns. After export open in excel and edit away but this will be detached from the points in the file.
Mike Evans

Civil3D 2013 / 2014 British UK
Windows 7 Professional 64-bit
Intel(R) Core(TM) i7-3820 CPU @ 3.60GHz (8 CPUs), ~4.0GHz With 32768MB RAM, AMD FirePro V4900, Dedicated Memory: 984 MB, Shared Memory: 814 MB

*Expert Elite*
Posts: 4,778
Registered: ‎12-15-2008
Message 3 of 4 (250 Views)

Re: How to copy a Point Table from Excel?

10-23-2013 04:50 AM in reply to: pocketmerlin
I concur with Mike

export the point group from the points menu, edit save a csv, reimport and the civil table will import
Thank you

Joseph D. Bouza, P.E. (one of 'THOSE' People) Civil 3D 2012 & 2013
HP Z210 Workstation
Intel Xeon CPU E31240 @ 3.30 Hz
12 GB Ram

Note: Its all Resistentialism, so keep calm and carry on

64 Bit Win7 OS
Distinguished Contributor
Posts: 112
Registered: ‎08-24-2013
Message 4 of 4 (237 Views)

Re: How to copy a Point Table from Excel?

10-23-2013 06:34 AM in reply to: Joe-Bouza

OK, I had been thinking that the export points command gave you some strange file format that I didn't know how to work with, because in the menu it gave formats such as ENZ, NEZ, etc, but then I realized that those meant "Easting, Northing, Elevation" and "Northing, Easting, Elevation," etc. and it gave it to you in a text file format, which I do know how to bring into Excel.


So...I'm good now. Thanks for your help.

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community

Civil 3D Exchange Apps

Created by the community for the community, Autodesk Exchange Apps for AutoCAD Civil 3D helps you achieve greater speed, accuracy, and automation from concept to manufacturing.

Connect with Civil 3D