Excel Sync
Send any parameter to Excel, edit it the way you like, and bring it back with a full preview.
Export the instance and type parameters of chosen elements to a colour-coded, protected workbook. Edit it in Excel, then validate before you import. Every change shows its old value, its new value and exactly what it will touch.
In Revit, the Excel Sync button still opens the Revit Excel Parameter Manager window, so the screenshots show that name.
“Export and import Revit parameters with Excel.”
Live demo
Revit parameters, edited in Excel.
| Element ID | Type | Mark | Comments | Width | Volume |
|---|---|---|---|---|---|
| 125401 | C1 | C1-001 | — | 600 | 0.97 m³ |
| 125402 | C1 | C1-002 | — | 600 | 0.97 m³ |
| 125403 | C1 | C1-003 | Check rebar | 600 | 0.97 m³ |
| 125488 | C2 | C2-001 | — | 650 | 1.14 m³ |
In Revit
The real thing
Workflow
How it works
- 1
Select data
Choose Entire model, Active view, Current selection or Manual element IDs, then pick categories from the discipline tree.
- 2
Select parameters
See each parameter’s Source (Built-in, Project, Shared), whether it is Instance or Type, and whether it can be edited.
- 3
Export Excel
You get a workbook with frozen headers, filters and a colour key. Read-only cells are locked and Level and Material columns have dropdowns.
- 4
Validate and import
Rows are matched by element ID, not row number, so sorting in Excel is safe. Review the change list, then apply.
Capabilities
What’s inside
Colour-coded cells
Light red cells can’t be edited. Light yellow cells are type values that change every element of that type. White cells are instance values.
Change preview
The change list shows Apply, Element ID, Parameter, Modification Target, Old Value, New Value, Status and Message. Filter it by Changed, Warnings, Errors and more.
Type-aware writes
Rows sharing a type are written once. 127 workbook rows on one type give one rename, not 127 writes.
Conflicts caught
Two rows asking for different values on the same type are blocked until you fix them. Values that can’t be read for the parameter’s units are flagged as Error.
Profiles
Save categories, source mode and parameters as a profile, and load the same export again with one click.
Import report
Save every applied change to ImportReport.xlsx for your records.
Safety guarantees
- Cancelling an export leaves no half-written file
- Changes are applied in batches of 200, one transaction each
- A batch that fails is rolled back
- You are warned if the workbook came from a different model
Help
Using Excel Sync
How do I open it?
Open a project in Revit 2022 to 2027. On the Nexaura tab, in the Excel panel, click Excel Sync. The Revit Excel Parameter Manager window opens.
Which elements are exported?
Choose Entire model, Active view, Current selection or Manual Element IDs. Tick the categories, then click Load Parameters. Categories with no elements are dimmed, but you can still tick them.
Why is a parameter missing from the list?
The list is read from a sample of up to 250 elements, spread across the model. A parameter that only a few elements carry may not appear. Select a few of those elements in Revit, use Current selection and load again.
What does an import really change?
Click Validate first. A Type parameter, or the Type column, changes every element of that type. An Assembly Name renames the assembly type for every assembly that shares it. Family names are never changed.
Can I stop an import halfway?
Changes are written in batches of 200. Cancel stops between batches. Batches already written stay, and each one is its own Undo step. A batch that Revit rejects is rolled back and its rows are marked as errors.
Where are profiles kept?
Save As... stores the categories, the element source and the chosen parameters in %AppData%\RevitExcelManager\Profiles. Load restores them. The parameters are ticked again the next time you click Load Parameters.