How to edit Revit parameters in Excel and import them back

The fire consultant has sent the door schedule back. It's a spreadsheet, 300 rows, with the ratings corrected in column F. Now somebody has to get those values into the model, and that somebody is you.

What plain Revit gives you

Two things, and between them they cover half the trip.

First, a schedule is editable. Open the door schedule, click a cell and type. An instance parameter changes for that one door. Change a type parameter and Revit warns you that every element of that type will follow.

Second, a schedule can leave Revit:

1. Open the schedule so it's the active view.
2. Go to File, Export, Reports, Schedule.
3. Choose a folder and a file name.
4. Set the file type to CSV, and in the Export Schedule dialog keep the column headers switched on.
5. Open the CSV in Excel.

That gets the data out. Revit has no matching import command, so nothing you change in that file comes back into the model.

Where the round trip breaks

So the edits come back by hand. Spreadsheet on one screen, schedule on the other. Find door 114, type the rating, find door 115.

It's slow, and it has no safety net. The exported file only carries the columns that were in the schedule, so the one thing tying a row to a door is usually the Mark, and Marks get duplicated or left blank. If someone renumbered doors after the export went out, you're matching against last week's model. Skip a row and nobody notices until the schedule is on a drawing.

This is where most offices go looking for something else. Some have a Dynamo script for it, which works as long as someone is around to look after it. Others install an add-in.

Bring 300 edited rows back into Revit without retyping one. The 7-day trial covers all 52 NexionTools add-ins and needs no card. Start the 7-day trial

Doing the round trip with Excel Sync

Excel Sync is the NexionTools tool built for this loop. It's a paid tool, and it's included in the trial.

1. Pick the scope: your current selection, everything in the active view, or a whole category such as Doors. Filter by level if you like, and choose instances or types.
2. Tick the parameters to include. They're colour-coded, green for instance, amber for type and red for read-only.
3. Export to an Excel workbook (.xlsx) or a CSV. The colours travel with the workbook, and an Instructions sheet tells whoever edits it to leave the ElementId column alone.
4. When the file comes back, load it. Nothing is written yet.
5. Read the diff. Every row shows the current value next to the new one, with a status: changed, type change, conflict, unchanged or deleted.
6. Untick anything you disagree with, then commit the rest.

The ElementId column is what makes this safe. Rows are matched to elements by ID, so a door that was renumbered last week still gets the right rating. The diff is worked out against the model as it is now, which means you see the live value before you overwrite it.

Approve a type-level change and you get a warning first, with an estimate of how many elements it will reach. The whole commit lands as one undo entry, so a single Ctrl+Z takes it all back.

Its limits:

• It's an export and an import. There's no live link to an open spreadsheet.
• It updates values on elements that already exist. It won't create parameters or elements.
• Rows it can't write, such as a read-only parameter or text typed into a number field, show as conflicts and can't be approved.
• On a workshared model, elements that stay locked by another user are skipped and counted as failed.

When you'd rather stay in Revit

Plenty of edits never need a spreadsheet. If you're the one making the change, Bulk Param does it inside Revit.

Pick the categories, load the elements, then choose the job. Write one value across all of them. Find and replace inside a parameter. Fix the capitalisation. Copy one parameter into another. It tells you how many elements it's about to touch before it writes, and each run is one undo. It's a paid tool too.

A simple way to choose: if the person who owns the data never opens Revit, send them a workbook with Excel Sync. If the person is you, use Bulk Param and skip Excel altogether.

Both sit in the NexionTools tab in the Revit ribbon, on Revit 2024 to 2027.

Try it on the next schedule a consultant sends back. All 52 tools run for 7 days from the first time you open them in Revit, with no card needed. Start the 7-day trial