Export BIM Data to Tables and Excel

Export the properties of selected BIM objects into tables in the drawing or CSV files for spreadsheets with ARES Commander. Select BIM entities manually, or from the filters in the BIM Navigator, and extract their BIM data. The wizard helps you to isolate only the properties you need. The data can be inserted as a table in the drawing or exported to a CSV file for use in Excel or other programs.

Data Extraction with ARES CAD Software

ARES Commander allows data extraction from BIM Entities. In this example, we have a building with 13 floors of identical houses and we are going to focus on one of them. To obtain a budget of all the carpentry that affects the 4 houses that make up the plant. For that, after calculating the cost for a level, we will multiply it by 13 since they are the number of housing levels that this building contains. Here we are observing one of the standard levels with 4 homes. The carpentry manufacturer has to pass a budget to the builder of the interior and exterior carpentry of the homes of this building. Just by knowing what the price of the carpentry by level is, then it will be multiplied by the 13 floors of the house to know the total. When opening the BIM Elements drop-down we can select categories of elements or select elements independently. Even several of them at once. The truth is that if we have an item selected we can “turn it off” or “show it”.

We can also turn off all the families that are identical to the project. Even those categories that have more than one variant, can be turned off all at once. In turn, having the category selected, you can easily distinguish all of its elements in the drawing. ARES Commander allows you to extract data from BIM elements in much the same way that you can extract data from entities in a DWG drawing.

In this example, we will extract all the data related to the carpentry. For that, we will create a filter in which we indicate the project, in this case, there is only one. In “CRITERIA” we will choose “CATEGORY” and among the categories, we will look for everything that is related to doors and windows. We select them and click add. We save this selection with the name “Carpentry”. Now we are going to extract data. In the dialog, we choose “CREATE A NEW DATA EXTRACTION”.

Naming an extension file

The extension file can be named DET. We can include the whole drawing or select only the elements that we had previously filtered. Press NEXT, and then again NEXT. We deselect the categories that do not interest us. leaving only the BIM COMMON category. In this case, we only need the “CATEGORY” property. Press NEXT. Notice that all the elements combined by type appear. If we deselect this option, the list with all the elements is shown individually. Thanks to this box, entities of the same type are combined, adding the amount in the “COUNT” column. Press NEXT. Now we can convert the data into a TABLE that we can insert into the drawing, or export the data into a CSV or TXT format file and then import it into Excel, for example. The truth is that we can do both at the same time. After giving a name to the data table, press SAVE and NEXT.

In this box, we specify the Table Style, if we have it created. But we can choose the Standard style offered by ARES Commander. In any place of the drawing, we can click to insert our table. From the top view, we can see our table. Even move it to a more suitable position. We click on a cell in the table, and after pressing the right button, we choose to Insert a Column Right. We can also do it from the Ribbon. Now we can add a title that says “Price for Unit”. We add 2 more columns to the right. We write the unit prices of each type of carpentry. In this column, we make a formula that allows multiplying the individual value of each carpentry by the amount existing in the level.

Estimating BIM Cost

In the right column, we create a new formula that multiplies the total cost per level of each type of carpentry multiplied by 13 which is the number of levels of this building. We repeat these operations for the rest of the cells. For that, we can select a cell with the formula and after pressing Copy, we can go to the rest of the cells and paste them. And as if it were Excel, the formula will be updated to the new position of related cells intelligently.

In the next column, we copy and paste the formula of the first cell following the above criteria. Now we are going to add a row below the table. For that, after selecting a cell, we press the right button and choose Insert, ROW BELOW. Now we are going to create a Sum of all subtotals. We write the title “TOTAL”, while in the last cell we will create the summation. To do this we press the right button and choose FORMULA and the SUM option. Now we make a selection of the cells that will be involved in this sum.

Thus, ARES Commander writes the formula for us. After accepting, we see the result. Remember that we have grips that will allow us to adjust the width of the columns. And all directly in ARES Commander. By the way, the data in this table is fully editable. For example to modify the description of BIM objects. That in this case, they appear in Spanish, because in Spanish there were the parameters of the families used in the original project. We may be interested in translating it into another language. Something we can do directly in ARES Commander, editing the corresponding cell. Or also within a table in Excel. Now, in EXCEL. We can import the CSV extension file that we had previously created. To finish creating a table with the data obtained from the BIM elements in ARES Commander.

Editing BIM Data using Excel

In Excel, as we did in ARES Commander we can create new columns, write unit prices, and then perform operations with them. Thus we will obtain the costs by level of each type of carpentry, as well as the total cost of these typologies throughout the building. Closing the table with the total cost of all carpentry. Whether we work with EXCEL or prefer to use the tables within ARES Commander we will get the same result, and we will achieve it with the same ease. Also, remember that we can make a selection of cells in Excel, then press Control plus the C key to Copy, and then in the drawing of ARES Commander paste it.

Highlighting that the table pasted from Excel can be edited directly in ARES Commander because it is linked between both programs. Although the disadvantage is that to share this project it is also necessary to send the Excel table to maintain its link.Unless we use ARES Commander tables directly which would make it independent. To learn more about Tables and how to work with the BIM elements of ARES Commander, visit the extensive help offered by the software. In addition to viewing other videos, we have on these topics. Learn more about the new features in ARES Commander.