1.9 provides a new way of exporting data to Excel. The new exporter allows you to export data to seprate separate Excel sheets and upload a multi sheet Excel and use it as a template. This opens the possibility to create more complex reports like COBie and Seps.
...
First select "Target type" - to define what data you want to export (Room, Item, Occurrence, Product etc.). You can also give the data source a name. After you have specified data source you can add fields you want to have as columns in your Excel export. Select "Add" and navigate the groups of data fields in the dialogue that appears. Include fields by double click on them to move them from the left list to the right, or use the arrow icons in the middle separation bar. You can re-arrange the order of the fields by using the Up/Down buttons. Click The Excel Export will be sorted by the first field that is positioned at the top, followed by the second field, and then the third field. Click 'Ok' when done.
If you want to add columns with a fixed, predefined text, you can select the option "Add fixed value" and specify a text/value in the text field on the right side of the window;
...