This video clip explains how to mass import Property values in ARCHICAD 20. Element Properties are fully integrated into the ARCHICAD BIM workflow. One very useful new feature is the ability to mass import Element Property values from Excel files. This feature works as follows: Create a Schedule Scheme that includes Properties as Fields. Generate the Schedule. Fields displaying Property values normally display their default values unless specifically set by the user otherwise. In many cases these values are provided by a consultant and the architect needs to enter them individually in ARCHICAD, which can be a long and tedious process. Activate the “File… Interoperability… Element Properties… Export Property Values from Schedule” menu command. In the upcoming Save Dialog navigate to the folder you wish to save to, then specify the name for the file. In the “Select Element Scheme” field you can select which Scheme ARCHICAD should export. Properties used as Fields in the selected Scheme will be exported in the specified Excel file. Finally, click the “Save” button to save the Excel file. This Excel file can now be forwarded to the consultant who can fill out data values for these exported Element Properties. The modified Excel file can then be given back to the architect. After receiving the Excel file containing the intended values for the scheduled Properties, activate the “File… Interoperability… Element Properties… Import Property Values into Elements” menu command. Select the Excel file to import and click the “Open” button. The “Import Property Values” Dialog opens and displays the contents of the Excel file in a table form. ARCHICAD will automatically recognize if a column belongs to a Property. To the left of the title of these columns there is a checkbox, which controls whether values in the given column are imported into elements. If the checkbox is checked the values of the corresponding Property are imported into elements. By default, all checkboxes are checked. Keep these checkboxes checked or uncheck them depending on whether you want to import their values into Properties or not. The upper left corner button of the Dialog lets you display values by either listing “Records by Rows”… or “Records by Columns”. Clicking the button lets you switch between these two modes. The table shows Info Tags and text coloring in the cells to give information about the data to be imported. All cells that contain a value to be imported are displayed with black text. All other cells that do not contain Property values are grayed, as these are not relevant in this import process. If a row or column of the table is a duplicate of another row or column, cells belonging to the first instance are displayed in blue, while cells belonging to the duplicate are gray. The row or column title also displays an information icon to indicate this. If a Property or Element referenced in the table is missing from the Project file, text in the cells of the corresponding row or column is grayed and that data will not be imported. The row or column’s title also displays a Warning Sign icon to indicate this. Cells containing no data are displayed as empty and no data will be imported for those Element Properties. The “Browse” button in the lower left corner of the Dialog lets you select another Excel file to import. Simply click it, and in the upcoming Dialog select the new Excel file to open, then click the “Open” button. The “Save Report” button at the bottom of the Dialog lets you save a version of the Excel file that includes the text color formatting options seen in the table. After clicking the button, simply provide a name and location for the Excel file and click the “Save” button. This report may be sent to the consultant, based on which they can make modifications and corrections in the source Excel file. If you click the “Close” button, the Dialog will be closed without importing Element Property values. Finally, if you click the “Import” button, values will be imported for all checked Element Properties as indicated by the appearing Dialog. If we now regenerate the Schedule from which the Excel file was saved, we can see that the Element Properties now display the values we have imported using this new feature.