Native XLSX format for exporting attributes

Earlier versions exported attributes and quantity data in XCA format, which is separated by commas. The XCA data was converted to XAC and opened in Microsoft Excel for modification. Room numbers such as 1.02 might have been interpreted as date formats.

Now you can use the native Excel format (*.xlsx) directly for export and import; the undesired formatting results no longer occur. The NEVARIS format (*.xcax) can also be used.

Note: If Microsoft Excel is not installed on the computer, the XLSX format is not available, and you will see a message.

Export

You can use the XLSX format when you export data with the Export Attributes and Export Quantities Data tools.

The Export Attributes tool no longer opens the dialog box for selecting the path and file name right away. Instead, click Settings: Export Attributes to open a dialog box, where you can define not only the report and follow-up program but also the file format, path, and file name: In addition to Allplan BCM (.xca), you can also select NEVARIS (.xcax) and Excel file (.xlsx).

The Export Quantities Data tool also opens a dialog box, where you can select the report, follow-up program, file format, path, and file name. Click to set the settings in the dialog box back to their defaults.

Import

When you import data with the Import Attributes and Import Quantities Data tools, you can also choose between Allplan BCM (.xca), NEVARIS (.xcax), and Excel file (.xlsx). Allplan presents all possible formats for selection; you can also filter by format.