The PLS I work under inquired if the pipe and structure tables provided in our construction plans are able to be exported to excel. The only way I know how is to use the reports manage. The problem is, the provided Pipes reports don't contain all the data we are looking for. How do I modify, or create a new, Pipe report? It seems like it should be really easy to export the data to excel......I've gotta be missing something.
Thanks
Solved! Go to Solution.
Solved by MikeEvansUK. Go to Solution.
Hrmm. What data do you want to show exactly? I know you can copy all the pipe structure or pipe data from toolspace. Would that get you what you need?
I would like to export all of the data represented in my structure table, as shown in the construction plans. Ideally, I could generate a Sturcture Report that would match my structure table (Number, Location, Structure, Frame & Cover, Grate Elev, Sump Elev, and depth) Once in excel, I would add a few additional columns and formulas to facilitate construction staking (i.e. - hub elevation, cuts/fills, etc..).
If it's not relatively easy to customize a report, I will just cob it all together via copy/paste and call er' good enough.
Thanks
Check out the thread above. Might be worth doing some digging. I assume once you get the exploded civil 3d table into the autocad table format or a CSV then you could do whatever you need in excel.
This might be too easy, but you can manipulate the columns you want in the Panorama; higlight the pipes or structures you want to see in the report; right-click and copy to clipboard; then paste into Excel. It's not dynamically linked or anything, but it'll make for a pretty easy solution.
There are ad on programs that perform this task but it should be included in Civil 3D 2013 and beyond. This is a pretty normal task when doing estimated quantities and tabulations. I'm currently trying to figure out how to export pipe works table data to an excel sheet. The process should be dynamically linked in both directions. AutoCad to Excel and vice versa. I do do table linking with Manhole and catch basin extracted block attribute data and that process works pretty well. I have created and manipulated my pipe network table but this table doesn't allow me to export the data to a CSV file and then into an excel sheet. What the heck? The whole purpose of linking is so we don't have to spend time typing information into the excel sheet and then linking to our dwg files. When you create a pipe network all that information is included with the network. Does anyone have a solution that allows Civil 3D users to perform table exports without having to purchase an add on? Managed Design has a program called pipes2excel that looks like it works the way I want it to work. This task should be included somewhere in this software.
Joe Bouza
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
The most stable method is to export the Network to SDF format.
Open an FDO connection to the SDF data.
Select the Data in the Task Pane and display it in a table.
Export select rows to .CSV format.
So for future reference, here is a free AutoCAD app you can download to export the information from any civil 3d table into excel directly. If the structure/pipe tables from your plans show the information you need you can simply use this. It doesn't work well with split tables, but best option I've found so far.