Civil Fast Forward


Import data from multiple XML Earthwork reports

When you design several roads or you have multiple design areas you can aggregate earthworks data by using XML reports instead of copying them manually from tables or other sources.

This method describes how to:

– use these files for many roads and,
– manage a large amount of data contained in these files,
using Autodesk Civil 3D 2012, Microsoft Internet Explorer 9 and Microsoft Excel 2010.



You can produce multiple XML files with your favorite names and save them wherever you want to save in a few simple steps:

1. In Autodesk Civil 3D choose the Display XML report option,


2. Choose File and select the Save As function,


3. Choose your favorite location, type the name of your file and click Save,


4.Import the data as mentioned in the > previous post <,

5. Leave the first column empty before dragging one more additional node for identification and sorting purposes,


6. Drag that one more node e.g. Alignment name,


7. Select all the files which you want to Import using “CTRL + click” or “SHIFT + click “ and Import them to your spreadsheet,


8. Now you have all your data and you can easily identify, analyze, and sort your data thanks to this additional XML node,

9. Additionally, you can summarize your data with a Pivot Table,

10. Choose the fields and drag them between areas in the Pivot Table Field List,

11. At last after formatting your data, changing the names in the Pivot Table and assigning Slicer
you have a pretty good looking business intelligence solution in which you can analyze your data
e.g. comparing earthworks in relation to:

– advanced design works or,
– an existing surface precision.

Now you can completely enjoy your well-formed XML data.