NexauraRevit add-in suite

Beginner · 8 min read

Round-trip parameters through Excel

Export, edit, validate and import, and learn what the cell colours mean.

  1. 1

    Step 1 — Select data

    Choose where elements come from: Entire model, Active view, Current selection or Manual element IDs. Then tick categories in the discipline tree (use Search, Select All, Clear All) and click “Load Parameters ▶”.

  2. 2

    Step 2 — Select parameters

    The grid lists each parameter with its Source (Built-in, Project, Shared, Identity), Instance/Type and Editable (🔒 if the tool cannot write it). Tick the ones you want to export.

    Parameters are discovered from a sample of up to 250 elements; a parameter that only a few elements carry may be missed.
  3. 3

    Step 3 — Export Excel

    Pick an output path (the default is <Project>_ParameterExport_<date>.xlsx), check the preview of the first 200 rows and click Export Excel. The workbook is only saved when writing finishes, so Cancel never leaves a partial file.

  4. 4

    Read the colours

    In the Element Data sheet, white cells are instance values you can edit. Light yellow cells are type values (editing one changes every element of that type). Light red cells cannot be edited. Headers and identity columns are frozen, filters are on, and Level and Material columns have dropdowns.

  5. 5

    Edit in Excel

    Change values freely, sort or filter as you like. Rows are matched by Element ID and a hidden key row, not by row position, so re-ordering is safe. Save the workbook.

  6. 6

    Validate

    Back in Revit, click Import, browse to the workbook and click Validate. Each proposed change appears with Old Value, New Value, Status and Message. Statuses include Change, Affects type/assembly (with the number of elements affected), Read Only, Not Found, Ownership, Duplicate, Conflict and Error. Filter the list, untick anything you don’t want.

  7. 7

    Import (Apply Selected Changes)

    Confirm the summary. Changes go in batches of 200, each its own transaction and undo step; a failing batch is rolled back. The status bar then shows Updated / No Change / Warnings / Errors totals, and Export Report to Excel saves ImportReport.xlsx.

Good to know

  • Rows that share a type are written once: 127 rows on one type give one rename, not 127 writes.
  • If the workbook came from a different model, the tool asks before continuing.
  • Save your category and parameter choices as a Profile to repeat the same export later.