Import Parameters from Excel

Import Parameters from Excel is the write-back half of Check Parameters. It reads a .xlsx file — typically the one Check Parameters exported, edited offline to fill in missing values — and matches each row to an element in the active model by its Element Id. Every proposed change is shown in a preview grid, grouped by category and by element, where you opt rows in or out before anything is written. On Apply, the selected values are written back to the model as one undoable operation.

1. In the B45 Labs | Coordination tab, open the External Tools panel and click Import Parameters from Excel.
2. Pick the .xlsx file that holds the values to apply — usually the workbook exported by Check Parameters.
3. Review the preview: one tab per category, rows grouped by element, each showing its current value, the new value, and a status. By default only actionable rows appear — tick Show all to also see skipped and unchanged rows.
4. Use the row checkboxes (or Select All / Deselect All, or a group's master checkbox) to choose exactly which changes to write; the search box filters long lists.
5. Click Apply to write the selected values back to the model as a single undo step.
6. Read the final report — applied, skipped, unchanged, and failed counts — then close it.

• The intended loop is Check Parameters -> export -> edit in Excel -> Import Parameters from Excel; the Element Id column is what ties each row back to its element.
• An empty (or "(empty)") cell is read as clear-intent, but only text parameters can actually be cleared — numeric and other types are surfaced as skipped.
• Rows that would clear a value are highlighted so a destructive edit is obvious before you Apply.